Oracle 1Z0-074 PDF Study Material

Question No. 1

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

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

Question No. 2

In which situation can the optimizer choose a hash join?

• A. when a non-equijoin is used and the join column in at least one of the tables is a primary key
• B. when a non-equijoin is used and the join column for both tables is a primary key
• C. when a non-equijoin is used between a table and a sorted hash cluster
• D. when an equality operator is used
• E. when any self-join is done

Question No. 3

Which two statements are true about FLEX ASM? (Choose two.)

• A. A database instance on any node can connect to an ASM instance on any node.
• B. A separate ASM network is required.
• C. It is impossible to connect to a database instance on one node if the database password file for the same
• D. Database instances that depend on an ASM instance that is terminated fail over to a node that has a
• E. Database instances that depend on an ASM instance that is terminated connect to a surviving ASM

Question No. 4

Identify four prerequisites for issuing the RMAN RECOVER TABLE command starting from ORACLE Database

12c Release 2.

• A. The COMPATIBLE parameter must be set to 12.0 or greater.
• B. The database must be in ARCHIVELOG mode.
• C. FLASHBACK DATABASE must be enabled.
• D. RMAN must use a recovery catalog.
• E. The database must be in the READ WRITE state.
• F. RMAN can recover the table only from a backupset.
• G. An export dump file of the table must be available.
• H. There must be sufficient space to start the auxiliary instance.

Question No. 5

The In-Memory compression level is set to MEMCOMPRESS FOR QUERY HIGH.

For what purpose is this optimized?

• A. for parallel query performance only
• B. for query performance and space saving
• C. for query performance and space saving with greater bias toward space saving
• D. for query performance only
• E. for space saving only

Question No. 6

HR.EMP.EMPLOYEE_ID is the primary key of the HR.EMP partitioned table, which contains 108 rows and resides in the EXAMPLE tablespace.

HR executes this command:

SQL> CREATE TABLE employees TABLESPACE users FOR EXCHANGE WITH TABLE hr.emp;

Table created.

Which two statements are true? (Choose two.)

• A. Dependent objects of HR.EMP are automatically created for HR.EMPLOYEES.
• B. HR.EMP is moved to the USERS tablespace.
• C. The column names HR.EMP and HR.EMPLOYEES are identical.
• D. The HR.EMPLOYEES table has 108 records.
• E. HR.EMPLOYEES.EMPLOYEE_ID is the PRIMARY KEY of HR.EMPLOYEES
• F. The column order HR.EMP and HR.EMPLOYEES are identical

Question No. 7

Which statement is true about transportable tablespaces?

• A. The tablespace data file or data files to be plugged in to the target database cannot have a different block size than any of the source database's data file or files.
• B. The cannot be dictionary-managed tablespaces
• C. The source tablespace can be encrypted
• D. They can be administrative tablespaces such as SYSTEM or SYSAUX