Unique Key creates Non-Cluster index in default, But in Primary Key create

When we can declare a column as Unique and Not Null both at
the same time. What is the use pf Primary Key then?

Question Posted / thanga prabu.n

Answer Posted / thanga prabu.n

Unique Key creates Non-Cluster index in default,
But in Primary Key creates Cluster index in default

Is This Answer Correct ?

16 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Explain locks? : Transact sql

951

Explain what is a view?

997

How do I save the results of sql query in a file?

926

what are the advantages of using stored procedures? : Sql dba

1059

How do you delete a table?

997

Enlist the data types that can be used in pl/sql?

1002

Are pl sql variables case sensitive?

997

What is consistency?

1061

Define concurrency control. : Transact sql

1103

what are different types of keys in sql?

1065

What is union, minus and interact commands?

1213

How to start the command-line sql*plus?

998

Why do we need pl sql?

935

How many sectors are in a partition?

1031

What do you understand by case manipulation functions?

952