What type of Index will get created after execut

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

(Continued from previous question...)

What type of Index will get created after executing the above statement?

Non-clustered index. Important thing to note: By default a clustered index gets created on the primary key, unless specified otherwise.

(Continued on next question...)

Other Job Interview Questions

• What is the system function to get the current user's user id?
• How to determine the service pack currently installed on SQL Server?
• But what if you have to create a database with two filegroups, one on drive C and the other on drive D with log on drive E with an initial size of 600 MB and with a growth factor of 15%?
• What's the difference between DELETE TABLE and TRUNCATE TABLE commands?
• What is RAID and what are different types of RAID configurations?
• Let’s assume you have data that resides on SQL Server 6.5. You have to move it SQL Server 7.0. How are you going to do it?
• What are the different ways of moving data/databases between servers and databases in SQL Server?
• Define candidate key, alternate key, composite key.
• What is an index? What are the types of indexes? How many clustered indexes can be created on a table? I create a separate index on each column of a table. What are the advantages and disadvantages of this approach?
• What are the steps you will take to improve performance of a poor performing query?
• More...