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

What is data definition language?

1136

What is offset in sql query?

1176

How you improve the performance of sql*loader? : aql loader

1063

What is sql*loader?

1285

Show how functions and procedures are called in a pl/sql block.

1186

What are the different ways to optimize a sql query?

990

Which are the different case manipulation functions in sql?

1077

what is union? : Sql dba

1082

Can function return multiple values in sql?

1098

what is datawarehouse? : Sql dba

1066

What is index example?

1046

What is a schema? How is it useful in sql servers?

1175

What is the difference between database trigger and stored procedure?

1138

What is synchronized subquery?

1220

what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba

1134