-
Hi ,
I have given some question which I have faced in OCP DBA 8i (Architecture and Admin). My score 50/64
I like to hear some tips for 8i Backup and Recovery....
Thank you to all.
1. Want to assing largt sort segment, without affecting data dictionary
-- Locally managed Temp tablspace
2. Level of storage objects....Database,Tablespace,Segment,Extent,Orale Block.
3. 32 employees has to concurrently work in OLTP systesm, how many rollback should be created?
-- it is 8 rollback segments.
4. Where will you find the # of online redo logs and # of groups?
-- I guess V$log and V$thread.
5. When PCTUSEd crosses its thresold..
-- No insert will happen.
6. When PCTUSE limit reaches BELOW, it will be added to Freelist.
7. When you rebuild index..
-- Can you convert from Btree to Bitmap
-- Can you convert from Reverse to Bitmap ( i don't know the answer)
8. When you resize the datafile (shrinking), upto what point will you do.
-- To the last block of last object?
-- to the bytes of datafile Header ( this also I don't know)
9. When you add a logmember to a group whithout specifying the size,
what will be the effort?
10. When you do direct load in SQL Loader, What are the restriction?
-
Congrates!
