DBA > Job Interview Questions > Microsoft SQL Server interview questions for DBA
CREATE INDEX myIndex ON myTable(myColumn)What ty
More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/
(Continued from previous question...)
CREATE INDEX myIndex ON myTable(myColumn)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