Tuning and Monitoring RMAN and the Automatic Diagnostic Workflow - OCP: Oracle Database 12c Administrator Certified Professional - page 280

12. In what view are you likely to see the following output?
SID SERIAL# EVENT SECONDS_IN_WAIT
---------- ---------- ------------------------------ ---------------
121 269 RMAN backup & recovery I/O 2
129 415 SQL*Net message from client 63
130 270 SQL*Net message from client 8
A. V$SESSION_EVENT
B. V$SESSION
C. V$WAITS
D. V$WAITSTAT
E. V$SYSSTAT
13. What view might you use to try to determine how long a particular backup will take?
A. V$SESSION_EVENT
B. V$SESSION
C. V$WAITS
D. V$WAITSTAT
E. V$SESSION_LONGOPS
14. What is the impact of the output of the following command?
RMAN> report unrecoverable database;
Report of files that need backup due to unrecoverable operations
File Type of Backup Required Name
---- ----------------------- -----------------------------------
4 full or incremental C:\ORACLE\ORADATA\ORCL\USERS01.DBF
A. There are no backup sets with any backups of the users01.dbf data file.
B. The users01.dbf data file has had unrecoverable operations occur in it. It will
need to be backed up or some data loss is possible during a recovery.
C. The users01.dbf data file is corrupted.
D. The users01.dbf data file backup exceeds the retention criteria.
E. The last backup of the users01.dbf data file failed and must be rerun.