In MS Access, the 'Cascade Update Related Fields' option will: MCQ with Answer and Explanation

Question

Share Report Error

In MS Access, the 'Cascade Update Related Fields' option will:

A. Automatically update the foreign key in related records when the primary key is changed

B. Delete related records when the primary record is deleted

C. Prevent deletion of records that have related records

D. Copy the primary key to child table

Answer: Option A

Solution (By JKSSB Mock Tests)

Cascade Update updates foreign keys. Cascade Delete deletes related records.

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, which key is used to delete text to the right of the insertion point?

A. Backspace

B. Insert

C. Delete

D. End

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Delete key removes the character to the right. Backspace deletes to the left.

This question belongs to: Computer Microsoft Office

Question #2

In MS Word, what is the purpose of the 'Section Break'?

A. To create columns

B. To divide a document into sections that can have different formatting

C. To insert a page break

D. To start a new chapter

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Section breaks allow you to apply different page formatting (like margins, headers/footers, columns) to different parts of the document.

This question belongs to: Computer Microsoft Office

Question #3

In Excel, which function would you use to find the position of 'at' in the text 'Education'?

A. FIND("at", "Education")

B. MATCH("at", "Education")

C. Both A and B

D. SEARCH("at", "Education")

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Both SEARCH and FIND return the starting position. SEARCH is case-insensitive, FIND is case-sensitive.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs