What are the tradeoffs between many vs few indexes? When would you want to have many, and when would it be better to have fewer?
Does a dba have to file taxes?
What is the difference between a database and instance? What is the relation between them?
What are four common errors found in an alert .log?
How to drop an oracle database?
The system has a program that always includes the word nocomp in its name, how can you determine the number of processes that are using this program?
You have installed oracle and you are now setting up the actual instance. You have been waiting an hour for the initialization script to finish, what should you check first to determine if there is a problem?
How can be determining the size of the log files?
Explain the term 'oracle grid architecture'?
When configuring sqlnet on the client what files need to be set up?
What os user should be used for the first part of an oracle installation (on unix)?
What is an artificial (derived) primary key?
How many control files should you have? Where should they be located?
What are the beneficial tools for administering the database?
How can you determine the space left in a file system?