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

How dts is used to extract, transform and consolidate data?

Why use identity in sql server?

What are the differences between local and global temporary tables?

Give me a SQL Query to find out the second largest company?

What is an execution plan? When would you use it? How would you view the execution plan?

Can group functions be used in the order by clause in ms sql server?

Is it possible we can connect our SQL database to GUI application? If it is yes than how tell me the explanation

What is acid mean in sql server?

what is memory-optimized nonclustered indexes

wat is tuff file in log shipping, wt is d use of tht file?

When I run the sql server 2000 setup, it just hangs. What do I do?

Tell me the phases a transaction has to undergo?

For more SQL Server Interview Questions Click Here