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

Question Posted / munindra

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

More SQL Server Interview Questions

CREATE a table from another table

write query for fourth maximum salary from employee table

Explain foreign key in sql server?

What is the most common trace flags used with sql server?

What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?

Can we add our custom code in ssis?

What are user defined datatypes and when you should go for them?

What is lookup override?

What are types of storage modes? : sql server analysis services, ssas

Explain about service Broker functions?

How to test values returned by a subquery with the in operator?

How to search for a string in all stored procedure in sql server?

For more SQL Server Interview Questions Click Here