A.PRIMARY KEY and FOREIGNY constraints can be specified at the column and at the table level

B.A table can have only one PRIMARY KEY but may have multiple FOREIGN KEY constraints.

C.A table can have only one PRIMARY KEY and one FOREIGN KEY constraint.

D.A table can have multiple PRIMARY KEY and multiple FOREIGN KEY constraints.

E.NOT NULL can be specified at the column and at the table level.

F.A FOREIGN KEY column in a child table and the referenced PRIMARY KEY column in the parenttable must have the same names.

A.The CREATE TABLE AS SELECTstatement can be used to upload data into regular table in the database from an external table.

B.The data and metadata for an external table are stored outside the database.

C.The default REJECT LIMITfor external tables is UNLIMITED.

D.ORACLE_LOADERand ORACLE_DATAPUMPhave exactly the same functionality when used with an external table.

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.SELECT member_id AS "MEMBER ID", due_date AS "DUE DATE", $2 AS "LATE FEE" FROM BOOKS_TRANSACTIONS;

B.SELECT member_id 'MEMBER ID', due_date 'DUE DATE', '$2 AS LATE FEE' FROM BOOKS_TRANSACTIONS;

C.SELECT member_id AS MEMBER_ID, due_date AS DUE_DATE, $2 AS LATE_FEE FROM BOOKS_TRANSACTIONS;

D.SELECT member_id AS "MEMBER ID", due_date AS "DUE DATE", '$2' AS "LATE FEE" FROM BOOKS_TRANSACTIONS;

A.PUBLIC should be replaced with specific usernames.

B.ALL should be replaced with a list of specific privileges.

C.WITH GRANT OPTION should be added to the statement.

D.Separate GRANT statements are required for the ORDERS and ORDER_ITEMS tables.