Can an automatic recovery be initiated by a user?
you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?
Can a table be created inside a trigger?
Is it true that rules do not apply to data already existing in a database at the time the rule is created?
Explain different backup plans?
When would you prefer to have a minimum number of indexes?
What specific conditions database should meet, before you can bulk copy data into it using bcp?
Can a trigger be created on a view?
What are the restraints imposed on the table design by a merge replication?
What is raid, and how it can influence database performance?
Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?
How would you choose between a clustered and a non-clustered index?
How raid can influence database performance?
A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?
Explain for xml explicit mode?