Free Oracle 1z1-067 Practice Test & Real Exam Questions

Exam Code/Number: 1z1-067
Exam Name/Title: Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP
Certification Provider: Oracle
Corresponding Certification: OCP

Exam Questions: 265
Updated On: Sep 04, 2026

Question #41

Which three statements are true about unplugging a pluggable database (PDB)? (Choose three.)

A. A PDB must be in MOUNT state before it can be unplugged.

B. A PDB must have been opened at least once after creation.

C. A PDB must be in closed state before it can be unplugged.

D. An unplugged PDB can be plugged into the same or another container database (CDB).

E. PDB data files are automatically removed from disk.

Discussion 0

Correct Answer: A,C,D Vote an answer

Question #42

Which three statements are true about common roles? (Choose three.)

A. A common user that is granted a common role can grant the role to other common and local users in a PDB

B. A common rule cannot be created by a local user

C. Only system privileges can be granted to a common role to a container database (CDB)

D. A common role can be granted only to a common user

E. Object privileges can be granted to a common role in a pluggable database (PDB)

Discussion 0

Correct Answer: A,B,E Vote an answer

Question #43

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

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

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

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

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

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

Discussion 0

Correct Answer: B,E Vote an answer

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

Question #44

You are connected to a recovery catalog and target database. You execute the command:
RMAN> CATALOG START WITH '/disk1/backups';
Which statement is true?

A. Only valid data file copies, existing in the /disk1/backups directory, are cataloged.

B. It lists all the data file copies, backup pieces, and archived logs cataloged in the recovery catalog in the
/disk1/backups directory and its subdirectories.

C. It lists and catalogs all valid data file copies, backup pieces, and archived logs that exist in all directory paths with the prefix /disk1/backups and their subdirectories.

D. Only valid backup pieces and archived logs, existing in the /disk1/backups directory, are cataloged.

Discussion 0

Correct Answer: C Vote an answer

Question #45

Which two are prerequisites for creating a backup-based duplicate database?

A. matching the database identifier (DBID) of the source database and the duplicate database

B. connecting to an auxiliary instance

C. creating an SPFILE for the target database

D. creating a password file for an auxiliary instance

E. connecting to the target database and a recovery catalog to execute the duplicate command

Discussion 0

Correct Answer: B,D Vote an answer

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

Question #46

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 less job metadata

B. It creates jobs in memory only

C. It writes compressed job metadata to disk

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

Discussion 0

Correct Answer: D Vote an answer

Question #47

Your database supports an online transaction processing (OLTP) workload in which one of the applications creates a temporary table for a session and performs transactions on it. This consumes a lot of undo tablespace and is affecting undo retention.
Which two actions would you take to solve this problem?

A. Increase the size of the temporary tablespace.

B. Increase the size of the redo log buffer.

C. Enable temporary undo for the database.

D. Enable Automatic Memory Management (AMM).

E. Enable undo retention guarantee.

Discussion 0

Correct Answer: A,C Vote an answer

Question #48

In your multitenant container database (CDB) that contains pluggable databases (PDBs), the hr user executes the following commands to create and grant privileges on a procedure:
CREATEORREPLACEPROCEDUREcreate_test_v(v_emp_idNUMBER,v_enameVARCHAR2,v_SALARYNU BEGIN INSERT INTO hr.test VALUES (v_emp_id, v_ename, v salary, v_dept_id); END;
/
GRANT EXECUTE ON CREATE_TEST TO John, jim, smith, king;
How can you prevent users having the execute privilege on the create_test_v procedure from inserting values into tables on which they do not have any privileges?

A. Create the create_test procedure with definer's rights.

B. Grant the execute privilege to users with grant option on the create_test procedure.

C. Create the create_test procedure as part of a package and grant users the execute privilege on the package.

D. Create the create_test procedure with invoker's rights.

Discussion 0

Correct Answer: D Vote an answer

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

Question #49

A database is running in archive log mode. The database contains locally managed tablespaces. Examine the RMAN command:
RMAN> BACKUP
AS COMPRESSED BACKUPSET
SECTION SIZE 1024M
DATABASE;
Which statement is true about the execution of the command?

A. The backup succeeds and only the used blocks are backed up with a maximum backup piece size of
1024 MB.

B. The backup fails because you cannot specify section size for a compressed backup.

C. The backup succeeds only if all the tablespaces are locally managed.

D. The backup succeeds only if the RMAN default device for backup is set to disk.

Discussion 0

Correct Answer: A Vote an answer

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

Question #50

You execute the command to recover your database.

Which statement is true?

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

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

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".

Discussion 0

Correct Answer: C Vote an answer

Download Free Oracle 1z1-067 Demo

Simply submit your e-mail address below to get started with our free demo of your Oracle 1z1-067 exam.