Oracle 1Z0-072 Online Practice Questions and Exam Preparation

Oracle 1Z0-072 Online Questions & Answers

• Question 1:

  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
  A. a user error such as dropping the wrong table
  C. user process failure
  E. media failure

• 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.
  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.

• Question 3:

  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.
  B. BROWN can revoke only WITH GRANT OPTION from SCOTT.

• Question 4:

  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.
  D. It is always performed when opening a database.
  E. It always occurs during instance startup performed immediately after a SHUTDOWN ABORT.

• Question 5:

  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
  C. ensuring that critical components are protected by implementing redundancy
  D. decreasing Mean Time to Recover (MTTR) by configuring FLASHBACK mode

• 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.
  A. It does not generate UNDO.
  D. It enforces referential integrity constraints.

• Question 7:

  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.
  A. The database must have FLASHBACK enabled in order to perform it.
  B. It is possible only when the database is in MOUNT state

• Question 8:

  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.
  A. It is guaranteed to complete within fast_start_mttr_target number of seconds.
  C. The database opens after the roll forward phase of instance recovery.

• Question 9:

  In the ORCL database, USER1 has unlimited quota on TBS1 and TBS2.

  The USER1.EMP table with primary key EMP_ENO_PK resides in TBS1.

  USER1.EMP_IDX residing in TBS2 is an index on U1.EMP.ENAME.

  TBS1 is exported from ORCL by using this command:

  

  The TESTDB database has a TBS1 tablespace but no TBS2. The SYSTEM user in TESTDB executes this command:

  

  What is the result and why?

  A. It imports EMP, EMP_ENO_PK, and the unique index associated with EMP_ENO_PK and EMP_IDX.
  B. It imports only EMP, EMP_ENO_PK, and the unique index associated with EMP_ENO_PK.
  C. It fails because TESTDB has TBS1.
  D. It imports only EMP.
  E. It fails because TESTDB does not have TBS2 to create EMP_IDX.
  B. It imports only EMP, EMP_ENO_PK, and the unique index associated with EMP_ENO_PK.

• Question 10:

  Which statement is true about database links?

  A. Private database link creation requires the same user to exist in both the local and the remote database.
  B. A database link can be created only between Oracle databases.
  C. A public database link can be used by a user in the local database to connect to any schema in the remote database.
  D. A database link created in a database allows a connection from that database instance to another, but not vice versa.
  E. A public database link can be created only by SYS.
  D. A database link created in a database allows a connection from that database instance to another, but not vice versa.