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

Question Posted / guest

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

More SQL Server Interview Questions

How to connect to a sql server using odbc_connect()?

How to execute multiple stored procedures at one time in sql server?

How to list all stored procedures in the current database using ms sql server?

in emptable i want to retrive the name of employee whose name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc.

What are xml indexes?

Explain why variables called the most powerful component of ssis?

When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?

what is the maximum size of sql row in mssql?

What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas

what is the main difference between after trigger and instead trigger.

How are SQL Server databases physically stored under Windows 2000?

can foreign key take role of primary key?

For more SQL Server Interview Questions Click Here