Interested to Buy Any Domain ? << Click Here >> for more details...
Explain the Difference Between a Primary Key and a Foreign Key.
- 1 Answers
- 1699 Views
- I also Faced
- E-Mail Answers
Answer Posted / hr@tgksolutions.com
Each record in a table is uniquely identified by its primary key, which also guarantees data integrity. There can only be one primary key per table, which guarantees that every record is distinct.
Conversely, a foreign key refers to the primary key in the associated table to establish a connection between two tables. By guaranteeing the validity of the link between the tables and the consistency of the data, this relationship aids in preserving referential integrity between them.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Why rdbms is called relational?
What is an advantage of a database?
What is 2nf and 3nf?
How do you create a report in a database?
What is father dbms?
How to detect applications and users that hold transactions open too long?
Define database model.
What is order by clause?
What are the types of database explain each of them briefly?
Explain a join between tables?
How can you perform pattern matching in sql?
What do database languages do?
What is rdbms architecture?
What is query in rdbms?
Differentiate between nested loop, hash loop and merge join.
