You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?
What is a livelock?
What are alternate keys?
What does it mean to normalize a database and why would you do it?
‘Order by’ is not allowed in a view how can you sort information from a view?
You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?
How do you use a subquery to find records that exist in one table and do not exist in another?
Can a cursor be updated? If yes, how you can protect which columns are updated?
What is xdr?
How can you set the threshold at which sql server will generate keysets asynchronously?
Which table keeps information about stored procedures?
How is a full-text index updated?
Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?
How can you find out how many rows returned in a cursor?
What is the difference between writing data to mirrored drives versus raid5 drives