Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP (1z1-067) Free Practice Test

Question 1

Your database is running in ARCHIVELOG mode. You use RMAN to take image copies and you update these copies incremental every six hours.
After a regular maintenance task, when you attempt to restart the instance, it halts in MOUNT state with an error indicating that one of the data files belonging to the EXAMPLE tablespace is lost. You want to recover the data file as quickly as possible while maximizing availability for the database.
Examine the possible steps involved in the recovery process:
Mount the database
Take the data file offline
Bring the tablespace online
Use the RMAN SWITCH command to switch to the image copy
Recover the tablespace
Open the database
Use the RMAN RESTORE command to switch to the image copy
Identify the correct sequence of the required steps:

A. 1, 2, 4, 6, 3

B. 2, 7, 5, 3

C. 1, 2, 7, 5, 3, 6

D. 2, 6, 4, 5, 3

E. 2, 4, 5, 3, 6

Correct Answer: D

Question 2

You wish to create jobs to satisfy these requirements:
1. Automatically bulk load data from a flat file.
2. Rebuild indexes on the SALES table after completion of the bulk load.
How would you create these jobs?

A. Create both jobs by using Scheduler raised events.

B. Create both jobs using application raised events.

C. Create one job to rebuild indexes using Scheduler raised events and another job to perform bulk load by using events raised by the application.

D. Create one job to rebuild indexes using application raised events and another job to perform bulk load using Scheduler raised events.

Correct Answer: D

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

Question 3

You want to prevent a group of users in your database from performing long-running transactions that consume huge amounts of space in the undo tablespace. If the quota for these users is exceed during execution of a data manipulation language (DML) statement, the operation should abort and return an error. However, queries should still be allowed, even if users have exceeded the undo space limitation.
How would you achieve this?

A. Decrease the number of Interested Transaction List (ITL) slots for the segments on which these users perform transactions

B. Specify the maximum amount of quota a user can be allocated in the undo tablespace

C. Implement a Database Resource Manager plan

D. Implement a profile for these users

Correct Answer: C

Question 4

Which two statements are true about the Automatic Diagnostic Repository (ADR)?

A. The ADR can be used for problem diagnosis even when the database instance is down.

B. The ADR can be used to store statspack snapshots to diagnose database performance issues.

C. The ADR base is shared across multiple instances.

D. The ADR is used to store Automatic Workload Repository (AWR) snapshots.

E. The ADR base keeps all diagnostic information in binary format.

Correct Answer: A,C

Question 5

Before a Flashback Table operation, you execute the following command:
ALTER TABLE employees ENABLE ROW MOVEMENT;
Why would you need this to be executed?

A. Because the object number changes after the flashback operation

B. Because the rows are retrieved from the recycle bin during the flashback operation

C. Because row IDs may change during the flashback operation

D. Because the table is moved forward and back to a temporary during the flashback operation

Correct Answer: C

Question 6

Your database is running in archive log mode and Automatic Undo Management is enabled.
Which two tasks should you perform before enabling Flashback Database?

A. Enable the recyclebin.

B. Enable undo retention guarantee.

C. Enable minimal supplemental logging.

D. Enable Fast Recovery Area.

E. Ensure that the db_flashback_retention_target parameter is set to a point in time (in minutes) to which the database can be flashed back.

Correct Answer: D,E

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

Question 7

You create a table with the period for clause to enable the use of the Temporal Validity feature of Oracle Database 12c.
Examine the table definition:
create table employees
(empno number, salary number,
deptid number, name varchar2(100),
period for employee_time);
Which three statements are true concerning the use of the Valid Time Temporal feature for the EMPLOYEES table?

A. The valid time columns employee_time_start and employee_time_end are automatically created.

B. The valid time columns are visible by default when the table is described.

C. Setting the session valid time using DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME sets the visibility for data manipulation language (DML), data definition language (DDL), and queries performed by the session.

D. The valid time columns are not populated by the Oracle Server automatically.

E. The same statement may filter on both transaction time and valid temporal time by using the AS OF TIMESTAMP and PERIOD FOR clauses.

Correct Answer: A,D,E

Question 8

Which two statements are true about a multitenant architecture?

A. A PDB can have a private undo tablespace.

B. A PDB can have a private temporary tablespace.

C. Log switches occur only at the container database level.

D. Each pluggable database (PDB) has its own initialization parameter file.

E. Each PDB has a private control file.

Correct Answer: B,C

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

Question 9

What two are the prerequisites for enabling Flashback Database?

A. The database must be in ARCHIVELOG mode

B. The database instance must be started in the NOMOUNT state

C. The database must be in MOUNT EXCLUSIVE mode

D. The database instance must have the keep buffer pool defined

E. The database must be opened in RESTRICTED mode

Correct Answer: A,C

Question 10

You are administering a multitenant container database (CDB) that has no startup triggers and contains three pluggable databases (PDBs). You execute the command to start up the CDB:
SQL>STARTUP
Which statement is true?

A. CDB$ROOT and PDB$SEED are opened in read-only mode, but the PDBs are in closed mode

B. CDB$ROOT, PDB$SEED, and the PDBs are opened in read-only mode

C. CDB$ROOT, PDB$SEED, and the PDBs are opened in read/write mode

D. CDB$ROOT is opened in read/write mode, but PDB$SEED and the PDBs are in closed mode

E. CDB$ROOT is opened in read/write mode, PDB$SEED in read-only mode, and the PDBs in MOUNT state

Correct Answer: E

Question 11

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

A. PDB data files are automatically removed from disk.

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

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

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

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

Correct Answer: B,D,E

Welcome to TestSimulate

Oracle Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP (1z1-067) Free Practice Test