Oracle Oracle Certifications 1Z0-072 Questions & Answers

• Question 81:

  Which three are true about Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), and the MMON background process? (Choose three.)

  A. AWR snapshots must be deleted when no longer required by ADDM.

  B. ADDM can recommend shrinking the buffer cache.

  C. By default, MMON creates an AWR snapshot every 30 minutes.

  D. ADDM can recommend extending the buffer cache.

  E. By default, AWR snapshots are automatically purged after eight days.

  F. ADDM performs its analysis only whenever a DBA requests it.

  Correct Answer: BEF

• Question 82:

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

  A. Incremental backups cannot be used to roll forward the database while performing it.

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

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

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

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

  Correct Answer: DE

• Question 83:

  Examine this command and its partial output:

  

  Why does the DB01.abc.com service show unknown status?

  A. The listener does not listen on the default port 1521.

  B. The SID_LIST_LISTENER section is missing in the LISTENER.ORA file.

  C. The service is dynamically registered.

  D. The service is statically registered.

  E. The LOCAL_LISTENER parameter list does not contain LISTENER_1.

  Correct Answer: B

• Question 84:

  TBS1 is a permanent user-defined tablespace created with Oracle Managed Files (OMF). Examine this command:

  

  Which is required to ensure that TBS1 is dropped and its datafiles are deleted from their file system?

  A. The INCLUDING CONTENTS AND DATAFILES clause must be added to the command.

  B. TBS1 must be placed in READ ONLY state.

  C. Objects in TBS1 must not be in use when the command is executed.

  D. TBS1 must not contain any temp files.

  E. DB_CREATE_FILE_DEST must refer to an Oracle Automatic Storage Management (ASM)disk group.

  Correct Answer: A

  Reference: https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_9004.htm

• Question 85:

  Which two tasks does DBUA perform by default? (Choose two.)

  A. setting user tablespaces to "read only" before starting the upgrade

  B. adding more data files if there is insufficient disk space for the SYSTEM tablespace during the upgrade

  C. running the Pre-Upgrade information tool

  D. starting the source database instance if not started

  E. enabling flashback in the source database if not enabled

  Correct Answer: AC

• Question 86:

  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.

  Correct Answer: F

• Question 87:

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

  A. It determines the optimal table join order and method.

  B. It generates execution plans for SQL statements based on relevant schema objects, system and session parameters, and information found in the Data Dictionary.

  C. It can optimize only SELECT statements.

  D. It will only generate SQL Plan Directives specific to a given SQL statement.

  E. It can re-optimize execution plans after previous executions detect suboptimal plans.

  F. It updates stale object statistics in the Data Dictionary.

  Correct Answer: ABC

  Reference: https://docs.oracle.com/cd/B10500_01/server.920/a96533/optimops.htm