Online Access Free 1Z0-072 Practice Test

A user complains about poor database performance. You suspect that the user's session is waiting for an event to complete.
You want to verify this.
Which two views may reveal for what the user's session is currently waiting? (Choose two.)

• A.V$SESSION_EVENT
• B.V$SYSTEM_EVENT
• C.V$SESSION_WAIT_CLASS
• D.V$SESSION_WAIT
• E.V$SESSION

Which three are true about the Oracle Optimizer? (Choose three.)

• A.It will only generate SQL Plan Directives specific to a given SQL statement.
• B.It can optimize only SELECT statements.
• C.It generates execution plans for SQL statements based on relevant schema objects, system and session parameters, and information found in the Data Dictionary.
• D.It updates stale object statistics in the Data Dictionary.
• E.It can re-optimize execution plans after previous executions detect suboptimal plans.
• F.It determines the optimal table join order and method.

Examine these commands:

What is the expected result?

• A.All rows in EMP.DAT are inserted into U1.EMP but ENAME is set to NULL for the second and third rows.
• B.It fails because EMP.DAT has some records with more than three characters corresponding to U1.EMP.ENAME.
• C.Only the first and fourth rows in EMP.DAT are inserted into U1.EMP.
• D.All rows in EMP.DAT are inserted into U1.EMP but ENAME is set to ### for the second and third rows.
• E.Only the first row in EMP.DAT is inserted into U1.EMP.

You want to use table compression suitable for OLTP that will:
1. Compress rows for all DML statements on that table
2. Minimize the overheads associated with compression.
Which compression option is best suited for this?

• A.COLUMN STORE COMPRESS FOR ARCHIVE LOW
• B.ROW STORE COMPRESS ADVANCED
• C.ROW STORE COMPRESS BASIC
• D.COLUMN STORE COMPRESS FOR QUERY LOW
• E.COLUMN STORE COMPRESS FOR ARCHIVE HIGH

Which statement is true about an undo tablespace created using the Database Configuration Assistant (DBCA)?

• A.It is a locally managed tablespace.
• B.It contains undo only for uncommitted transactions.
• C.It can be recovered while the instance is open in READ WRITE mode.
• D.It must be a smallfile tablespace.
• E.It is used for the FLASHBACK TABLE...TO BEFORE DROP operation.