Sign Up Login


  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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

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

Is sql a case sensitive language?

0 Answers  

where are cookies actually stored on the hard disk? : Sql dba

0 Answers  

suppose u hav 1 book with set...page 1-100 n 101 -200 now print page from 2-100 n 102 -200... how we will do..?

6 Answers  

How do you add a column to a table?

0 Answers  

How do I find sql profiler?

0 Answers  




how to create a database in oracle?please gve anser with example

1 Answers  

mail-id table contains two columns(email_id,userid) it contains different types of mail-ids,and no of users. here username length is differ na,(ex- tamil@yahoo.com,joshua@hotmail.com like) now i want to fetch the email-ids only starting from '@' (ex-@gmail.com,@yahoo.com,@hotmail.com

5 Answers  

have table with two columns with datatypes as number and varchar and the values in A column like 1,2,3 AND B column values like a,b,c. now need to display data in a single column as 1,a,2,b,3,c.

8 Answers   IBM, Zensar,

when a procedure /package is getting invalidated?

4 Answers   TCS,

Types of optimization?

6 Answers   Microsoft,

What is difference between nchar and nvarchar?

0 Answers  

How to display the records between two range in Oracle SQL Plus?

0 Answers   MCN Solutions,

For more SQL PLSQL Interview Questions Click Here
Categories