Oracle Oracle Database 1Z0-072 Questions & Answers

• Question 1:

  As the DBA, you execute this command:

  

  BROWN then executes this command:

  

  GRANT SELECT ON hr.emp TO scott WITH GRANT OPTION;

  Which is true?

  A. You can revoke only WITH GRANT OPTION from BROWN.

  B. BROWN can revoke only WITH GRANT OPTION from SCOTT.

  C. When you revoke the SELECT privilege from BROWN, it is automatically revoked from SCOTT.

  D. When you revoke the SELECT privilege from BROWN, nothing is revoked from SCOTT.

  E. When you revoke the SELECT privilege from BROWN, only the WITH GRANT OPTION is revoked from SCOTT.

  Correct Answer: B

• Question 2:

  Which two are true about roles? (Choose two.)

  A. The ALTER USER statement must be used to set specific default roles for a user.

  B. A role must be disabled before it can be revoked from a user.

  C. The SET ROLE statement can be used once per session.

  D. The SET ROLE statement enables as well as disables roles in a session.

  E. All privileges and roles granted to a user are enabled by default when the user logs in.

  Correct Answer: DE

• Question 3:

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

  A. a user error such as dropping the wrong table

  B. network interface card (NIC) failure

  C. user process failure

  D. statement failure

  E. media failure

  Correct Answer: ACE

• Question 4:

  Which two are true about instance recovery? (Choose two.)

  A. It is guaranteed to complete within fast_start_mttr_target number of seconds.

  B. Archived REDO log files are required to perform instance recovery.

  C. The database opens after the roll forward phase of instance recovery.

  D. It is performed when mounting a database.

  E. Archived REDO log files are never required to perform instance recovery.

  F. It occurs after a SHUTDOWN IMMEDIATE.

  Correct Answer: AC

• Question 5:

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

  A. The database must have FLASHBACK enabled in order to perform it.

  B. It is possible only when the database is in MOUNT state

  C. Uncommitted transactions will be rolled back after it completes.

  D. Incremental backups can be used to roll forward the database while performing it.

  E. Only RMAN backupsets can be used to restore a database as part of it.

  Correct Answer: AB

• Question 6:

  Which two are true about conventional path SQL load? (Choose two.)

  A. It does not generate UNDO.

  B. It cannot load data into clustered tables.

  C. It locks objects being processed.

  D. It enforces referential integrity constraints.

  E. It always generates redo.

  Correct Answer: AD

• Question 7:

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

  A. decreasing Mean Time Between Failures (MTBF) by configuring FLASHBACK mode

  B. implementing FLASHBACK DATA ARCHIVE to decrease MTBF

  C. ensuring that critical components are protected by implementing redundancy

  D. decreasing Mean Time to Recover (MTTR) by configuring FLASHBACK mode

  E. implementing FLASHBACK DATA ARCHIVE to decrease MTTR

  Correct Answer: CD

• Question 8:

  Which two are true about instance recovery for a database that is open in read write mode? (Choose two.)

  A. It is guaranteed to complete within fast_start_mttr_target number of seconds.

  B. No users can log on until instance recovery has completed.

  C. Only the CURRENT REDO log group is required to perform instance recovery.

  D. It is always performed when opening a database.

  E. It always occurs during instance startup performed immediately after a SHUTDOWN ABORT.

  F. The database opens after the roll forward phase of instance recovery has completed.

  Correct Answer: DE

• Question 9:

  Which two operations can be performed on external tables? (Choose two.)

  A. creating invisible indexes

  B. creating views

  C. creating partitions

  D. creating public synonyms

  E. executing UPDATE statements

  Correct Answer: BD

  Reference: https://oracle-base.com/articles/9i/external-tables-9i

• Question 10:

  DATADIR1 and DATADIR2 are database directory objects.

  Examine this command: Which two are true about the expdp operation? (Choose two.)

  

  A. It creates a dump file for the entire database.

  B. It fails if the total size of the dump file is more than 2 GB.

  C. It creates a dump file only for objects in the SYSTEM schema.

  D. It creates a master table to store details of the export operation.

  E. It starts only when four worker processes are available.

  Correct Answer: AE

  Reference: https://docs.oracle.com/database/121/SUTIL/GUID-1E134053-692A-4386-BB77153CB4A6071A.htm#SUTIL887