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. DROP TABLE table_name;

D. DELETE FROM 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

Data that has been processed, organized, structured, or presented in a given context to make it useful is known as what?

A. Field

B. Raw facts

C. Information

D. Database

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Information is data that has been processed, structured, or organized in a meaningful way to provide context and utility to the user.

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

Question #2

Share Report

What is a self join?

A. Joining two different tables

B. Joining a table with itself

C. Joining tables without a common column

D. Joining more than two tables

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
A self join is a join where a table is joined with itself, often used to compare rows within the same table.

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

Question #3

Share Report

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

A. Domain

B. Relation

C. Tuple

D. Attribute

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

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)

Explore All Database Management System (DBMS) MCQs