3 Comments on “Which statement will result in the creation of an index?”

1. Ivo says:

   July 1, 2016 at 12:55 pm

   This commands will make a table right? Not an index.

   So the question should be:
   Which statement will result in the creation of an table?

   
   
   
   0

   
   
   
   1
2. Olivia says:

   September 9, 2016 at 5:54 am

   By default, a clustered index would be created when you create a primary key, so I think the question is right in this case.

   
   
   
   8

   
   
   
   0
3. Sven says:

   September 29, 2016 at 5:12 pm

   Olivia is right. When you create a table with a primary key, and index is created automatically.

   
   
   
   4

   
   
   
   0