What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
Name a tablespace automatically created when you create a database.
When creating a user, what permissions must you grant to allow them to connect to the database?
how to restore files with rman?
How do you add a data file to a tablespace?
What is fill factor? : sql server DBA
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
What purpose does the model database server? : sql server DBA
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
How would you go about increasing the buffer cache hit ratio?
how do see how much space is used and free in a tablespace
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
what is a user-defined lock?