In which dictionary table or view would you look to
determine at which time a snapshot or MVIEW last
successfully refreshed?
What is the difference between clustered and non-clustered index? : sql server DBA
When a user process fails, what background process cleans up after it?
What would you use to improve performance on an insert statement that places millions of rows into that table?
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
What purpose does the model database server? : sql server DBA
how can you initialize log miner?
Name two files used for network connection to a database.
Explain the difference between a data block, an extent and a segment.
Which dictionary tables and/or views would you look at to diagnose a locking issue?
What is database replicaion? What are the different types of replication you can set up in SQL Server?
How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.
What is the default fill factor value? : sql server DBA