Which index created when Create Index on table(col), Why

Answers were Sorted based on User's Feedback



Which index created when Create Index on table(col), Why..

Answer / indexes

Non Clustered Index by Default.

Is This Answer Correct ?    15 Yes 0 No

Which index created when Create Index on table(col), Why..

Answer / sanjay

whenever you create index without specifying the type, its
non-clustered.

Is This Answer Correct ?    5 Yes 0 No

Post New Answer

More SQL Server Interview Questions

How real and float literal values are rounded?

0 Answers  


Can two different columns be merged into single column? Show practically?

0 Answers   QuestPond,


What are the underflow and overflow behaviors on float literals?

0 Answers  


Which are the olap features?

0 Answers  


Where can you add custom error messages to sql server?

0 Answers  






What is etl - extraction, transformation, and loading?

0 Answers  


What does truncate do?

0 Answers  


What is sub-query in sql server?

0 Answers  


What is the difference between for xml raw and for xml auto?

0 Answers  


How efficient you are in oracle and SQL server?

0 Answers   CGI,


tell me the disaster recovery plan

0 Answers   Microsoft,


Why we use trigger in sql server with example?

0 Answers  


Categories