Which of the following is a NoSQL database?

A. MySQL

B. MongoDB

C. PostgreSQL

D. Oracle

Answer: Option B

MongoDB is a NoSQL database designed for scalability and flexibility.

1

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

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

Which of the following is a NoSQL database?

1

What does the SQL 'TRUNCATE' command do?

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

Which of the following is a NoSQL database?

1 What does the SQL 'TRUNCATE' command do?

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

What does the SQL 'TRUNCATE' command do?

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?