Answer Posted / 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.

What is type and rowtype in pl sql?

978

---

What is the use of index in sql?

975

---

name 3 ways to get an accurate count of the number of records in a table? : Sql dba

1017

---

How show all rows in sql?

982

---

What is the difference between a primary key and a unique key?

1014

---

what is 'mysqldump'? : Sql dba

1060

---

is it possible to pass an object or table to a procedure as an argument?

1077

---

how to start mysql server? : Sql dba

1162

---

What are pl/sql packages?

1051

---

Is pl sql a programming language?

943

---

How can a pl sql block be executed?

908

---

Are null values same as that of zero or a blank space?

982

---

does sql support programming? : Sql dba

1005

---

What is break?

1151

---

Can we call procedure in select statement?

990

---