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. DELETE * FROM table_name;

C. ALTER TABLE;

D. TRUNCATE TABLE;

Answer: Option B

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 MS Access, what is a 'lookup field'?

A. A field with an input mask

B. A field that stores hyperlinks

C. A field that displays a list of values from a table or query for selection

D. A field used to search records quickly

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
A lookup field provides a dropdown list of values from a row source.

This question belongs to: Computer Microsoft Office

Question #2

In PowerPoint, what is the function of the 'Reuse Slides' option?

A. Insert slides from another presentation without copying manually

B. Reformat all slides

C. Duplicate the current slide

D. Reset slide layout

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Reuse Slides (Home tab -> New Slide dropdown) imports slides from other presentations.

This question belongs to: Computer Microsoft Office

Question #3

In Access, which of the following is a valid way to import data from an Excel spreadsheet?

A. External Data tab > Excel

B. Home > Import

C. File > Open > Excel

D. Create > Import Excel

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
The External Data tab has options to import from Excel. File > Open opens Access databases, not import.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs