1z0-067 Oracle Exam Questions and Free Practice Test

Question 43

Which three methods can be used to create a pluggable database (PDB) in an existing multitenant container database (CDB)? (Choose three.)

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

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

C. Use PDB$SEED for creating a PDB.

D. To clone an existing PDB.

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

Correct Answer:BCD

Question 44

As part of a manual upgrade process, after installing the software for Oracle Database 12c and preparing the new Oracle home, you shut down the existing single-instance database.
Which step should you perform next to start the upgrade of the database?

A. Start up the database instance by using the new location of the server parameter file and run the catuppst.sqi script to generate informational messages and log files during the upgrade.

B. Start up the database instance by using the new location of the server parameter file and run the cact1.pl script from the new Oracle home to use parallel upgrade options that reduce down time.

C. Start up the database instance by using the STARTUP UPGRADE command and gather fixed object statistics to minimize the time needed for recompilation.

D. Start up the database instance by using the STARTUP UPGRADE command, which opens the existing database, and then performs additional upgrade operations.

Correct Answer:D

Question 45

Your database is running in ARCHIVELOG mode. Complete database backups are performed daily at midnight. A user accidently truncates an important table at 10 AM after the last backup. After that, a few important transactions are performed on the database.
Which two best methods are performed the truncated table data? (Choose two.)

A. Table Point-in-Time Recovery.

B. Database Point-in-Time Recovery

C. Tablespace Point-in-Time Recovery

D. Flashback Database

E. Flashback Transaction Backout

Correct Answer:CD

Question 46

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

A. All data files belonging to pdb2_1 are backed up and all archive log files are deleted.

B. All data files belonging to pdb2_1 are backed up along with the archive log files.

C. Only the data files belonging to pdb2_ are backed up.

D. This command gives an error because archive log files can be backed up only when RMAN is connected to the root database.

Correct Answer:C

Question 47

Examine the command:
$expdp SYSTEM FULL=YES DUMPFILE=dpump_dir1:fulll%U.dmp, dpump_dir2:full2% U.dmp, dpump_dir3:full3%U.djnp FILESIZE=400M PARALLEL=3 JOB_NAME=expfull
Which statement is true about the execution of the command?

A. It fails because the log file parameter is not specified.

B. It fails because no absolute path is specified for the log file and dump file.

C. It succeeds and exports the full database, simultaneously creating three copies of dump files at three different locations.

D. It succeeds and exports the full database, simultaneously creating three dump files at three different locations, but the total number of dump files can exceed three.

Correct Answer:D
It can create more than 3 files because you say that each file has a maximum of 400 MB. For example in my export that had 1,2 gb it created 4 files. %u makes 01, 02, 03 and so on.

Question 48

You use RMAN to take regular backups for your database. Examine the RMAN commands:
RMAN> CROSSCHECK BACKUP; RMAN> DELETE EXPIRED BACKUP;
Which statement is true?

A. All metadata pertaining to backups and archived redo log files that have exceeded the age set by the RMAN retention policy are deleted from the repository.

B. All backups that have exceeded the age set by the RMAN retention policy are deleted.

C. All metadata, for backups and archived redo log files that are recorded in the repository but do not exist on disk or media, is deleted.

D. All backups and archived redo log files that are not required for the recovery are deleted and the repository is updated.

Correct Answer:C

START 1z0-067 EXAM