Interested to Buy Any Domain ? << Click Here >> for more details...
Explain the Difference Between a Primary Key and a Foreign Key.
- 1 Answers
- 1743 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 dbms and its advantages?
Write down the differences between nosql and rdbms?
What is called dbms?
What are the benefits of database?
What is rdbms and its features?
What do you understand by data model?
What is index hunting?
What is procedure in database?
What does clipper stand for?
What is built_in Subprogram ?
Which database is best for storing images?
There are 100 datafiles, numbered from 1 to 100. File number 10 is deleted and it has 500 MB of data. The database is working in archive log mode. How can be the database recovered ? While doing recovery the archive logs applied are from nos 1 to 100, but 50 gets corrupted. What do we do? Can we proceed further? If so how?
What are the restrictions applicable while creating views?
How do convert or display the date or time as string?
What is a deadlock and mention how it can be resolved?
