A.SELECT order_id, order_date FROM orders
WHERE order_date >
ANY
(SELECT order_date FROM orders WHERE customer_id = 101);

B.SELECT order_id, order_date FROM orders
WHERE order_date > ALL
(SELECT MAX(order_date) FROM orders ) AND customer_id = 101;

C.SELECT order_id, order_date FROM orders
WHERE order_date > ALL
(SELECT order_date FROM orders WHERE customer_id = 101);

D.SELECT order_id, order_date FROM orders
WHERE order_date > IN
(SELECT order_date FROM orders WHERE customer_id = 101);

A.A non-deferrable PRIMARY KEY or UNIQUE KEY constraint in a table automatically attempts to creates a unique index.

B.Indexes should be created on columns that are frequently referenced as part of any expression.

C.When a table is dropped, the corresponding indexes are automatically dropped.

D.For each DML operation performed, the corresponding indexes are automatically updated.

A.It applies for equijoin and nonequijoin conditions.

B.It requires column names to be the same in all tables being joined.

C.It only applies for equijoin conditions.

D.It must have primary-key and foreign-key constraints defined on the join columns.

A.INSERT statements can insert NULLS explicitly into a column.

B.UPDATE statements can have different subqueries to specify the values for each updated column.

C.INSERT INTO...SELECT...FROM statements automatically commit.

D.DELETE statements can remove multiple rows based on multiple conditions.

E.DML statements require a primary key be defined on a table.

A.It can be accessed only by the SYS user.

B.It can be used to display only constants or pseudo columns.

C.It can display multiple rows but only a single column.

D.It can display multiple rows and columns.

E.It consists of a single row and single column of VARCHAR2 data type.

F.It can be accessed by any user who has the SELECT privilege in any schema