Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP

Question 1

You want to migrate your Oracle 11g database as a pluggable database (PDB) in a multitenant container database (CDB).
Examine the steps required to perform the migration:
1. Use Data Pump export to perform a full transportable export on the source database with the export parameter VERSION=12.
2. Place all tablespaces in read-only mode on the source database.
3. Upgrade the source database to Oracle Database 12c.
4. Copy the dump file and data files to the desired location in the target database.
5. Create a new PDB in the target CDB.
6. Synchronize the PDB on the target CDB.
7. Use Data Pump import on the new PDB by using the full transportable import options.
Identify the required steps in the correct order.
Choose the best answer.

A. 2, 1, 3, 5, 7, and 6

B. 3, 2, 5, 1, 4, and 7

C. 2, 5, 1, 4, 7, and 6

D. 1, 5, 4, 7, and 6

Correct Answer: C

Question 2

Which two statements are true about RMAN duplexed backups? (Choose two.)

A. It is not supported for image copies.

B. Duplex backups can be performed on either disk or media, but cannot be performed on media and disk simultaneously.

C. For performing duplexed backups, the parallelism for the device must be set equal to the number of copies.

D. It is only supported for backups to tape via media management interface.

E. Duplex backups can contain only data files and control files.

Correct Answer: A,B

Question 3

Which three statements are true about Oracle Restart?

A. While starting any components, it automatically attempts to start all dependencies first and in proper order.

B. It can be used to only start Oracle components.

C. It runs periodic check operations to monitor the health of Oracle components.

D. It can be configured to automatically attempt to restart various components after a hardware or software failure.

E. It can be configured to automatically restart a database in case of normal shutdown of the database instance.

Correct Answer: A,C,D

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 4

You created a tablespace with this statement:
CREATE BIGFILE TABLESPACE adtbs
DATAFILE '/proddb/data/adtbs.dbf' SIZE 10G;
The tablespace is nearly full and you need to avoid any out of space errors for the load of a 5 gig table.
Which two alter statements will achieve this?

A. ALTER TA3LESPACE adtbs ADD DATAFILE;

B. ALTER TA3LESPACE adtbs ADD DATAFILE '/proddb/data/adtbsl.dbf' SIZE 1QG;

C. ALTER TA3LESPACE adtbs MODIFY DATAFILE '/proddb/data/adtbs.dbf AUTOEXTEND ON;

D. ALTER TA3LESPACE adtbs RESI2E 20G;

E. ALTER TABLESPACE adtbs AUTOEXTEND ON;

Correct Answer: D,E

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 5

LDAP_DIRECTORY_SYSAUTH is set to YES.
Users requiring DBAs access have been granted the sysdba enterprise role in Oracle Internet Directory(OID).
SSL has been configure for the database and OLD and the password file has been configured for the database.
User scott with sysdba privilege tries to connect remotely using this command:
$sqlplusscott/tiger@DB0l As sysdba where DB01 is the net service name.
Which authentication method will be attempted first?

A. authentication by using certificates over SSL

B. authentication by using the Oracle Internet Directory

C. authentication by password file

D. authentication by using the local OS of the database server

Correct Answer: C

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 6

Examine the RMAN command:
RMAN> BACKUP VALIDATE DATABASE;
Which statement is true about the execution of the command?

A. The command checks for blocks containing all zeros, an invalid checksum, or a corrupt block header.

B. Block change tracking must be enabled before executing this command.

C. The command checks for blocks that contain a valid checksum and matching headers and footers, but that has logically inconsistent contents.

D. The database must be running in archivelog mode for the successful execution of this command.

E. A complete database backup must exist before executing this command.

Correct Answer: A

Question 7

Your multitenant container database (CDB) cdb1 that is running in archivelog mode contains two pluggable databases (PDBs), pdb2_1 and pdb2_2. RMAN is connected to the target database pdb2_1.
Examine the command executed to back up pdb2_1:
RMAN> BACKUP DATABASE PLUS ARCHIVELOG;
Which statement is true about the execution of this command?

A. It fails because the pluggable clause is missing.

B. It fails because archive log files cannot be backed up using a connection to a PDB.

C. It succeeds and all data files belonging to PDB2_1 are backed up along with the archive log files.

D. It succeeds but only the data files belonging to the PDB2_1 pluggable database are backed up.

Correct Answer: D

Question 8

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 unmount state.

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

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

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

Correct Answer: D

Question 9

Which two statements are true about unified auditing?

A. Unified auditing is enabled by setting the audit_trail parameter to db, extended.

B. A unified audit trail captures audit information from unified audit policies and audit settings.

C. Audit records are created only for the DML and DDL operations performed on database objects.

D. A unified audit trail resides in a read-only table in the audsys schema in the system tablespace.

E. Audit records are created for all users except sys.

F. Unified auditing is enabled by executing make-fins_rdbms.mk uniaud_onioracle ORACLE_HOME=SORACLE_HOME.

Correct Answer: B,F

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 10

Consider the following scenario for your database:
-Backup optimization is enabled in RMAN.
-The recovery window is set to seven days in RMAN.
-The most recent backup to disk for the tools tablespace was taken on March 1, 2015.
-The tools tablespace is read-only since March 2, 2015.
On March 15, 2015, you issue the RMAN command to back up the database via the Media Manager Interface.
Which statement is true about the backup of the tools tablespace?

A. RMAN creates a backup of the tools tablespace because backup optimization is applicable only for the backups written to media.

B. The RMAN backup fails because the tools tablespace is read-only.

C. RMAN skips the backup of the tools tablespace because backup optimization is enabled.

D. RMAN creates a backup of the tools tablespace because no backup of the tablespace exists within the seven-day recovery window.

Correct Answer: D

Question 11

In the SPFILE, UNDO TABLESPACE is Set to UNDO TBS.
You rename the undotbs undo tablespace:
ALTER TABLESPACE undotbs RENAME TO undotbs_old;
Which statement is true?

A. The tablespace will be renamed and a message written to the alert log indicating that you should change the corresponding initialization parameter.

B. The tablespace will be renamed and all the changes will be logged in the alert log.

C. The statement will fail because you cannot rename an undo tablespace.

D. The tablespace will be renamed but the data file headers will not be updated.

E. You must set the undo_tablespace parameter to some other tablespace name before renaming undotbs.

Correct Answer: B

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

Latest Update

Useful Links

Contact Us