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

How do I run a query in pl sql developer?

553


What is a variable in sql?

508


Describe different types of general function used in sql?

527


How consistent is the view of the data between and within multiple sessions, transactions or statements ?

1701


Define implicit and explicit cursors.

622






Enlist the characteristics of pl/sql?

1231


Is left join faster than inner join?

607


What are the advantages of indexing?

513


What is a system versioned table?

522


Explain the uses of database trigger.

645


What is meant by truncate in sql?

520


How do I order by ascending in sql?

530


How many aggregate functions are available there in sql?

522


What are the different parts of a package?

624


Does sap use sql?

512