Central Exam — Computer Knowledge
UPSC · SSC · Bank · Railway · NDA — Central Government Exam MCQ Practice
Showing 61–65 of 65 questions
Q.61
Hard
Database/SQL
In database normalization, what does the Boyce-Codd Normal Form (BCNF) address that 3NF might miss?
Correct Answer:
B. Removal of anomalies from composite candidate keys
Explanation:
BCNF handles edge cases in 3NF where anomalies can occur with composite candidate keys where determinants are not candidate keys themselves.
Q.62
Hard
Database/SQL
In distributed systems, what is a consensus algorithm primarily used for?
Correct Answer:
B. Ensuring all nodes agree on a single value despite failures
Explanation:
Consensus algorithms (like Raft, Paxos) enable distributed systems to reliably agree on state even with node failures.
Q.63
Hard
Database/SQL
What is the primary challenge of implementing ACID properties in distributed databases?
Correct Answer:
B. Network partitions, latency, and node failures make maintaining consistency difficult while ensuring availability
Explanation:
The CAP theorem shows it's impossible to guarantee all three: Consistency, Availability, and Partition tolerance simultaneously.
Q.64
Hard
Database/SQL
In AI/ML, what is the role of activation functions in neural networks?
Correct Answer:
B. Introduce non-linearity enabling networks to learn complex patterns
Explanation:
Activation functions (ReLU, sigmoid, tanh) add non-linearity, allowing neural networks to approximate non-linear relationships.
Q.65
Hard
Database/SQL
In a sharded database architecture deployed on cloud infrastructure, which of the following represents the most critical challenge that must be addressed?
Correct Answer:
A. Shard key selection and distribution skew
Explanation:
Shard key selection determines data distribution and performance. Poor shard key choices lead to hotspots, uneven load distribution, and performance degradation across the sharded cluster.