What are the different types of indexes available in sql server? : sql server DBA
what is the purpose of catlaog in oracle rman?
Why would you call update statistics? : sql server DBA
how will you see when the database was started using sql prompt?
What column differentiates the V$ views to the GV$ views and how?
Explain CREATE DATABASE syntax?
What SQL query from v$session can you run to show how many sessions are logged in as a particular user account?
Explain the concept of the DUAL table.
Give the two types of tables involved in producing a star schema and the type of data theyhold.
How would you determine the time zone under which a database was operating?
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
How to start SQL Server in minimal configuration mode?
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA