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
Can we change the table name in sql?
What is cursor status?
What is scalar function in sql?
Does truncate table reset auto increment?
what is top in tsql? : Transact sql
How can use stored procedures in sql?
How show all rows in sql?
What is coalesce sql?
What is a data manipulation language?
What is java sql connection?
How would you pass hints to the sql processor?
What is posting?
Why do we use set serveroutput on?
What is multiple partition?
How to connect a sql*plus session to an oracle server?