What does the SQL 'TRUNCATE' command do?

A. Deletes all rows from a table without logging individual row deletions

B. Deletes only duplicate records

C. Removes table structure

D. Backs up the table

Answer: Option A

TRUNCATE removes all rows quickly without logging each row delete.

1

Which of the following is a NoSQL database?

A. MySQL

B. MongoDB

C. PostgreSQL

D. Oracle

2

Which SQL clause is used to filter records based on conditions?

A. GROUP BY

B. ORDER BY

C. HAVING

D. WHERE

3

Which SQL clause is used to aggregate rows based on a condition?

A. ORDER BY

B. GROUP BY

C. HAVING

D. FILTER

4

Which SQL keyword is used to remove duplicate records in a SELECT query?

A. DISTINCT

B. UNIQUE

C. REMOVE

D. EXCLUDE

Database MCQs	Computers and IT
Computer Fundamentals MCQ	Operating System MCQs
MS Word MCQs	MS Excel MCQs
C Programming MCQs	Data Structures & Algorithms MCQs
Computer Networking MCQs

What does the SQL 'TRUNCATE' command do?

1

Which of the following is a NoSQL database?

2

Which SQL clause is used to filter records based on conditions?

3

Which SQL clause is used to aggregate rows based on a condition?

4

Which SQL keyword is used to remove duplicate records in a SELECT query?

Categories

Random Posts

About

Important Links

Company

Others

Social Media

What does the SQL 'TRUNCATE' command do?

1 Which of the following is a NoSQL database?

2 Which SQL clause is used to filter records based on conditions?

3 Which SQL clause is used to aggregate rows based on a condition?

4 Which SQL keyword is used to remove duplicate records in a SELECT query?

Categories

Random Posts

Social Media

1

Which of the following is a NoSQL database?

2

Which SQL clause is used to filter records based on conditions?

3

Which SQL clause is used to aggregate rows based on a condition?

4

Which SQL keyword is used to remove duplicate records in a SELECT query?