Note the following statements that use flashback technology:
1. FLASHBACK TABLE <table> TO SCN <scn>;
2. SELECT * FROM <table> AS OF SCN 123456;
3. FLASHBACK TABLE <table> TO BEFORE DROP;
4. FLASHBACK DATABASE TO TIMESTAMP <timestamp>;
5. SELECT * FROM <table> VERSIONS AS OF SCN 123456 AND 123999;
Which of these statements will be dependent on the availability of relevant undo data in the
undo segment?
A. 1, 2, and 5
B. 1, 3, and 4
C. 2, 3, 4, and 5
D. 1, 2, 3, 4, and 5
Answer: A
Question: 27
The DBA has chosen to manage SGA and PGA memory separately in an OLTP database because of his unique knowledge of the application.Which of these are good starting points to use when configuring the maximum values for SGA and PGA, based on the amount of memory available on the system?
A. 20% SGA, 80% PGA
B. 25% SGA, 75% PGA
C. 50% SGA, 50% PGA
D. 75% SGA, 25% PGA
E. 80% SGA, 20% PGA
Answer: E
ORACLE 1Z0-053 Exam Sample Questions Practice Exam
Question: 28
You decided to use Direct NFS configuration in a non-RAC Oracle installation and created the oranfstab file in / etc. Which two statements are true regarding this oranfstab file? (Choose two.)
A. Its entries are specific to a single database.
B. It contains file systems that have been mounted by Direct NFS.
C. It is globally available to all Oracle 11g databases on the machine.
D. It contains file systems that have been mounted by the kernel NFS system.
Answer: C,D
Question: 29
Identify three key features of ASM. (Choose three.)
A. file striping
B. allocation unit mirroring
C. automatic disk rebalancing
D. automatic file size increment
E. automatic undo management
Answer: A,B,C
Question: 30
What is the net effect of the following command?
Alter diskgroup dgroup1 drop disk abc;
A. The disk ABC will be dropped from the disk group. Since you did not issue a rebalance command, the data on that disk will be lost.
B. The command will raise an error indicating that you need to rebalance the disk group to remove the data from that disk prior to dropping the disk.
C. The disk group will be automatically rebalanced during the drop operation. Once the rebalancing is complete, the disk will be dropped.
D. This command will fail because you cannot drop a specific disk in an ASM disk group.
E. The disk drop command will be suspended for a predetermined amount of time, waiting for you to also issue an alter diskgroup rebalance command. Once you
have issued the rebalance command, ASM will proceed to rebalance the disk group and then drop the disk.
Answer: C
ORACLE 1Z0-053 Practice Exam Free Download
