Explain the Difference Between a Primary Key and a Foreign Key.
- 1 Answers
- 263 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 |
Explain primary key and composite key.
What is the use of GRANT option in IMP command ?
What do you understand by index hunting?
What is Data Redundancy and Consistency ?
Define entity, entity type, and entity set.
Explain the importance of database partitioning.
Is it possible to Disable the Parameter form while running the report ?
What is Database Management System?
Describe why operational and informational systems are separate.
Do we consider null values the same as that of blank space or zero?
What SYSTEM VARIABLE is used to refer DATABASE TIME ?
Have you written applications to retrieve stored images in a table?
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
