1z0-067 | Downloadable Database 12c 1z0-067 exam
Q71. You execute the RMAN commands:
RMAN> BACKUP VALIDATE DATABASE;
RMAN> RECOVER CORRUPTION LIST;
Which task is performed by these commands?
A. Corrupted blocks, if any, are repaired in the backup created.
B. Only those data files that have corrupted blocks are backed up.
C. Corrupted blocks in the data files are checked and repaired before performing the database backup.
D. The database is checked for physically corrupt blocks and any corrupted blocks are repaired.
Answer: C
Q72. You want to create a guaranteed restore point for your database by executing the command:
SQL> CREATE RESTORE POINT dbrsp1 GUARANTEE FLASHBACK DATABASE;
Identify two prerequisites for the successful execution of this command.
A. The database must be running in archivelog mode.
B. Flashback Database must be enabled.
C. Fast Recovery Area must be enabled.
D. The recyclebin must be enabled for the database.
E. Undo retention guarantee must be enabled.
F. A database backup must be taken.
Answer: A,C
Reference:http://docs.oracle.com/cd/B19306_01/backup.102/b14192/rpfbdb002.htm
Q73. Your database is running in archivelog mode and a nightly backup of the database, along with an autobackup of the control file, is taken by using RMAN. Because of a media failure, the SPFILE and the control files are lost.
Examine the steps to restore the SPFILE and the control file to mount the database:
1. Set D3ID of the target database in RMAN.
2.Start the database instance by using the startup force nomount command in RMAN.
3.Restore the control files from the backup.
4.Mount the database.
5.Restore the SPFILE from the autobackup.
6.Create a PFILE from the recovered SPFILE.
7.Restart the instance in nomount state.
Identify the required steps in the correct order.
A. 1, 2, 5, 3, 6, 4
B. 1, 2, 3, 5, 6, 4
C. 2, 1, 5, 7, 3, 4
D. 2, 1, 5, 6, 7, 4, 3
Answer: D
Q74. Which parameter must be set to which value to implement automatic PGA memory management?
A. Set memory_target to zero.
B. Set STATISTICS_LEVEL to BASIC.
C. Set pga_aggregate_target to a nonzero value.
D. Set pga_aggregate_target and sga_target to the same value.
E. Set sgajtarget to zero.
Answer: C
Reference:http://docs.oracle.com/cd/B28359_01/server.111/b28310/memory004.htm#ADM IN11233
Q75. Which three statements are true about the startup and shutdown of multitenant container databases (CDBs) and pluggable databases (PDBs)?
A. A PDB opened in restricted mode allows only local users to connect.
B. When a CDB is open in restricted mode, PDBs must also be opened in restricted mode.
C. When a CDB is in mount state, PDBs are automatically placed in mount state.
D. All PDBs must be shut down before shutting down a CDB instance.
E. When a CDB instance is started, PDBs can be placed in open state by using database triggers or by executing the alter pluggable database command.
Answer: D,E
Q76. For which three pieces of information can you use the RMAN list command?
A. stored scripts in the recovery catalog
B. available archived redo log files
C. backup sets and image copies that are obsolete
D. backups of tablespaces
E. backups that are marked obsolete according to the current retention policy
Answer: A,C,D
Reference:http://docs.oracle.com/cd/B19306_01/backup.102/b14192/bkup007.htm
Q77. Your database is running in archivelog mode. Examine the parameters for your database instance:
LOG_ARCHIVE_DEST_l ='LOCATION=/disk1/arch MANDATORY' LOG_ARCHIVE_DEST_2 ='LOCATION=/disk2/arch' LOG_ARCHIVE_DEST_3 ='LOCATIO=/disk3/arch' LOG_ARCHIVE_DEST_4 ='LOCATIONs/disk4/arch'
LOG_ARCHIVE_MIN_SUCCEED_DEST=2
While the database is open, you notice that the destination set by the log_archive_dest_1 parameter is not available. All redo log groups have been used.
What happens at the next log switch?
A. The database instance hangs and the redo log files are not overwritten.
B. The archived redo log files are written to the fast recovery area until the mandatory destination is made available.
C. The database instance is shutdown immediately.
D. The destination set by the log_archive_destparameter is ignored and the archived redo log files are created in the next two available locations to guarantee archive log success.
Answer: D
Q78. Which three conditions must be met before you create a Virtual Private Catalog (VPC)?
A. A base recovery catalog should exist.
B. The owner of VPC cannot own recovery catalog.
C. At least one target database should be registered in the recovery catalog.
D. The register database privilege should be granted to the virtual catalog owner.
E. The recovery_catalog_owner role should be granted to the virtual catalog owner.
Answer: C,D,E
Reference:http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta013.htm
Q79. You use RMAN with a recovery catalog to back up your database. The backups and the archived redo log files are backed up to media daily. Because of a media failure, the entire database along with the recovery catalog database is lost.
Examine the steps required to recover the database: 1.Restore an autobackup of the server parameter file. 2.Restore the control file.
3. Start up the database instance in nomount state.
4.Mount the database.
5.Restore the data files.
6.Open the database with the resetlogs option.
7.Recover the data files.
8.Set D3ID for the database.
Identify the required steps in the correct order.
A. 1, 8, 3, 2, 4, 5, 7, 6
B. 8, 1, 3, 2, 4, 5, 7, 6
C. 1, 3, 2, 4, 8, 5, 6, 7
D. 8, 3, 2, 4, 5, 7, 6
E. 8, 1, 3, 2, 4, 5, 6
Answer: D
Q80. You specified the warning and critical thresholds for a locally managed tablespace to be 60% and 70%, respectively.
From the tablespace space usage metrics, you find that the space usage has reached the specified warning threshold value, but no alerts have been generated.
What could be the reason for this?
A. The event parameter was not set.
B. The sql_trace parameter is set to false.
C. Enterprise Manager was not used.
D. The statistics_level parameter is set tobasic.
E. The t:kid_statistics parameter is set to false.
Answer: D