Q1. 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,B,D
Reference:http://docs.oracle.com/cd/B19306_01/backup.102/b14192/bkup007.htm
http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmreprt.htm#BRADV89585
The primary purpose of the LIST command is to list backup andcopies. For example, you can list:
–Backups and proxy copies of a database, tablespace, datafile, archived redo log, or control file
–Backups that have expired
–Backups restricted by time, path name, device type, tag, or recoverability
–Archived redolog files and disk copies
Q2. Which three statements are true about Consolidated Database Replay?
A. The workload capture and replay systems must have the same operating system (OS).
B. Multiple workload captures from multiple databases can be replayed simultaneously on all pluggable databases (PDBs) in a multitenant container database (CDB).
C. A subset of the captured workload can be replayed.
D. The number of captured workloads must be the same as the number of PDBs in a multitenant CDB.
E. Multiple replay schedules can be defined for a consolidated replay and during replay initialization, you can select from any of the existing replay schedules.
Answer: B,C,E
Q3. Your production database is running in archivelog mode. You use RMAN with a recovery catalog to back up your database to media and the database is uniquely identified in the recovery catalog.
You want to create a test database from the production database and allow the production database to remain open during the duplicate process. You restore the database backups to a new host with the same directory structure as the production database and want to use the recovery catalog for future backups after the database is successfully restored to the new host.
How would you achieve this?
A. by using the RMAN switch command to set the new location for the data files
B. by using the RMAN duplicate command with nofilenamecheck to recover the database to the new host
C. by using the RMAN duplicate command with dbid and set nekname for tablespace to recover the database to the new host
D. by creating a new database in the new host, and then using the RMAN recover command
Answer: D
Q4. Which two statements are true about a common user?
A. A common user connected to a pluggable database (PDB) can exercise privileges across other PDBs.
B. A common user with the create user privilege can createother common users, as well as local users.
C. A common user can be granted only a common role.
D. A common user can have a local schema in a PDB.
E. A common user always uses the global temporary tablespace that is defined at the CDB level as the default temporary tablespace.
Answer: C,D
Q5. 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.
Answer: B
Q6. In your database, there are tablespaces that were read-only when thelast backup was taken. These tablespaces have not been made read/write since then. You want to perform an incomplete recovery on the database by using a backup control file.
What precaution must you take for the read-only tablespaces before performing anincomplete recovery?
A. All the read-only tablespaces should be taken offline.
B. All the read-only tablespaces should be restored separately.
C. All the read-only tablespaces should be renamed to have the MISSINGnnnn format.
D. All the read-only tablespacesshould be made online with logging disabled.
Answer: B
Q7. View the SPFILE parameter settings in the Exhibit.
You issue this command and get errors:
SQL> startup
ORA-00824:cannotsetSGAJTARGET or MEMORY_TARGET dueto existing internalsettings,seealertlog for moreinformation
Why did the instance fail to start?
A. because pga_aggregate_target is not set
B. because statistics_level is set to basic
C. because memory_target and memory_max_target cannot be equal
D. because sga_target and memory_target are both set
Answer: B
Q8. You plan to use the In-Database Archiving feature of Oracle Database 12c, and store rows that are inactive for over three months, in Hybrid Columnar Compressed (HCC) format.
Which three storage options support the use of HCC?
A. ASM disk groups with ASM disks consisting of Exadata Grid Disks.
B. ASM disk groups with ASM disks consisting of LUNS on any Storage Area Network array
C. ASM disk groups with ASM disks consisting of any zero padded NFS-mounted files
D. Database files stored in ZFS and accessed using conventional NFS mounts.
E. Database files stored in ZFS and accessed using the Oracle Direct NFS feature
F. Database files stored in any file system and accessed using the Oracle Direct NFS feature
G. ASM disk groups with ASM disks consisting of LUNs on Pillar Axiom Storage arrays
Answer: A,E,G
Explanation: HCC requires the use of Oracle Storage – Exadata (A), Pillar Axiom (G) or
Sun ZFS Storage Appliance (ZFSSA).
Note:
*
Hybrid Columnar Compression, initially only available on Exadata, has been extended to support Pillar Axiom and Sun ZFS Storage Appliance (ZFSSA) storage when used with Oracle Database Enterprise Edition 11.2.0.3 and above
*
Oracle offers the ability to manage NFS using a feature called Oracle Direct NFS (dNFS). Oracle Direct NFS implements NFS V3 protocol within the Oracle database kernel itself. Oracle Direct NFS client overcomes many of the challenges associated with using NFS with the Oracle Database with simple configuration, better performance than traditional NFS clients, and offers consistent configuration across platforms.
Q9. You notice performance degradation in your production Oracle 12c database. You want to know what caused this performance difference.
Which method or feature should you use?
A. Database Replay
B. Automatic Database Diagnostic Monitor (ADDM) Compare Period report
C. Active Session History (ASH) report
D. SQL Performance Analyzer
Answer: B
Reference:http://docs.oracle.com/cd/E24628_01/server.121/e17635/tdppt_degrade.htm
Q10. You are administering a database that supports data warehousing workload and Is running in noarchivelog mode. You use RMAN to perform a level 0 backup on Sundays and level 1 Incremental backups on all the other days of the week.
One of the data files is corrupted and the current online redo log file is lost because of a media failure.
You want to recover the data file.
Examine the steps involved in the recovery process:
1.Shut down the database instance.
2.Start up the database instance in nomount state.
3.Mount the database.
4.Take the data file offline.
5.Put the data file online.
6.Restore the control file.
7.Restore the database.
8.Restore the data file.
9.Open the database with the resetlog option.
10.Recover the database withthe noredo option.
11.Recover the data file with the noredo option.
Identify the required steps in the correct order.
A. 4, 8, 11, 5
B. 1, 3, 8, 11, 9
C. 1, 2, 6, 3, 7, 10, 9
D. 1, 3, 7, 10, 9
E. 1, 2, 6, 3, 8, 11, 9
Answer: C