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 Question | Next 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? |