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
- 187746 Views
- Banking, CMC, CTS, HCL, Infosys, Keggfarms, SkyEss, Sunrise, TCS, Web Synergies, Wipro, I also Faced
- E-Mail Answers
Answer Posted / ck
Primary key is a key which will not allow any null values.
whereas unique key which will allows null value only once.
Foreign key is a key which values should match some values
in the primary key value.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Which Statement would you use to remove the EMPLOYEE_Id_PK PRIMARY KEY constraint and all depending constraints from the EMPLOYEE table?
WHAT IS THE PURPOSE OF TESTING INTEGRITY OF THE UNIVERSE?
what is ad-hoc access? what is the diff b/w managed query and ad-hoc access?
What are the disadvantages of views in a database?
What happens when shared and exclusive locks are applied on data item?
what is the role of auditor in auditing data oriented applications?
sparse lookup and where its options we find in OCI and db2?
Is data lake a database?
issues involved in modeling and building data werahouses
How default key is different from primary key?
What is a trace file?
What is a database example?
Explain file manager?
Explain database partitioning. What is its importance?
How many indexes can be created on a table?
