In MS Access, to delete all records from a table while keeping the structure, use: MCQ with Answer and Explanation

Question

Share Report Error

In MS Access, to delete all records from a table while keeping the structure, use:

A. DROP TABLE table_name;

B. ALTER TABLE;

C. TRUNCATE TABLE;

D. DELETE * FROM table_name;

Answer: Option D

Solution (By JKSSB Mock Tests)

DELETE command removes records. DROP TABLE removes entire table. Access does not support TRUNCATE.

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 Access, which of the following is used to create a query that asks for user input?

A. Select Query

B. Parameter Query

C. Crosstab Query

D. Action Query

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Parameter queries prompt for input.

This question belongs to: Computer Microsoft Office

Question #2

In MS Word, which feature allows you to see the formatting applied to text?

A. Thesaurus

B. Styles

C. Format Painter

D. Reveal Formatting

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Reveal Formatting (Shift+F1) shows a task pane displaying all formatting of selected text. Styles show applied style but not all formatting.

This question belongs to: Computer Microsoft Office

Question #3

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. Flash Fill

C. AutoFill handle

D. Data Validation

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

Explore All Microsoft Office MCQs