Login / Signup

Question

What is the purpose of a FOREIGN KEY constraint?

A To uniquely identify each row in a table

B To prevent NULL values in a column

C To speed up query execution automatically

D To enforce a link between the data in two tables, referencing the primary key of another table

E To create an index on a column

Practice Next

More IT Operating System Questions

What is a significant disadvantage of having too many indexes on a database table?
What is the worst-case time complexity for searching an element in a general (unbalanced) binary tree?
Which of the following is a common technique used in debugging to systematically narrow down the location of a bug?
Bus topology is also known by which one of the alternative names below?
What is the time complexity for inserting an element into a binary heap?
What is the primary goal of concurrent programming in software development?
What is the main reason to use a try-catch block in programming?
Perform a dry run of Binary Search for target = 29 in the sorted array [2, 12, 15, 17, 27, 29, 45]. What are the values of mid in each iteration until the ...
What is the final value of x after the following C++ code snippet executes? int x = 10; for (int i = 0; i < 3; ++i) { x += i; } ...
What is the time complexity of the KMP algorithm for searching a pattern of length 'M' in a text of length 'N'?

Hey! Ask a query

ask-question