What is the difference between the Primary and Foreign key?
- 7 Answers
- 14420 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / slokh
Primary key does not contain NULL or duplicate values.
whereas Foreign key accepts duplicate values but not null
values.
Primary key states the Entity integrity constraint, which
says that every row in a table is unique.
Foreign key states the referential integrity constraint,
that says that you can only insert values that is present
in the primary of the parent table.
| Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
In pl/sql, what is bulk binding, and when/how would it help performance?
What is server name sql?
How do you rename a table in sql?
What is the use of stored procedures?
What are three advantages to using sql?
Mention what does plv msg allows you to do?
What is a native sql query?
How to write html code in pl sql?
What is difference between rank () row_number () and dense_rank () in sql?
how to shut down the server with 'mysqladmin'? : Sql dba
what is top in tsql? : Transact sql
What are actual parameters and formal parameters?
What is the requirement of self-join?
How do I debug a stored procedure?
What are the benefits of triggers?
