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 Delete Related Records

B. Neither

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

Share Report

Which Excel feature allows you to automatically fill cells with a series (e.g., 1,2,3 or Mon,Tue,Wed)?

A. Goal Seek

B. Data Validation

C. AutoFill handle

D. Flash Fill

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Dragging the fill handle (small square at bottom-right) creates series. Flash Fill detects patterns.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

In PowerPoint, the 'Animations' tab contains:

A. Transitions and timings

B. Slide layouts

C. Chart animations

D. Entrance, Emphasis, Exit, Motion Paths

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Animations tab for object animations.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

What is the keyboard shortcut to extend a cell selection block from the active cursor position down to the very last populated cell in that column in MS Excel?

A. Ctrl + Shift + End

B. Shift + Page Down

C. Alt + Shift + Down Arrow

D. Ctrl + Shift + Down Arrow

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl + Shift + Down Arrow extends the selection range down to the last non-blank cell in that column. Pressing Ctrl + Down Arrow jumps to that cell without selecting the range.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs