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.

Answer / sandeep yadav

Yes table can have two or more primary key.

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.

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))

What are literals in sql server?

0 Answers  

---

How do I copy a table in sql?

0 Answers  

---

write a qurey for finding the length of the sting.

6 Answers   Infosys, TCS,

---

If you want a column to be part of the result set, after which SQL keyword does it belong? 1. SELECT 2. FROM 3. WHERE 4. GROUP BY 5. HAVING

10 Answers   HCL, TCS,

---

after tell procedure whole code he asked can i write the same way in a function

3 Answers  

---

Difference between a query and strored procedure?

4 Answers   Microsoft,

---

I want to know the difference between A Record Type and a Table.

3 Answers   Thermotech,

---

How does postgresql compare to "nosql"?

0 Answers  

---

HOW TO APPEAR FOR ONLINE EXAMS OF SQL & PL/SQL? WHICH BOOKS WILL BE BETTER FOR REFERENCE TO QUALIFY THESE EXAMS? ARE THERE ANY MODEL PAPERS AVAILABLE IN THE MARKET ABOUT SQL & PLSQL?

2 Answers  

---

What is difference between sql and oracle?

0 Answers  

---

select 1,col1,col2 from table1. output?

5 Answers   Ramco,

---

How do I view a table in sql?

0 Answers  

---