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 steps for performance tuning.

0 Answers  

---

What is mutating error?

0 Answers  

---

How write primary and foreign key relationship between two tables without using constraints? u can use any of procedure/function/trigger and any sql?

1 Answers   Parexel,

---

create a store procedure and created synonms for that store procedure after modify that store procedure will effect on synonms? If we delete the store procedure what happened to that synonms?

2 Answers   Polaris,

---

Can we group by two columns in sql?

0 Answers  

---

Explain ddl statements in pl/sql?

0 Answers  

---

how to insert the records in particular position

1 Answers  

---

Is sql similar to python?

0 Answers  

---

What is left join in postgresql?

0 Answers  

---

Is progress software supports to ( pl/sql )?

0 Answers  

---

What is the difference between local variables and global variables?

0 Answers  

---

What is range partitioning?

0 Answers  

---