Which SQL statement is used to delete all rows from a table without logging individual row deletions? MCQ with Answer and Explanation

Question

Share Report Error

Which SQL statement is used to delete all rows from a table without logging individual row deletions?

A. TRUNCATE TABLE table_name;

B. REMOVE FROM table_name;

C. DELETE FROM table_name;

D. DROP TABLE table_name;

Answer: Option A

Solution (By JKSSB Mock Tests)

TRUNCATE TABLE removes all rows and is a DDL operation with minimal logging, often faster than DELETE without WHERE.

This question belongs to: Computer Database Management System (DBMS)

Request complete Subject PDF

Discuss this Question (0)

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

Practice More Database Management System (DBMS) Questions

Question #1

Share Report

What is the alternative mathematical term used for a 'Table' in a relational database model?

A. Attribute

B. Tuple

C. Relation

D. Domain

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
In relational model terminology introduced by E.F. Codd, a table is formally referred to as a relation.

This question belongs to: Computer Database Management System (DBMS)

Question #2

Share Report

In SQL, which statement is used to create a new database?

A. NEW DATABASE

B. CREATE DATABASE

C. CREATE TABLE

D. CREATE SCHEMA

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
CREATE DATABASE is used to create a new database in SQL.

This question belongs to: Computer Database Management System (DBMS)

Question #3

Share Report

Which of the following represents raw, unorganized, and unprocessed facts that lack contextual meaning?

A. Knowledge

B. Data

C. Metadata

D. Information

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Data refers to raw, unorganized, and unprocessed facts, figures, or symbols that do not convey a specific meaning on their own. When data is processed and organized, it becomes information.

This question belongs to: Computer Database Management System (DBMS)

Explore All Database Management System (DBMS) MCQs