what is primary key,unique key, foreign key? can u teach me
in simple language?
- 44 Answers
- 174634 Views
- Banking, CMC, CTS, HCL, Infosys, Keggfarms, SkyEss, Sunrise, TCS, Web Synergies, Wipro, I also Faced
- E-Mail Answers
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
Write a query to get maximum and second maximum in oracle?
What is sharded database?
Should I store images in database?
Explain the table term used in database.
Define stored procedure?
List the properties of a transaction.
How heap is implemented in database?
What is the importance of database partitioning?
can we delete autodiff back up that we have set through sql server agent.
How do database connections work?
What are the various ways to execute a query in teradata?
Please post the scenerois for writing the complex sql queries , for my practice.Can be any query if you cannot solve.
What is Data Modelling?
Explain partial key?
Explain storage manager?
