Free Oracle 1z1-072 Exam Dumps Questions & Answers

Which two are responsibilities of an Oracle DBA regarding database availability, backup, and recovery?

• A.  implementing FLASHBACK DATA ARCHIVE to decrease MTTR
• B.  implementing FLASHBACK DATA ARCHIVE to decrease MTBF
• C.  decreasing Mean Time Between Failures (MTBF) by configuring FLASHBACK mode
• D.  decreasing Mean Time to Recover (MTTR) by configuring FLASHBACK mode
• E.  ensuring that critical components are protected by implementing redundancy

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_WAIT
• B.  V$SESSION
• C.  V$SYSTEM_EVENT
• D.  V$SESSION_EVENT
• E.  V$SESSION_WAIT_CLASS

Which two are true about complete and incomplete recovery? (Choose two.)

• A.  The database must have FLASHBACK enabled in order to perform incomplete recovery.
• B.  Uncommitted transactions will be rolled back after complete recovery completes.
• C.  Uncommitted transactions will be rolled back after incomplete recovery completes.
• D.  Incomplete recovery is possible only when the database is open.
• E.  Only incremental backups can be used to roll forward the database while performing complete recovery.

Which three failures do not require intervention for recovery? (Choose three.)

• A.  network interface card (NIC) failure
• B.  transaction failure
• C.  media failure
• D.  user process failure
• E.  statement failure

Which two are true about direct path load?

• A.  DML statements may occur on tables being loaded.
• B.  It writes only to blocks above the high-water mark.
• C.  It fires insert triggers, if any.
• D.  It enforces only primary key, unique, and not NULL, constraints.
• E.  It uses the database buffer cache.