1Z0-067 Exam - Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP

NEW QUESTION 1
Your database is running in archivelog mode and a nightly backup of the database, along with an autobackup of the control file, is taken by using RMAN. Because of a media failure, the SPFILE and the control files are lost.
Examine the steps to restore the SPFILE and the control file to mount the database:
1. Set DBID of the target database in RMAN.
2. Start the database instance by using the STARTUP FORCE NOMOUNT command in RMAN.
3. Restore the control files from the backup.
4. Mount the database.
5. Restore the SPFILE from the autobackup.
6. Create a PFILE from the recovered SPFILE.
7. Restart the instance in NOMOUNT state. Identify the required steps in the correct order.

• A. 1, 2, 5, 3, 6, 4
• B. 1, 2, 3, 5, 6, 4
• C. 2, 1, 5, 7, 3, 4
• D. 2, 1, 5, 6, 7, 4, 3

Answer: C

NEW QUESTION 2
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

Answer: B

Explanation: 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. https://docs.oracle.com/database/121/DBSEG/audit_config.htm#CHDDHEIA

NEW QUESTION 3
You plan to duplicate the multitenant container database (CDB) cdb1 that contains the pluggable database (PDB) SALES:
RMAN> DUPLICATE TARGET DATABASE TO cdbdup PLUGGABLE DATABASE sales
FROM ACTIVE DATABASE PASSWORD FILE
SPFILE NOFILENAMECHECK;
Which two statements are true? (Choose two.)

• A. RMAN must be connected to a recovery catalog for the execution of the command.
• B. A backup of the SALES PDB must exist before the execution of the command.
• C. The root and seed databases are included in the duplication.
• D. Only the SALES PDB is duplicated as the non-CDB CDBDUP.
• E. An auxiliary instance must have been started with the initialization parameter ENABLE_PLUGGABLE_DATABASE set to TRUE.

Answer: CE

NEW QUESTION 4
You need to perform a block media recovery on the tools01.dbf data file in your database by using Recovery Manager (RMAN).
Which two are prerequisites for performing this operation? Choose two.

• A. You must take the tools01.dbf data file offline.
• B. You must ensure that the database is mounted or open.
• C. You must use an incremental level-1 backup to restore blocks.
• D. You must configure a block change tracking file.
• E. You must have full or level-0 backups to restore block

Answer: BE

NEW QUESTION 5
Which four actions are possible during an Online Datafile Move operation?

• A. Creating and dropping tables in the datafile being moved
• B. Performing file shrink of the data file being moved
• C. Querying tables in the datafile being moved
• D. Performing Block Media Recovery for a data block in the datafile being moved
• E. Flashing back the database
• F. Executing DML statements on objects stored in the datafile being moved

Answer: ACEF

Explanation: “The good news is that Oracle 12cR1 now offers the ability to move entire datafiles between different storage locations without ever having to take the datafiles offline. The datafiles being moved remain completely accessible to applications in almost all situations, including querying against or performing DML and DDL operations against existing objects, creating new objects, and even rebuilding indexes online. Online Move Datafile (OMD) also makes it possible to migrate a datafile between non-ASM and ASM storage (or vice-versa) while maintaining transparent application access to that datafile’s underlying database objects. OMD is completely compatible with online block media recovery, the automatic extension of a datafile, the modification of a tablespace between READ WRITE and READ ONLY mode, and it even permits backup operations to continue against any datafiles that are being moved via this feature.”
http://muhammad-asif-dba.blogspot.com.br/2013/11/oracle-12c-database-online-movedatafile. html

NEW QUESTION 6
Which two are prerequisites for setting up Flashback Data Archive?

• A. Fast Recovery Area should be defined.
• B. Undo retention guarantee should be enabled.
• C. Supplemental logging should be enabled.
• D. Automatic Undo Management should be enabled.
• E. All users using Flashback Data Archive should have unlimited quota on the Flashback Data Archive tablespace.
• F. The tablespace in which the Flashback Data Archive is created should have Automatic Segment Space Management (ASSM) enabled.

Answer: DF

Explanation: http://www.dba-oracle.com/t_11g_new_enabling_fdba.htm There are a number of restrictions for flashback archives: The tablespaces used for a flashback archive must use local extent management and automatic segment space management. The database must use automatic undo management.

NEW QUESTION 7
You are administering a multitenant container database (CDB) that contains multiple pluggable databases (PDBs). RMAN is connected to CDB$ROOT.
Examine the command: RMAN> LIST FAILURE;
Which statement is true about this command?

• A. It lists failures only if RMAN is connected to a PDB.
• B. It lists failures for the CDB and all the PDBs in this CDB.
• C. It lists failures for a PDB only when RMAN is connected to a recovery catalog.
• D. It lists failures only for the CDB root databas

Answer: B

NEW QUESTION 8
You execute the RMAN commands:
RMAN> BACKUP VALIDATE DATABASE; RMAN> RECOVER CORRUPTION LIST;
Which task is performed by these commands?

• A. Corrupted blocks, if any, are repaired in the backup created.
• B. Only those data files that have corrupted blocks are backed up.
• C. Corrupted blocks in the data files are checked and repaired before performing the database backup.
• D. The database is checked for physically corrupt blocks and any corrupted blocks are repaire

Answer: D

Explanation: Reference: http://www.dba-oracle.com/t_rman_36_validate_backup.htm

NEW QUESTION 9
You created a database with DBCA by using one of the Oracle supplied templates. Which is the default permanent tablespace for all users except DBSNMP and OUTLN?

• A. USERS
• B. SYSTEM
• C. SYSAUX
• D. EXAMPLE

Answer: A

Explanation: This table space is used to store permanent user objects and dat
A. Like the TEMP table space, every
database should have a table space for permanent user data that is assigned to users. Otherwise, user objects will be created in the SYSTEM table space, which is not good practice. In the
preconfigured database, USERS is assigned the default table space, and space for all objects created by non-system users comes from this table space. For system users, the default permanent table space remains SYSTEM.

NEW QUESTION 10
You are administering a multitenant container database (CDB) CDB1 with two pluggable databases (PDBs), PDB1 and PDB2. You execute the following commands on CBD$ROOT as the SYS user: SQL> CREATE USER c##scott IDENTIFIED BY scottorcl1;
SQL> GRANT CREATE SESSION TO c##scott;
Which statement is true about the C##SCOTT user? Choose the best answer.

• A. It is created in all the PDBs with CREATE SESSION privilege.
• B. It is created in all the PDBs but has CREATE SESSION privilege only in CDB$ROOT.
• C. It is created and has the CREATE SESSION privilege only in a PDB that is open.
• D. It is created only in CDB$ROOT and has the CREATE SESSION privileg

Answer: D

NEW QUESTION 11
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 promp

Answer: C

NEW QUESTION 12
Your database supports a Decision Support System (DSS) workload that involves the execution of complex queries. Currently, the database is running with peak workload. You want to analyze some of the most resource-intensive statements cached in the library cache.
What must you run to receive recommendations on the efficient use of indexes and materialized views to improve query performance?

• A. SQL Performance Analyzer
• B. SQL Access Advisor
• C. SQL Tuning Advisor
• D. Automatic Workload Repository (AWR) report
• E. Automatic Database Diagnostic Monitor (ADDM)

Answer: B

Explanation: References:
http://docs.oracle.com/cd/B28359_01/server.111/b28275/tdppt_sqltune.htm#TDPPT160

NEW QUESTION 13
Examine the commands executed in the root container of your multitenant container database (CDB) that has multiple pluggable databases (PDBs):
SQL> CREATE USER c##a_admin IDENTIFIED BY orcl123; SQL> CREATE ROLE c##role1 CONTAINER=ALL;
SQL> GRANT CREATE VIEW TO C##roleI CONTAINER=ALL;
SQL> GRANT c##role1 TO c##a_admin CONTAINER=ALL; SQL> REVOKE c##role1 FROM c##a_admin;
What is the result of the revoke command?

• A. It executes successfully and the c##role1 role is revoked from the c##a_admin user only in the root container.
• B. It fails and reports an error because the container=all clause is not used.
• C. It executes successfully and the c##rocl1 role is revoked from the c##a_admin user in the root database and all the PDBs.
• D. It fails and reports an error because the comtainer=current clause is not use

Answer: B

Explanation: SQL> REVOKE c##role1 FROM c##a_admin; REVOKE c##role1 FROM c##a_admin * ERROR at line 1: ORA - 01951: ROLE ‘C##ROLE1’ not granted to ‘C##A_ADMIN’ SQL> REVOKE c##role1 FROM
c##a_admin CONTAINER=ALL; Revoke succeeded. SQL> This CREATE USER c##a_admin IDENTIFIED BY orcl123; will create common user event container is not specified.

NEW QUESTION 14
Examine the output:
SQL > ARCHIVE LOGLIST
Database log mode Archive Mode Automatic archival Enabled
Archive Destination USE_DB_RECOVERY_FILE_DEST Oldest online log sequence 376
Next log sequence to archive 378 Current log sequence 378
Which three types of files are automatically placed in the fast recovery area?

• A. Flashback data archives (FDA)
• B. Archived redo log files
• C. Control file autobackups
• D. Server parameter file (SPFILE)
• E. Recovery Manager (RMAN) backup pieces

Answer: BCE

Explanation: References: http://docs.oracle.com/cd/E11882_01/backup.112/e10642/glossary.htm#BRADV526

NEW QUESTION 15
Examine the RMAN command:
RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON; RMAN> BACKUP DATABASE PLUS ARCHIVELOG;
Which prerequisite must be met before accomplishing the backup?

• A. The password for the encryption must be set up.
• B. Oracle wallet for the encryption must be set up.
• C. All the tablespaces in the database must be encrypted.
• D. Oracle Database Vault must be enabled.

Answer: B

Explanation:
Configuration encryption will used by Transparent encryption. For transparent encryption, you will need to create a wallet, and it must be open. Transparent encryption will then occur automatically
after you have issued the CONFIGURE ENCRYPTION FOR DATABASE ON or CONFIGURE ENCRYPTION FOR TABLESPACE ON command. http://docs.oracle.com/cd/E25054_01/backup.1111/e10642/rcmbckad.htm#CEGEJABH
CONFIGURE ENCRYPTION : You can use this command to persistently configure transparent encryption. You cannot persistently configure dual mode or password mode encryption. SET ENCRYPTION : You can use this command to configure dual mode or password mode encryption at the RMAN session level.

NEW QUESTION 16
You want to reduce fragmentation and reclaim unused space for the sales table but not its dependent objects. During this operation, you want to ensure the following:

• A. i.Long-running queries are not affecte
• B. ii.No extra space is used.ii
• C. Data manipulation language (DML) operations on the table succeed at all times throughout the process.i
• D. Unused space is reclaimed both above and below the high water mar
• E. Which alter TABLE option would you recommend?
• F. DEALLOCATE UNUSED
• G. SHRINK SPACE CASCADE
• H. SHRINK SPACE COMPACT
• I. ROW STORE COMPRESS BASIC

Answer: C

Explanation: The COMPACT clause lets you divide the shrink segment operation into two phases. When you specify COMPACT, Oracle Database defragments the segment space and compacts the table rows but postpones the resetting of the high water mark and the deallocation of the space until a future time. This option is useful if you have long-running queries that might span the operation and attempt to read from blocks that have been reclaimed. The defragmentation and compaction results are saved
to disk, so the data movement does not have to be redone during the second phase. You can reissue the SHRINK SPACE clause without the COMPACT clause during off-peak hours to complete the second phase.
https://docs.oracle.com/cd/B28359_01/server.111/b28310/schema003.htm

NEW QUESTION 17
You are administering a multitenant container database (CDB).
Identify two ways to access a pluggable database (PDB) that is open in read-only mode.

• A. by using the connect statement as a local user having only the set container privilege
• B. by using easy connect
• C. by using external authentication
• D. as a common user with the set container privilege
• E. by executing the alter session set container command as a local user

Answer: BD

Explanation: Reference: https://docs.oracle.com/database/121/ADMIN/cdb_pdb_admin.htm#ADMIN13861