Passed Admin 8i - Feedback....

[ramlal]

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?

[vimalp]

Congratulations Ram :)