September 2010
M T W T F S S
« Jul    
 12345
6789101112
13141516171819
20212223242526
27282930  

OCP 10g(1z0-042) daily 10 practices-3

1.Your database is running under automatic undo management and the UNDO_RETENTION parameter is set to 900 sec.
You executed the following command to enable retention guarantee:
ALTER TABLESPACE undotbs1 RETENTION GUARANTEE
What efeect would this statement have on the database?
A – The extents in undo tablespace retain data until the next full database backup.
B – The extents containing [...]

OCP 10g(1z0-042) daily 10 practices-1

1.What are the consequences of executing the SHUTDOWN ABORT command(Choose tow)

A – The database files are synchronized.
B – Uncommitted changes are no rolled back.
C – The database is closed,but the instance is still started.
D – Database buffers and redo buffers are not written to the disk.
E – The data base undergose automatic media recovery during [...]