Can a table have two primary keys?

Question Posted / pk

44 Answers
96359 Views
HCL, MetaCube, I also Faced
E-Mail Answers

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 few of the schema objects that are created using PL/SQL?

0 Answers

What is oracle pl sql developer?

0 Answers

Which is better stored procedure or query?

0 Answers

What is query optimization in sql?

0 Answers

Is sql better than excel?

0 Answers

what is the difference between cluster and non cluster index? : Sql dba

0 Answers

Easy way to convert tableau "IF - ELSEIF" statements to Netezza "CASE" statements.

1 Answers CTS,

What is trigger and types?

0 Answers

Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com

0 Answers TCS,

Explain the rollback statement?

0 Answers

What are the new features in Oracle 10g. Compared to Oracle 9i?

1 Answers Polaris,

Which are the most commonly used sql joins?

1 Answers

For more SQL PLSQL Interview Questions Click Here