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.
| Is This Answer Correct ? | 31 Yes | 18 No |
Post New Answer View All Answers
Is sql sequential or random?
What are sql data types?
What does seeding a database mean?
how to shutdown mysql server? : Sql dba
What is the use of count (*) in sql?
How do I create a sql database?
how to check myisam tables for errors? : Sql dba
How do I find sql profiler?
What is primary key in db?
What does the sign mean in sql?
What are sql functions? Describe in brief different types of sql functions?
How do you declare a variable in pl sql?
How do we accept inputs from user during runtime?
What is dml statement?
Show the two pl/sql cursor exceptions.