Q1hard
(Logic/Schema) How does a Snowflake Schema differ from a Star Schema regarding Normalization?
Back to Database Management Systems
24 Questions Total
NoSQL & Modern Databases MCQs
Topic-wise practice questions for Database Management Systems. Test your knowledge, check solutions on demand, and pace your preparation.
Zero-leak answer engine • Rate-limited explanations
Practice in Timed ModeQ2hard
Why is Denormalization considered a standard "Best Practice" in NoSQL design, whereas it is avoided in Relational (SQL) design?
Q3medium
Which property of NewSQL databases (like CockroachDB or Google Spanner) distinguishes them from traditional NoSQL?
Q4hard
A social media company needs to implement a "Friend Recommendation" engine. The engine needs to traverse relationships like "Friends of Friends who also like the same Page." Which NoSQL model is mathematically optimized for this type of deep relationship traversal?
Q5medium
A researcher has a dataset of 1 million anonymous medical records. They use an algorithm to group patients into 5 distinct groups based on similar health metrics without knowing any pre-defined labels. This is an example of:
Q6medium
In a relational database, you "Scale Up" (Vertical Scaling). In NoSQL, you "Scale Out" (Horizontal Scaling). What is the main architectural challenge of Scaling Out?
Q7medium
A bank uses two systems. System A processes every ATM withdrawal and update instantly. System B generates a report every quarter showing spending trends across different age groups over the last 5 years. How are these systems categorized?
Q8medium
(Calculation/Logic) In a multi-dimensional Data Cube representing Sales, the user moves from looking at "Sales by Year" to "Sales by Quarter" to "Sales by Month". What is this OLAP operation called?
Q9easy
What is a "Factless Fact Table" in a Data Warehouse?
Q10easy
What is the primary use-case for a Column-Family Database (like Cassandra or HBase)?