Exam A
QUESTION 1
You perform differential incremental level 1 backups of your database on each working day and level 0
backup on Sundays, to tape. Which two statements are true about differential incremental backups?
(Choose two.)
A. The backup performed on Sundays contains all the blocks that have ever been used in the database.
B. The backup performed on Sundays contains all the blocks that have changed since the last level 1
backup.
C. The backup performed on each working day contains all the blocks that have changed since the last
level 0 backup.
D. The backup performed on Monday contains all the blocks that have changed since the level 0 backup,
and every other working day contains all the blocks that have changed since the level 1 backup.
Answer: AD
Section: (none)
Explanation/Reference:
QUESTION 2
View the Exhibit to examine the output produced by the following query at three different times since the
database instance started and has experienced workloads of different capacities:
SQL> SELECT substr(component, 0, 10) COMP, current_size CS, user_specified_size US FROM v
$memory_dynamic_components
WHERE current_size!=0;
What do you infer from this?
A. The database instance is running with manual PGA management.
B. The database instance is running with manual shared memory management.
C. The database instance has the MEMORY_TARGET value set to a nonzero value.
D. All sessions are connected to the database instance in dedicated mode, and no RMAN or parallel query
operations have been performed.
Answer: C
Section: (none)
Explanation/Reference:
QUESTION 3
Identify two situations in which you can use Data Recovery Advisor for recovery. (Choose two.)
A. The database files are corrupted when the database is open.
B. The user has dropped an important table that needs to be recovered.
C. The archived redo log files are missing for which the backup is not available.
D. The database is not opening because the required database files are missing.
Answer: AD
Section: (none)
Explanation/Reference:
