In a relational database, which object is defined to guarantee that each value in a column of one table already exists as a matching value in a column of another table, thereby enforcing referential integrity?
Stored procedure
Index
Foreign key constraint
View
A foreign key constraint links a column or set of columns in one table to the primary key (or unique key) of another table. This relationship prevents inserting rows with values that do not exist in the referenced table and stops deletions or updates that would break existing links, thus enforcing referential integrity. An index improves search performance but does not validate relationships. A view is a saved query that presents data but cannot enforce referential rules. A stored procedure is executable code used to automate tasks and likewise does not impose referential integrity.
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
All IT & Cybersecurity Package plans include the following perks and exams .
Our pricing is simple. Full access to all certifications and exams in each package, for one price.
As many practice tests for as many topics as you want.
Use study mode non-stop, no limits.
Access to our AI assistant, Bash, trained to help you pass your exam.
Track your scores over time in study mode and report cards.
See how you improve over time, and where you need to focus.
Access our store with even bigger discounts than before.
Unlimited access to all performance questions and be prepared for the real thing.
All IT & Cybersecurity Package plans include unlimited access to the following study materials.
Create an account or sign in to access our study materials.