Explain the Difference Between a Primary Key and a Foreign Key.
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
explain about the critical recovery scenario you had experienced
What is the sql 'in' clause?
What is query in rdbms?
What does clipper stand for?
Define dml compiler.
How to prevent firebird.log file from filling up the disk partition?
What are the steps to follow when preparing to create a table?
Can I use google sheets as a database?
What is database join?
What do you understand by cursor?
What is maintaining database?
What is database host?
Explain environment of openedge?
What is 3 level architecture dbms?
What are the database skills?