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 is the sql*loader? : aql loader

0 Answers  

---

Can you have multiple SPs with the same name on a database?

6 Answers   CGI,

---

Is stored procedure faster than query?

0 Answers  

---

What is memory optimized?

0 Answers  

---

Types of optimization?

6 Answers   Microsoft,

---

What are the types of index in sql?

0 Answers  

---

Which join condition can be specified using on clause?

0 Answers  

---

What does partition by mean in sql?

0 Answers  

---

How to make a copy values from one column to another in sql?

0 Answers  

---

What is pls integer?

0 Answers  

---

Explain the rollback statement?

0 Answers  

---

Why do we use partitions in sql?

0 Answers  

---