what is primary key,unique key, foreign key? can u teach me
in simple language?
- 44 Answers
- 174379 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
Explain entity set?
HOW PASS PARAMETERS FOLLOWING ORDER RPG-CL-RPG?
Please post the scenerois for writing the complex sql queries , for my practice.Can be any query if you cannot solve.
Re: Where can i get informatica certification Exam dumps and details? please forward it to emailid:
Given a table Employee which has columns name and salary, write an SQL query to find the employee with the second highest salary.
How to shrink a database?
What is the importance of database partitioning?
What are indexes in oracle?
WHAT KIND OF TOOL BO IS?
What is the difference between specialization and generalization?
What is Object Oriented model?
Explain the record term used in database.
What the various ways to tune a teradata query
How do you connect to a database?
What is the purpose of firebase?
