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.

explain the advantages and disadvantages of stored procedure? : Sql dba

990

---

What is a common use of group by in sql?

1029

---

What are all the common sql functions?

998

---

What jobs use sql?

966

---

Which tcp/ip port does sql server run on? How can it be changed? : Sql dba

979

---

how many tables will create when we create table, what are they? : Sql dba

1051

---

What is package in pl sql?

999

---

What is mdf ldf and ndf?

975

---

What does the hierarchical profiler does?

1047

---

What is data type in sql?

941

---

What does cursor do in sql?

1003

---

Is primary key clustered or nonclustered?

991

---

how to load data files into tables with 'mysqlimport'? : Sql dba

1078

---

Can pl sql procedure have a return statement?

1000

---

What does sql stand for?

974

---