What should you do to prepare for MS SQL Server

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What should you do to prepare for MS SQL Server upgrade?

Before starting update a MS SQL Server, you should examine the upgrade prerequisites, back up all databases, choose an appropriate upgrade methods, etc.

(Continued on next question...)

Other Job Interview Questions

• What is the default TCP/IP port # used by MS SQL Server to receive connection requests?
• What two categories you can divide T-SQL statements into?
• On MS SQL Server management tool, how would you find what actions you can perform for a particular object?
• What is the meaning of the following T-SQL command: "GRANT CREATE TABLE TO <username>"
• What is the meaning of Data Normalization?
• When revoking one security role from a user, does it affect other security roles granted to same user?
• What is the size of an Extent in MS SQL Server?
• Is T-SQL language syntax case-sensitive?
• What is the meaning of the following T-SQL command: "GRANT CREATE TABLE TO <username>"
• What is the use of *.ndf files in MS SQL Server?
• More...