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.

Whate is use of MOD function in pl/sql.

3 Answers   Oracle,

---

Are subqueries better than joins?

0 Answers  

---

explain advantages of myisam over innodb? : Sql dba

0 Answers  

---

What is a pl/sql block?

0 Answers  

---

What are functions in sql?

0 Answers  

---

Is pl sql different from sql?

0 Answers  

---

How can you fetch first 5 characters of the string?

0 Answers  

---

Whis is not false in primary key?

0 Answers   Fintellix,

---

what is self join and what is the requirement of self join? : Sql dba

0 Answers  

---

Explain the purpose of %type and %rowtype data types with the example?

0 Answers  

---

What is cold data?

0 Answers  

---

Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?

0 Answers  

---