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 ...

Choose three Which three statements are true about GLOBAL TEMPORARY TABLES? A) GLOBAL TEMPORARY TABLE rows inserted by a session are available to any other session whose user has been granted select o ...

Choose three Which three are true about dropping columns from a table? A) A column can be removed only if it contains no data. B) A column drop is implicitly committed C) A column that is referenced b ...

Choose the best answer You have been asked to create a table for a banking application. One of the columns must meet three requirements: 1) Be stored in a format supporting date arithmetic without usi ...