Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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

What is the difference between a primary key and a clustered index?

0 Answers  

Is sql pronounced sequel or sql?

0 Answers  

If a procedure within a package is invalidated whether the entire package will be invalid and has to be recompiled again?

2 Answers   IBM, TCS,

How do I clear the screen in sql plus?

0 Answers  

What is pl sql block in dbms?

0 Answers  

what is a scheduled jobs or what is a scheduled tasks? : Sql dba

0 Answers  

What is sql*loader and what is it used for?

0 Answers  

define a variable representing the expression used to calculate on emps total annual remuneration.use the variable in a statement which finds all emps who can earn 30000 a year or more.

5 Answers  

Explain what is a column in a table?

0 Answers  

1> how are u debugging in plsql ? 2> how to connect oracle database from unix. is there ne way other than using sqlplus ?

2 Answers  

what is switch column,colums cost in oracle?

0 Answers   Metric Stream,

What is the usage of distinct keyword?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories