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 committed data in the undo tablespace are never overwritten.
C - The extents which no longer contain uncommitted data in the undo tablespace
are not overwritten for at least 15 minutes.
D - The extents containing committed data in the undo tablespace are not overwritten
until the instance is shut down.
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 the next startup.
Loading...
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 committed data in the undo tablespace are never overwritten.
C - The extents which no longer contain uncommitted data in the undo tablespace
are not overwritten for at least 15 minutes.
D - The extents containing committed data in the undo tablespace are not overwritten
until the instance is shut down.
More…
Popularity: 36% [?]
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 the next startup.
More…
Popularity: 36% [?]