Oracle Oracle Certifications 1Z0-067 Questions & Answers

• Question 101:

  You issue the RMAN commands:

  RMAN> CONFIGURE DEFAULT DEVICE TYPE TO disk;

  RMAN> CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COPY;

  RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;

  RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;

  Which three tasks are performed by the BACKUP DATABASE command?

  A. switching the online redo log file

  B. backing up all data files as image copies and archive log files, and deleting those archive log files

  C. backing up only the used blocks in the data files

  D. backing up all used and unused blocks in the data files

  E. backing up all archived log files and marking them as obsolete

  Correct Answer: ABD

  Reference: https://docs.oracle.com/database/121/BRADV/rcmbckba.htm#BRADV89516

• Question 102:

  As part of a manual upgrade process, after installing the software for Oracle Database 12c and preparing

  the new Oracle home, you shut down the existing single-instance database.

  Which step should you perform next to start the upgrade of the database?

  A. Start up the database instance by using the new location of the server parameter file and run the catuppst.sqi script to generate informational messages and log files during the upgrade.

  B. Start up the database instance by using the new location of the server parameter file and run the cact1.pl script from the new Oracle home to use parallel upgrade options that reduce down time.

  C. Start up the database instance by using the STARTUP UPGRADE command and gather fixed object statistics to minimize the time needed for recompilation.

  D. Start up the database instance by using the STARTUP UPGRADE command, which opens the existing database, and then performs additional upgrade operations.

  Correct Answer: D

  Reference: http://docs.oracle.com/database/121/UPGRD/upgrade.htm#CHDBHAHE

• Question 103:

  Which two statements are true about tablespaces in multitenant container databases (CDBs)?

  A. Default permanent tablespaces can be shared across pluggable databases (PDBs).

  B. The current container must be set to root to create or modify the default temporary tablespace or tablespace group for a CDB.

  C. Each PDB can have its own default temporary tablespace.

  D. The default permanent tablespace for a PDB can be changed only by a local user with the required permissions.

  E. The amount of space that each PDB can use in a shared temporary tablespace must be set at the CDB level.

  Correct Answer: BC

  References: https://oracle-base.com/articles/12c/multitenant-manage-tablespaces-in-a-cdb-and-pdb-12cr1#temporarytablespaces

• Question 104:

  When is the UNDO_RETENTION parameter value ignored by a transaction?

  A. when the data file of the undo tablespace is autoextensible

  B. when there are multiple undotablespaces available in a database

  C. when the undo tablespace is of a fixed size and retention guarantee is not enabled

  D. when Flashback Database is enabled

  Correct Answer: C

  References:

  http://docs.oracle.com/cd/B19306_01/server.102/b14231/undo.htm (undo retention, see the bullets)

• Question 105:

  Which statement is true about the loss or damage of a temp file that belongs to the temporary tablespace of a pluggable database (PDB)?

  A. The PDB is closed and the temp file is re-created automatically when the PDB is opened.

  B. The PDB is closed and requires media recovery at the PDB level.

  C. The PDB does not close and the temp file is re-created automatically whenever the container database (CDB) is opened.

  D. The PDB does not close and starts by using the default temporary tablespace defined for the CD

  Correct Answer: C

  If a temp file belonging to a PDB temporary tablespace is lost or damaged, and the user issuing the statement uses it, an error during the execution of SQL statements that require that temporary space for sorting occurs. ... The PDB can open with a missing temporary file. If any of the temporary files do not exist when the PDB is opened, they are automatically re-created. They are also automatically recreated at CDB startup.

• Question 106:

  You execute the commands on a multitenant container database CDB1 that has multiple pluggable databases:

  $ . oraenv ORACLE_SID = [oracle] ? cdb1 The oracle base for ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1 is /u01/app/oracle $ rman target /

  Recovery Manager : Release 12.1.0.0.2 - production on Fri Ju1 19 05:18:33: 2013

  Coppyright (c) 1982, 2013, oracle and/or its affiliates. All rights reserved.

  Connected to target database:CDB1 (DBID=782249327)

  RMAN>SELECT name FROMv$tablespace;

  Which statement is true about the execution of the last command?

  A. It succeeds and displays all the tablespaces that belong to the root database.

  B. It fails and returns an error because a connection is not made by using the sysdba privilege.

  C. It succeeds and displays all the tablespaces that belong to the root and pluggable databases.

  D. It fails and returns an error because SQL commands cannot be executed at the RMAN prompt.

  Correct Answer: C

• Question 107:

  Which Oracle Database component is audited by default if the Unified Auditing option is enabled?

  A. Oracle Data Pump

  B. Oracle Recovery Manager (RMAN)

  C. Oracle Label Security

  D. Oracle Database Vault

  E. Oracle Real Application Security

  Correct Answer: B

  Unlike other Oracle Database components, you do not create a unified audit policy for Oracle Recovery Manager events. The UNIFIED_AUDIT_TRAIL data dictionary view has a set of fields, whose names begin with RMAN_, that automatically record Recovery Manager-related events. References: https://docs.oracle.com/database/121/DBSEG/audit_config.htm#CHDDHEIA

• Question 108:

  In a database supporting an OLTP workload, tables are frequently updated on both key and nonkeycolumns.

  Reports are also generated by joining multiple tables.

  Which table organization or type would provide the best performance for this hybrid workload?

  A. heap table with a primary key index

  B. external table

  C. hash clustered table

  D. global temporary table

  E. index clustered table

  Correct Answer: E

  Do not cluster tables if the application joins them only occasionally or modifies their common column values frequently. Modifying a row's cluster key value takes longer than modifying the value in an unclustered table, because Oracle might need to migrate the modified row to another block to maintain the cluster. References: http://docs.oracle.com/cd/B28359_01/server.111/b28274/data_acc.htm#i7690

• Question 109:

  In your database, there are tablespaces that were read-only when the last backup was taken. These tablespaces have not been made read/write since then. You want to perform an incomplete recovery on the database by using a backup control file.

  What precaution must you take for the read-only tablespaces before performing an incomplete recovery?

  A. All the read-only tablespaces should be taken offline.

  B. All the read-only tablespaces should be restored separately.

  C. All the read-only tablespaces should be renamed to have the MISSINGnnnn format.

  D. All the read-only tablespaces should be made online with logging disabled.

  Correct Answer: A

  Take data files from read-only tablespaces offline before doing recovery with a backup control file, and

  then bring the files online at the end of media recovery.

  References:

  http://docs.oracle.com/cd/E11882_01/backup.112/e10642/osadvsce.htm#BRADV227

• Question 110:

  Examine the RMAN commands executed in your database:

  RMAN>CONFIGURE DEFAULT DEVICE TYPE TO disk; RMAN>CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO BACKUPSET; RKAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;

  You issue the command: RMAN> BACKUP DATABASE;

  Which two statements are true about the command?

  A. It performs a log switch.

  B. It creates compressed backup sets by using binary compression by default.

  C. It backs up only the used blocks in data files.

  D. It backs up data files, the control file, and the server parameter file.

  E. It creates a backup of only the control file whenever the database undergoes a structural change.

  Correct Answer: CD

  C: RMAN backup sets automatically use unused block compression.

  D: If CONFIGURE CONTROLFILE AUTOBACKUP is ON (by default it is OFF), then RMAN automatically backs up the control file and server parameter file after every backup and after database structural changes. Not E: spfile is also backed up. References: http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta007.htm#i1015382 http://docs.oracle.com/cd/B19306_01/backup.102/b14192/bkup003.htm#i1009642