A.A table owner must grant the REFERENCES privilege to allow other users to create FOREIGN KEY constraints using that table.

B.The owner of an object acquires all object privileges on that object by default.

C.An object privilege can be granted to other users only by the owner of that object.

D.An object privilege can be granted to a role only by the owner of that object.

E.The WITH GRANT OPTION clause can be used only by DBA users.

A.When a data definition language statement is executed

B.When a TRUNCATE statement is executed after the pending transaction

C.When a DELETE statement is executed

D.When a ROLLBACK command is executed

E.When a PL/SQL anonymous block is executed

A.Performance would degrade in query 2.

B.There would be no change in performance.

C.Performance would improve in query 2.

D.Performance would improve in query 2 only if there are null values in the CUST_CREDIT_LIMIT column.

A.It displays values for variables prefixed with &&.

B.It displays values for variables created by the DEFINE command.

C.It displays values for variables used only in the WHERE clause of a query.

D.It can be used only in SQL*plus.

E.It can be used in SQL Developer and SQL*Plus.

A.The CREATE TABLE AS SELECT statement 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 LIMIT for external tables is UNLIMITED.

D.ORACLE_LOADER and ORACLE_DATAPUMP have exactly the same functionality when used with an external table.