Interested to Buy Any Domain ? << Click Here >> for more details...
Explain the Difference Between a Primary Key and a Foreign Key.
- 1 Answers
- 1797 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
What is metadata and why should I use it?
Can I use google sheets as a database?
Enlist the advantages of dbms.
what are parameter, we can check after creating a database in terms of QC and for each tables what should be the parameters for QC and QA?
What do you understand by ‘atomicity’ and ‘aggregation’?
What is a field in database?
i have cleared the nic test...please send me the interview questions if anyone have them.... my email id is v84priya@gmail.com
What are the main characteristics of database approach?
What is a distributed database system?
What do you understand by the view and mention the steps to create, update and drop a view?
What are the various types of relationships in database? Define them.
What are the functions of rdbms?
What is cold backup (in case of oracle)?
Explain the difference between physical and logical data independence?
What is data modelling explain?
