which background process will run @ the time of creation of catalog database
What is the difference between dropping a database and taking a database offline? : sql server DBA
How would you go about generating an EXPLAIN plan?
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
What the different components in replication and what is their use? : sql server DBA
You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?
Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
How do you find out from the RMAN catalog if a particular archive log has been backed-up?
Why would you call update statistics? : sql server DBA
what is difference between user managed backup and rman backup?
What is the difference between LMT & DLT?
What is blocking and how would you troubleshoot it?