Arrange according to the size

A. Record, field, byte, bit

B. Bit, field, byte, record

C. Field, byte, record, bit

D. Byte, bit, record, field

Answer: Option A

1

Which of the following is a NoSQL database?

A. MySQL

B. MongoDB

C. PostgreSQL

D. Oracle

2

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

3

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

A. GROUP BY

B. ORDER BY

C. HAVING

D. WHERE

4

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

A. ORDER BY

B. GROUP BY

C. HAVING

D. FILTER

5

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

Arrange according to the size

1

Which of the following is a NoSQL database?

2

What does the SQL 'TRUNCATE' command do?

3

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

4

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

5

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

Categories

Random Posts

About

Important Link

Company

Others

Social Media

Arrange according to the size

1 Which of the following is a NoSQL database?

2 What does the SQL 'TRUNCATE' command do?

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

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

5 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

What does the SQL 'TRUNCATE' command do?

3

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

4

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

5

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