What is the default index ?

the question says "wgat is the default index"

answer: we have no shuch a thing as default, if it is about what is the first index that SQL will pick? the answer is when ever the SQL server plan is going to pick, it all depends on your query and etc.... 

you will get a NON UNIQUE , on a NON-CLUSTER index

plus you will have a clustered index becasue of the "ID int primary key"

The best approach would probably be to have Microsoft SQL Server installed and have the above script executed and check oneself.

 

In the process will you not get lot more knowledge, confidence and a hand-on experieance with the product you want to know more about?

 

That confidence will be invaluable as it will change your body language while answering the questions during interview.