You ran this command on a source database:
$> expdp hr/hr DIRECTORY=dumpdir DUMPFILE=emp1.dmp VIEWS_AS_TABLES=emp_dept On the target database, you run this command:
$> impdp hr/hr DIRECTORY=dumpdir DUMPFILE=emp1.dmp VIEWS_AS_TABLES=emp_dept Which two statements are true? (Choose two.)

• A. The expdp operation exports all rows for tables contained in the defining query of the EMP_DEPT view
• B. The impdp operation creates EMP_DEPT as a table
• C. The expdp operation exports all rows that are displayed when querying the EMP_DEPT view with no filter
• D. The impdp operation creates separate tables for each table contained in the defining query of the EMP_DEPT view
• E. The expdp operation exports the table definitions for tables that are queried in the EMP_DEPT view.
• F. The impdp operation creates EMP_DEPT as a view

In your database, archive logging and control file autobackup are enabled.
The data files and redo log files are intact but control files are impacted due to media failure.
In which two recovery scenarios must you use the RESETLOGS option? (Choose two.)

• A. One control file copy is intact and damaged control file copies have to be restored to the default location.
• B. All copies of the control file are damaged and the auto backed up control file is used for recovery.
• C. One control file copy is intact and damaged control file copies have to be restored to a non-default location.
• D. One control file copy is intact so the spfile is changed to refer to only one copy.
• E. All copies of the control file are damaged and the CREATE CONTROLFILE statement is executed manually.

You want to create a locally managed tablespace called NEWTBS to store segments with different extent sizes.
Which set of tablespace attributes can be specified for a tablespace that satisfies the requirements?

• A. EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT UNIFORM
• B. REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
• C. EXTENT MANAGEMENT LOCAL STORAGE (INITIAL 5M MAXSIZE 10M)
• D. EXTENT MANAGEMENT LOCAL AUTOALLOCATE

Which statement is true about the Log Writer process?

• A. It writes when a user commits a transaction.
• B. It writes concurrently to all members of multiplexed redo log groups.
• C. It writes after the Database Writer process writes dirty buffers to disk.
• D. It writes when it receives a signal from the checkpoint process (CKPT).

You have the following entry in the tnsnames.ors of your hq.us.example.com host machine:

You issue the following command at the command prompt:
Sqlplus HR/HR@ORCL
Which statement is true about the connection to the ORCL database instance?

• A. The connection succeeds, provided the ORCL.us.example.com database service is registered with a listener, the listener is up, and the database is open.
• B. The connection succeeds, provided the SERVICE_NAMES initialization parameter is set to ORCL.
• C. The connection fails because the net service name does not have the suffix us.example.com.
• D. The connection succeeds, provided the NAMES.DEFAULT_DOMAIN parameter is set to us.example.com in the sqlnet.ora file on the client side.