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
Why plvtab is considered as the easiest way to access the pl/sql table?
Is mariadb nosql?
What is a database event trigger?
What do you mean by “trigger” in sql?
What are some emotional triggers?
How do you run a query?
What are inner and outer joins examples of both?
What is the difference between the repeatable read and serializable isolation levels? : Transact sql
What view means?
what are the authentication modes in sql server? How can it be changed? : Sql dba
How is data stored on a disk?
Which is faster subquery or join?
Explain autonomous transaction.
How can you load multi line records? : aql loader
What is the difference between instead of trigger and after trigger?