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

How to install sql server 2005 express edition?

1 Answers  


what is the difference between procedure and function.

4 Answers   Thomson,


How to use copy and concatenate commands in SQL?

1 Answers   Amdocs,


Using query analyzer, name 3 ways you can get an accurate count of the number of records in a table?

5 Answers   eFunds,


How do I edit a procedure in sql server?

1 Answers  


Can I work with several databases simultaneously? : sql server management studio

1 Answers  


What are three SQL keywords used to change or set someone?s permissions?

3 Answers  


What is difference between oltp and olap?

1 Answers  


What is the sql case statement used for? Explain with an example?

1 Answers  


How to create an index on an existing table in ms sql server?

1 Answers  


Define master database?

1 Answers  


Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.

1 Answers  


Categories