Which action query type in MS Access allows a database administrator to permanently remove a specific group of records from an underlying table based on criteria filters? MCQ with Answer and Explanation

Which action query type in MS Access allows a database administrator to permanently remove a specific group of records from an underlying table based on criteria filters?
A. Make-Table Query
B. Append Query
C. Update Query
D. Delete Query
Answer: Option D
Solution (By JKSSB Mock Tests)
A Delete Query targets records that match specified criteria filters and permanently deletes those rows from the database table.

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1
What is the shortcut key to insert a new worksheet in Excel?
A. Both A and B
B. Ctrl + Shift + N
C. Alt + I, W
D. Shift + F11

Correct Answer: Option A


Explanation:
Shift+F11 inserts a new worksheet, and Alt+I,W is the old menu shortcut. So both are valid.

This question belongs to: Computer Microsoft Office
Question #2
In Excel, what does the 'CONCATENATE' function do?
A. Splits text into separate columns
B. Compares two text strings
C. Converts text to uppercase
D. Joins two or more text strings into one

Correct Answer: Option D


Explanation:
CONCATENATE combines multiple text strings into a single string. In newer versions, CONCAT or TEXTJOIN are also used.

This question belongs to: Computer Microsoft Office
Question #3
What is the function of the keyboard shortcut Ctrl + K across Microsoft Word, Excel, and PowerPoint applications?
A. Opens the Insert Hyperlink dialog box window
B. Applies an italic style formatting layer
C. Deletes the selected paragraph line block
D. Launches the spell checker tool

Correct Answer: Option A


Explanation:
Ctrl + K is the standard keyboard shortcut used to open the Insert Hyperlink dialog box across Microsoft Office applications, allowing users to link to files or web pages.

This question belongs to: Computer Microsoft Office