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 86 of 386 · 18,491 tasks

Knowledge Check · Easy · 1 min

What is the main purpose of Partial index in database indexes plans

What is the main purpose of Partial index in database indexes plans?

View task

Knowledge Check · Easy · 1 min

What is the main purpose of Index selectivity in database indexes plans

What is the main purpose of Index selectivity in database indexes plans?

View task

Knowledge Check · Easy · 1 min

What is the main purpose of Execution plan in database indexes plans

What is the main purpose of Execution plan in database indexes plans?

View task

Knowledge Check · Hard · 1 min

While reviewing database indexes plans, queries filter tenant then order by time. Which action fixes it, and which check proves it worked

While reviewing database indexes plans, queries filter tenant then order by time. Which action fixes it, and which check proves it worked?

View task

Knowledge Check · Hard · 1 min

While reviewing database indexes plans, queries repeatedly find active jobs. Which action fixes it, and which check proves it worked

While reviewing database indexes plans, queries repeatedly find active jobs. Which action fixes it, and which check proves it worked?

View task

Knowledge Check · Hard · 1 min

While reviewing database indexes plans, an index on a boolean is ignored. Which action fixes it, and which check proves it worked

While reviewing database indexes plans, an index on a boolean is ignored. Which action fixes it, and which check proves it worked?

View task

Knowledge Check · Hard · 1 min

While reviewing database indexes plans, a query slows after data growth. Which action fixes it, and which check proves it worked

While reviewing database indexes plans, a query slows after data growth. Which action fixes it, and which check proves it worked?

View task

Knowledge Check · Medium · 1 min

While reviewing database indexes plans, queries filter tenant then order by time. Which action best addresses the problem

While reviewing database indexes plans, queries filter tenant then order by time. Which action best addresses the problem?

View task

Knowledge Check · Medium · 1 min

While reviewing database indexes plans, queries repeatedly find active jobs. Which action best addresses the problem

While reviewing database indexes plans, queries repeatedly find active jobs. Which action best addresses the problem?

View task

Knowledge Check · Medium · 1 min

While reviewing database indexes plans, an index on a boolean is ignored. Which action best addresses the problem

While reviewing database indexes plans, an index on a boolean is ignored. Which action best addresses the problem?

View task

Knowledge Check · Medium · 1 min

While reviewing database indexes plans, a query slows after data growth. Which action best addresses the problem

While reviewing database indexes plans, a query slows after data growth. Which action best addresses the problem?

View task

Knowledge Check · Easy · 1 min

What is the main purpose of Expand phase in database migrations

What is the main purpose of Expand phase in database migrations?

View task

Knowledge Check · Easy · 1 min

What is the main purpose of Backfill in database migrations

What is the main purpose of Backfill in database migrations?

View task

Knowledge Check · Easy · 1 min

What is the main purpose of Contract phase in database migrations

What is the main purpose of Contract phase in database migrations?

View task

Knowledge Check · Easy · 1 min

What is the main purpose of Online index in database migrations

What is the main purpose of Online index in database migrations?

View task

Knowledge Check · Hard · 1 min

While reviewing database migrations, a live service needs a renamed column. Which action fixes it, and which check proves it worked

While reviewing database migrations, a live service needs a renamed column. Which action fixes it, and which check proves it worked?

View task

Knowledge Check · Hard · 1 min

While reviewing database migrations, a new column is empty for millions of records. Which action fixes it, and which check proves it worked

While reviewing database migrations, a new column is empty for millions of records. Which action fixes it, and which check proves it worked?

View task

Knowledge Check · Hard · 1 min

While reviewing database migrations, some instances may still read the old column. Which action fixes it, and which check proves it worked

While reviewing database migrations, some instances may still read the old column. Which action fixes it, and which check proves it worked?

View task

Knowledge Check · Hard · 1 min

While reviewing database migrations, a busy table needs a new index. Which action fixes it, and which check proves it worked

While reviewing database migrations, a busy table needs a new index. Which action fixes it, and which check proves it worked?

View task

Knowledge Check · Medium · 1 min

While reviewing database migrations, a live service needs a renamed column. Which action best addresses the problem

While reviewing database migrations, a live service needs a renamed column. Which action best addresses the problem?

View task

Knowledge Check · Medium · 1 min

While reviewing database migrations, a new column is empty for millions of records. Which action best addresses the problem

While reviewing database migrations, a new column is empty for millions of records. Which action best addresses the problem?

View task

Knowledge Check · Medium · 1 min

While reviewing database migrations, some instances may still read the old column. Which action best addresses the problem

While reviewing database migrations, some instances may still read the old column. Which action best addresses the problem?

View task

Knowledge Check · Medium · 1 min

While reviewing database migrations, a busy table needs a new index. Which action best addresses the problem

While reviewing database migrations, a busy table needs a new index. Which action best addresses the problem?

View task

Knowledge Check · Easy · 1 min

What is the main purpose of Network partition in distributed systems

What is the main purpose of Network partition in distributed systems?

View task

Knowledge Check · Easy · 1 min

What is the main purpose of Leader election in distributed systems

What is the main purpose of Leader election in distributed systems?

View task

Knowledge Check · Easy · 1 min

What is the main purpose of Quorum in distributed systems

What is the main purpose of Quorum in distributed systems?

View task

Knowledge Check · Easy · 1 min

What is the main purpose of Clock uncertainty in distributed systems

What is the main purpose of Clock uncertainty in distributed systems?

View task

Knowledge Check · Hard · 1 min

While reviewing distributed systems, two regions lose connectivity but remain running. Which action fixes it, and which check proves it worked

While reviewing distributed systems, two regions lose connectivity but remain running. Which action fixes it, and which check proves it worked?

View task

Knowledge Check · Hard · 1 min

While reviewing distributed systems, two schedulers assign the same singleton job. Which action fixes it, and which check proves it worked

While reviewing distributed systems, two schedulers assign the same singleton job. Which action fixes it, and which check proves it worked?

View task

Knowledge Check · Hard · 1 min

While reviewing distributed systems, one replica is stale during a write. Which action fixes it, and which check proves it worked

While reviewing distributed systems, one replica is stale during a write. Which action fixes it, and which check proves it worked?

View task

Knowledge Check · Hard · 1 min

While reviewing distributed systems, ordering relies on timestamps from different hosts. Which action fixes it, and which check proves it worked

While reviewing distributed systems, ordering relies on timestamps from different hosts. Which action fixes it, and which check proves it worked?

View task

Knowledge Check · Medium · 1 min

While reviewing distributed systems, two regions lose connectivity but remain running. Which action best addresses the problem

While reviewing distributed systems, two regions lose connectivity but remain running. Which action best addresses the problem?

View task

Knowledge Check · Medium · 1 min

While reviewing distributed systems, two schedulers assign the same singleton job. Which action best addresses the problem

While reviewing distributed systems, two schedulers assign the same singleton job. Which action best addresses the problem?

View task

Knowledge Check · Medium · 1 min

While reviewing distributed systems, one replica is stale during a write. Which action best addresses the problem

While reviewing distributed systems, one replica is stale during a write. Which action best addresses the problem?

View task

Knowledge Check · Medium · 1 min

While reviewing distributed systems, ordering relies on timestamps from different hosts. Which action best addresses the problem

While reviewing distributed systems, ordering relies on timestamps from different hosts. Which action best addresses the problem?

View task

Knowledge Check · Easy · 1 min

What is the main purpose of Safe method in HTTP semantics

What is the main purpose of Safe method in HTTP semantics?

View task

Knowledge Check · Easy · 1 min

What is the main purpose of Conditional request in HTTP semantics

What is the main purpose of Conditional request in HTTP semantics?

View task

Knowledge Check · Easy · 1 min

What is the main purpose of Content negotiation in HTTP semantics

What is the main purpose of Content negotiation in HTTP semantics?

View task

Knowledge Check · Easy · 1 min

What is the main purpose of Retry-After in HTTP semantics

What is the main purpose of Retry-After in HTTP semantics?

View task

Knowledge Check · Hard · 1 min

While reviewing HTTP semantics, a crawler follows a link that deletes data. Which action fixes it, and which check proves it worked

While reviewing HTTP semantics, a crawler follows a link that deletes data. Which action fixes it, and which check proves it worked?

View task

Knowledge Check · Hard · 1 min

While reviewing HTTP semantics, a client updates an older resource version. Which action fixes it, and which check proves it worked

While reviewing HTTP semantics, a client updates an older resource version. Which action fixes it, and which check proves it worked?

View task

Knowledge Check · Hard · 1 min

While reviewing HTTP semantics, clients need JSON and another media type. Which action fixes it, and which check proves it worked

While reviewing HTTP semantics, clients need JSON and another media type. Which action fixes it, and which check proves it worked?

View task

Knowledge Check · Hard · 1 min

While reviewing HTTP semantics, a service rejects traffic during overload. Which action fixes it, and which check proves it worked

While reviewing HTTP semantics, a service rejects traffic during overload. Which action fixes it, and which check proves it worked?

View task

Knowledge Check · Medium · 1 min

While reviewing HTTP semantics, a crawler follows a link that deletes data. Which action best addresses the problem

While reviewing HTTP semantics, a crawler follows a link that deletes data. Which action best addresses the problem?

View task

Knowledge Check · Medium · 1 min

While reviewing HTTP semantics, a client updates an older resource version. Which action best addresses the problem

While reviewing HTTP semantics, a client updates an older resource version. Which action best addresses the problem?

View task

Knowledge Check · Medium · 1 min

While reviewing HTTP semantics, clients need JSON and another media type. Which action best addresses the problem

While reviewing HTTP semantics, clients need JSON and another media type. Which action best addresses the problem?

View task

Knowledge Check · Medium · 1 min

While reviewing HTTP semantics, a service rejects traffic during overload. Which action best addresses the problem

While reviewing HTTP semantics, a service rejects traffic during overload. Which action best addresses the problem?

View task

Knowledge Check · Easy · 1 min

What is the main purpose of Request key in idempotency consistency

What is the main purpose of Request key in idempotency consistency?

View task