98. Which statement is true regarding the COALESCE function? A. It can have a maximum of five expressions in a list. 最多只能有5个表达式，错，无限个 B. It returns the highest NOT NULL  value in the list for all r

87. You want to display the date for the first Mon day of the next  month and issue the following command: SQL>SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE),'MON'), ‘dd "is the first Monday for" fmmont

78. Evaluate the following query: SQL> SELECT TRUNC(ROUND(156.00,-1),-1)    FROM DUAL; What would be the outcome? A. 16 B. 100 C. 160 D. 200 E. 150 Answer: C   答案解析： 参考： http://blog.csdn.ne

51. Which statement is true regarding synonyms? A. Synonyms can be created only   for a table.  不只是表，schema object B. Synonyms are used to reference only those tables that are owned by another u

135. Which three statements are true regarding subqueries? (Choose three.) A. Subqueries can contain GROUP BY and ORDER BY clauses. 对，可以包含group by 和order by B. Main query and subquery can get data f

134. Where can subqueries be used? (Choose all that apply.) A. field  names in the  SELECT statement  标量子查询 B. the  FROM clause in the  SELECT statement  内联视图 C. the  HAVING clause in the  SELECT s