16. The backup retention policy is configured as RECOVERY WINDOW 2. You executed the following
command in Recovery Manager (RMAN) against your database:
RMAN> REPORT OBSOLETE;
What would you see in the output?
A. a list of all the expired backups and copies
B. a list of all those files that have been deleted in the last two days
C. a list of all those files that have been recovered within the last two days
D. a list of backups and copies that are outside the range covered by the current retention policy
Answer:D
————————
17. Last night, a media failure caused the loss of a temporary file that belongs to your database. Which two things
may happen this morning when you try to open your database? (Choose two.)
A. The database opens normally.
B. The database prompts for a database recovery.
C. The database writer writes to a trace file, indicating that the temporary file is not found.
D. The database gets mounted and throws an error indicating that the temporary file requires recovery.
Answer:AC
—————
18. A user executes a query on the EMP table, which contains thousands of rows, to get details about employees in
one of the departments. The user receives the following error:
SQL> SELECT ename FROM emp WHERE deptno=10 ORDER BY sal;
SELECT ename FROM emp WHERE deptno=10 ORDER BY sal
*
ERROR at line 1:
ORA-01157: cannot identify/lock data file 201 - see DBWR trace file
ORA-01110: data file 201: ‘/u01/app/oracle/oradata/orcl/temp01.dbf’
What is a possible reason?
A. The tempfile belonging to the default temporary tablespace is missing.
B. The database is opened in restricted mode, so queries are not allowed.
C. The default temporary tablespace required to execute the query is offline.
D. The default temporary tablespace required to execute the query is dropped.
E. The default temporary tablespace required to execute the query is read-only.
Answer:A
—————-
19.You are working on a database, where you have three redo log groups. When the database is down for a backup,
an operating system (OS) user deletes all the redo log files in a group. What will happen when you open your
database?
A. The instance starts and the database opens because two redo log groups still exist.
B. Before the instance starts, you receive an error about the missing redo log files of a group.
C. The instance starts and the database opens with an error message written to the alert log file.
D. The instance starts and the database opens, but every attempt to write to redo log files fails with an error.
E. The instance starts, the database is mounted, but efforts to open the database fail, and an error about the missing
redo log group is displayed.
Answer:E
——————–
20.A media failure has occurred. This has resulted in all the members of the next log group being rendered
inaccessible to the log writer process (LGWR) at a log switch. How does this failure affect the operational
database?
A. The database re-creates the missing redo log files automatically.
B. The database continues to function normally with the existing files.
C. The database allows only queries; no other statements are allowed.
D. The database returns an error and the database instance shuts down.
E. The user sessions that generate redo logs are terminated automatically.
Answer:D
More Infomation Visit: