Yes we can use. for Example create table emp(empno number(5), ename var

Can a table have two primary keys?

Question Posted / jamalvalli

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

Please Help Members By Posting Answers For Below Questions

Mention what does plv msg allows you to do?

1097

What is pl sql in dbms?

934

How will you distinguish a global variable with a local variable in pl/sql?

1132

Explain the steps needed to create the scheduled job?

1023

what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba

949

explain the options of myisamchk to improve the performance of a table. : Sql dba

992

How to sort the rows in sql.

1050

Why is partition used in sql?

1104

Which is faster truncate or drop?

1030

Is pl sql still used?

961

Why do we use sql constraints? Which constraints we can use while creating database in sql?

1022

What is the current version of postgresql?

1048

Describe sql comments?

1012

What is parameter substitution in sql?

1014

What are the advantages of normalization?

1068