what is primary key,unique key, foreign key? can u teach me
in simple language?
Answer Posted / haripriya
Primary Key:- The primary key is the key which is uniquely
identifing in a table which not take null value for that
particular field and we don't take dublicate value for that
key.
unique key~ unique key creates non clustered index by
default.it allows "one null value".
A foreign key (sometimes called a referencing key) is a key
used to link two tables together.
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
What is a database lookup?
define primary key index, bitmap index, hash index,virtual indwx
Under which circumstance should you create an index on a table?
Explain buffer manager?
What is the difference between database and server?
Why merge statement is used inside the database?
What is the Difference Primary key and Unique Key
how to reject duplicates in source sequential file and if by filter option then where is that filter option in the sequential file.
What is table scan and index scan?
how can you perform lookup range in lookup stage expalin in detail?
If the master device is full, how do I make the master database bigger?
What is the purpose of TNS?
What are the tools used for backup and ticketing?
What is replicaset?
What is a database example?