High quality and Value for the 1Z0-052 Exam.
Killtest Practice Exams for Oracle Database 11g: Administrator I : 1z1-052 Exam 1Z0-052 are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development.
100% Guarantee to Pass Your 11g exam and get your 11g Certification.
We guarantee your success in the first attempt. If you do not pass the 1Z0-052 (Oracle Database 11g: Administrator I : 1z1-052 Exam) on your first attempt we will give you a FULL REFUND of your purchasing fee AND send you another same value product for free.
1Z0-052：please download 1Z0-052 in PDF format Demo
63. Your database instance is configured with automatic undo management and the UNDO_RETENTION parameter is set to 900 seconds. You executed the following command to enable retention guarantee:
SQL> ALTER TABLESPACE undotbs1 RETENTION GUARANTEE;
What effect would this command have on the database?
A.The extents in the undo tablespace retain data until the next full database backup.
B.The extents containing committed undo in the undo tablespace are not overwritten for at least 15 minutes.
C.The extents containing committed data in the undo tablespace are not overwritten until the instance is shut down.
D.The extents containing committed undo in the undo tablespace are transferred to Flash Recovery Area before being overwritten.
Answer: B
64. In which situation may the UNDO_RETENTION parameter be ignored, even if it is set to a value?
A.when the data file of the undo tablespace is autoextensible
B.when there are more than one undo tablespaces available in the database
C.when the undo tablespace is of a fixed size and retention guarantee is not enabled
D.when the undo tablespace is autoextensible and retention guarantee is not enabled
Answer: C