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

Can a table have two primary keys?

Question Posted / pk

Answers were Sorted based on User's Feedback



Can a table have two primary keys?..

Answer / anand

Yes table can have two or more primary key,when we want to
create more then one primary we use unique constranit with
not null or we can create with triggre.

Is This Answer Correct ?    1 Yes 6 No

Can a table have two primary keys?..

Answer / sandeep yadav

Yes table can have two or more primary key.

Is This Answer Correct ?    1 Yes 9 No

Can a table have two primary keys?..

Answer / ashwin kumar

yes, a table may have more than 1 primary keys but, of them
we only choose 1 column as identifiable column called
primary key. The other columns are called surrogate keys or
candidate key.

Is This Answer Correct ?    25 Yes 43 No

Can a table have two primary keys?..

Answer / jamalvalli

Yes we can use. for Example

create table emp(empno number(5), ename varchar2(20),
deptno number(5) add primary key Pk_constraint( empno,
deptno))

Is This Answer Correct ?    18 Yes 38 No

Post New Answer

More SQL PLSQL Interview Questions

What are the return values of functions SQLCODE and SQLERRM ?

2 Answers   PreVator,

What is memory optimized?

0 Answers  

what is union, minus and interact commands? : Sql dba

0 Answers  

What are the different types of joins and explain them briefly.

3 Answers  

What is difference between rank () row_number () and dense_rank () in sql?

0 Answers  

Does sql backup shrink transaction log?

0 Answers  

What is difference between joins and union?

0 Answers  

While inserting/updating million of records into a database table, how do I came to know how many records has been inserted or updated successfully so far?

2 Answers   HSBC,

Explain the components of sql?

0 Answers  

what is query cache in mysql? : Sql dba

0 Answers  

Can delete statement be rollbacked?

0 Answers  

How many types of cursors supported in pl/sql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories