In normalization, which normal form removes partial dependencies?

A. First Normal Form (1NF)

B. Second Normal Form (2NF)

C. Third Normal Form (3NF)

D. Boyce-Codd Normal Form (BCNF)

Answer: Option B

2NF removes partial dependency i.e., when a non-prime attribute depends only on part of a composite primary key.

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

In normalization, which normal form removes partial dependencies?

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 Links

Company

Others

Social Media

In normalization, which normal form removes partial dependencies?

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?