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

how to include character strings in sql statements? : Sql dba

999

how to install mysql? : Sql dba

1041

Does a join table need a primary key?

901

what are the different type of sql's statements ? : Sql dba

871

Why use truncate instead of delete?

959

Do prepared statements prevent sql injection?

896

What is the difference between truncate and drop statements?

1080

Which is the correct statement about truncate and delete?

1032

How run sql*plus commands that are stored in a local file?

973

How do I save the results of sql query in a file?

925

What are the parameter modes supported by pl/sql?

1015

What are sql ddl commands?

1018

Is microsoft sql free?

1042

What can you do with pl sql?

1031

What are literals in sql server?

1068