多項選擇題

Which two statements are true regarding single row functions?（）

A.They accept only a single argument
B.They can be nested only to two levels
C.Arguments can only be column values or constants
D.They always return a single result row for every row of a queried table
E.They can return a data type value different from the one that is referenced

你可能感興趣的試題

多項選擇題

You need to generate a list of all customer last names with their credit limits from the CUSTOMERS table. Those customers who do not have a credit limit should appear last in the list. Which two queries would achieve the required result?（）

A.SELECT cust_last_name, cust_credit_limit FROM customers ORDER BY cust_credit_limit DESC
B.SELECT cust_last_name, cust_credit_limit FROM customers ORDER BY cust_credit_limit
C.SELECT cust_last_name, cust_credit_limit FROM customers ORDER BY cust_credit_limit NULLS LAST
D.SELECT cust_last_name, cust_credit_limit FROM customers ORDER BY cust_last_name, cust_credit_limit NULLSLAST

多項選擇題

Where can subqueries be used?（）

A.field names in the SELECT statement
B.the FROM clause in the SELECT statement
C.the HAVING clause in the SELECT statement
D.the GROUP BY clause in the SELECT statement
E.the WHERE clause in only the SELECT statement
F.the WHERE clause in SELECT as well as all DML statements

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美 国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线

Which two statements are true regarding single row functions?（）

你可能感興趣的試題

You need to generate a list of all customer last names with their credit limits from the CUSTOMERS table. Those customers who do not have a credit limit should appear last in the list. Which two queries would achieve the required result?（）

Where can subqueries be used?（）

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线