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.

diff b/w function and procedure?

9 Answers   iFlex,

---

What is sql resultset?

0 Answers  

---

wht is the difference between truncat,drop in sqlserver wht is the difference between function and stored procedure

3 Answers   Apollo,

---

What is sql used for?

0 Answers  

---

How do I find duplicates in two columns?

0 Answers  

---

---

when is the use of update_statistics command? : Sql dba

0 Answers  

---

<<labele>> declare a=10 b=20, begin some statements declare a=30 c=40 end; what is the A value in nested block?

1 Answers   ITC Infotech,

---

What is the difference between the implicit and explicit cursors?

0 Answers  

---

Name Salary Abc 50000 Abc 50000 xyz 20000 find the max salary using aggregate function?

2 Answers   CTS,

---

What is the starting oracle error number? What is meant by forward declaration in functions?

0 Answers  

---

Explain 3 basic parts of a trigger.

0 Answers  

---

How do you change a value in sql?

0 Answers  

---