Public task directory

Technical interview practice tasks

Every entry below is a crawlable link to a unique public task page. This directory complements the interactive filters and keeps the complete catalog connected through standard pagination.

Page 88 of 386 · 18,491 tasks

Knowledge Check · Easy · 1 min

What is the main purpose of Unique constraint in relational modeling

What is the main purpose of Unique constraint in relational modeling?

View task

Knowledge Check · Easy · 1 min

What is the main purpose of Join table in relational modeling

What is the main purpose of Join table in relational modeling?

View task

Knowledge Check · Easy · 1 min

What is the main purpose of Normalization in relational modeling

What is the main purpose of Normalization in relational modeling?

View task

Knowledge Check · Hard · 1 min

While reviewing relational modeling, order items point to deleted orders. Which action fixes it, and which check proves it worked

While reviewing relational modeling, order items point to deleted orders. Which action fixes it, and which check proves it worked?

View task

Knowledge Check · Hard · 1 min

While reviewing relational modeling, two accounts share one normalized email. Which action fixes it, and which check proves it worked

While reviewing relational modeling, two accounts share one normalized email. Which action fixes it, and which check proves it worked?

View task

Knowledge Check · Hard · 1 min

While reviewing relational modeling, users may belong to many teams. Which action fixes it, and which check proves it worked

While reviewing relational modeling, users may belong to many teams. Which action fixes it, and which check proves it worked?

View task

Knowledge Check · Hard · 1 min

While reviewing relational modeling, customer address copies drift across orders. Which action fixes it, and which check proves it worked

While reviewing relational modeling, customer address copies drift across orders. Which action fixes it, and which check proves it worked?

View task

Knowledge Check · Medium · 1 min

While reviewing relational modeling, order items point to deleted orders. Which action best addresses the problem

While reviewing relational modeling, order items point to deleted orders. Which action best addresses the problem?

View task

Knowledge Check · Medium · 1 min

While reviewing relational modeling, two accounts share one normalized email. Which action best addresses the problem

While reviewing relational modeling, two accounts share one normalized email. Which action best addresses the problem?

View task

Knowledge Check · Medium · 1 min

While reviewing relational modeling, users may belong to many teams. Which action best addresses the problem

While reviewing relational modeling, users may belong to many teams. Which action best addresses the problem?

View task

Knowledge Check · Medium · 1 min

While reviewing relational modeling, customer address copies drift across orders. Which action best addresses the problem

While reviewing relational modeling, customer address copies drift across orders. Which action best addresses the problem?

View task

Knowledge Check · Easy · 1 min

What is the main purpose of JSON schema in serialization protocols

What is the main purpose of JSON schema in serialization protocols?

View task

Knowledge Check · Easy · 1 min

What is the main purpose of Field compatibility in serialization protocols

What is the main purpose of Field compatibility in serialization protocols?

View task

Knowledge Check · Easy · 1 min

What is the main purpose of Canonical encoding in serialization protocols

What is the main purpose of Canonical encoding in serialization protocols?

View task

Knowledge Check · Easy · 1 min

What is the main purpose of Unknown field in serialization protocols

What is the main purpose of Unknown field in serialization protocols?

View task

Knowledge Check · Hard · 1 min

While reviewing serialization protocols, clients disagree about nullable response fields. Which action fixes it, and which check proves it worked

While reviewing serialization protocols, clients disagree about nullable response fields. Which action fixes it, and which check proves it worked?

View task

Knowledge Check · Hard · 1 min

While reviewing serialization protocols, a removed numeric field gets a new purpose. Which action fixes it, and which check proves it worked

While reviewing serialization protocols, a removed numeric field gets a new purpose. Which action fixes it, and which check proves it worked?

View task

Knowledge Check · Hard · 1 min

While reviewing serialization protocols, equivalent objects generate different signatures. Which action fixes it, and which check proves it worked

While reviewing serialization protocols, equivalent objects generate different signatures. Which action fixes it, and which check proves it worked?

View task

Knowledge Check · Hard · 1 min

While reviewing serialization protocols, an older consumer receives an added field. Which action fixes it, and which check proves it worked

While reviewing serialization protocols, an older consumer receives an added field. Which action fixes it, and which check proves it worked?

View task

Knowledge Check · Medium · 1 min

While reviewing serialization protocols, clients disagree about nullable response fields. Which action best addresses the problem

While reviewing serialization protocols, clients disagree about nullable response fields. Which action best addresses the problem?

View task

Knowledge Check · Medium · 1 min

While reviewing serialization protocols, a removed numeric field gets a new purpose. Which action best addresses the problem

While reviewing serialization protocols, a removed numeric field gets a new purpose. Which action best addresses the problem?

View task

Knowledge Check · Medium · 1 min

While reviewing serialization protocols, equivalent objects generate different signatures. Which action best addresses the problem

While reviewing serialization protocols, equivalent objects generate different signatures. Which action best addresses the problem?

View task

Knowledge Check · Medium · 1 min

While reviewing serialization protocols, an older consumer receives an added field. Which action best addresses the problem

While reviewing serialization protocols, an older consumer receives an added field. Which action best addresses the problem?

View task

Knowledge Check · Easy · 1 min

What is the main purpose of Inner join in SQL querying

What is the main purpose of Inner join in SQL querying?

View task

Knowledge Check · Easy · 1 min

What is the main purpose of Left join in SQL querying

What is the main purpose of Left join in SQL querying?

View task

Knowledge Check · Easy · 1 min

What is the main purpose of Aggregate filter in SQL querying

What is the main purpose of Aggregate filter in SQL querying?

View task

Knowledge Check · Easy · 1 min

What is the main purpose of Window function in SQL querying

What is the main purpose of Window function in SQL querying?

View task

Knowledge Check · Hard · 1 min

While reviewing SQL querying, a report needs orders with existing customers. Which action fixes it, and which check proves it worked

While reviewing SQL querying, a report needs orders with existing customers. Which action fixes it, and which check proves it worked?

View task

Knowledge Check · Hard · 1 min

While reviewing SQL querying, a report needs customers with zero orders. Which action fixes it, and which check proves it worked

While reviewing SQL querying, a report needs customers with zero orders. Which action fixes it, and which check proves it worked?

View task

Knowledge Check · Hard · 1 min

While reviewing SQL querying, a report needs users with three purchases. Which action fixes it, and which check proves it worked

While reviewing SQL querying, a report needs users with three purchases. Which action fixes it, and which check proves it worked?

View task

Knowledge Check · Hard · 1 min

While reviewing SQL querying, each order needs its customer running total. Which action fixes it, and which check proves it worked

While reviewing SQL querying, each order needs its customer running total. Which action fixes it, and which check proves it worked?

View task

Knowledge Check · Medium · 1 min

While reviewing SQL querying, a report needs orders with existing customers. Which action best addresses the problem

While reviewing SQL querying, a report needs orders with existing customers. Which action best addresses the problem?

View task

Knowledge Check · Medium · 1 min

While reviewing SQL querying, a report needs customers with zero orders. Which action best addresses the problem

While reviewing SQL querying, a report needs customers with zero orders. Which action best addresses the problem?

View task

Knowledge Check · Medium · 1 min

While reviewing SQL querying, a report needs users with three purchases. Which action best addresses the problem

While reviewing SQL querying, a report needs users with three purchases. Which action best addresses the problem?

View task

Knowledge Check · Medium · 1 min

While reviewing SQL querying, each order needs its customer running total. Which action best addresses the problem

While reviewing SQL querying, each order needs its customer running total. Which action best addresses the problem?

View task

Knowledge Check · Easy · 1 min

What is the main purpose of Atomic transaction in transactions isolation

What is the main purpose of Atomic transaction in transactions isolation?

View task

Knowledge Check · Easy · 1 min

What is the main purpose of Read committed in transactions isolation

What is the main purpose of Read committed in transactions isolation?

View task

Knowledge Check · Easy · 1 min

What is the main purpose of Serializable isolation in transactions isolation

What is the main purpose of Serializable isolation in transactions isolation?

View task

Knowledge Check · Easy · 1 min

What is the main purpose of Deadlock handling in transactions isolation

What is the main purpose of Deadlock handling in transactions isolation?

View task

Knowledge Check · Hard · 1 min

While reviewing transactions isolation, inventory decreases but order creation fails. Which action fixes it, and which check proves it worked

While reviewing transactions isolation, inventory decreases but order creation fails. Which action fixes it, and which check proves it worked?

View task

Knowledge Check · Hard · 1 min

While reviewing transactions isolation, a transaction rereads a row after another commit. Which action fixes it, and which check proves it worked

While reviewing transactions isolation, a transaction rereads a row after another commit. Which action fixes it, and which check proves it worked?

View task

Knowledge Check · Hard · 1 min

While reviewing transactions isolation, concurrent bookings can oversell one seat. Which action fixes it, and which check proves it worked

While reviewing transactions isolation, concurrent bookings can oversell one seat. Which action fixes it, and which check proves it worked?

View task

Knowledge Check · Hard · 1 min

While reviewing transactions isolation, two updates lock rows in opposite order. Which action fixes it, and which check proves it worked

While reviewing transactions isolation, two updates lock rows in opposite order. Which action fixes it, and which check proves it worked?

View task

Knowledge Check · Medium · 1 min

While reviewing transactions isolation, inventory decreases but order creation fails. Which action best addresses the problem

While reviewing transactions isolation, inventory decreases but order creation fails. Which action best addresses the problem?

View task

Knowledge Check · Medium · 1 min

While reviewing transactions isolation, a transaction rereads a row after another commit. Which action best addresses the problem

While reviewing transactions isolation, a transaction rereads a row after another commit. Which action best addresses the problem?

View task

Knowledge Check · Medium · 1 min

While reviewing transactions isolation, concurrent bookings can oversell one seat. Which action best addresses the problem

While reviewing transactions isolation, concurrent bookings can oversell one seat. Which action best addresses the problem?

View task

Knowledge Check · Medium · 1 min

While reviewing transactions isolation, two updates lock rows in opposite order. Which action best addresses the problem

While reviewing transactions isolation, two updates lock rows in opposite order. Which action best addresses the problem?

View task

Knowledge Check · Easy · 1 min

What is the main purpose of Cache in CI/CD cache artifacts

What is the main purpose of Cache in CI/CD cache artifacts?

View task