Question
In relational databases, which of the following best
describes the role of a "foreign key"?Solution
A foreign key is a column or group of columns in one table that refers to the primary key of another table, thus creating a relationship between the two tables. This key ensures referential integrity , meaning that the data in the foreign key column must match existing data in the primary key column of the referenced table. Referential integrity prevents orphaned records and maintains the consistency of the data across the database. A (Incorrect): This describes a primary key , not a foreign key. C (Incorrect): Foreign keys may allow duplicate values if the relationship permits it, but this is not their defining characteristic. D (Incorrect): While a foreign key references the primary key of another table, it is not itself the primary key of the current table. E (Incorrect): Foreign keys are not used solely for indexing; their main purpose is to enforce relationships between tables.
22nd Summit of the SCO Council hosted by which ministry ?
The English defeated the _________ in the battle of Wandiwash.
Which two numbers should be interchanged to make the given equation correct?
72 – 56 + (13 +19) × 2 – 95 ÷ 5 +17 = 76
(Note: Interch...
Which of the following option is not correct about “Beti Bachao Beti Pdhao”?
With reference to the public finance, which of the following statements is/are correct?
I. All revenues rece...
निम्नलिखित में से कौन सा/से ऑस्ट्रेलिया के संविधान से नही�...
What is the minimum distance one has to stand at from a wall to hear an echo?
Which of the following is not a secondary market instrument?
The country's first commercial-scale biomass-based hydrogen plant is coming up in which district of Madhya Pradesh?
In which state the 30th National Panchayati Raj Day function was held?