Oracle 1Z0-072 Online Practice Questions and Exam Preparation

Oracle 1Z0-072 Online Questions & Answers

• Question 11:

  orcl.dmp contains a full export of the ORCL database.

  This command is executed to load data from orcl.dmp into the TESTDB database:

  

  Which two are true? (Choose two.)

  A. It skips only tables that exist in both ORCL:SH and TESTDB:HR.
  B. It drops and recreates tables that exist in both ORCL:SH and TESTDB:HR.
  C. It skips all indexes of ORCL:SH and ORCL:OE.
  D. It skips only indexes that exist in both ORCL:SH and TESTDB:HR.
  E. It drops and re-creates indexes that exist in both ORCL:SH and TESTDB:HR.
  D. It skips only indexes that exist in both ORCL:SH and TESTDB:HR.
  E. It drops and re-creates indexes that exist in both ORCL:SH and TESTDB:HR.

• Question 12:

  Which two are true about Oracle recovery and data protection solutions? (Choose two.)

  A. RMAN can be used to FLASHBACK a database.
  B. RMAN can be used to roll back committed transactions.
  C. Data Recovery Advisor can be used to restore a single file from an RMAN backupset.
  D. Data Recovery Advisor can be used to validate backup strategies.
  E. Oracle Data Guard can prevent data loss caused by a site failure.
  A. RMAN can be used to FLASHBACK a database.
  E. Oracle Data Guard can prevent data loss caused by a site failure.

• Question 13:

  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
  B. creating views
  D. creating public synonyms

• Question 14:

  For which three purposes is UNDO used? (Choose three.)

  A. flashback queries
  B. B. FLASHBACK TABLE TO BEFORE DROP operations
  C. the roll forward phase of instance recovery
  D. RESTORE DATABASE operations
  E. ROLLBACK operations
  F. read consistency
  A. flashback queries
  E. ROLLBACK operations
  F. read consistency

• Question 15:

  Which two backup configurations are set by default when you choose Cloud Storage Only as the backup destination? (Choose two.)

  A. encryption of backups only for Enterprise Edition databases
  B. automatic daily full database backups
  C. RMAN incremental backups in a seven-day cycle
  D. encryption of backups only for High Performance and Extreme Performance database versions
  E. on-demand backups that need to be scheduled
  F. encryption for all backups
  C. RMAN incremental backups in a seven-day cycle
  D. encryption of backups only for High Performance and Extreme Performance database versions

• Question 16:

  Your database instance is started by using an spfile. You want to modify the value of a static initialization parameter.

  Examine these steps:

  1.

  Shut down the database instance.

  2.

  Modify the parameter in the spfile with scope = SPFILE.

  3.

  Modify the parameter in a pfile.

  4.

  Use the spfile to create a pfile.

  5.

  Use the pfile to create a spfile.

  6.

  Modify the parameter in the spfile with scope = BOTH.

  7.

  Start up the database instance.

  Which are the minimum required steps in the correct order?

  A. 2, 1, 7
  B. 1, 7, 2
  C. 1, 2, 7
  D. 6, 1, 7
  E. 1, 4, 3, 5, 7
  C. 1, 2, 7

• Question 17:

  Which three are true about Oracle Managed Files (OMF)? (Choose three.)

  A. If DB_CREATE_FILE_DEST is specified but DB_CREATE_ONLINE_LOG_DEST_n is not, the redo logs and control files are placed in DB_CREATE_FILE_DEST by default.
  B. If DB_RECOVERY_FILE_DEST is specified, at least two different locations must be specified for DB_CREATE_ONLINE_LOG_DEST_n.
  C. If only DB_CREATE_FILE_DEST is specified, only the data files and temp files are OMF.
  D. If DB_RECOVERY_FILE_DEST is specified but DB_CREATE_ONLINE_LOG_DEST_n is not, the redo logs and control files are placed in DB_RECOVERY_FILE_DEST by default.
  E. If DB_CREATE_ONLINE_LOG_DEST_1 is specified but DB_CREATE_FILE_DEST is not, the data files and temp files are placed in DB_CREATE_ONLINE_LOG_DEST_1 by default.
  F. If only DB_CREATE_ONLINE_LOG_DEST_n is specified, only the redo logs and control files are OMF.
  A. If DB_CREATE_FILE_DEST is specified but DB_CREATE_ONLINE_LOG_DEST_n is not, the redo logs and control files are placed in DB_CREATE_FILE_DEST by default.
  B. If DB_RECOVERY_FILE_DEST is specified, at least two different locations must be specified for DB_CREATE_ONLINE_LOG_DEST_n.
  F. If only DB_CREATE_ONLINE_LOG_DEST_n is specified, only the redo logs and control files are OMF.

• Question 18:

  The ORCL database has DEFERRED_SEGMENT_CREATION set to TRUE.

  UNDOTBS2 is the active undo tablespace.

  Examine these commands:

  

  USER1 executes DML, which generates more than 2 MB of UNDO.

  What is the result and why?

  A. It suspends the transaction, which can be resumed by increasing the size of UNDOTBS2.
  B. It returns an error because UNDOTBS2 is fixed size and has RETENTION GUARANTEE.
  C. It suspends the transaction, which can be resumed by increasing USER1's quota on UNDOTBS2.
  D. It returns an error because UNDOTBS2 has RETENTION GUARANTEE.
  E. It suspends the transaction, which can be resumed by setting UNDOTBS1 as the active undo tablespace.
  F. It returns an error because UNDOTBS2 is fixed size.
  F. It returns an error because UNDOTBS2 is fixed size.

• Question 19:

  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 20:

  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.