In MS Access, which SQL statement query mode is used to permanently remove specified records from an underlying data table row range? MCQ with Answer and Explanation

Question

In MS Access, which SQL statement query mode is used to permanently remove specified records from an underlying data table row range?

A. Truncate Action

B. Drop Table Query

C. Remove Rows Macro

D. Delete Query

Answer: Option D

Solution (By JKSSB Mock Tests)

A Delete Query matches target row entries using defined criteria limits and permanently removes those records from the table database.

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

In MS Access, the 'Required' field property set to 'Yes' means:

A. The field is indexed with duplicates allowed

B. The field must be the primary key

C. The field cannot be left blank; it must contain a value

D. The field will auto-increment

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Required enforces that the field is not null.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

What is the native presentation file save format extension for MS PowerPoint versions 2007 and newer?

A. .pptx

B. .ppt

C. .ppsx

D. .potx

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
.pptx is the standard XML-based default file extension format for PowerPoint files since 2007.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

To quickly minimize the ribbon in MS Office, press:

A. F1

B. Ctrl + F1

C. Alt + F1

D. Shift + F1

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Ctrl+F1 collapses/expands the ribbon.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs