No, Non clustered index create when we declare a primary or unique key an

Can we create non-clustured index on a clustered index ?

Question Posted / amit

Answer Posted / amit

No,
Non clustered index create when we declare a primary or
unique key and clustered indexes are created by user.

Is This Answer Correct ?

7 Yes

27 No

Please Help Members By Posting Answers For Below Questions

How many types of index are there?

1098

what are the different type of sql's statements ? : Sql dba

975

what is the difference between clustered and non clustered index in sql? : Sql dba

1185

What is dialect in sql?

987

which command using query analyzer will give you the version of sql server and operating system? : Sql dba

1104

How many subqueries can be nested in a statement?

1038

explain primary keys and auto increment fields in mysql : sql dba

1015

What is AUTH_ID and AUTH_USER in pl/sql ?

2232

What are its different types of dbms?

1052

What is the use of desc in sql?

1018

What is a file delimiter?

1161

Does db2 use sql?

1009

Can we write dml inside a function in sql server?

1003

Is the primary key an index?

1077

What do you mean by dbms? What are its different types?

1061