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.

You execute the following commands to audit database activities:

SQL > ALTER SYSTEM SET AUDIT_TRIAL=DB, EXTENDED SCOPE=SPFILE;

SQL > AUDIT SELECT TABLE, INSERT TABLE, DELETE TABLE BY JOHN By SESSION WHENEVER

SUCCESSFUL;

Which statement is true about the audit record that generated when auditing after instance restarts?

A. One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command on a table, and contains the SQL text for the SQL Statements.

B. One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command, and contains the execution plan for the SQL statements.

C. One audit record is created for the whole session if john successfully executes a SELECT, INSERT, or DELETE command, and contains the execution plan for the SQL statements.

D. One audit record is created for the whole session if JOHN successfully executes a select command, and contains the SQL text and bind variables used.

E. One audit record is created for the whole session if john successfully executes a SELECT, INSERT, or DELETE command on a table, and contains the execution plan, SQL text, and bind variables used.

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.

Examine the following steps:

A DBA grants the CREATE TABLE system privilege with ADMIN OPTION to the user SIDNEY. SIDNEY grants the CREATE TABLE system privilege to the HR user.

Which statement is true?

A. SIDNEY can revoke the CREATE TABLE system privilege only from HR, to whom he granted it.

B. HR can grant the CREATE TABLE system privilege to other users.

C. Neither SIDNEY nor HR can create new tables if the DBA revokes the CREATE TABLE privilege from SIDNEY.

D. HR still retains the CREATE TABLE system privilege if the DBA revokes the CREATE TABLE privilege from SIDNEY.