Oracle Oracle Database 1Z0-067 Questions & Answers

• Question 1:

  Which three types of backups can be performed for a database running in NOARCHIVELOG mode? (Choose three.)

  A. backup of only the used blocks in a critical tablespace (SYSTEM or SYSAUX) while the database is open

  B. backup of noncritical tablespaces without shutting down the instance

  C. backup of only those blocks that have changed since the last backup while the database is mounted

  D. backup of the database without shutting down the instance

  E. consistent whole database backup

  Correct Answer: BCE

• Question 2:

  You are connected to a pluggable database (PDB) as a common user with the sysdba privilege. The PDB is open and you issue the shutdown immediate command.

  What is the outcome?

  A. The PDB is closed and left in the mount state.

  B. The PDB is closed and left in the unmount state.

  C. The command executes only if the common user is granted the set container privilege for the PDB.

  D. The command results in an error because the PDB can be shut down only by a local user.

  Correct Answer: A

• Question 3:

  In which three situations must you use a recovery catalog? (Choose three.)

  A. when you want to store RMAN global scripts that can be used across multiple databases

  B. when you want to list data files that were in a target database at a given time by using the AT clause with the REPORT SCHEMA command

  C. when you want to restrict the amount of space used by backups

  D. when you want to maintain backup metadata longer than the period specified by the CONTROL_FILE_RECORD_KEEP_TIME parameter

  E. when you want to perform incremental backups by using a block change tracking file

  Correct Answer: ABD

• Question 4:

  You execute the RMAN commands:

  RMAN> CONFIGURE DEFAULT DEVICE TYPE TO disk

  RMAN> CONFIGURE DEVICE TYPE disk PARALLELISM 2;

  RMAN> CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT "/disk/%U';

  RMAN> CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT "/disk/%U';

  RMAN> BACKUP DATABASE;

  Which statement is true about the backup set created by the BACKUP command?

  A. Two channels are allocated and two copies of the backup set are taken in parallel in both locations

  B. Two channels are allocated and backup pieces for the backup set are created in both the specified destinations

  C. The default channel is allocated and the backup set is created in only one destination

  D. Two channels are allocated and a copy of the backup set is taken in the location specified by CHANNEL 2

  Correct Answer: B

• Question 5:

  You are installing Oracle Database 12c with the Oracle Universal Installer (OUI). You select the option to create a database by using file system storage but you do not explicitly set ORACLE_BASE. What is the effect on the installation?

  A. The installation proceeds with the default value but a message is generated in the alert log file

  B. The installation terminates with an error

  C. The installation proceeds with the default value but the database creation is not attempted

  D. The software installation proceeds with the default value but database creation fails

  Correct Answer: A

• Question 6:

  Which three statements are true about Flashback Data Archieve? (Choose three.)

  A. A table enabled for Flashback Data Archieve cannot be dropped unless Flashback Data Archieve is disabled or disassociated first

  B. While enabling Flashback Data Archieve for a table, if no name is provided for Flashback Data Archieve, it is enabled using the default Flashback Data Archieve

  C. To use Flashback Data Archieve, users must have unlimited quota on the Flashback Data Archieve tablespace

  D. Flashback Data Archieve prevents flashback queries from getting a snapshot-too-old error

  E. To enable Flashback Data Archieve for a table, it is mandatory to have a default Flashback Data Archieve for a database

  Correct Answer: ACD

• Question 7:

  RMAN is configured to create backupset backups for your database. You issue the command to back up

  the database:

  RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;

  Which two statements are true about the backup performed by the command? (Choose two.)

  A. It backs up all the data files and deletes obsolete backups after the backup is complete

  B. It backs up all the archived log files and deletes the ones that were just backed up

  C. Only the used blocks in the data files are backed up

  D. It backs up all archived redo log files and online log files and deletes the archived log files after the backup is complete

  E. It backs up only those archived log files that are not backed up at least once

  Correct Answer: BC

• Question 8:

  Examine the query and its output executed in an RDBMS instance:

  

  Which three statements are true about the users (other than SYS) in the output? (Choose three.)

  A. The C##D_ADMIN user can perform backup and recovery operations for Automatic Storage Management (ASM)

  B. The C##C_ADMIN user can perform the data guard operation with Data Guard Broker

  C. The C##A_ADMIN user can perform wallet operations

  D. The C##B_ADMIN user can perform all backup and recovery operations using RMAN or SQL*Plus

  E. The C##B_ADMIN user can perform all backup and recovery operations using RMAN only

  Correct Answer: ABD

• Question 9:

  Examine the output from v$DIAG_INFO: Which statement is true about the Automatic Diagnostic Repository (ADR)?

  

  A. The SQL trace file for a session is stored in Diag Trace

  B. The text alert log is available in Diag Trace

  C. The XML version of the alert log is available in Diag Trace

  D. An Automatic Database Diagnostic Management (ADDM) report is generated and stored in the Health Monitor whenever an incident occurs

  Correct Answer: B

• Question 10:

  You enable Flashback Data Archive for a table for which you want to track and save all transactions for four years. After some time, the requirement changes for keeping transactions from four to two years. You execute the following command to change the requirement:

  SQL> ALTER FLASHBACK ARCHIVE fdal MODIFY RETENTION 2 YEAR;

  What is the outcome?

  A. An error is returned because the retention period cannot be reduced

  B. All historical data older than two years, if any, is archived to flashback logs and the flashback archive is set to new retention time

  C. All historical data older than two years, if any, is purged from the flashback archive FDA1.

  D. All the flashback data archives are purged and the subsequently created flashback archives are maintained for two years

  Correct Answer: C