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

A. A PDB must be in mount state or it must be unplugged.

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

C. The data files associated with a PDB are automatically removed from disk.

D. A PDB must be in closed state.

E. A dropped and unplugged PDB can be plugged back into the same multitenant container database (CDB) or other CDBs.

F. The backups associated with a PDB are removed.

A. transparent encryption

B. default encryption

C. password-mode encryption

D. dual-mode encryption

A. EXAMPLE

B. USERS

C. SYSAUX

D. SYSTEM

A. They can be used only for nonpartitioned tables.

B. The amount of undo retained is user controlled.

C. Fragmentation is minimized by using variable-sized chunks.

D. They support random reads and writes of encrypted LOB data.

A. A database that already exists prior to the Grid Infrastructure installation

B. Oracle Healthcheck services

C. Oracle CSSD services

D. An Oracle Net Listener that already exists prior to the Grid Infrastructure installation

E. Oracle Notification services

A. Use PDB$SEED for creating a PDB.

B. Use the DBMS_PDB package to plug a non-CDB into an existing CDB.

C. Use Enterprise Manager Database Express to create a PDB in an existing CDB.

D. To clone an existing PDB.

E. Use the DBMS_PDB package to plug a pre-Oracle 12c database into an existing CDB.

A. Shut down the instance if not already shut down, restore all data files for the entire database from the last backup, and restart the instance.

B. Shut down the instance if not already shut down, restore the corrupted data file belonging to the system tablespace from the last backup, and restart the instance.

C. Mount the database, restore all data files belonging to the system tablespace from the last backup, and open the database.

D. Shut down the instance if not already shut down, restore all data files belonging to the system tablespace from the last backup, and restart the instance.

A. 3, 1, 5, and 6

B. 2, 3, and 6

C. 2, 3, 1, and 6

D. 1, 5, and 4

E. 2, 1, 6, and 4

A. from the beginning of the current redo log file to the checkpoint position

B. from the last complete checkpoint position

C. from the beginning of the current redo log file until the instance failure

D. from the last committed transaction

E. from the most recent incremental checkpoint

A. You can use EM express to manage multiple databases running on the same server.

B. You cannot start up or shut down a database instance by using create and configure pluggable databases by using EM express.

C. By default, EM express is available for a database after database creation.

D. You can create and configure pluggable databases by using EM express.

E. You can perform basic administrative tasks for pluggable databases by using the EM express interface.

A. It improves overall auditing performance.

B. The audit trail cannot be easily modified because it is read-only

C. It automatically audits Recovery Manager (RMAN) events.

D. It guarantees zero-loss auditing.

E. Decreased use of storage to store audit trail rows in the database.

A. physical data block corruption

B. loss of a non-critical data file

C. loss of a control file

D. loss of an archived redo log file

E. logical data block corruption

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

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

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

D. switching the online redo log file

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

A. All files must be backed up as backup sets.

B. The database must be backed up as an image copy.

C. The tablespace must be taken offline.

D. The backup must be performed in mount state.