1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

Post New Answer

More SQL Server Interview Questions

What is 2nf normalization form?

1 Answers  

explain different types of backups avaialabe in sql server? : Sql server database administration

1 Answers  

what is the difference between delete table and truncate table commands? : Sql server database administration

1 Answers  

How to perform key word search in tables?

1 Answers  

What is Dependency Injection and provide example?

1 Answers  

If you are working on a SQL database and if suddenly a developer changes the code and your queries results start giving errors,how will you check using a T-SQL query (on system tables) that what has changed in the database.

2 Answers   Microsoft,

Write a sql query to sort on different column name according to the parameters passed in the function?

1 Answers  

Differentiate between truncate vs delete in mssql?

1 Answers  

What is the ‘fillfactor’?

1 Answers  

Explain about merge replications?

1 Answers  

What is Report Server,Report Manager and Report Builder in SSRS 2005?

1 Answers  

Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?

1 Answers  

For more SQL Server Interview Questions Click Here
Categories