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

Question Posted / guest

2 Answers
6006 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

What is Check point? Explain in Brief what it will do?

1 Answers Wipro,

IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do

0 Answers

What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.

0 Answers

How make remote connection in database?

1 Answers

How fixed length strings are truncated and padded?

0 Answers

What are the different types of cursor?

0 Answers HCL,

Can an automatic recovery be initiated by a user?

0 Answers

What is default constraint?

0 Answers

What is meant by indexing?