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

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

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

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

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

A.All constraints can be defined at the table or column level.

B.A column with a unique constraint can contain a null value.

C.A constraint can be disabled even if the constrained column contains data.

D.Constraints are enforced only during insert operations.

E.A column with a FOREIGN key constraint can never contain a null value.

A.They cannot have a data type explicitly specified.

B.They can be referenced in the set clause of an update statement as the name of the column To be updated.

C.They can be indexed.

D.They can be referenced in the column expression of another virtxial column.

E.They can be referenced In the where clause of an update or debete statement.

A.Views have no object number.

B.Views can join tables only if they belong to the same schema.

C.Rows inserted into a table using a view are retained in the table if the view is dropped

D.A SELECT statement cannot contain a where clause when querying a view containing a WHERE clause in its defining query

E.Views have no segment.

F.A view can be created that refers to a non-existent table in its defining query.

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

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

C.SELECT FROM customers WHERE insert date = '01-JAN-19';

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

E.SELECT. FRON customers WE TO DATE (Insert _ date) = DATE '2019-01-01';

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