If a tablespace has a default pctincrease of zero what will this cause (in relationship to the smon process)?
What is an artificial (derived) primary key? When should an artificial (or derived) primary key be used?
What is the difference between truncate and delete? Why is one faster? Can we rollback both? How would a full table scan behave after?
Where would you look to find out if a redo log was corrupted assuming you are using oracle mirrored redo logs?
Which function is used to find the largest integer less than or equal to aspecific value?
What is pct free/pct used/pct increase parameter in segment? What is growth factor?
Which files are vital that should be backed up?
How do I become a dba?
What exactly does a dba do?
What database block size should I use?
As an oracle dba what are the entire unix file you should be familiar with?
What are the types of schemas?
What does a hard one-to-one relationship mean (one where the relationship on both ends is "must")?
What are elements of administration?
You see multiple extents in the temporary tablespace. Is this a problem?