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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is int identity in sql?

664


Explain ttitle and btitle.

742


what is a materialized view? : Sql dba

658


Which data type is a composite type?

629


how to get help information from the server? : Sql dba

597






Is microsoft sql free?

699


What are the possible values for the boolean data field?

596


What is the starting oracle error number?

646


What sql does db2 use?

642


Explain unique key in sql.

651


What types of commands can be executed in sql*plus?

646


Name three sql operations that perform a sort.

680


What packages are available to pl/sql developers?

712


Why do we create views in sql?

659


What is java sql package?

626