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

2,015 questions to explore

Showing 601–620 of 2015 results

1…30 31 32…101

Database design and storage · Multiple Choice
Difficulty: Medium
What identifier is based on attributes that already have meaning in the business domain?
Key designEntity identity
Answer →
Database design and storage · Multiple Choice
Difficulty: Medium
What key consists of two or more attributes together?

Key designEntity identity

Database design and storage · Multiple Choice

Difficulty: Medium

What relationship permits at most one associated record on each side?

Relationship modelingReferential integrity

Database design and storage · Multiple Choice

Difficulty: Medium

What relationship allows one parent record to be referenced by multiple child records?

Relationship modelingReferential integrity

Database design and storage · Multiple Choice

Difficulty: Medium

What relationship allows multiple records on either side to associate with multiple records on the other side?

Relationship modelingReferential integrity

Database design and storage · Multiple Choice

Difficulty: Medium

What relation stores associations between the two sides of a many-to-many relationship?

Relationship modelingReferential integrity

Database design and storage · Multiple Choice

Difficulty: Medium

What data property requires stored references to remain consistent with the existence of their target rows?

Relationship modelingReferential integrity

Database design and storage · Multiple Choice

Difficulty: Medium

Which transaction property ensures its changes are accepted together or rolled back together?

ACID propertiesTransactions

Database design and storage · Multiple Choice

Difficulty: Medium

Which ACID property requires a transaction to preserve the database's defined integrity rules?

ACID propertiesTransactions

Database design and storage · Multiple Choice

Difficulty: Medium

Which ACID property governs how concurrent transactions interact and what intermediate states they can observe?

ACID propertiesTransactions

Database design and storage · Multiple Choice

Difficulty: Medium

Which ACID property preserves committed changes across failures covered by the database's guarantees?

ACID propertiesTransactions

Database design and storage · Multiple Choice

Difficulty: Medium

What unit groups database operations into a shared success-or-failure boundary?

ACID propertiesTransactions

Database design and storage · Multiple Choice

Difficulty: Medium

What anomaly occurs when a transaction observes changes made by another transaction that has not committed?

Concurrency anomaliesIsolation

Database design and storage · Multiple Choice

Difficulty: Medium

What anomaly occurs when rereading the same row observes a committed change made by another transaction?

Concurrency anomaliesIsolation

Database design and storage · Multiple Choice

Difficulty: Medium

What anomaly occurs when repeating a predicate query finds a changed set of matching rows?

Concurrency anomaliesIsolation

Database design and storage · Multiple Choice

Difficulty: Medium

What anomaly occurs when one write overwrites another update based on an outdated read?

Concurrency anomaliesIsolation

Database design and storage · Multiple Choice

Difficulty: Extra Hard

What anomaly occurs when transactions read a shared constraint but update different rows in a way that jointly violates it?

Concurrency anomaliesIsolation

Database design and storage · Multiple Choice

Difficulty: Medium

In a storage engine supporting clustering, which index organization determines how the table's data rows are stored?

Index designQuery performance

Database design and storage · Multiple Choice

Difficulty: Medium

Which index provides an additional lookup path separate from the table's primary storage organization?

Index designQuery performance

Database design and storage · Multiple Choice

Difficulty: Hard

What index contains all the columns a particular query needs, potentially avoiding a separate table lookup?

Index designQuery performance

Showing 601–620 of 2015 results

1…30 31 32…101