Questions Quizzes Daily challenge System design My attempts

Loading questions…

Practice / Questions

Question bank.

Explore 2,015 questions across 22 categories. Choose a subject, format, and difficulty, then learn from each explanation.

Prefer a full quiz? Browse quizzes →

Find a question

Search questions

Category

Topic

Question format

Difficulty

65 questions found

Showing 41–60 of 65 results

1 2 3 4

Database design and storage · Multiple Choice
Difficulty: Medium
Which database model stores self-contained structured records with nested fields and arrays?
Nonrelational modelsData modeling
Answer →
Database design and storage · Multiple Choice
Difficulty: Medium

Which database model primarily retrieves a stored value by its associated key?

Nonrelational modelsData modeling

Database design and storage · Multiple Choice

Difficulty: Medium

Which database model organizes sparse rows using families or groupings of columns?

Nonrelational modelsData modeling

Database design and storage · Multiple Choice

Difficulty: Medium

Which database model makes entities and their relationships central to storage and querying?

Nonrelational modelsData modeling

Database design and storage · Multiple Choice

Difficulty: Medium

Which database model specializes in measurements associated with timestamps?

Nonrelational modelsData modeling

Database design and storage · Multiple Choice

Difficulty: Medium

What recovery milestone records a state from which less log replay is needed after restart?

Maintenance and recoveryDatabase operations

Database design and storage · Multiple Choice

Difficulty: Hard

In PostgreSQL, which maintenance process makes storage occupied by obsolete row versions reusable?

Maintenance and recoveryDatabase operations

Database design and storage · Multiple Choice

Difficulty: Hard

What storage maintenance process merges runs and discards superseded or obsolete entries?

Maintenance and recoveryDatabase operations

Database design and storage · Multiple Choice

Difficulty: Medium

What retained copy of database data supports recovery after loss or corruption?

Maintenance and recoveryDatabase operations

Database design and storage · Multiple Choice

Difficulty: Hard

What recovery capability restores a database to a selected moment using a base backup and subsequent change records?

Maintenance and recoveryDatabase operations

Database design and storage · Matching

Difficulty: Extra Hard

Match the descriptions to these normalization terms: First normal form, Second normal form, Third normal form, Boyce-Codd normal form.

NormalizationConcept relationships

Database design and storage · Matching

Difficulty: Medium

Match the descriptions to these key design terms: Candidate key, Superkey, Surrogate key, Natural key.

Key designConcept relationships

Database design and storage · Matching

Difficulty: Medium

Match the descriptions to these relationship modeling terms: One-to-one relationship, One-to-many relationship, Many-to-many relationship, Junction table.

Relationship modelingConcept relationships

Database design and storage · Matching

Difficulty: Medium

Match the descriptions to these acid properties terms: Atomicity, Consistency, Isolation, Durability.

ACID propertiesConcept relationships

Database design and storage · Matching

Difficulty: Medium

Match the descriptions to these concurrency anomalies terms: Dirty read, Nonrepeatable read, Phantom read, Lost update.

Concurrency anomaliesConcept relationships

Database design and storage · Numerical Answer

Difficulty: Easy

A 12 GiB dataset is stored as 2 complete replicas in total. Ignoring indexes and overhead, how many GiB are stored?

ReplicationStorage planning

Database design and storage · Numerical Answer

Difficulty: Easy

A 15 GiB dataset is stored as 3 complete replicas in total. Ignoring indexes and overhead, how many GiB are stored?

ReplicationStorage planning

Database design and storage · Numerical Answer

Difficulty: Easy

A 18 GiB dataset is stored as 4 complete replicas in total. Ignoring indexes and overhead, how many GiB are stored?

ReplicationStorage planning

Database design and storage · Numerical Answer

Difficulty: Easy

A 21 GiB dataset is stored as 2 complete replicas in total. Ignoring indexes and overhead, how many GiB are stored?

ReplicationStorage planning

Database design and storage · Numerical Answer

Difficulty: Easy

A 24 GiB dataset is stored as 3 complete replicas in total. Ignoring indexes and overhead, how many GiB are stored?

ReplicationStorage planning

Showing 41–60 of 65 results

1 2 3 4