adplus-dvertising
frame-decoration

Question

Purpose of foreign key constraint in SQL Server is __________

a.

FOREIGN KEY constraints identify and enforce the relationships between tables

b.

A foreign key in one table points to a candidate key in another table

c.

You cannot insert a row with a foreign key value, except NULL, if there is no candidate key with that value

d.

None of the mentioned

Posted under SQL Server

Answer: (a).FOREIGN KEY constraints identify and enforce the relationships between tables

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. Purpose of foreign key constraint in SQL Server is __________

Similar Questions

Discover Related MCQs

Q. Point out the wrong statement.

Q. Constraints can be applied on ___________

Q. Which of the following constraint does not enforce uniqueness?

Q. Point out the correct statement.

Q. Which of the following is not a class of constraint in SQL Server?

Q. Find all the tuples having temperature greater than ‘Paris’.

Q. The UNION SQL clause can be used with ____________

Q. Which is the duplication of computer operations and routine backups to combat any unforeseen problems?

Q. Which of the following is an aggregate function?

Q. The EXISTS keyword will be true if ____________

Q. To alter a database ___________ command is used.

Q. _______________ joins are SQL server default.

Q. Which is a duplicate copy of a file program that is stored on a different storage media than the original location?

Q. To delete a database ___________ command is used.

Q. Select ________ dept_name from instructor;

Here which of the following displays the unique values of the column?

Q. Which server can join the indexes when only multiple indexes combined can cover the query?

Q. Suppose we are given a view tot credits (year, num credits) giving the total number of credits taken by students in each year.The query that computes averages over the 3 preceding tuples in the specified sort order is _________

Q. Select ID, GPA from student grades order by GPA ____________

Inorder to give only 10 rank on the whole we should use.

Q. The ________ connective tests for set membership, where the set is a collection of values produced by a select clause. The _________ connective tests for the absence of set membership.

Q. Select __________ from instructor where dept name= ’Comp. Sci.’;

Which of the following should be used to find the mean of the salary?