Answer / manoj

primary key is a key which always accept unique value.

secondary key is a key which when you are making primary key
for more than one column as primary key for retrieving of
reords.
eg.
create table tnam
(ano number,
bno number,
bname char(12),
primary key(ano,bno))

In this bno is secondary key.

Answer / renu kakkar

PRIMARY REPRESENTS THE ROW/TUPPLE UNIQUELY WHEREAS
SECONDARY KEY REPRESENTS THE SET OF TUPPLES
EMPLOY_ID IS A PRIMARY KEY AND EMPLOY_DEPTT. IS A SECONDARY
KEY.

How to remove duplicate rows from a table?.

3 Answers  

---

Is oracel sql developer written in java?

0 Answers  

---

What is a transaction?

5 Answers  

---

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

0 Answers  

---

what is SCALAR Queries?

2 Answers   ITC Infotech,

---

Why do you partition data?

0 Answers  

---

What are the operators in sql?

0 Answers  

---

What does trigger mean in slang?

0 Answers  

---

What is difference between % ROWTYPE and TYPE RECORD ?

2 Answers  

---

Can we commit inside a trigger?

0 Answers  

---

What is trigger in sql? Explain

0 Answers  

---

What are the sql commands?

0 Answers  

---