Interested to Buy Any Domain ? << Click Here >> for more details...
Can a table have two primary keys?
- 44 Answers
- 96827 Views
- HCL, MetaCube, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
Yes table can have two or more primary key.
| Is This Answer Correct ? | 1 Yes | 9 No |
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 |
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 |
What is memory optimized table?
how to retrieve the top 3 salaries of the table using rownum
What is sql injection owasp?
Why is sql important?
How to pronounce postgresql?
What kind of join is join?
Can we use loop in sql?
Does sap use sql?
What is the basic form of sql query?
What does where 1/2 mean in sql?
can i use dbms_output.put_line in a function u are telling as return statement
write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
