What is normalization in database design? MCQ with Answer and Explanation

Question

Share Report Error

What is normalization in database design?

A. The process of organizing data to reduce redundancy and improve integrity

B. The process of indexing tables

C. The process of encrypting data

D. The process of increasing data duplication

Answer: Option A

Solution (By JKSSB Mock Tests)

Normalization is the process of structuring a relational database to reduce data redundancy and dependency, typically by dividing large tables into smaller, related tables.

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

Which of the following is a valid way to join three tables in SQL?

A. SELECT * FROM table1, table2, table3 WHERE condition1 AND condition2;

B. Neither

C. SELECT * FROM table1 JOIN table2 ON condition1 JOIN table3 ON condition2;

D. Both A and B

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Both syntaxes are valid: explicit JOIN syntax and implicit comma join with WHERE conditions.

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

Question #2

What is the purpose of the SQL 'IN' operator?

A. To join tables

B. To check if a value is between two values

C. To check if a value is null

D. To check if a value matches any value in a list

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
IN is used to test membership in a set of values.

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

Question #3

A Primary Key in RDBMS must be:

A. Always a foreign key

B. Can have null values

C. Unique and not null

D. Duplicate values allowed

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
A primary key uniquely identifies each record and cannot contain null values.

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

Explore All Database Management System (DBMS) MCQs