Interested to Buy Any Domain ? << Click Here >> for more details...
what is primary key,unique key, foreign key? can u teach me
in simple language?
- 44 Answers
- 189073 Views
- Banking, CMC, CTS, HCL, Infosys, Keggfarms, SkyEss, Sunrise, TCS, Web Synergies, Wipro, I also Faced
- E-Mail Answers
Answer Posted / rama
primary key:primary key is not allowed null values and
duplicate values.
unique key: this key allows null values but does not allow
duplicate values.
foreign key:
this key is used to refer another table.(i.e)other table
primary key values is used in foreign key table.it makes
relation ship between two tables.
| Is This Answer Correct ? | 19 Yes | 10 No |
Post New Answer View All Answers
What advantages does DBMS have over traditional file systems?
What is a database connection string?
Differentiate between delete and truncate table?
What is the difference between specialization and generalization?
How to shrink a database?
Why merge statement is used inside the database?
Given a table Employee which has columns name and salary, write an SQL query to find the employee with the second highest salary.
Explain the table term used in database.
Explain the various types of normalization.
What is the difference between oracle and MS Access?
Explain entity set?
What does new grouping sets enables you to do?
Explain the record term used in database.
How to produce such kind of file?
Which Statement would you use to remove the EMPLOYEE_Id_PK PRIMARY KEY constraint and all depending constraints from the EMPLOYEE table?
