Q1. Which two statement is true concerning dropping a pluggable database (PDB)?

A. The PDB must be open in read-only mode.

B. The PDB must be in mount state.

C. The PDB must be unplugged. 

D. The PDB data files are always removed from disk.

E. A dropped PDB can never be plugged back into a multitenant container database (CDB).

View Answer

Q2. You upgraded your database from pre-12c to a multitenant container database (CDB) containing pluggable databases (PDBs).

Examine the query and its output:

Which two tasks must you perform to add users with SYSBACKUP, SYSDG, and SYSKM privilege to the password file?

A. Assign the appropriate operating system groups to SYSBACKUP, SYSDG, SYSKM.

B. Grant SYSBACKUP, SYSDG, and SYSKM privileges to the intended users.

C. Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege and the FORCE argument set to No.

D. Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege, and FORCE arguments set to Yes.

E. Re-create the password file in the Oracle Database 12c format.

View Answer

Q3. You enabled an audit policy by issuing the following statements:

SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SCOTT;

SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SYS, SYSTEM;

For which database users and for which executions is the audit policy now active? Select two.

A. SYS, SYSTEM

B. SCOTT

C. Only for successful executions

D. Only for failed executions

E. Both successful and failed executions

View Answer

Q4. 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. 

View Answer

Q5. You configure your database Instance to support shared server connections.

Which two memory areas that are part of PGA are stored in SGA instead, for shared server connection?

A. User session data

B. Stack space

C. Private SQL area

D. Location of the runtime area for DML and DDL Statements

E. Location of a part of the runtime area for SELECT statements

View Answer

Q6. You upgrade your Oracle database in a multiprocessor environment. As a recommended you execute the following script:

SQL > @utlrp.sql

Which two actions does the script perform?

A. Parallel compilation of only the stored PL/SQL code

B. Sequential recompilation of only the stored PL/SQL code

C. Parallel recompilation of any stored PL/SQL code

D. Sequential recompilation of any stored PL/SQL code

E. Parallel recompilation of Java code

F. Sequential recompilation of Java code

View Answer

Q7. On your Oracle 12c database, you Issue the following commands to create indexes

SQL > CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customers_id, sales_rep_id) INVISIBLE;

SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customers_id, sales_rep_id);

Which two statement are correct?

A. Both the indexes are created; however, only the ORD_COSTOMER index is visible.

B. The optimizer evaluates index access from both the Indexes before deciding on which index to use for query execution plan.

C. Only the ORD_CUSTOMER_IX1 index is created. 

D. Only the ORD_CUSTOMER_IX2 index is created. 

E. Both the indexes are updated when a new row is inserted, updated, or deleted In the orders table.

View Answer

Q8. Examine the parameters for your database instance:

Which three statements are true about the process of automatic optimization by using cardinality feedback?

A. The optimizer automatically changes a plan during subsequent execution of a SQL statement if there is a huge difference in optimizer estimates and execution statistics.

B. The optimizer can re optimize a query only once using cardinality feedback.

C. The optimizer enables monitoring for cardinality feedback after the first execution of a query.

D. The optimizer does not monitor cardinality feedback if dynamic sampling and multicolumn statistics are enabled. 

E. After the optimizer identifies a query as a re-optimization candidate, statistics collected by the collectors are submitted to the optimizer.

View Answer

Q9. Which two statements are true about the RMAN validate database command?

A. It checks the database for intrablock corruptions.

B. It can detect corrupt pfiles.

C. It can detect corrupt spfiles.

D. It checks the database for interblock corruptions.

E. It can detect corrupt block change tracking files.

View Answer

Q10. You upgraded from a previous Oracle database version to Oracle Database version to Oracle Database 12C.  Your database supports a mixed workload.  During the day, lots of insert, update, and delete operations are performed.  At night, Extract, Transform, Load (ETL) and batch reporting jobs are run. The ETL jobs perform certain database operations using two or more concurrent sessions.

After the upgrade, you notice that the performance of ETL jobs has degraded.  To ascertain the cause of performance degradation, you want to collect basic statistics such as the level of parallelism, total database time, and the number of I/O requests for the ETL jobs.

How do you accomplish this?

A. Examine the Active Session History (ASH) reports for the time period of the ETL or batch reporting runs.

B. Enable SQL tracing for the queries in the ETL and batch reporting queries and gather diagnostic data from the trace file.

C. Enable real-time SQL monitoring for ETL jobs and gather diagnostic data from the V$SQL_MONITOR view.

D. Enable real-time database operation monitoring using the DBMS_SQL_MONITOR.BEGIN_OPERATION function, and then use the DBMS_SQL_MONITOR.REPORT_SQL_MONITOR function to view the required information.

View Answer