Oracle 1Z0-072 Online Practice Questions and Exam Preparation

Oracle 1Z0-072 Online Questions & Answers

• Question 31:

  Which three statements are true about an spfile? (Choose three)

  A. It contains only static initialization parameters.
  B. It is the first file processed at instance startup.
  C. It can be edited by SYS when the database instance is shut down.
  D. It must exist for a database instance to start.
  E. It can be used to create a pfile.
  F. It contains initialization parameters whose values can be changed using the ALTER SYSTEM command.
  D. It must exist for a database instance to start.
  E. It can be used to create a pfile.
  F. It contains initialization parameters whose values can be changed using the ALTER SYSTEM command.

• Question 32:

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

  Which two statements are true about VSTABLESPACE and DBA_ TABLESPACE?

  A. VSTABLESPACE cab be queries by all users, but DBA_ TABLESPACEs cab be queries only by SYSDBA users.
  B. VSTABLESPACE is a dynamic view that is populated with data from th DBA_ TABLESPACE dictionary view.
  C. VSTABLESPACE is a dynamic view that is populated with data from the DBA_ TABLESPACES data queried only when a database is open.
  D. VSTABLESPACE and DBA_ TABLESPACES are view based on base tables in the data dictionary.
  E. VSTABLESPACE metadata is lost at shutdown, but DBA_ TABLESPACE metadata persists across shutdowns.
  D. VSTABLESPACE and DBA_ TABLESPACES are view based on base tables in the data dictionary.
  E. VSTABLESPACE metadata is lost at shutdown, but DBA_ TABLESPACE metadata persists across shutdowns.

• Question 34:

  Which two are prerequisites for shrinking a table online?

  A. It must have a unique key constraint.
  B. It must not have any referential integrity constraints.
  C. It must not have any DML triggers.
  D. It must be in a tablespace that uses Automatic Segment Space Management (ASSM) .
  E. It must have row movement enabled.
  A. It must have a unique key constraint.
  B. It must not have any referential integrity constraints.

• Question 35:

  Which two can you use to recover a dropped table? (Choose two.)

  A. FLASHBACK QUERY
  B. FLASHBACK DATABASE
  C. FLASHBACK TRANSACTION
  D. FLASHBACK TABLE TO SCN
  E. FLASHBACK DROP
  D. FLASHBACK TABLE TO SCN
  E. FLASHBACK DROP

• Question 36:

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

  In your database, you create a user, HR, and then execute this command:

  

  Which three actions can HR perform? (Choose three.)

  A. Grant the CREATE SESSION privilege without ADMIN OPTION to other users.
  B. Grant the CREATE SESSION privilege with ADMIN OPTION to other users.
  C. Execute DML statements in the HR schema.
  D. Log in to the database instance.
  E. Revoke the CREATE SESSION privilege from other users.
  F. Execute DDL statements in the HR schema.
  B. Grant the CREATE SESSION privilege with ADMIN OPTION to other users.
  D. Log in to the database instance.
  E. Revoke the CREATE SESSION privilege from other users.

• Question 38:

  Which three are true about Oracle Database backup taken with RMAN?

  A. A whole backup contains all data blocks of all data files.
  B. RMAN cannot backup REDO logs.
  C. A full backup contains all data blocks from one or more data files.
  D. An RMAN image copy can be written only to disk.
  E. Only offline backup are consistent.
  F. RMAN always includes the control file in a backup.
  C. A full backup contains all data blocks from one or more data files.
  D. An RMAN image copy can be written only to disk.
  F. RMAN always includes the control file in a backup.

• Question 39:

  Examine this command:

  

  Which two changes must you make so that TEMP_TBS is created? (Choose two.)

  A. Add the EXTENT MANAGEMENT LOCAL UNIFORM clause.
  B. Add the NOLOGGING clause.
  C. Remove the SEGMENT MANAGEMENT AUTO clause.
  D. Remove the AUTOEXTEND ON clause.
  E. Remove the ONLINE clause.
  F. Add MAXSIZE for the AUTOEXTEND ON clause.
  A. Add the EXTENT MANAGEMENT LOCAL UNIFORM clause.
  F. Add MAXSIZE for the AUTOEXTEND ON clause.

• Question 40:

  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.
  A. Drop and re-create EMP_IDX.
  B. Coalesce EMP_IDX.