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

Can a table be moved to different filegroup?

Explain steps of normalization?

What is correlated subquery in sql server?

In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

what is the sql equivaent of the dataset relation object ?

What are the properties of sub-query?

what are default? Is there a column to which a default cant be bound?

What is data modeling and Reterminal integrity?

How many databases instances are there in sql server 2000?

How can we rewrite sub-queries into simple select statements or with joins?

What is SQL server agent?

What do you understand by integration services in sql server?

For more SQL Server Interview Questions Click Here