**** 本内容被作者隐藏 ****

Choose the best answer. Examine this query: SELECT 2 FROM dual d1 CROSS JOIN dual d2 CROSS JOIN dual d3; What is returned upon execution? A) 0 rows B) an error C) 8 rows D) 6 rows E) 1 row F) 3 rows ...

Choose two Which two true about a sql statement using SET operations such as UNION? A) The data type of each column returned by the second query must be implicitly convertible to the data ty p e of ...

Choose two Which two statements are true about INTERVAL data types A) INTERVAL YEAR TO MONTH columns only support monthly intervals within a range of years. B) The value in an INTERVAL DAY TO SECOND c ...

Choose two Which two statements are true about conditional INSERT ALL? A) Each row returned by the subquery can be inserted into only a single target table. B) It cannot have an ELSE clause. C) The to ...

Choose two Which two statements are true about date/time functions in a session where NLS_DATE_PORMAT is set to DD- MON-YYYY SH24:MI:SS A) SYSDATE can be used in expressions only if the default date f ...

What is true about non-equijoin statement performance? A. The between condition always performs less well than using the >= and = and

Choose two. You create a table by using this command: CREATE TABLE rate_list (rate NUMBER(6,2)); Which two are true about executing statements? A) INSERT INTO rate_list VALUES (-.9) inserts the value ...