In Access, which of the following is a valid way to enforce referential integrity? MCQ with Answer and Explanation

Question

Share Report Error

In Access, which of the following is a valid way to enforce referential integrity?

A. Neither

B. Cascade Delete Related Records

C. Both A and B

D. Cascade Update Related Fields

Answer: Option C

Solution (By JKSSB Mock Tests)

When defining a relationship, you can set referential integrity and optionally cascade update/delete. Both are options.

This question belongs to: Computer Microsoft Office

Request complete Subject PDF

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Microsoft Office Questions

Question #1

In MS Access, which action query permanently deletes records from a table?

A. Append query

B. Delete query

C. Update query

D. Make-Table query

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Delete query removes records. Update changes values, Append adds records to a table, Make-Table creates a new table.

This question belongs to: Computer Microsoft Office

Question #2

In MS Word, the 'Compare' feature is used to:

A. Compare two versions of a document and show differences

B. Compare document with a template

C. Check grammar

D. Measure reading level

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Compare (Review tab) merges and highlights changes between two documents.

This question belongs to: Computer Microsoft Office

Question #3

In MS Access, which of the following is a valid event for a form?

A. After Update

B. On Load

C. All of these

D. On Click

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Forms have many events including On Load, On Click, After Update.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs