The HR.DEPARTMENTS table is the parent of the HR.EMPLOYEES table. The EMPLOYEES.DEPARTMENT_ID column has a foreign key constraint with the ON DELETE CASCADE option that refers to the DEPARTMENTS.DEPARTMENT_ID column. An index exists on the DEPARTMENTS.DEPARTMENT_ID column. A transaction deletes a primary key in the DEPARTMENTS table, which has child rows in the EMPLOYEES table.
Which statement is true?

• A.The transaction acquires a table lock on the DEPARTMENTS table. This lock enables other sessions to query but not update the DEPARTMENTS table until the transaction on the DEPARTMENTS table is complete.
• B.The transaction acquires a table lock on the EMPLOYEES table. This lock enables other sessions to query but not update the EMPLOYEES table until the transaction on the DEPARTMENTS table is complete.
• C.Only the rows that are deleted in the DEPARTMENTS and EMPLOYEES tables are locked until the transactions on the DEPARTMENTS table is complete.
• D.The transaction acquires a table lock only on the DEPARTMENTS table until the transaction is complete.

Comment: *

Name: *

Email: *

Verification: *

You create an Oracle 12c database and then import schemas that are required by an application which has not yet
been developed.
You want to get advice on creation of or modifications to indexes, materialized views and partitioning in these
schemas.
What must you run to achieve this?

• A.SQL Tuning Advisor
• B.SQL Access Advisor with a SQL tuning set
• C.SQL Performance Analyzer
• D.Automatic Database Diagnostic Monitor (ADDM) report
• E.SQL Access Advisor with a hypothetical workload

Comment: *

Name: *

Email: *

Verification: *

You are connected using SQL* Plus to a multitenant container database (CDB) with SYSDBA privileges and execute the following sequence statements:

What is the result of the last SET CONTAINER statement and why is it so?

• A.If fails because the SET CONTAINER statement cannot be used with PDB$SEED as the target pluggable database (PDB).
• B.It fails because common users are unable to use the SET CONTAINER statement.
• C.It fails because local users are unable to use the SET CONTAINER statement.
• D.It succeeds because the PDB_ADMIN user has the required privileges.

Comment: *

Name: *

Email: *

Verification: *

You performed an incremental level 0 backup of a database:
RMAN > BACKUP INCREMENTAL LEVEL 0 DATABASE;
To enable block change tracking after the incremental level 0 backup, you issued this command:
SQL > ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE
'/mydir/rman_change_track.f';
To perform an incremental level 1 cumulative backup, you issued this command:
RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE;
Which three statements are true?

• A.Backup change trackingwill sometimes reduce I/O performed during cumulative incremental backups.
• B.The change tracking file must always be backed up when you perform a full database backup.
• C.Block change tracking will always reduce I/O performed during cumulative incrementalbackups.
• D.More than one database block may be read by an incremental backup for a change made to a single block.
• E.The incremental level 1 backup that immediately follows the enabling of block change tracking will not read the change tracking file to discover changed blocks.

Comment: *

Name: *

Email: *

Verification: *

You want to import the schema objects of the HR user from the development database DEVDB to the production database PRODDB by using Oracle Data Pump. A database link devdb.us.oracle.com is created between PRODDB and DEVDB.
You execute the following command on the PRODDB database server:

What should you do to resolve the error?

• A.Change the dumpfile option value to [email protected].
• B.Replace the schemas option with network_1ink = devdb.us.oracle.com.
• C.Add network_link = devdb.us.oracle.com.
• D.Replace the dumpfile option with network_1ink = devdb.us.oracle.com.
• E.Add the SYSTEM user to the schemas option.

Comment: *

Name: *

Email: *

Verification: *