what is primary key,unique key, foreign key? can u teach me
in simple language?
- 44 Answers
- 179768 Views
- Banking, CMC, CTS, HCL, Infosys, Keggfarms, SkyEss, Sunrise, TCS, Web Synergies, Wipro, I also Faced
- E-Mail Answers
Answer Posted / kranthi
primary key: primary creates a clustered index on the
column and it doesn't allow null values.
unique key: unique key creates non clustered index by
default.it allows "one null value".
foreign key: A foreign key (FK) is a column or combination
of columns used to establish and enforce a link between the
data in two tables
| Is This Answer Correct ? | 212 Yes | 76 No |
Post New Answer View All Answers
What are different types of joins used in?
What are indexes in oracle?
Explain various types of locks in a transaction? Which is better and why?
What is a database example?
What is the advantage of varchar2 over char?
What is the difference between database and server?
What is a sequence? Explain it with one example?
What is the Difference Primary key and Unique Key
What is database bounce?
How do I setup a database connection?
What is ase database?
What is difference between server and database?
How heap is implemented in database?
What are the validations performed on the source data? If there are junk data available in the source data, how to eliminate it?
What is the importance of database partitioning?
