Oracle Oracle Certifications 1Z0-072 Questions & Answers

• Question 31:

  Which two types of files are opened by a database instance in the NOMOUNT state?

  A. control files

  B. the alert log

  C. the initialization parameter file

  D. data files

  E. online redo logs

  Correct Answer: CD

  Reference: http://www.dba-oracle.com/concepts/starting_database.htm

• Question 32:

  Which two are true about Oracle Database Cloud Service (DBCS)? (Choose two.)

  A. Third-party tools can be used with database instances in the cloud.

  B. Oracle-supplied tools can be used with database instances in the cloud.

  C. Database instances in the cloud can be accessed only by using SSH.

  D. DBCS only creates compute nodes; the Oracle Database software must be installed and the database created.

  E. Database instances in the cloud can be accessed only by using Oracle*Net.

  Correct Answer: BC

• Question 33:

  Which statement is true about an undo tablespace created using the Database Configuration Assistant (DBCA)?

  A. It contains undo only for uncommitted transactions.

  B. It is used for the FLASHBACK TABLE...TO BEFORE DROP operation.

  C. It can be recovered while the instance is open in READ WRITE mode.

  D. It must be a smallfile tablespace.

  E. It is a locally managed tablespace.

  Correct Answer: AD

• Question 34:

  A user complains about poor database performance. You suspect that the user's session is waiting for an

  event to complete.

  You want to verify this.

  Which two views may reveal for what the user's session is currently waiting? (Choose two.)

  A. V$SYSTEM_EVENT

  B. V$SESSION_EVENT

  C. V$SESSION_WAIT_CLASS

  D. V$SESSION_WAIT

  E. V$SESSION

  Correct Answer: BD

  Reference: https://blogs.oracle.com/oraclemagazine/beginning-performance-tuning-diagnose-the-past

• Question 35:

  Yom database is in ARCHIEVELOG mode. The USER)! tablespace is online in read write and no error conditions exists for any of its data files.

  You want to take USER01 offline so that all existing transactions involving objects in it can complete. What must yon do?

  A. Change its state to read only, and then take it offline with the temporary option.

  B. Take it offline with the normal option.

  C. Take it offline with the temporary option.

  D. Take it offline with the immediate option.

  E. Change its state to read only, and then take it offline with the normal option.

  F. Change its state to read only, and then take it offline with the immediate option.

  Correct Answer: E

• Question 36:

  EMP_IDX is an index on the EMP.ENO column. EMP and EMP_IDX reside in the TBS1 tablespace. During an INSERT into EMP, you get this error:

  

  Which two actions would you take to correct the space problem in TBS1 without affecting uncommitted transactions on EMP? (Choose two.)

  A. Drop and re-create EMP_IDX.

  B. Coalesce EMP_IDX.

  C. Shrink EMP.

  D. Rebuild EMP_IDX online in a tablespace with sufficient space.

  E. Shrink TBS1.

  Correct Answer: AB

• Question 37:

  Which statement is true about smallfile tablespaces?

  A. Extent location metadata is stored in the data dictionary by default.

  B. The number of data files is constrained only by the size of the storage array.

  C. Maximum file size can be set to unlimited only if the logical volume manager supports striping.

  D. Segments can span multiple tablespaces.

  E. Segments can span multiple data files.

  Correct Answer: E

  Reference: https://docs.oracle.com/database/121/CNCPT/logical.htm

• Question 38:

  In a database, the default temporary tablespace is TEMP and USER1's default tablespace is DATA. Examine these parameters:

  

  Which tablespace stores UNDO generated by USER1's DML on temporary tables?

  A. DATA

  B. SYSTEM

  C. SYSAUX

  D. TEMP

  E. UNDOTBS1

  Correct Answer: D

• Question 39:

  A user complains about poor database performance. You suspect that the user's session is losing time waiting for events to complete.

  You want to verify this.

  Which view reveals on what events a session has spent time waiting in the past?

  A. V$SESSION_WAIT_CLASS

  B. V$SYSTEM_EVENT

  C. V$SESSION

  D. V$SESSION_EVENT

  E. V$SESSION_WAIT

  Correct Answer: C

  Reference: https://blogs.oracle.com/oraclemagazine/beginning-performance-tuning

• Question 40:

  Which two are true about users who are granted SYSDBA or SYSOPER privileges? (Choose two.)

  A. Only users granted SYSDBA can query or update tables in all user schemas.

  B. Only users granted SYSDBA can take a complete backup of a database.

  C. Users granted either SYSDBA or SYSOPER connect to an instance as SYS.

  D. Users granted either SYSDBA or SYSOPER can mount or open a database.

  E. Only users granted SYSDBA can start up and shut down a database instance.

  F. Users granted either SYSDBA or SYSOPER can query data in all user schemas.

  Correct Answer: BC