1z1-074 Exam Training Practice Tests (Oracle Upgrade Oracle DBA 11g or 12c to 12c R2)]

Question 1

Which three statements are true about the deferred invalidation clause in DDL statements? (Choose three.)

A. It defers invalidating dependent cursor when possible. B. It cannot be used for creating a secondary index on index organized tables C. The CURSOR_INVALIDATION parameter always overrides the deferred invalidation clause. D. It cannot be used for bitmap index creation. E. It always overrides the CURSOR_INVALIDATION setting.

Correct Answer: A,B,C

Question 2

Which two are true about tables recovered by using the RMAN RECOVER TABLE command or the command itself, starting from Oracle Database 12c Release 2? (Choose two.)

A. They must be un-partitioned tables B. They can be recovered by RMAN without an AUXILIARY instance C. They may be recovered to a schema in a different PDB D. They may be recovered to a different schema in the same pluggable database (PDB) E. An AUXILIARY instance is started only if there is sufficient disk space

Correct Answer: D,E

Question 3

Users BIXBY, RLAYTON, and MURDOK each have a table named CUST_RECORDS in their schema.
BIXBY has created a procedure, UPDATE_CUST, which updates the CUST_RECORDS table with invoker's right.
BIXBY grants the execute permission on UPDATE_CUST to the RLAYTON user.
When RLAYTON executes the UPDATE_CUST procedure, which table does the procedure attempt to update?

A. CUST_RECORDS table in Rlayton's schema B. CUST_RECORDS table in the schema of Bixby and Rlayton C. CUST_RECORDS table in the schema of Bixby, Rlayton, and Murdok D. CUST_RECORDS table in Murdok's schema E. CUST_RECORDS table in Bixby's schema

Correct Answer: A

Question 4

In a Database Cloud Service (DBCS) environment, which pre-created user has sudo privileges to run certain root commands?

A. oinstall B. grid C. oracle D. nobody E. opc

Correct Answer: E

Question 5

Which three statements are true about the Automatic Database Diagnostic Monitor (ADDM)? (Choose three.)

A. It analyzes only the components and waits that are impacting database performance. B. It determines the segments on which waits are occurring when the database has a high number of buffer busy waits. C. It recommends implementing SQL profiles to generate better execution plans. D. It analyzes the performance of the database instance based on the latest two AWR snapshots. E. It determines SQL statements that are performing poorly. F. It analyzes only those memory components of the database instance that are impacting performance.

Correct Answer: B,D,E

Question 6

Which three statements are true about the SQL Performance Analyzer? (Choose three.)

A. It always executes triggers that are fired recursively in FULLDML mode. B. It compares and analyzes execution plans for the SQL statements in a SQL Tuning Set (STS). C. It recommends the creation of indexes for regressed SQL statements. D. It recommends the use of SQL Tuning Advisor for regressed SQL statements. E. It generates execution plans for each SQL statement in an STS.

Correct Answer: B,D,E

Question 7

You create a refreshable copy PDB, PDB_COPY, from the PDB_ORG PDB by using the REFRESH MODE EVERY 5 MINUTES clause.
What happens every five minutes?

A. PDB_COPY is automatically closed provided there is no ongoing transaction in PDB_ORG and then reopened as read-only after the refresh is complete. B. An automatic refresh is done provided PDB_COPY is in read-only mode; otherwise the refresh is deferred and attempted again after five minutes. C. An automatic refresh is done provided PDB_COPY is closed; otherwise the refresh is differed and attempted again after five minutes. D. PDB_COPY'S state is automatically changed to read-only and then reopened as read-write after the refresh is complete. E. PDB_COPY'S state is automatically changed to read-write and back to read-only after the refresh is complete.

Correct Answer: B

Question 8

Which three resources can be controlled or managed by using Oracle Database Resource Manager? (Choose three.)

A. number of parallel queries issued by a consumer group B. UNDO quota for a consumer group C. sessions that are not blocking other sessions D. sessions that are blocking other sessions E. maximum number of DML operations performed by a consumer group

Correct Answer: A,B,D

Oracle Upgrade Oracle DBA 11g or 12c to 12c R2 - 1z1-074 Exam Practice Test