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.Which three statements are true regarding the logical structure of the Oracle database?(choose three)
A - Each segment contains one or more extents
B - Mutiple tablespaces can share single datafile
C - A data block is a smallest unit of I/O for data files.
D - it is possible to have tablespaces of different blocks size in a database
E - Each data block in the database always corresponds to one OS block.
(Answer:A,C,D)
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.Which three statements are true regarding the logical structure of the Oracle database?(choose three)
A - Each segment contains one or more extents
B - Mutiple tablespaces can share single datafile
C - A data block is a smallest unit of I/O for data files.
D - it is possible to have tablespaces of different blocks size in a database
E - Each data block in the database always corresponds to one OS block.
(Answer:A,C,D)
More…
Popularity: 33% [?]
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% [?]
I found this web site scribd by accident.There are lots of books on this site.Here’s another similar site slideshare. Have fun!
Popularity: 35% [?]
if you get ORA-00600 or the following error message on your Oracle standby database:
Fri Mar 09 10:57:49 2007
Errors in file c:\oracle\admin92\crm\bdump\crmsb_mrp0_524.trc:
ORA-00600: internal error code, arguments: [3020], [356515961], [1], [4606], [2], [16], [], []
ORA-10567: Redo is inconsistent with data block (file# 85, block# 121)
ORA-10564: tablespace UNDOTBS2
ORA-01110: data file 85: ‘K:\ORADATA\CRM\UNDOTBS02_1.DBF’
ORA-10560: block type ‘KTU SMU HEADER BLOCK’
Or your undo tablespace has grown to unmanageable size (~ 35 Gbytes), you may want to recreate unto tablespace. Here is how:
More…
Popularity: 49% [?]