Which of the following is a property of a well-designed database? MCQ with Answer and Explanation

Which of the following is a property of a well-designed database?
A. Ease of data maintenance
B. Support for efficient data retrieval
C. Avoidance of data redundancy
D. All of the above
Answer: Option D
Solution (By JKSSB Mock Tests)
Good database design aims to minimize redundancy, simplify maintenance, and provide efficient access.

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Database Management System (DBMS) Questions

Question #1
The range of all permissible and valid values that an attribute can hold is formally defined as its what?
A. Domain
B. Tuple
C. Schema
D. Relation

Correct Answer: Option A


Explanation:
A Domain is the pool of legal, atomic values from which an attribute can take its value.

This question belongs to: Computer Database Management System (DBMS)
Question #2
What is the purpose of the SQL 'WITH' clause (Common Table Expression)?
A. To create a view
B. To delete data
C. To define a temporary result set that can be referenced within a query
D. To update data

Correct Answer: Option C


Explanation:
A Common Table Expression (CTE) provides a temporary named result set that can be used within a SELECT, INSERT, UPDATE, or DELETE statement.

This question belongs to: Computer Database Management System (DBMS)
Question #3
A table is in Third Normal Form (3NF) if it is in 2NF and has absolutely no non-prime attributes that exhibit what type of dependency?
A. Partial Dependency
B. Join Dependency
C. Transitive Dependency
D. Trivial Dependency

Correct Answer: Option C


Explanation:
Third Normal Form (3NF) requires a relation to be in 2NF with no transitive dependencies, meaning non-prime attributes cannot be determined by other non-prime attributes.

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