Can we create nonclustered index in a table without
creating a clustered index



Can we create nonclustered index in a table without creating a clustered index..

Answer / neelesh kumar

Yes, we can. for example we can use unique constraint
without any clustered index.

Is This Answer Correct ?    16 Yes 1 No

Post New Answer

More SQL Server Interview Questions

1.what is the difference between view and cursor? 2.If we do any change in view will it affect the database,similarly when we do changes in cursor will it affect the databse?with certain example?Thanks

5 Answers  


Which language is supported by sql server?

0 Answers  


Do you know what is openxml in sql server?

0 Answers  


what are defaults? : Sql server database administration

0 Answers  


What is meant by datasource?

0 Answers  






Can you explain what are commit and rollback in sql?

0 Answers  


What is spid in sql server profiler?

0 Answers  


How to drop an existing schema in ms sql server?

0 Answers  


How do we get current date in SQL Server 2000, Oracle, MS Access?

13 Answers  


Please explain go command in sql server?

0 Answers  


How to defragment indexes with alter index ... Reorganize?

0 Answers  


in my server i have 3 instances,one of them got failed, and this cause we r not able to connect to server, how to know which instance was dameged?

1 Answers   IBM,


Categories