Oracle Oracle Database 1Z0-067 Questions & Answers

• Question 11:

  You are performing regular backups of your production database by using a recovery catalog.

  You add two new tablespaces to your production database after performing a backup. They must be

  included in future backups. Which action should you perform?

  A. Synchronize the recovery catalog with the target database control file

  B. Add the tablespaces in the recovery catalog by using the CATALOG command

  C. Synchronize all the physical data files with the logical records in the recovery catalog by using the CROSSSCHECK command

  D. Create a new database incarnation record

  Correct Answer: A

• Question 12:

  Your database is running in ARCHIVELOG mode. You use RMAN to take image copies and you update these copies incremental every six hours. After a regular maintenance task, when you attempt to restart the instance, it halts in MOUNT state with an error indicating that one of the data files belonging to the EXAMPLE tablespace is lost. You want to recover the data file as quickly as possible while maximizing availability for the database. Examine the possible steps involved in the recovery process:

  1.

  Mount the database

  2.

  Take the data file offline

  3.

  Bring the tablespace online

  4.

  Use the RMAN SWITCH command to switch to the image copy

  5.

  Recover the tablespace

  6.

  Open the database

  7.

  Use the RMAN RESTORE command to switch to the image copy

  Identify the correct sequence of the required steps:

  A. 2, 7, 5, 3

  B. 2, 4, 5, 3, 6

  C. 1, 2, 4, 6, 3

  D. 1, 2, 7, 5, 3, 6

  E. 2, 6, 4, 5, 3

  Correct Answer: E

• Question 13:

  Examine the RMAN commands:

  RMAN> CONNECT TARGET "sbu@prod AS SYSBACKUP"; RMAN> CONNECT AUXILIARY "sbu@dup_db AS SYSBACKUP"; RMAN> DUPLICATE TARGET DATABASE TO dup_db FROM ACTIVE DATABASE PASSWORD FILE SECTION SIZE 400M;

  Which statement is true about the DUPLICATE command?

  A. It succeeds and creates multisection backup sets that are used for active database duplication

  B. It fails because there is no connection to a recovery catalog

  C. It succeeds only if the target database is in MOUNT state

  D. It fails because no parallel channels are allocated for the auxiliary database

  Correct Answer: A

• Question 14:

  You use multiple temporary tables frequently in your database. Which two are benefits of configuring temporary undo? (Choose two.)

  A. Temporary undo reduces the amount of undo stored in undo tablespaces

  B. Performance improves because less redo is written to the redo log

  C. Performance improves because no redo and undo are generated for the temporary tables

  D. Performance improves because data manipulation language (DML) operations performed on temporary tables do not use the buffer cache

  Correct Answer: AB

• Question 15:

  Examine this command:

  SQL>ALTER SYSTEM SET db_securefile = `IGNORE';

  Which statement is true?

  A. It forces SecureFiles to be created even if the BASICFILE option is specified

  B. It forces SecureFiles to be created using default values and ignores any SECUREFILE parameters

  C. It forces BasicFiles to be created even if the SECUREFILE option is specified

  D. It ignores the SECUREFILE option only if storing the LOB segment in a Free List managed tablespace

  Correct Answer: C

• Question 16:

  The SYS user creates this job:

  

  Which two statements are true about this job? (Choose two.)

  A. It executes with the privileges of SYS

  B. It is automatically dropped after the last run

  C. The globalization environment that exist at job creation is used run time

  D. It executes with the privileges of OPS

  Correct Answer: AB

• Question 17:

  Which three statements are true about transportable databases? (Choose three.)

  A. The transported database must have the same database identifier (DBID) as the source database

  B. Recovery Manager (RMAN) is used to convert the necessary data files of a database if the endian format of the target platform is different

  C. The COMPATIBLE parameter must be set to 10.0.0 or higher and the database must be opened in read-only mode before being transported

  D. Redo logs and control files are also transported

  E. Both the source and target databases must use the same character set

  Correct Answer: BCD

• Question 18:

  Which statement is true about unified auditing?

  A. The unified audit trail contains audit records only from unified audit policies and AUDIT settings

  B. Only the CREATE, ALTER, and DROP statements are audited for all users, including SYS

  C. Unified auditing is enabled only if the AUDIT_TRAIL parameter is set to NONE

  D. The unified audit trail, by default, resides in a read-only table in the AUDSYS schema in the SYSAUX tablespace

  Correct Answer: D

• Question 19:

  Examine Exhibits: Exhibit1

  

  and Exhibit2.

  

  Both processes use an existing job template PROG_1 Jobs elapsed times are recorded in table TEST_LOG.

  Why is job creation in Exhibit1 faster than in Exhibit2?

  A. It creates jobs in memory only

  B. It writes compressed job metadata to disk

  C. It creates less job metadata

  D. It updates tables in the SYSTEM tablespace instead of creating new tables

  Correct Answer: D

• Question 20:

  You execute the command to recover your database.

  

  Which statement is true?

  A. It restores all data files from the specified time, and then applies the redo logs

  B. It restores all data files, redo log files, and control files, and then applies the redo logs up to the specified time

  C. It restores all data files and control files from the most recent backup taken before the "until time", and then recovers up to the "until time" using any restored archieve logs that are needed to complete the task

  D. It restores the control file and all data files from the most recent backup, and then applies the redo logs up to the "until time".

  Correct Answer: C