Exam : Oracle 1Z0-052
Title
: Oracle Database 11g:
Administration I
Version : Demo
Cheat-Test,help you pass any IT exam!
Cheat-Test.com All rights reserved
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: A, D
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?
Cheat-Test.com All rights reserved
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
3. Identify two situations in which you can use Data Recovery Advisor for recovery. (Choose two.)
A. Th