Which two statements are true about Oracle Data Pump? (Choose two.)

• A. It cannot be used to export data as of a previous SCN.
• B. The DBMS_DATAPUMP package can be used only with Data Pump clients
• C. impdp can change target data file names, schemas, and tablespaces during import.
• D. expdp and impdp are its client components.
• E. impdp always uses conventional path inserts when importing data.

You execute this command to connect to an instance from a client on a different machine:
CONNECT username/password@net_service_name
No name servers are configured.
Which two are true about net_service_name? (Choose two.)

• A. It must contain only one address protocol for one listener.
• B. It must be defined in the tnsnames.ora file on the client side.
• C. It must have the same name as the SERVICE_NAME defined in it.
• D. It must contain the address protocol for only one listener.
• E. It must be defined in the tnsnames.ora file on the server side.

The ORCL database has DEFERRED_SEGMENT_CREATION set to TRUE.
UNDOTBS2 is the active undo tablespace.
Examine these commands:

USER1 executes DML, which generates more than 2 MB of UNDO.
What is the result and why?

• A. It returns an error because UNDOTBS2 is fixed size and has RETENTION GUARANTEE.
• B. It suspends the transaction, which can be resumed by setting UNDOTBS1 as the active undo tablespace.
• C. It suspends the transaction, which can be resumed by increasing USER1's quota on UNDOTBS2.
• D. It returns an error because UNDOTBS2 is fixed size.
• E. It returns an error because UNDOTBS2 has RETENTION GUARANTEE.
• F. It suspends the transaction, which can be resumed by increasing the size of UNDOTBS2.

You want to use table compression suitable for OLTP that will:
1. Compress rows for all DML statements on that table
2. Minimize the overheads associated with compression.
Which compression option is best suited for this?

• A. ROW STORE COMPRESS BASIC
• B. COLUMN STORE COMPRESS FOR QUERY LOW
• C. ROW STORE COMPRESS ADVANCED
• D. COLUMN STORE COMPRESS FOR ARCHIVE LOW
• E. COLUMN STORE COMPRESS FOR ARCHIVE HIGH

Which two are true about direct path load?

• A. It fires insert triggers, if any.
• B. DML statements may occur on tables being loaded.
• C. It enforces only primary key, unique, and not NULL, constraints.
• D. It uses the database buffer cache.
• E. It writes only to blocks above the high-water mark.