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. Cascade Update Related Fields

B. Both A and B

C. Cascade Delete Related Records

D. Neither

Answer: Option B

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 Word, to insert an index, go to:

A. Insert -> Index

B. References -> Insert Index

C. Review -> Index

D. Layout -> Index

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Index is under References tab.

This question belongs to: Computer Microsoft Office

Question #2

In Excel, which function is used to find the smallest value in a range?

A. MINIFS

B. SMALL

C. MIN

D. MINA

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
MIN returns the smallest numeric value. SMALL returns the nth smallest, MINA includes logical values, MINIFS based on criteria.

This question belongs to: Computer Microsoft Office

Question #3

Which of the following is a valid way to start a formula in Excel?

A. = (equal sign)

B. + (plus sign)

C. @ (at sign)

D. All of these

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
While = is standard, you can also start with + or - and Excel will convert it to a formula. @ is used in table references but not to begin a formula. So only = is required. + also works in some cases (e.g., +A1+A2). Many exams consider = only. I'll stick with = only. I'll set answer A.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs