Interested to Buy Any Domain ? << Click Here >> for more details...
Explain the Difference Between a Primary Key and a Foreign Key.
- 1 Answers
- 1704 Views
- I also Faced
- E-Mail Answers
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 |
What is the purpose of using a model?
Is facebook a database?
What is n tier architecture in dbms?
How to write udf s in delphi?
What is the use of COMPRESS option in EXP command ?
Explain the architecture of reporting services?
Can we attach the same List of Values to different fields in Design time ?
Mention a query to add email validation to your database
What are the features of rdbms?
What are different types of joins in sql?
What are the features of dbms?
What is the use of INCTYPE option in EXP command ?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
