what is primary key,unique key, foreign key? can u teach me
in simple language?
- 44 Answers
- 174200 Views
- Banking, CMC, CTS, HCL, Infosys, Keggfarms, SkyEss, Sunrise, TCS, Web Synergies, Wipro, I also Faced
- E-Mail Answers
Answer Posted / kiran chandra sarkar
PRIMARY KEY: A table can contain only one PRIMARY KEY. It
doesn’t allow null values; it is used as Foreign Key in
another Table (like Reference Key).
UNIQUE KEY: A Table may contain one or more UNIQUE
constraints. It’s allowing only one null value. Use this
key we maintain unique vales in the table.
FOREIGN KEY: A key used in one table to represent the value
of a primary key in a related table. While primary keys
must contain unique values, foreign keys may have
duplicates. For instance, if we use student ID as the
primary key in a Students table (each student has a unique
ID), we could use student ID as a foreign key in a Courses
table: as each student may do more than one course, the
student ID field in the Courses table (often shortened to
Courses. student ID) Will hold duplicate values.
| Is This Answer Correct ? | 92 Yes | 29 No |
Post New Answer View All Answers
Explain alternate key?
Is it good to store images in database?
Explain entity set?
What is the importance of database partitioning?
What does specialization in DBMS mean?
Two tables emp(empid,name,deptid,sal) and dept(deptid,deptname) are there.write a query which displays empname,corresponding deptname also display those employee names who donot belong to any dept.
What is database bounce?
Can you tell any two advantages of stored procedures?
What is a sequence? Explain it with one example?
Write a query to get maximum and second maximum in oracle?
What is ole db used for?
HOW PASS PARAMETERS FOLLOWING ORDER RPG-CL-RPG?
What is a Transformation?
Explain entity type?
Given a table of Player which contains Sno and player name, write a query which finds all possible Table Tennis doubles pairings.
