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

Answers were Sorted based on User's Feedback



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

Answer / 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

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

Answer / swapna

The concept of adding an unique key and not null constraint
to a column as well as adding as unique index to it , you
will assume to get the benefits of adding an primary key
to that column.

But use it for the purpose of referential integrity will
not allow to do so.

That's what PK is so useful. You will use it for
normalization purpose.

Is This Answer Correct ?    12 Yes 6 No

Post New Answer

More SQL PLSQL Interview Questions

What will you get by the cursor attribute sql%notfound?

0 Answers  


When is the update_statistics command used?

0 Answers  


How is Oracle 10g helpful when compared to oracle 9i and what is grid computing

1 Answers   Flextronics,


Difference between IN and EXISTS

4 Answers   Nous, Polaris,


one of the column in my table contains the data like SAL ---- 1000 1000 2000 3000 3000 So my requirement is i want output like SAL --- 1000 2000 3000 it mean i want to delete duplicate rows only how should u write query?

9 Answers   TCS,






what are properties of a transaction? : Sql dba

0 Answers  


What is the best strategy to use COMMIT in a pl/sql loop?

3 Answers  


What are the syntax and use of the coalesce function?

0 Answers  


What are the advantages of pl sql?

0 Answers  


what is difference between decode and case function?

2 Answers  


I want to execute a piece of code before calling a procedure. How to achieve it?

1 Answers   Oracle,


What are procedures used for?

0 Answers  


Categories