A. SELECT * FROM customers WHERE TO_ CHAR (customer_ id) ='0001';

B. SELECT * FROM customers WHERE customer_ id = 0001 ;

C. SELECT * FROM customers WHERE customer id = '0001';

D. SELECT * FROM customers WHERE insert date ='01-JAN-19'

E. SELECT * FROM customers WHERE insert_ date = DATE '2019-01-01';

A. They always use subqueries.

B. The unconditional INSERT ALL statement must have the same number of columns in both the source and target tables.

C. The conditional INSERT ALL statement inserts rows into a single table by aggregating source rows.

D. The conditional INSERT FIRST statement always inserts a row into a single table.

E. They can transform a row from a source table into multiple rows in a target table.

A. The foreign key constraint will be enabled and IMMEDIATE.

B. The primary key constraint will be enabled and DEFERRED.

C. The foreign key constraint will be disabled.

D. The primary key constraint will be enabled and IMMEDIATE.

E. The foreign key constraint will be enabled and DEFERRED.

A. SELECT TO_ CHAR(TO_ DATE('29-10-2019') + INTERVAL '3' MONTH + INTERVAL '7' DAY - INTERVAL '360' SECOND, ' DD-MON-YYYY') AS "date" FROM DUAL;

B. SELECT To CHAR(TO _DATE('29-10-2019') + INTERVAL '2' NONTH + INTERVAL '5' DAY INEERVAL '120' SECOND, ' DD-MON-YYY) AS "date" FROM DUAL;

C. SELECT TO_ CHAR(TO_ DATE('29-10-2019') +INTERVAL '2'; MONTH + INTERVAL '5'; DAY - INTERVAL '86410' SECOND, ' DD-MON-YYYY') AS "date" FROM DUAL;

D. SELECT-TO_CHAR(TO _DATE('29-10-2019'+ INTERVAL '2' MONTH+INTERVAL '4' DAYINTERVAL
'120' SECOND, 'DD-MON-YY') AS "daTe"
FROM DUAL;

E. SELECT-TO_CHAR(TO _DATE('29-10-2019'+ INTERVAL '2' MONTH+INTERVAL '6' DAYINTERVAL
'120' SECOND, 'DD-MON-YY') AS "daTe"
FROM DUAL;

A. All conditions evaluated using CASE can also be evaluated using DECODE.

B. DECODE is a function and CASE is not.

C. Both CASE and DECODE are functions.

D. AIl conditions evaluated using DECODE can also be evaluated using CASE.

E. Neither CASE nor DECODE is a function.

F. CASE is a function and DECODE is not.

A. 3 returns an error.

B. 1 and 4 give the same result.

C. 1 and 4 give different results.

D. 2 returns the value 20.

E. 2 and 3 give the same result.

A. UNION ALL

B. MINUS

C. INTERSECT

D. UNION

E. SUBTRACT

A. Views cannot be used to add or modify rows in an underlying table if the defining query of the view contains the DISTINCT keyword.

B. Insert statements can always be done on a table through a view.

C. Views cannot be used to add rows to an underlying table if the table has columns with NOT NULL constraints lacking default values which are not referenced in the defining query of the view.

D. Delete statements can always be done on a table tough a view.

E. Views cannot be used to query rows from an underlying table if the table has a PRIMARY KEY and the PRIMARY KEY columns are not referenced in the defining query of the view.

F. WITH CHECK clause has no effect when deleting rows from the underlying table through the view.

A. All user actions are recorded in the data dictionary.

B. The SYS user owns all base tables and user-accessible views in the data dictionary.

C. The data dictionary is constantly updated to reflect changes to database objects, permissions, and data.

D. All users have permissions to access all information in the data dictionary by default

E. Base tables in the data dictionary have the prefix DBA_.