Oracle 1Z0-072 Online Practice Questions and Exam Preparation

Oracle 1Z0-072 Online Questions & Answers

• Question 21:

  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.
  B. ADDM can recommend shrinking 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.

• Question 22:

  A database is configured to use automatic undo management with temporary undo enabled. An update is executed on a heap-organized table stored in the TBS1 tablespace. Where is the undo stored?

  A. in the SYSAUX tablespace
  B. in the undo tablespace
  C. in the redo logs
  D. in rollback segments
  E. in the temporary tablespace
  A. in the SYSAUX tablespace

• Question 23:

  When is a SID_LIST_ section required in a LISTENER.ORA file?

  A. when the listener uses multiple port numbers for different database instances
  B. when a static listener is used
  C. when a dynamic listener is used
  D. when multiple dynamic listeners are used
  E. when the list of existing database services must be defined
  B. when a static listener is used

• Question 24:

  Which is always true about privileges?

  A. Connections as SYSTEM can use only the SYSOPER privilege.
  B. Connections as SYS must be made using the SYSDBA privilege
  C. System privileges can be granted only to users.
  D. The owner of a schema is granted all object privileges within the schema by default.
  E. The SYSDBA privilege can be granted to a user or role.
  D. The owner of a schema is granted all object privileges within the schema by default.

• Question 25:

  Which is true about security rules on a compute node?

  A. The port used for HTTPS connections is enabled by default based on a predefined security rule.
  B. A security rule can restrict IP addresses that can connect to a database instance on a compute node.
  C. A new database deployment on a compute node automatically enables a set of predefined security rules.
  D. New security rules can be defined to use only the TCP protocol but multiple port numbers.
  E. A compute node port can be enabled only if it is associated with an existing security rule.
  C. A new database deployment on a compute node automatically enables a set of predefined security rules.

• Question 26:

  Which two are true about Oracle database wait events that are described in V$EVENT_NAME? (Choose two.)

  A. They reveal the cause of performance problems.
  B. They are grouped into classes.
  C. They are maintained at the session and system level.
  D. They display how often a database instance performs particular operations.
  E. All events might be used by an instance regardless of parameter settings.
  A. They reveal the cause of performance problems.
  B. They are grouped into classes.

• Question 27:

  Which two statements are true about Oracle Data Pump? (Choose two.)

  A. expdp and impdp are its client components.
  B. impdp always uses conventional path inserts when importing data.
  C. The DBMS_DATAPUMP package can be used only with Data Pump clients
  D. It cannot be used to export data as of a previous SCN.
  E. impdp can change target data file names, schemas, and tablespaces during import.
  A. expdp and impdp are its client components.
  C. The DBMS_DATAPUMP package can be used only with Data Pump clients

• Question 28:

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

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

• Question 29:

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

  The DATA tablespace uses Automatic Segment Space Management.

  Examine this query and its output:

  

  A block in EMP is 90% full.

  At what percentage of free space will INSERT operations into the block again be possible?

  A. 10%
  B. 25%
  C. 50%
  D. 75%
  E. 90%
  A. 10%