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 can we optimize a sql query?

0 Answers  

---

In what condition is it good to disable a trigger?

0 Answers  

---

What are pl sql procedures?

0 Answers  

---

Is grant a ddl statement?

0 Answers  

---

what is the difference between varray and table data type..please expalain with some examples... under what situation you will go for varray..instead of index by table...

1 Answers   HCL, Satyam,

---

---

How do I restart sql?

0 Answers  

---

why should required nested tables, Object types, partition tables and varying arrays. what is the difference between these are all. give me example with explanation.

2 Answers  

---

What are types of joins?

0 Answers  

---

what is the functionality of the function htmlentities? : Sql dba

0 Answers  

---

How do I run pl sql in sql developer?

0 Answers  

---

what are rollup and cube in t-sql? : Transact sql

0 Answers  

---

Which function is used to return remainder in a division operator in sql?

0 Answers  

---