Practice Library
All MCQs
Browse exam-wise, subject-wise, and country-wise MCQs with explanations.
Choose an option to check your answer.
A.
converting SQL into machine code
B.
enforcing every foreign key twice
C.
intentionally adding redundancy to improve read performance in selected cases
D.
removing all data from tables
Show Answer
Correct Answer: C. intentionally adding redundancy to improve read performance in selected cases
Explanation:
This statement is correct because denormalization means that intentionally adding redundancy to improve read performance in selected cases.
Choose an option to check your answer.
A.
removing all data from tables
B.
converting SQL into machine code
C.
intentionally adding redundancy to improve read performance in selected cases
D.
enforcing every foreign key twice
Show Answer
Correct Answer: C. intentionally adding redundancy to improve read performance in selected cases
Explanation:
denormalization is used in Advanced DBMS because intentionally adding redundancy to improve read performance in selected cases.
Choose an option to check your answer.
A.
converting SQL into machine code
B.
removing all data from tables
C.
enforcing every foreign key twice
D.
intentionally adding redundancy to improve read performance in selected cases
Show Answer
Correct Answer: D. intentionally adding redundancy to improve read performance in selected cases
Explanation:
The correct answer explains denormalization in the context of Physical Design and Tuning.
Choose an option to check your answer.
A.
normalization applies only to MongoDB indexes
B.
normalization is only a security technique
C.
normalization always eliminates all joins
D.
normalization reduces redundancy but may require joins that affect performance
Show Answer
Correct Answer: D. normalization reduces redundancy but may require joins that affect performance
Explanation:
This statement is correct because normalization trade-off means that normalization reduces redundancy but may require joins that affect performance.
Choose an option to check your answer.
A.
normalization is only a security technique
B.
normalization reduces redundancy but may require joins that affect performance
C.
normalization always eliminates all joins
D.
normalization applies only to MongoDB indexes
Show Answer
Correct Answer: B. normalization reduces redundancy but may require joins that affect performance
Explanation:
normalization trade-off is used in Advanced DBMS because normalization reduces redundancy but may require joins that affect performance.
Choose an option to check your answer.
A.
normalization reduces redundancy but may require joins that affect performance
B.
normalization applies only to MongoDB indexes
C.
normalization always eliminates all joins
D.
normalization is only a security technique
Show Answer
Correct Answer: A. normalization reduces redundancy but may require joins that affect performance
Explanation:
The correct answer explains normalization trade-off in the context of Physical Design and Tuning.
Choose an option to check your answer.
A.
removing all constraints to make data flexible
B.
storing every table as a spreadsheet
C.
adjusting schema, indexes, queries, and configuration to improve performance
D.
turning off transactions permanently
Show Answer
Correct Answer: C. adjusting schema, indexes, queries, and configuration to improve performance
Explanation:
This statement is correct because database tuning means that adjusting schema, indexes, queries, and configuration to improve performance.
Choose an option to check your answer.
A.
removing all constraints to make data flexible
B.
adjusting schema, indexes, queries, and configuration to improve performance
C.
turning off transactions permanently
D.
storing every table as a spreadsheet
Show Answer
Correct Answer: B. adjusting schema, indexes, queries, and configuration to improve performance
Explanation:
database tuning is used in Advanced DBMS because adjusting schema, indexes, queries, and configuration to improve performance.
Choose an option to check your answer.
A.
removing all constraints to make data flexible
B.
turning off transactions permanently
C.
adjusting schema, indexes, queries, and configuration to improve performance
D.
storing every table as a spreadsheet
Show Answer
Correct Answer: C. adjusting schema, indexes, queries, and configuration to improve performance
Explanation:
The correct answer explains database tuning in the context of Physical Design and Tuning.
Choose an option to check your answer.
A.
drawing only conceptual ER diagrams
B.
assigning usernames to employees only
C.
deciding storage structures, indexes, partitions, and access paths for performance
D.
writing marketing content for a database product
Show Answer
Correct Answer: C. deciding storage structures, indexes, partitions, and access paths for performance
Explanation:
This statement is correct because physical database design means that deciding storage structures, indexes, partitions, and access paths for performance.
Choose an option to check your answer.
A.
writing marketing content for a database product
B.
deciding storage structures, indexes, partitions, and access paths for performance
C.
assigning usernames to employees only
D.
drawing only conceptual ER diagrams
Show Answer
Correct Answer: B. deciding storage structures, indexes, partitions, and access paths for performance
Explanation:
physical database design is used in Advanced DBMS because deciding storage structures, indexes, partitions, and access paths for performance.
Choose an option to check your answer.
A.
writing marketing content for a database product
B.
drawing only conceptual ER diagrams
C.
assigning usernames to employees only
D.
deciding storage structures, indexes, partitions, and access paths for performance
Show Answer
Correct Answer: D. deciding storage structures, indexes, partitions, and access paths for performance
Explanation:
The correct answer explains physical database design in the context of Physical Design and Tuning.
