SQL Server Database Administrator Question:
Download Questions PDF

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

Answer:

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

Download SQL Server DB Administrator Interview Questions And Answers PDF

Previous QuestionNext Question
What are triggers?
How many triggers you can have on a table?
How to invoke a trigger on demand?
What is a transaction and what are ACID properties?