Which of the following is a way to avoid redundancy in a database? MCQ with Answer and Explanation

Question

Share Report Error

Which of the following is a way to avoid redundancy in a database?

A. Normalization

B. Replication

C. Denormalization

D. Indexing

Answer: Option A

Solution (By JKSSB Mock Tests)

Normalization reduces redundancy by organizing data into tables with minimal duplication.

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 model represents data in the form of tables?

A. Entity-Relationship model only

B. Hierarchical model

C. Relational model

D. Network model

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
The relational model uses tables (relations) to represent data and relationships.

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

Question #2

Which of the following is a valid SQL statement to add a new column to a table?

A. ALTER TABLE table_name ADD column_name datatype;

B. ADD COLUMN TO table_name column_name datatype;

C. ALTER TABLE table_name ADD COLUMN column_name datatype;

D. Both A and C

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Both 'ADD column_name datatype' and 'ADD COLUMN column_name datatype' are valid syntax in some DBMS, but standard SQL uses 'ADD column_name datatype'. However, many DBMS support both.

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

Question #3

Which of the following represents raw, unorganized, and unprocessed facts that lack contextual meaning?

A. Information

B. Metadata

C. Knowledge

D. Data

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Data refers to raw, unorganized, and unprocessed facts, figures, or symbols that do not convey a specific meaning on their own. When data is processed and organized, it becomes information.

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

Explore All Database Management System (DBMS) MCQs