Online Access Free 1z0-067 Practice Test

You install Oracle Grid Infrastructure for a standalone server and issue this command:
crsctl start has
Which two components get automatically added to the Oracle Restart configuration the first time this command is issued?
Choose two.

• A.An Oracle Net Listener that already exists prior to the Grid Infrastructure installation
• B.A database that already exists prior to the Grid Infrastructure installation
• C.Oracle Healthcheck services
• D.Oracle CSSD services
• E.Oracle Notification services

Which three statements are true about the database instance startup after an instance failure?

• A.Uncommitted changes are rolled back to ensure transactional consistency.
• B.Changes committed before the failure, which were not written to the data files, are re-applied.
• C.Online redo log files and archived redo log files are required to complete the rollback stage of instance recovery.
• D.Media recovery is required to complete the database recovery.
• E.The SMON process automatically performs the database recovery.
• F.The RECO process recovers the uncommitted transactions at the next instance startup.

You execute the RMAN commands:
RMAN> CONFIGURE DEFAULT DEVICE TYPE TO disk
RMAN> CONFIGURE DEVICE TYPE disk PARALLELISM 2;
RMAN> CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT "/disk/%U';
RMAN> CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT "/disk/%U';
RMAN> BACKUP DATABASE;
Which statement is true about the backup set created by the BACKUP command?

• A.The default channel is allocated and the backup set is created in only one destination
• B.Two channels are allocated and backup pieces for the backup set are created in both the specified destinations
• C.Two channels are allocated and two copies of the backup set are taken in parallel in both locations
• D.Two channels are allocated and a copy of the backup set is taken in the location specified by CHANNEL 2

You are performing regular backups of your production database by using a recovery catalog.
You add two new tablespaces to your production database after performing a backup. They must be included in future backups. Which action should you perform?

• A.Create a new database incarnation record
• B.Add the tablespaces in the recovery catalog by using the CATALOG command
• C.Synchronize all the physical data files with the logical records in the recovery catalog by using the CROSSSCHECK command
• D.Synchronize the recovery catalog with the target database control file

You create a new database by using the CREATE DATABASE command in SQL*Plus, with the ENABLE PLUGGABLE DATABASE clause specified.
Which statement is true about the database that is created? (Choose the best answer.)

• A.It is created as a container database (CDB) with CDB$ROOT, PDB$SEED, and a pluggable database (PDB).
• B.It is created as a non-CDB that becomes a CDB after the first PDB is plugged in.
• C.It is created as a CDB with the CDB$ROOT and PDB$SEED databases.
• D.It is created as a PDB that must be plugged into an existing CDB.