Oracle Oracle Database 1Z0-067 Questions & Answers

• Question 31:

  You want to perform an RMAN backup of database as a copy. Which two factors will you consider while performing the backup operation? (Choose two.)

  A. The backup as copy can only be taken to disk

  B. The backup as copy can only be taken to tape

  C. Backup can be performed only when the instance is shutdown

  D. Backup will constitute all used and unused blocks in the database

  Correct Answer: AD

• Question 32:

  Which three conditions must be met before you create a Virtual Private Catalog (VPC)?

  A. A base recovery catalog should exist.

  B. The owner of VPC cannot own recovery catalog.

  C. At least one target database should be registered in the recovery catalog.

  D. The register database privilege should be granted to the virtual catalog owner.

  E. The DBA role should be granted to the virtual catalog owner.

  Correct Answer: ADE

• Question 33:

  Which two statements describe the relationship between a window, a resource plan, and a job class? (Choose two.)

  A. A window specifies a Resource Manager plan that is automatically activated when the windows opens.

  B. A window specifies a job class that will be activated when that window opens.

  C. A job class specifies a window that will be open when that job class becomes active.

  D. A window and the job class associated with a job controls resource allocation for that job.

  E. A window and the Resource Manager plan that is active when a job runs determine the job class for the job.

  Correct Answer: AD

• Question 34:

  Identify three benefits of unified auditing.

  A. Decreased use of storage to store audit trail rows in the database.

  B. It guarantees zero-loss auditing.

  C. The audit trail cannot be easily modified because it is read-only

  D. It improves overall auditing performance.

  E. It automatically audits Recovery Manager (RMAN) events.

  Correct Answer: CDE

• Question 35:

  Your database is running on the host OUSERVER. You back up your database regularly using RMAN and the backups are cataloged in a recovery catalog. For testing purposes, you want to replicate your database to another host, OUSERVER1, with the same directory structure. So, you copy the backups to the new host. What must you do to make the database operational in OUSERVER1?

  A. Restore the data files by using the NOCATALOG option and use the SET NEWNAME command to change the location

  B. Restore the control file from the backup by using the CATALOG options, restore the data files by using the SET NEWNAME command, and recover the data files

  C. Restore the data files from the backup by using the recovery catalog, use the SWITCH command to change the location, and recover the data files

  D. Restore the control file from the backup by using the NOCATALOG option, and then restore and recover the data files

  Correct Answer: D

• Question 36:

  Which statements describe the capabilities of the DBMS_NETWORK_ACL_ADMIN package? (Choose all that apply.)

  A. It can be used to allow the access privilege settings for users but not roles.

  B. It can be used to allow the access privilege settings for users as well as roles.

  C. It can be used to control the time interval for which the access privilege is available to a user.

  D. It can be used to selectively restrict the access for each user in a database to different host computers.

  E. It can be used to selectively restrict a user's access to different applications in a specific host computer.

  Correct Answer: BCD

• Question 37:

  You perform an RMAN block media recovery on the tools 01.dbf data file in the SALES database. Which two statements are true? (Choose two.)

  A. You must ensure that the SALES database is mounted or open.

  B. You must restore a backup control file to perform a block media recovery.

  C. You must take the tools01.dbf data file offline before you start a block media recovery.

  D. You must put the database in NOARCHIVELOG mode to perform a block media recovery.

  E. You can perform only a complete media recovery of individual blocks, point-in-time recovery of individual data blocks is not supported.

  Correct Answer: AE

• Question 38:

  What two are the prerequisites for enabling Flashback Database?

  A. The database must be in ARCHIVELOG mode

  B. The database must be in MOUNT EXCLUSIVE mode

  C. The database must be opened in RESTRICTED mode

  D. The database instance must be started in the NOMOUNT state

  E. The database instance must have the keep buffer pool defined

  Correct Answer: AB

• Question 39:

  Which statements are true regarding system-partitioned tables? (Choose all that apply.)

  A. Only a single partitioning key column can be specified.

  B. All DML statements must use partition-extended syntax.

  C. The same physical attributes must be specified for each partition.

  D. Unique local indexes cannot be created on a system-partitioned table.

  E. Traditional partition pruning and partitionwise joins are not supported on these tables.

  Correct Answer: DE

• Question 40:

  ENCRYPT_TS is an encrypted tablespace that contains tables with data.

  Which statement is true regarding the effect of queries and data manipulation language (DML) statements on the encrypted data in the tables?

  A. The data is decrypted during SORT and JOIN operations.

  B. The data remains encrypted when it is read into memory.

  C. The data remains encrypted when it is stored in the redo logs

  D. The data remains encrypted in the UNDO tablespace provided that the UNDO tablespace was created with the encryption option enabled.

  Correct Answer: C