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

Question Posted / guest

2 Answers
5027 Views
CGI, I also Faced
E-Mail Answers

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 to write character string constants or literals in ms sql server?

0 Answers

Is it possible to create a stored procedure that runs a query and outputs the results to a text file and allows me to add extra delimeters and static field info. If so How?

1 Answers

2) Consider a Table name A which has below records ID --- 5 5 5 5 5 Consider another table B which has below records ID -- 5 5 5 5 5 5 5 5 How many rows will be returned by each of the below queries a) select * from A inner join B on A.id = b.ID b) select * from A left join B on A.id = b.ID c) select * from A right join B on A.id = b.ID

2 Answers Synechron, TCS,

How to round a numeric value to a specific precision?

0 Answers

what is denormalization? : Sql server database administration

0 Answers

Explain optimistic and pessimistic concurrency?

0 Answers

what is dbcc? : Sql server database administration

0 Answers

Explain the difference between control flow and data flow?

0 Answers

Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security