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.

What are the types of dbms?

0 Answers  

---

what are enums used for in mysql? : Sql dba

0 Answers  

---

What is the difference between Union and Union all. Which is faster.

0 Answers  

---

a procedure one in two out parameters i am waiting it in a sql query can i get the output

1 Answers  

---

What is a parameter query?

0 Answers  

---

---

TABLE A TABLE B EMPNO ENAME EMPNO ENAME 1 A 1 A 2 B 2 B 3 C 3 C 4 D 4 D 5 E 5 E 6 F 7 G HOW TO GET THE UNMATCHED RECORDS IN SQL QUERY?

10 Answers   Satyam,

---

What is the difference between an inner and outer join?

0 Answers  

---

Why is sql better than hql?

0 Answers  

---

What are character functions?

0 Answers  

---

What is the difference between numeric and autonumber?

0 Answers  

---

Can we have exception part in trigger ?

1 Answers  

---

What is Materialized View? In What Scenario we Use Materialized View?

2 Answers   Dinesh, Marlabs,

---