You are the DBA supporting an Oracle 11g Release 2 database and wish to move a table containing several DATE, CHAR, VARCHAR2, and NUMBER data types, and the table's indexes, to another tablespace.

The table does not have a primary key and is used by an OLTP application.

Which technique will move the table and indexes while maintaining the highest level of availability to the application?

A. Oracle Data Pump.

B. An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD to move the indexes.

C. An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD ONLINE to move the indexes.

D. Online Table Redefinition.

E. Edition-Based Table Redefinition.

You run a script that completes successfully using SQL*Plus that performs these actions:

1.

Creates a multitenant container database (CDB)

2.

Plugs in three pluggable databases (PDBs)

3.

Shuts down the CDB instance

4.

Starts up the CDB instance using STARTUP OPEN READ WRITE

Which two statements are true about the outcome after running the script? (Choose two.)

A. The seed will be in mount state.

B. The seed will be opened read-only.

C. The seed will be opened read/write.

D. The other PDBs will be in mount state.

E. The other PDBs will be opened read-only.

F. The PDBs will be opened read/write.

Which two statements are true about Oracle Managed Files (OMF)? (Choose two.)

A. OMF cannot be used in a database that already has data files created with user-specified directions.

B. The file system directions that are specified by OMF parameters are created automatically.

C. OMF can be used with ASM disk groups, as well as with raw devices, for better file management.

D. OMF automatically creates unique file names for table spaces and control files.

E. OMF may affect the location of the redo log files and archived log files.

Examine the parameter settings in your local ORCL database:

Examine the parameter settings for the remote SALES database:

As the SYS user, you issue the following command on ORCL:

CREATE PUBLIC DATABASE LINK sales.us.example.com USING `sales1';

The sales1 tnsnames entry points to the sales database instance.

Which two are requirements to ensure that you can successfully connect by using this database link? (Choose two.)

A. The GLOBAL_NAMES initialization parameter should be set to FALSE in the ORCL database.

B. The SALES1 net service name should be known to both the local and remote databases.

C. Local database users who use this database link should have accounts and the required privileges in the remote database.

D. The REMOTE_OS_AUTHENT initialization parameter should be set to FALSE in the remote database.

E. Only the user creating the database link must have an account and the required privileges in the remote database.

Your single-instance Oracle 12c database home currently supports conventional auditing and uses Automatic Storage Management (ASM). You want to enable unified auditing by executing the command:

$ make –fins_rdbms.mk uniaud_on ioracle ORACLE_HOME=$ORACLE_HOME

Which two steps should you perform before executing this command? (Choose two.)

A. Ensure that the initialization parameter AUDIT_TRAIL is set to DB.

B. Drop any existing fine-grained audit (FGA) policies.

C. Stop the listener.

D. Shut down the database instance.

E. Disable auditing by setting the initialization parameter AUDIT_TRAIL to NONE.