May 2008
M T W T F S S
« Apr   Jun »
 1234
567891011
12131415161718
19202122232425
262728293031  

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-2

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 [...]

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 [...]

Site of Books

I found this web site scribd  by accident.There are lots of books on this site.Here’s another similar site slideshare. Have fun!

How to drop and recreate oracle undo tablespace and its datafile

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 [...]

Page 1 of 212