| 1 | What are the core data types supported by Redis, and what is each one typically used for? Redis › Data Types | Redis | Data Types | Beginner |
| 2 | How would you model a many to many relationship, such as users following other users, using Redis's native data types? Redis › Data Types | Redis | Data Types | Advanced |
| 3 | What are the 2 broad classifications of data types available in C#? C# Programming › Data Types in C# | C# Programming | Data Types in C# | Beginner |
| 4 | How do you create user-defined data types in C#? C# Programming › Data Types in C# | C# Programming | Data Types in C# | Intermediate |
| 5 | What are the eight primitive data types in Java, and how do they differ fundamentally from reference types like String or a custom class? Java › Java Fundamentals: Syntax, Data Types & Operators | Java | Java Fundamentals: Syntax, Data Types & Operators | Beginner |
| 6 | What are the most commonly used data types in SQL Server, and when would you use each one? SQL Server › Data Types & Schema Design | SQL Server | Data Types & Schema Design | Beginner |
| 7 | What are the basic data types available in PHP? PHP › Basics & Types | PHP | Basics & Types | Beginner |
| 8 | How do you actually properly read and write different basic primitive data types, such as a String, an int, and a bool, using the shared_preferences package's own available methods? Flutter › Local Data Storage with SharedPreferences | Flutter | Local Data Storage with SharedPreferences | Beginner |
| 9 | Why does choosing the right Redis data type for your data matter, rather than just storing everything as a string? Redis › Data Types | Redis | Data Types | Beginner |
| 10 | How do you check which specific data type and internal encoding a given Redis key is currently using? Redis › Data Types | Redis | Data Types | Intermediate |
| 11 | What are the internal memory encoding optimizations Redis applies to small collections, and how do they affect performance and memory usage? Redis › Data Types | Redis | Data Types | Advanced |
| 12 | What is the difference between a Redis set and a Redis sorted set, and when would you choose one over the other? Redis › Data Types | Redis | Data Types | Intermediate |
| 13 | What is a Redis hash, and why is it often a more efficient choice than storing separate keys for each field of an object? Redis › Data Types | Redis | Data Types | Intermediate |
| 14 | How do you actually properly pass genuinely complex data types, such as a Map or a List, between Dart and native code through a platform channel, and what specific limitations genuinely exist regarding exactly what data can actually genuinely be sent? Flutter › Platform Channels (Native Android & iOS Integration) | Flutter | Platform Channels (Native Android & iOS Integration) | Intermediate |
| 15 | What data types and values can be safely passed as props from a server component to a client component? Next.js › Server Components | Next.js | Server Components | Advanced |
| 16 | How would you evaluate whether to use a Redis module for a specific feature versus implementing similar functionality using Redis's core data types directly? Redis › Redis Modules Overview | Redis | Redis Modules Overview | Advanced |
| 17 | What are the differences between value types and reference types? C# Programming › Data Types in C# | C# Programming | Data Types in C# | Beginner |
| 18 | How would you use TypeScript's 'unknown' type, rather than 'any', when initially typing uncertain data during migration to preserve safety? TypeScript › Migrating JavaScript to TypeScript | TypeScript | Migrating JavaScript to TypeScript | Advanced |
| 19 | What do you mean by casting a data type? C# Programming › Data Types in C# | C# Programming | Data Types in C# | Beginner |
| 20 | What are the 2 kinds of data type conversions available in C#? C# Programming › Data Types in C# | C# Programming | Data Types in C# | Beginner |
| 21 | What's the difference between shallow copy and deep copy for a nested data structure, and which functions perform each? Python › Data Types & Structures | Python | Data Types & Structures | Intermediate |
| 22 | How do you choose an appropriately sized data type for a column to balance storage efficiency with future flexibility? SQL Server › Data Types & Schema Design | SQL Server | Data Types & Schema Design | Intermediate |
| 23 | How would you implement a custom, memory-efficient data structure using __slots__ instead of a regular class with a __dict__? Python › Data Types & Structures | Python | Data Types & Structures | Advanced |
| 24 | How do dictionaries maintain insertion order internally since Python 3.7, and what data structure change made this both possible and efficient? Python › Data Types & Structures | Python | Data Types & Structures | Advanced |
| 25 | How would you use collections.Counter to efficiently count occurrences and find the most common elements in a large dataset? Python › Data Types & Structures | Python | Data Types & Structures | Advanced |
| 26 | How would you choose between a list, a set, a dict, and a specialized structure like heapq for efficiently finding the K smallest/largest elements in a large dataset? Python › Data Types & Structures | Python | Data Types & Structures | Advanced |
| 27 | How does Java's implicit numeric type promotion and narrowing/widening conversion rules work, and what specific data-loss or precision risks does an implicit narrowing conversion (requiring an explicit cast) guard against? Java › Java Fundamentals: Syntax, Data Types & Operators | Java | Java Fundamentals: Syntax, Data Types & Operators | Advanced |
| 28 | How does Java's String immutability, combined with the string pool, interact with security-sensitive code (like handling passwords), and why is char[] generally recommended over String for storing sensitive data temporarily in memory? Java › Java Fundamentals: Syntax, Data Types & Operators | Java | Java Fundamentals: Syntax, Data Types & Operators | Advanced |
| 29 | What are the main types of data binding in Angular? Angular › Data Binding | Angular | Data Binding | Beginner |
| 30 | How would you create a reusable, generic React component using TypeScript, such as a list component that works with any data type? React › TypeScript with React | React | TypeScript with React | Advanced |
| 31 | How would you create a reusable, generic Angular component using TypeScript, such as a list component that works with any data type? Angular › TypeScript with Angular | Angular | TypeScript with Angular | Advanced |
| 32 | What is the difference between a set and a list in terms of uniqueness and ordering? Python › Data Types & Structures | Python | Data Types & Structures | Beginner |
| 33 | How does Java's compound assignment operator (like +=) implicitly include a narrowing cast that a corresponding explicit expanded assignment (x = x + y) does not, and what surprising behavior results from this? Java › Java Fundamentals: Syntax, Data Types & Operators | Java | Java Fundamentals: Syntax, Data Types & Operators | Advanced |
| 34 | What built-in masking functions are available in SQL Server for dynamic data masking? SQL Server › Dynamic Data Masking | SQL Server | Dynamic Data Masking | Beginner |
| 35 | What does it mean to pivot data in SQL Server, and what kind of reporting need does it typically address? SQL Server › Pivoting & Unpivoting Data | SQL Server | Pivoting & Unpivoting Data | Beginner |
| 36 | What does it mean to unpivot data, and how is it essentially the opposite operation of pivoting? SQL Server › Pivoting & Unpivoting Data | SQL Server | Pivoting & Unpivoting Data | Beginner |
| 37 | What is the XML data type in SQL Server, and why would you use it instead of storing XML as plain text? SQL Server › XML Data Type & Querying | SQL Server | XML Data Type & Querying | Beginner |
| 38 | What geospatial capabilities does Redis provide, and what commands are used to add location data? Redis › Geospatial Data in Redis | Redis | Geospatial Data in Redis | Beginner |
| 39 | Difference between int and Int32 in C# C# Programming › Data Types in C# | C# Programming | Data Types in C# | Beginner |
| 40 | What is the difference between an implicit conversion and an explicit conversion? C# Programming › Data Types in C# | C# Programming | Data Types in C# | Beginner |
| 41 | What is the difference between EF Core's Code-First (migrations) approach and Database-First (scaffolding) approach? .NET › Entity Framework Core & Data Access | .NET | Entity Framework Core & Data Access | Intermediate |
| 42 | How does EF Core map inheritance hierarchies to database tables, and what are the three main strategies (TPH, TPT, TPC)? .NET › Entity Framework Core & Data Access | .NET | Entity Framework Core & Data Access | Intermediate |
| 43 | How do you enable Change Data Capture on a specific table, and what does that process actually create? SQL Server › Change Data Capture (CDC) | SQL Server | Change Data Capture (CDC) | Intermediate |
| 44 | How do you query the change data captured for a table to find out exactly what changed within a specific time range? SQL Server › Change Data Capture (CDC) | SQL Server | Change Data Capture (CDC) | Intermediate |
| 45 | How do you grant a specific user or role permission to see the real, unmasked data despite dynamic data masking being applied? SQL Server › Dynamic Data Masking | SQL Server | Dynamic Data Masking | Intermediate |
| 46 | How do you remove dynamic data masking from a column once it is no longer needed? SQL Server › Dynamic Data Masking | SQL Server | Dynamic Data Masking | Intermediate |
| 47 | How can you retrieve the actual stored coordinates for a specific member in a Redis geospatial dataset? Redis › Geospatial Data in Redis | Redis | Geospatial Data in Redis | Intermediate |
| 48 | What is Boxing and Unboxing in C#? C# Programming › Data Types in C# | C# Programming | Data Types in C# | Intermediate |
| 49 | What happens during the process of boxing? C# Programming › Data Types in C# | C# Programming | Data Types in C# | Intermediate |
| 50 | How would you decide between using the XML data type and the JSON functions available in SQL Server for a new project that needs to store semi structured data? SQL Server › XML Data Type & Querying | SQL Server | XML Data Type & Querying | Advanced |
| 51 | What is the underlying geohash based encoding that Redis uses to store geospatial data, and how does it affect the accuracy of location queries? Redis › Geospatial Data in Redis | Redis | Geospatial Data in Redis | Advanced |
| 52 | What other probabilistic data structures does RedisBloom provide besides Bloom and Cuckoo filters, and what specific use cases do they address? Redis › RedisBloom (Probabilistic Data Structures) | Redis | RedisBloom (Probabilistic Data Structures) | Advanced |
| 53 | How do PHP's integer and float types handle precision limitations, and what issues can arise when performing arithmetic with floating point numbers? PHP › Basics & Types | PHP | Basics & Types | Advanced |
| 54 | What is the difference between a Python list and a tuple? Python › Data Types & Structures | Python | Data Types & Structures | Beginner |
| 55 | How do you access, add, and remove items from a dictionary? Python › Data Types & Structures | Python | Data Types & Structures | Beginner |
| 56 | What is the difference between the == operator and the .equals() method when comparing two custom objects, if the class hasn't overridden equals()? Java › Java Fundamentals: Syntax, Data Types & Operators | Java | Java Fundamentals: Syntax, Data Types & Operators | Beginner |
| 57 | What is the difference between VARCHAR and NVARCHAR, and when should you choose one over the other? SQL Server › Data Types & Schema Design | SQL Server | Data Types & Schema Design | Beginner |
| 58 | How do slicing operations work on a list, including negative indices and step values? Python › Data Types & Structures | Python | Data Types & Structures | Intermediate |
| 59 | Why must dictionary keys (and set elements) be hashable, and what makes an object hashable in Python? Python › Data Types & Structures | Python | Data Types & Structures | Intermediate |
| 60 | What is the difference between collections.deque and a regular list for queue-like operations? Python › Data Types & Structures | Python | Data Types & Structures | Intermediate |
| 61 | How does Java's operator precedence and associativity determine the evaluation order of a complex expression, and what are some common precedence-related mistakes? Java › Java Fundamentals: Syntax, Data Types & Operators | Java | Java Fundamentals: Syntax, Data Types & Operators | Intermediate |
| 62 | What is the difference between the == operator and the .equals() method when comparing String objects, and why does String's string pool (interning) behavior sometimes make == appear to 'work' for strings? Java › Java Fundamentals: Syntax, Data Types & Operators | Java | Java Fundamentals: Syntax, Data Types & Operators | Intermediate |
| 63 | What is the difference between a Java text block (introduced as a standard feature in Java 15) and a traditional String literal, and what specific syntax rules govern indentation handling? Java › Java Fundamentals: Syntax, Data Types & Operators | Java | Java Fundamentals: Syntax, Data Types & Operators | Intermediate |
| 64 | What is the difference between the ++ (increment) and -- (decrement) operators used in prefix versus postfix position, and what subtle bug can arise from using them within a complex expression? Java › Java Fundamentals: Syntax, Data Types & Operators | Java | Java Fundamentals: Syntax, Data Types & Operators | Intermediate |
| 65 | What is the difference between a compile-time constant expression and a regular final variable, and why does this distinction matter for switch statement case labels and certain compiler optimizations? Java › Java Fundamentals: Syntax, Data Types & Operators | Java | Java Fundamentals: Syntax, Data Types & Operators | Intermediate |
| 66 | How does Java's short-circuit evaluation for && and || operators differ from the non-short-circuiting & and | operators when applied to boolean operands, and why does this distinction matter for avoiding NullPointerException? Java › Java Fundamentals: Syntax, Data Types & Operators | Java | Java Fundamentals: Syntax, Data Types & Operators | Intermediate |
| 67 | What is the difference between an instance initializer block and a static initializer block, and when does each execute relative to a class's constructors? Java › Java Fundamentals: Syntax, Data Types & Operators | Java | Java Fundamentals: Syntax, Data Types & Operators | Intermediate |
| 68 | How do you type the data returned from an API call inside a server component to get proper autocomplete and error checking? Next.js › TypeScript with Next.js | Next.js | TypeScript with Next.js | Intermediate |
| 69 | What are the differences between DATETIME, DATETIME2, and DATE, and when would you choose each one? SQL Server › Data Types & Schema Design | SQL Server | Data Types & Schema Design | Intermediate |
| 70 | How do computed columns work in SQL Server, and what are some practical use cases for them? SQL Server › Data Types & Schema Design | SQL Server | Data Types & Schema Design | Intermediate |
| 71 | How does frozenset differ from a regular set, and what specific use case does its immutability enable? Python › Data Types & Structures | Python | Data Types & Structures | Advanced |
| 72 | How does Python's small integer caching (interning) affect identity comparisons ('is') versus equality comparisons ('==') for integers? Python › Data Types & Structures | Python | Data Types & Structures | Advanced |
| 73 | How would you efficiently merge two dictionaries in modern Python, and how do the different approaches handle overlapping keys? Python › Data Types & Structures | Python | Data Types & Structures | Advanced |
| 74 | How does Python's list implementation achieve amortized O(1) append performance despite lists being dynamically resizable arrays under the hood? Python › Data Types & Structures | Python | Data Types & Structures | Advanced |
| 75 | How does Java's autoboxing and unboxing mechanism work at the bytecode level, and what specific performance and correctness pitfalls does it introduce in seemingly innocuous code, such as within a loop? Java › Java Fundamentals: Syntax, Data Types & Operators | Java | Java Fundamentals: Syntax, Data Types & Operators | Advanced |
| 76 | How does the var keyword (local variable type inference, introduced in Java 10) work, and what specific restrictions apply to where it can and cannot be used, given Java remains a statically-typed language? Java › Java Fundamentals: Syntax, Data Types & Operators | Java | Java Fundamentals: Syntax, Data Types & Operators | Advanced |
| 77 | How does Java's integer division and modulo operator behave with negative operands, and how does this differ from the mathematical definition of modulo used in some other contexts (like array indexing wraparound)? Java › Java Fundamentals: Syntax, Data Types & Operators | Java | Java Fundamentals: Syntax, Data Types & Operators | Advanced |
| 78 | How do you design a schema to properly handle a many to many relationship between two entities, such as students and courses? SQL Server › Data Types & Schema Design | SQL Server | Data Types & Schema Design | Advanced |
| 79 | What factors should guide the decision to denormalize a schema for performance reasons, and what tradeoffs come with that decision? SQL Server › Data Types & Schema Design | SQL Server | Data Types & Schema Design | Advanced |
| 80 | Name a few common TypedArray types and their byte sizes. JavaScript › ArrayBuffer, TypedArrays & Binary Data | JavaScript | ArrayBuffer, TypedArrays & Binary Data | Beginner |
| 81 | How would you define a strongly typed interface for data returned from an API, and use it throughout an Angular service? Angular › TypeScript with Angular | Angular | TypeScript with Angular | Intermediate |
| 82 | How can you properly store a genuinely more complex object, such as a List of strings or a Map, using SharedPreferences, given that it only genuinely natively supports fairly simple basic primitive types directly? Flutter › Local Data Storage with SharedPreferences | Flutter | Local Data Storage with SharedPreferences | Intermediate |
| 83 | How do you properly parse and correctly handle several genuinely different types of incoming JSON messages received over a single shared WebSocket connection, such as distinguishing between a genuinely new chat message and a separate typing indicator event? Flutter › WebSockets & Real Time Data in Flutter | Flutter | WebSockets & Real Time Data in Flutter | Intermediate |
| 84 | What are the three main built in collection types in Dart, List, Set, and Map, and what makes each one uniquely suited for a different kind of data storage need? Flutter › Dart Collections & Generics | Flutter | Dart Collections & Generics | Beginner |
| 85 | What specific types of data can actually be sent as a message between two separate isolates in Dart, and why can an arbitrary complex object, such as one containing an active network connection, genuinely not simply be passed directly between them? Flutter › Flutter Isolates & Multithreading | Flutter | Flutter Isolates & Multithreading | Intermediate |
| 86 | How does reflection allow inspecting an assembly's types and metadata at runtime, and what are common uses? .NET › Assemblies & NuGet | .NET | Assemblies & NuGet | Advanced |
| 87 | How would you design a layered set of views to progressively simplify a complex data model for different types of users, such as analysts versus casual business users? SQL Server › Views | SQL Server | Views | Advanced |
| 88 | How should an API validate the structure and types of incoming JSON data to ensure it matches the expected schema before processing it further? PHP › JSON Handling in PHP | PHP | JSON Handling in PHP | Advanced |
| 89 | How do you create a simple immutable record using collections.namedtuple? Python › Dataclasses & NamedTuples | Python | Dataclasses & NamedTuples | Beginner |
| 90 | How do you extract a value from an XML column using the value method? SQL Server › XML Data Type & Querying | SQL Server | XML Data Type & Querying | Beginner |
| 91 | How do you add items to a Bloom filter and check if an item might already exist using RedisBloom commands? Redis › RedisBloom (Probabilistic Data Structures) | Redis | RedisBloom (Probabilistic Data Structures) | Beginner |
| 92 | What is the difference between First(OrDefault) and Single(OrDefault) in EF Core queries, and when should you use each? .NET › Entity Framework Core & Data Access | .NET | Entity Framework Core & Data Access | Intermediate |
| 93 | What are some practical, real world use cases where PIVOT and UNPIVOT are commonly applied in business reporting? SQL Server › Pivoting & Unpivoting Data | SQL Server | Pivoting & Unpivoting Data | Intermediate |
| 94 | How do you use the query and nodes methods to work with repeating elements within an XML document, such as a list of items in an order? SQL Server › XML Data Type & Querying | SQL Server | XML Data Type & Querying | Intermediate |
| 95 | How do you modify a specific part of an XML document stored in a column without replacing the entire document? SQL Server › XML Data Type & Querying | SQL Server | XML Data Type & Querying | Intermediate |
| 96 | How do you convert the results of a SQL query directly into an XML formatted document using the FOR XML clause? SQL Server › XML Data Type & Querying | SQL Server | XML Data Type & Querying | Intermediate |
| 97 | Why can items not be removed from a standard Bloom filter, and what alternative structure does RedisBloom offer if you need removal support? Redis › RedisBloom (Probabilistic Data Structures) | Redis | RedisBloom (Probabilistic Data Structures) | Intermediate |
| 98 | How does the configured false positive rate affect both the accuracy and the memory usage of a Bloom filter? Redis › RedisBloom (Probabilistic Data Structures) | Redis | RedisBloom (Probabilistic Data Structures) | Intermediate |
| 99 | How do you use named placeholders in a PDO prepared statement, and how do they improve readability compared to positional question mark placeholders? PHP › PDO & Databases | PHP | PDO & Databases | Intermediate |
| 100 | How do you implement soft deletes in EF Core using a global query filter? .NET › Entity Framework Core & Data Access | .NET | Entity Framework Core & Data Access | Advanced |
| 101 | How would you build a cross tabulation report using PIVOT that shows multiple aggregate calculations, such as both total and average, for each category? SQL Server › Pivoting & Unpivoting Data | SQL Server | Pivoting & Unpivoting Data | Advanced |
| 102 | How do you declare and initialize an array of objects (reference types) versus an array of primitives, and what is the key difference in their default values? Java › Arrays & Multidimensional Arrays | Java | Arrays & Multidimensional Arrays | Beginner |
| 103 | What is a primary key constraint, and why is it important for a database table? SQL Server › Constraints (Primary Key, Foreign Key, Check & Unique) | SQL Server | Constraints (Primary Key, Foreign Key, Check & Unique) | Beginner |
| 104 | What is an INNER JOIN, and how does it combine data from two tables? SQL Server › Joins | SQL Server | Joins | Beginner |
| 105 | What is database normalization, and why is it an important concept in schema design? SQL Server › Normalization | SQL Server | Normalization | Beginner |
| 106 | Can you insert, update, or delete data through a view, and what conditions must be met for this to work? SQL Server › Views | SQL Server | Views | Beginner |
| 107 | Why is managing memory usage particularly important for Redis compared to a typical disk based database? Redis › Redis Memory Optimization | Redis | Redis Memory Optimization | Beginner |
| 108 | What is RedisJSON, and how does it improve working with JSON data compared to storing it as a plain string? Redis › RedisJSON | Redis | RedisJSON | Beginner |
| 109 | How do you add a new data point to a Redis time series, and how do you query a range of recent data? Redis › RedisTimeSeries | Redis | RedisTimeSeries | Beginner |
| 110 | What is the Redis string data type, and what kinds of values can it actually store? Redis › Strings & Bitmaps in Redis | Redis | Strings & Bitmaps in Redis | Beginner |
| 111 | What is PHP and what makes it particularly well suited for web development? PHP › Basics & Types | PHP | Basics & Types | Beginner |
| 112 | How does the CLR's type system distinguish between value types and reference types, and where is each typically allocated? .NET › CLR & Runtime | .NET | CLR & Runtime | Intermediate |
| 113 | What is the relationship between equals() and the == operator when comparing primitive types versus reference types, and how does this affect comparing boxed wrapper types like Integer? Java › equals(), hashCode() & toString() Contracts | Java | equals(), hashCode() & toString() Contracts | Intermediate |
| 114 | What is the multi-catch syntax (catch (IOException | SQLException e)) introduced in Java 7, and what restriction applies to the exception types combined in a single multi-catch block? Java › Exceptions | Java | Exceptions | Intermediate |
| 115 | How do you prevent a recursive common table expression from running forever if the underlying data accidentally contains a circular reference? SQL Server › Common Table Expressions (CTEs) | SQL Server | Common Table Expressions (CTEs) | Intermediate |
| 116 | What is a check constraint, and how do you use one to enforce a specific business rule at the database level? SQL Server › Constraints (Primary Key, Foreign Key, Check & Unique) | SQL Server | Constraints (Primary Key, Foreign Key, Check & Unique) | Intermediate |
| 117 | How do you temporarily disable a constraint to perform a bulk data load, and how do you safely re-enable it afterward? SQL Server › Constraints (Primary Key, Foreign Key, Check & Unique) | SQL Server | Constraints (Primary Key, Foreign Key, Check & Unique) | Intermediate |
| 118 | What performance issues commonly arise when querying data through a linked server, and how can you address them? SQL Server › Linked Servers | SQL Server | Linked Servers | Intermediate |
| 119 | What practical problems, such as update anomalies, can occur in a poorly normalized database, and how does normalization address them? SQL Server › Normalization | SQL Server | Normalization | Intermediate |
| 120 | How do you determine which partition a specific row of data belongs to, and how can this help with troubleshooting? SQL Server › Partitioning | SQL Server | Partitioning | Intermediate |
| 121 | How do you analyze the data captured by an Extended Events session once it has been running for a period of time? SQL Server › SQL Server Profiler & Extended Events | SQL Server | SQL Server Profiler & Extended Events | Intermediate |
| 122 | What is the difference between using EXISTS and IN when checking for the presence of related data with a subquery? SQL Server › Subqueries | SQL Server | Subqueries | Intermediate |
| 123 | How do statistics and query optimization differ between temporary tables and table variables, and how does this affect performance for larger data sets? SQL Server › Temporary Tables & Table Variables | SQL Server | Temporary Tables & Table Variables | Intermediate |
| 124 | How do you check basic information about a Redis key, such as its data type and remaining time to live? Redis › Redis CLI & Basic Commands | Redis | Redis CLI & Basic Commands | Intermediate |
| 125 | How do you use shorter key names and more compact data structures to meaningfully reduce Redis's overall memory footprint? Redis › Redis Memory Optimization | Redis | Redis Memory Optimization | Intermediate |
| 126 | How do you update or delete a RedisSearch index without affecting the underlying data it was built from? Redis › RedisSearch (Full Text Search) | Redis | RedisSearch (Full Text Search) | Intermediate |
| 127 | What aggregation functions are available when querying a range of data from a Redis time series, and how do you apply one during a query? Redis › RedisTimeSeries | Redis | RedisTimeSeries | Intermediate |
| 128 | How do you share data between processes using multiprocessing, given that separate processes don't share memory the way threads do? Python › Concurrency (asyncio/threading/multiprocessing) | Python | Concurrency (asyncio/threading/multiprocessing) | Advanced |
| 129 | How does schema reuse work in OpenAPI (via $ref and components/schemas), and how does Swashbuckle handle types shared across multiple endpoints? ASP.NET Core › API Documentation with Swagger/OpenAPI | ASP.NET Core | API Documentation with Swagger/OpenAPI | Advanced |
| 130 | How would you add a new constraint to an existing table that already contains data, especially if some existing rows might violate that constraint? SQL Server › Constraints (Primary Key, Foreign Key, Check & Unique) | SQL Server | Constraints (Primary Key, Foreign Key, Check & Unique) | Advanced |
| 131 | What are the performance considerations and limitations of querying JSON data stored as text compared to using normalized relational columns? SQL Server › JSON Support in SQL Server | SQL Server | JSON Support in SQL Server | Advanced |
| 132 | How would you use MERGE to implement a slowly changing dimension pattern in a data warehouse, tracking historical changes to a record over time? SQL Server › Merge Statement (Upsert) | SQL Server | Merge Statement (Upsert) | Advanced |
| 133 | When would it make sense to intentionally denormalize a database design, and what specific tradeoffs come with that decision? SQL Server › Normalization | SQL Server | Normalization | Advanced |
| 134 | How would you approach normalizing an existing, poorly designed legacy database without breaking the applications that currently depend on it? SQL Server › Normalization | SQL Server | Normalization | Advanced |
| 135 | How would you design a set of reusable functions for a data warehouse to standardize common calculations like currency conversion or fiscal period determination? SQL Server › User Defined Functions | SQL Server | User Defined Functions | Advanced |
| 136 | How would you design a document based data model using RedisJSON for an application that would traditionally use a document database like MongoDB? Redis › RedisJSON | Redis | RedisJSON | Advanced |
| 137 | What are the three main types of replication in SQL Server, and how do they differ? SQL Server › Replication | SQL Server | Replication | Beginner |
| 138 | Why should passwords always be hashed before storing them in a database, and how does PHP's password_hash function make this straightforward and secure? PHP › Security | PHP | Security | Intermediate |
| 139 | What are custom post types and custom fields in WordPress, and how do they let you extend WordPress beyond its default posts and pages to represent other kinds of content? PHP › WordPress Plugin & Theme Development | PHP | WordPress Plugin & Theme Development | Intermediate |
| 140 | What are Triggers in MAUI and what types exist? .NET MAUI › Styling, Resources & Themes | .NET MAUI | Styling, Resources & Themes | Advanced |
| 141 | What are Triggers in MAUI and what types exist? .NET MAUI › Styling, Resources & Themes | .NET MAUI | Styling, Resources & Themes | Advanced |
| 142 | How would you convert between the legacy java.util.Date/Calendar classes and the modern java.time API when working with older libraries or APIs that still require the legacy types? Java › Java Date & Time API (java.time) | Java | Java Date & Time API (java.time) | Advanced |
| 143 | How would you design a notification preference center allowing users to control which types of notifications they receive via which channels? Node.js › Email & Notifications | Node.js | Email & Notifications | Advanced |
| 144 | How do data providers in PHPUnit let you run the exact same test logic repeatedly against many different sets of input data, without duplicating the test method itself? PHP › Unit Testing with PHPUnit | PHP | Unit Testing with PHPUnit | Advanced |
| 145 | How does a property decorator differ from a method decorator in what it receives and what it can do? TypeScript › Decorators | TypeScript | Decorators | Advanced |
| 146 | What is the difference between a positional argument and an optional argument (flag) in argparse? Python › Command-Line Interfaces (argparse) | Python | Command-Line Interfaces (argparse) | Beginner |
| 147 | How do you write a basic list comprehension, and how does it compare to an equivalent for loop? Python › Comprehensions & Generators | Python | Comprehensions & Generators | Beginner |
| 148 | How do you add a filtering condition to a list comprehension using 'if'? Python › Comprehensions & Generators | Python | Comprehensions & Generators | Beginner |
| 149 | How does a try/except block work, and what happens if no matching except clause exists? Python › Exception Handling | Python | Exception Handling | Beginner |
| 150 | What are the common file modes ('r', 'w', 'a', 'rb') passed to open(), and what does each one do? Python › File I/O & Context Managers | Python | File I/O & Context Managers | Beginner |
| 151 | What is the difference between positional arguments and keyword arguments when calling a function? Python › Functions & Scope | Python | Functions & Scope | Beginner |
| 152 | How do default parameter values work, and when are they evaluated? Python › Functions & Scope | Python | Functions & Scope | Beginner |
| 153 | What are 'magic methods' (dunder methods) in Python, and why are they called that? Python › Magic Methods & Operator Overloading | Python | Magic Methods & Operator Overloading | Beginner |
| 154 | How does __repr__ help with debugging when printing a list of custom objects? Python › Magic Methods & Operator Overloading | Python | Magic Methods & Operator Overloading | Beginner |
| 155 | How does Python primarily manage memory for objects? Python › Memory Management & Garbage Collection | Python | Memory Management & Garbage Collection | Beginner |
| 156 | What are annotations in Java, and what purpose do they serve? Java › Annotations | Java | Annotations | Beginner |
| 157 | How do you declare, initialize, and access elements of a one-dimensional array in Java? Java › Arrays & Multidimensional Arrays | Java | Arrays & Multidimensional Arrays | Beginner |
| 158 | What problem do build tools like Maven and Gradle solve for a Java project? Java › Build Tools: Maven & Gradle | Java | Build Tools: Maven & Gradle | Beginner |
| 159 | What is the standard Maven directory layout, and why does following this convention matter? Java › Build Tools: Maven & Gradle | Java | Build Tools: Maven & Gradle | Beginner |
| 160 | What is an enum in Java, and how does it differ from simply using a set of integer or String constants? Java › Enums | Java | Enums | Beginner |
| 161 | What is the difference between checked and unchecked exceptions in Java, and how does the compiler treat each differently? Java › Exceptions | Java | Exceptions | Beginner |
| 162 | What is the basic syntax and control flow of a try-catch-finally block, and what determines which catch block (if multiple exist) handles a thrown exception? Java › Exceptions | Java | Exceptions | Beginner |
| 163 | What is the difference between byte streams (InputStream/OutputStream) and character streams (Reader/Writer) in the classic java.io package? Java › I/O & NIO | Java | I/O & NIO | Beginner |
| 164 | How do you read all bytes or all lines of a small-to-medium text file in a single, concise call using modern NIO.2 utility methods? Java › I/O & NIO | Java | I/O & NIO | Beginner |
| 165 | How do you instantiate a non-static inner class from OUTSIDE the enclosing class (from a different class entirely), and what is the exact syntax required? Java › Inner Classes & Anonymous Classes | Java | Inner Classes & Anonymous Classes | Beginner |
| 166 | Can an interface declare instance fields, and if so, what implicit modifiers are automatically applied to any field declared in an interface? Java › Interfaces & Abstract Classes | Java | Interfaces & Abstract Classes | Beginner |
| 167 | What is full text search in SQL Server, and how is it different from a regular LIKE search? SQL Server › Full Text Search | SQL Server | Full Text Search | Beginner |
| 168 | How do you create a full text index on a table so you can use full text search functions? SQL Server › Full Text Search | SQL Server | Full Text Search | Beginner |
| 169 | What is an index in SQL Server, and how does it help speed up queries? SQL Server › Indexes | SQL Server | Indexes | Beginner |
| 170 | How do you store and query JSON formatted text in SQL Server? SQL Server › JSON Support in SQL Server | SQL Server | JSON Support in SQL Server | Beginner |
| 171 | What is the difference between the JSON_VALUE and JSON_QUERY functions? SQL Server › JSON Support in SQL Server | SQL Server | JSON Support in SQL Server | Beginner |
| 172 | What does the MERGE statement do in SQL Server, and why is it called an upsert operation? SQL Server › Merge Statement (Upsert) | SQL Server | Merge Statement (Upsert) | Beginner |
| 173 | What are the three main clauses of a MERGE statement, and what does each one control? SQL Server › Merge Statement (Upsert) | SQL Server | Merge Statement (Upsert) | Beginner |
| 174 | What is the first normal form, and what specific rule does it require a table to follow? SQL Server › Normalization | SQL Server | Normalization | Beginner |
| 175 | What is the difference between a table scan and an index seek in an execution plan, and why does this distinction matter for performance? SQL Server › Query Optimization & Plans | SQL Server | Query Optimization & Plans | Beginner |
| 176 | What is the difference between Windows Authentication and SQL Server Authentication? SQL Server › SQL Server Security & Permissions | SQL Server | SQL Server Security & Permissions | Beginner |
| 177 | What is a table variable in SQL Server, and how is it declared and used? SQL Server › Temporary Tables & Table Variables | SQL Server | Temporary Tables & Table Variables | Beginner |
| 178 | What is the difference between an AFTER trigger and an INSTEAD OF trigger? SQL Server › Triggers | SQL Server | Triggers | Beginner |
| 179 | What is a user defined function in SQL Server, and why would you create one instead of repeating the same logic in multiple queries? SQL Server › User Defined Functions | SQL Server | User Defined Functions | Beginner |
| 180 | What is a view in SQL Server, and what benefits does it provide? SQL Server › Views | SQL Server | Views | Beginner |
| 181 | What is a Redis hash, and how do you create one to store a simple object with multiple fields? Redis › Hashes in Redis | Redis | Hashes in Redis | Beginner |
| 182 | How do you retrieve a single field or all fields from a Redis hash? Redis › Hashes in Redis | Redis | Hashes in Redis | Beginner |
| 183 | What is a HyperLogLog in Redis, and what problem does it solve? Redis › HyperLogLog in Redis | Redis | HyperLogLog in Redis | Beginner |
| 184 | Why are Redis sorted sets a natural fit for building a leaderboard feature? Redis › Leaderboards with Sorted Sets | Redis | Leaderboards with Sorted Sets | Beginner |
| 185 | What is a Redis list, and how do you add items to either end of it? Redis › Lists in Redis | Redis | Lists in Redis | Beginner |
| 186 | How do you retrieve a range of items from a Redis list without removing them? Redis › Lists in Redis | Redis | Lists in Redis | Beginner |
| 187 | What do the basic SET, GET, and DEL commands do in Redis? Redis › Redis CLI & Basic Commands | Redis | Redis CLI & Basic Commands | Beginner |
| 188 | How do you check how much memory a specific Redis key is currently using? Redis › Redis Memory Optimization | Redis | Redis Memory Optimization | Beginner |
| 189 | What are the fundamental differences between Redis and Memcached as caching solutions? Redis › Redis vs Memcached | Redis | Redis vs Memcached | Beginner |
| 190 | How do you set and retrieve a specific nested field within a JSON document using RedisJSON's path syntax? Redis › RedisJSON | Redis | RedisJSON | Beginner |
| 191 | How do you create a search index in RedisSearch, and what does defining a schema for that index actually do? Redis › RedisSearch (Full Text Search) | Redis | RedisSearch (Full Text Search) | Beginner |
| 192 | What is a Redis set, and what guarantee does it provide about the items you store in it? Redis › Sets & Sorted Sets in Redis | Redis | Sets & Sorted Sets in Redis | Beginner |
| 193 | How do you check if a specific item exists in a Redis set, and how do you remove an item from it? Redis › Sets & Sorted Sets in Redis | Redis | Sets & Sorted Sets in Redis | Beginner |
| 194 | How do you add a new entry to a Redis Stream, and how do you read entries back from it? Redis › Streams | Redis | Streams | Beginner |
| 195 | How do you atomically increment and decrement a numeric value stored as a Redis string? Redis › Strings & Bitmaps in Redis | Redis | Strings & Bitmaps in Redis | Beginner |
| 196 | What is the DateTime class in PHP, and why is it generally preferred over using the older date function alone? PHP › Date & Time Handling | PHP | Date & Time Handling | Beginner |
| 197 | How do you restrict an argument's accepted values using the 'choices' parameter? Python › Command-Line Interfaces (argparse) | Python | Command-Line Interfaces (argparse) | Intermediate |
| 198 | How do you accept a variable number of arguments for a single flag, like a list of filenames? Python › Command-Line Interfaces (argparse) | Python | Command-Line Interfaces (argparse) | Intermediate |
| 199 | How do you provide a short and a long form for the same flag, like -v and --verbose? Python › Command-Line Interfaces (argparse) | Python | Command-Line Interfaces (argparse) | Intermediate |
| 200 | How do dict comprehensions and set comprehensions differ in syntax from list comprehensions? Python › Comprehensions & Generators | Python | Comprehensions & Generators | Intermediate |
| 201 | How do you write a nested comprehension, like flattening a list of lists into a single flat list? Python › Comprehensions & Generators | Python | Comprehensions & Generators | Intermediate |
| 202 | How does functools.total_ordering reduce boilerplate for comparison methods? Python › functools & Functional Programming Tools | Python | functools & Functional Programming Tools | Intermediate |
| 203 | How does Python know whether to treat a for-in target as iterable, and what error occurs if it isn't? Python › Iterators & the Iterator Protocol | Python | Iterators & the Iterator Protocol | Intermediate |
| 204 | What is the difference between iter(obj) and using obj directly in a for-loop, in terms of what Python calls internally? Python › Iterators & the Iterator Protocol | Python | Iterators & the Iterator Protocol | Intermediate |
| 205 | How do you overload arithmetic operators like + and - using __add__ and __sub__? Python › Magic Methods & Operator Overloading | Python | Magic Methods & Operator Overloading | Intermediate |
| 206 | What do __eq__ and __hash__ need to satisfy together, and what happens if you only override __eq__? Python › Magic Methods & Operator Overloading | Python | Magic Methods & Operator Overloading | Intermediate |
| 207 | How do __len__, __getitem__, and __setitem__ let a custom class act like a sequence or mapping? Python › Magic Methods & Operator Overloading | Python | Magic Methods & Operator Overloading | Intermediate |
| 208 | How do comparison magic methods like __lt__, __le__, __gt__, and __ge__ support custom sorting? Python › Magic Methods & Operator Overloading | Python | Magic Methods & Operator Overloading | Intermediate |
| 209 | How does __contains__ let you customize the behavior of the 'in' operator? Python › Magic Methods & Operator Overloading | Python | Magic Methods & Operator Overloading | Intermediate |
| 210 | What is the sys.getsizeof() function, and what are its limitations for measuring memory usage? Python › Memory Management & Garbage Collection | Python | Memory Management & Garbage Collection | Intermediate |
| 211 | What role does the class namespace dict play during class creation, and how can __prepare__ customize it? Python › Metaclasses & Class Customization | Python | Metaclasses & Class Customization | Intermediate |
| 212 | How does __set_name__ let a descriptor discover the attribute name it's assigned to within a class? Python › Metaclasses & Class Customization | Python | Metaclasses & Class Customization | Intermediate |
| 213 | What is the practical difference between isinstance(obj, cls) and type(obj) is cls, particularly regarding metaclasses and inheritance? Python › Metaclasses & Class Customization | Python | Metaclasses & Class Customization | Intermediate |
| 214 | What is the Common Type System (CTS), and how does it enable interoperability between different .NET languages? .NET › CLR & Runtime | .NET | CLR & Runtime | Intermediate |
| 215 | How do annotations with elements (parameters) work, including default values and the special `value` element? Java › Annotations | Java | Annotations | Intermediate |
| 216 | What is the difference between the @Nullable/@NonNull annotations (from libraries like JetBrains or JSR-305) and Java's built-in Optional type for expressing nullability? Java › Annotations | Java | Annotations | Intermediate |
| 217 | How do multidimensional arrays work in Java, and how do they differ from truly rectangular arrays in languages like C? Java › Arrays & Multidimensional Arrays | Java | Arrays & Multidimensional Arrays | Intermediate |
| 218 | How do you correctly iterate a 2D array using both traditional indexed for-loops and the enhanced for-each loop, and when is each approach preferable? Java › Arrays & Multidimensional Arrays | Java | Arrays & Multidimensional Arrays | Intermediate |
| 219 | How does Gradle's build script (build.gradle / build.gradle.kts) differ structurally from Maven's declarative XML pom.xml? Java › Build Tools: Maven & Gradle | Java | Build Tools: Maven & Gradle | Intermediate |
| 220 | How do you configure the Maven Compiler Plugin to target a specific Java language version, and what's the difference between source, target, and release configuration? Java › Build Tools: Maven & Gradle | Java | Build Tools: Maven & Gradle | Intermediate |
| 221 | What are the immutable collection factory methods (List.of(), Set.of(), Map.of()) introduced in Java 9, and how do they differ from Collections.unmodifiableList()? Java › Collections Framework | Java | Collections Framework | Intermediate |
| 222 | How do you correctly use an enum as a switch statement/expression's target, and what changed with the introduction of arrow-style switch expressions (Java 14+) regarding exhaustiveness and fall-through? Java › Enums | Java | Enums | Intermediate |
| 223 | How would you use an enum to represent a fixed set of configuration keys combined with a shared lookup method, avoiding scattered String literal keys throughout a codebase? Java › Enums | Java | Enums | Intermediate |
| 224 | How does Objects.equals() and Objects.hash() from java.util.Objects simplify writing correct equals() and hashCode() implementations, particularly regarding null-safety? Java › equals(), hashCode() & toString() Contracts | Java | equals(), hashCode() & toString() Contracts | Intermediate |
| 225 | How does a local or anonymous class defined inside a static method or static context differ from one defined inside an instance method, regarding what enclosing state it can access? Java › Inner Classes & Anonymous Classes | Java | Inner Classes & Anonymous Classes | Intermediate |
| 226 | How would you access the enclosing outer class's instance from within a nested inner class when there's a naming conflict (like a shadowed field with the same name), using the OuterClassName.this syntax? Java › Inner Classes & Anonymous Classes | Java | Inner Classes & Anonymous Classes | Intermediate |
| 227 | How would you calculate the difference between two dates or times using Period and Duration, and what's the distinction between these two classes? Java › Java Date & Time API (java.time) | Java | Java Date & Time API (java.time) | Intermediate |
| 228 | How do you parse and format date/time values using DateTimeFormatter, and how does this replace the older, notoriously thread-unsafe SimpleDateFormat class? Java › Java Date & Time API (java.time) | Java | Java Date & Time API (java.time) | Intermediate |
| 229 | How would you determine whether a given year is a leap year, and calculate the number of days in a specific month, using the java.time API's built-in support rather than hand-writing this classic calendrical logic? Java › Java Date & Time API (java.time) | Java | Java Date & Time API (java.time) | Intermediate |
| 230 | How would you write and run a basic 'Hello World' JPMS-modularized application from scratch, including the module-info.java, directory structure, and the specific javac/java command-line invocations needed? Java › Java Platform Module System (JPMS) | Java | Java Platform Module System (JPMS) | Intermediate |
| 231 | What is the difference between COUNT(*), COUNT(1), and COUNT(column_name) in SQL Server? SQL Server › Aggregate Functions & GROUP BY | SQL Server | Aggregate Functions & GROUP BY | Intermediate |
| 232 | What are the three recovery models available in SQL Server, and how do they affect your backup strategy? SQL Server › Backup & Recovery | SQL Server | Backup & Recovery | Intermediate |
| 233 | How does columnstore compression work, and why does it typically achieve much higher compression ratios than regular row based storage? SQL Server › Columnstore Indexes | SQL Server | Columnstore Indexes | Intermediate |
| 234 | What is a recursive common table expression, and what kind of problems is it commonly used to solve? SQL Server › Common Table Expressions (CTEs) | SQL Server | Common Table Expressions (CTEs) | Intermediate |
| 235 | How is a unique constraint different from a primary key constraint, and when would you use one instead of the other? SQL Server › Constraints (Primary Key, Foreign Key, Check & Unique) | SQL Server | Constraints (Primary Key, Foreign Key, Check & Unique) | Intermediate |
| 236 | What is the difference between the CONTAINS and FREETEXT predicates when performing a full text search? SQL Server › Full Text Search | SQL Server | Full Text Search | Intermediate |
| 237 | How do you decide which columns to choose, and in what order, when creating a composite index covering multiple columns? SQL Server › Indexes | SQL Server | Indexes | Intermediate |
| 238 | What is a FULL OUTER JOIN, and when would you use one instead of a LEFT or RIGHT JOIN? SQL Server › Joins | SQL Server | Joins | Intermediate |
| 239 | What common mistakes do developers make when writing multi table joins that can lead to unexpectedly large or incorrect result sets? SQL Server › Joins | SQL Server | Joins | Intermediate |
| 240 | How do you generate JSON formatted output directly from a SQL query's result set? SQL Server › JSON Support in SQL Server | SQL Server | JSON Support in SQL Server | Intermediate |
| 241 | How do you update a specific value within a JSON document stored in a column without replacing the entire JSON text? SQL Server › JSON Support in SQL Server | SQL Server | JSON Support in SQL Server | Intermediate |
| 242 | What are the security considerations when configuring authentication for a linked server connection? SQL Server › Linked Servers | SQL Server | Linked Servers | Intermediate |
| 243 | How do you use the OUTPUT clause together with a MERGE statement to capture which rows were inserted, updated, or deleted? SQL Server › Merge Statement (Upsert) | SQL Server | Merge Statement (Upsert) | Intermediate |
| 244 | What is the second normal form, and how does it build on the requirements of the first normal form? SQL Server › Normalization | SQL Server | Normalization | Intermediate |
| 245 | What is the third normal form, and what kind of dependency does it specifically eliminate? SQL Server › Normalization | SQL Server | Normalization | Intermediate |
| 246 | What are the most common causes of poor query performance that you should check first when troubleshooting a slow query? SQL Server › Query Optimization & Plans | SQL Server | Query Optimization & Plans | Intermediate |
| 247 | How do you use output parameters in a stored procedure to return a value back to the calling code, in addition to or instead of a normal result set? SQL Server › Stored Procedures & Functions | SQL Server | Stored Procedures & Functions | Intermediate |
| 248 | What are common mistakes developers make when writing subqueries that can lead to incorrect results or poor performance? SQL Server › Subqueries | SQL Server | Subqueries | Intermediate |
| 249 | What is the difference between a local temporary table and a global temporary table? SQL Server › Temporary Tables & Table Variables | SQL Server | Temporary Tables & Table Variables | Intermediate |
| 250 | How do you access the old and new values of a row that was just updated from inside a trigger? SQL Server › Triggers | SQL Server | Triggers | Intermediate |
| 251 | Why should triggers generally be designed to handle multiple affected rows at once rather than assuming only a single row was changed? SQL Server › Triggers | SQL Server | Triggers | Intermediate |
| 252 | What are the differences between the various string functions available in T-SQL, such as SUBSTRING, CONCAT, and TRIM? SQL Server › T-SQL Fundamentals & Syntax | SQL Server | T-SQL Fundamentals & Syntax | Intermediate |
| 253 | What restrictions exist on what a user defined function is allowed to do compared to a stored procedure? SQL Server › User Defined Functions | SQL Server | User Defined Functions | Intermediate |
| 254 | What is the difference between RANK, DENSE_RANK, and ROW_NUMBER when there are tied values in the ordering column? SQL Server › Window Functions | SQL Server | Window Functions | Intermediate |
| 255 | How do LAG and LEAD window functions let you access values from a previous or following row without needing a self join? SQL Server › Window Functions | SQL Server | Window Functions | Intermediate |
| 256 | How does the PARTITION BY clause within a window function differ from GROUP BY, and why is this distinction useful? SQL Server › Window Functions | SQL Server | Window Functions | Intermediate |
| 257 | How do you check if a specific field exists within a hash, and how do you delete just one field without affecting the rest of the hash? Redis › Hashes in Redis | Redis | Hashes in Redis | Intermediate |
| 258 | How do you retrieve only the field names or only the values from a Redis hash, without needing both together? Redis › Hashes in Redis | Redis | Hashes in Redis | Intermediate |
| 259 | How accurate is a Redis HyperLogLog's estimated count, and why might a small amount of inaccuracy be an acceptable tradeoff? Redis › HyperLogLog in Redis | Redis | HyperLogLog in Redis | Intermediate |
| 260 | How do you merge multiple HyperLogLog structures together to get a combined unique count across them? Redis › HyperLogLog in Redis | Redis | HyperLogLog in Redis | Intermediate |
| 261 | How does the internal sparse and dense representation of a HyperLogLog in Redis affect its memory usage as the number of unique items grows? Redis › HyperLogLog in Redis | Redis | HyperLogLog in Redis | Intermediate |
| 262 | How do you retrieve all players within a specific score range on a leaderboard, such as everyone between a thousand and two thousand points? Redis › Leaderboards with Sorted Sets | Redis | Leaderboards with Sorted Sets | Intermediate |
| 263 | How do you implement a simple first in first out queue using a Redis list? Redis › Lists in Redis | Redis | Lists in Redis | Intermediate |
| 264 | What is the sliding window log algorithm for rate limiting, and how can it be implemented using a Redis sorted set? Redis › Rate Limiting with Redis | Redis | Rate Limiting with Redis | Intermediate |
| 265 | How do you implement a priority queue pattern using Redis, where certain tasks should be processed before others? Redis › Redis as a Message Queue | Redis | Redis as a Message Queue | Intermediate |
| 266 | How do you use the EXISTS and RENAME commands, and what should you be careful about when using RENAME? Redis › Redis CLI & Basic Commands | Redis | Redis CLI & Basic Commands | Intermediate |
| 267 | How does the size of values stored in Redis affect overall performance, and what strategies help manage very large values? Redis › Redis Performance Tuning & Benchmarking | Redis | Redis Performance Tuning & Benchmarking | Intermediate |
| 268 | What are Redis ACL categories, and how do they simplify granting permissions for groups of related commands? Redis › Redis Security & ACL | Redis | Redis Security & ACL | Intermediate |
| 269 | How do you work with arrays within a JSON document stored in Redis, such as adding a new item to an existing array? Redis › RedisJSON | Redis | RedisJSON | Intermediate |
| 270 | How do you atomically increment a numeric value nested within a JSON document using RedisJSON? Redis › RedisJSON | Redis | RedisJSON | Intermediate |
| 271 | How do you write a RedisSearch query that combines full text search with a numeric range filter? Redis › RedisSearch (Full Text Search) | Redis | RedisSearch (Full Text Search) | Intermediate |
| 272 | How do you sort and paginate search results returned by a RedisSearch query? Redis › RedisSearch (Full Text Search) | Redis | RedisSearch (Full Text Search) | Intermediate |
| 273 | How do you find the intersection, union, and difference between two or more Redis sets? Redis › Sets & Sorted Sets in Redis | Redis | Sets & Sorted Sets in Redis | Intermediate |
| 274 | How do sorted sets differ from regular sets, and what additional capability does the associated score provide? Redis › Sets & Sorted Sets in Redis | Redis | Sets & Sorted Sets in Redis | Intermediate |
| 275 | How do you retrieve a random member, or several random members, from a Redis set without removing them? Redis › Sets & Sorted Sets in Redis | Redis | Sets & Sorted Sets in Redis | Intermediate |
| 276 | How do you limit the size of a Redis Stream to prevent it from growing indefinitely and consuming unlimited memory? Redis › Streams | Redis | Streams | Intermediate |
| 277 | What are Redis bitmaps, and how do they let you efficiently work with individual bits within a string? Redis › Strings & Bitmaps in Redis | Redis | Strings & Bitmaps in Redis | Intermediate |
| 278 | How do you use the SETRANGE and GETRANGE commands to work with a specific portion of a Redis string without affecting or retrieving the rest of it? Redis › Strings & Bitmaps in Redis | Redis | Strings & Bitmaps in Redis | Intermediate |
| 279 | What's the difference between IEnumerable<T> and List<T>? C# Programming › C# Language Fundamentals | C# Programming | C# Language Fundamentals | Intermediate |
| 280 | How do you add or subtract a specific amount of time from a date using PHP's DateInterval and the modify or add methods? PHP › Date & Time Handling | PHP | Date & Time Handling | Intermediate |
| 281 | How do you write a comprehension with MULTIPLE 'if' conditions, and how does that differ from combining them with 'and'? Python › Comprehensions & Generators | Python | Comprehensions & Generators | Advanced |
| 282 | How would you implement a caching/memoization decorator from scratch, similar to functools.lru_cache? Python › Decorators | Python | Decorators | Advanced |
| 283 | How do properties and descriptors interact with __slots__, and what special consideration is needed? Python › Descriptors & Properties | Python | Descriptors & Properties | Advanced |
| 284 | How does functools.cmp_to_key bridge old-style comparison functions with Python 3's key-based sorting? Python › functools & Functional Programming Tools | Python | functools & Functional Programming Tools | Advanced |
| 285 | How can functools.lru_cache be used with typed=True, and what does that change? Python › functools & Functional Programming Tools | Python | functools & Functional Programming Tools | Advanced |
| 286 | What is the difference between __iter__ returning self versus returning a separate iterator object? Python › Iterators & the Iterator Protocol | Python | Iterators & the Iterator Protocol | Advanced |
| 287 | How does itertools.groupby depend on input order, and what's a common mistake when using it? Python › Iterators & the Iterator Protocol | Python | Iterators & the Iterator Protocol | Advanced |
| 288 | How do __iadd__ and other in-place operator methods (__isub__, __imul__) differ from their non-in-place counterparts? Python › Magic Methods & Operator Overloading | Python | Magic Methods & Operator Overloading | Advanced |
| 289 | How does __bool__ (or the legacy __nonzero__) determine an object's truthiness, and what's the fallback if it's not defined? Python › Magic Methods & Operator Overloading | Python | Magic Methods & Operator Overloading | Advanced |
| 290 | How does the weakref module help avoid reference cycles and memory leaks? Python › Memory Management & Garbage Collection | Python | Memory Management & Garbage Collection | Advanced |
| 291 | How does object interning (like small integer caching and string interning) affect memory and identity comparisons? Python › Memory Management & Garbage Collection | Python | Memory Management & Garbage Collection | Advanced |
| 292 | What is memory fragmentation in the context of Python's object allocator, and how does pymalloc address it for small objects? Python › Memory Management & Garbage Collection | Python | Memory Management & Garbage Collection | Advanced |
| 293 | How does __class_getitem__ enable generic-looking syntax like MyClass[int]? Python › Metaclasses & Class Customization | Python | Metaclasses & Class Customization | Advanced |
| 294 | What is boxing and unboxing, and what performance cost does it incur? .NET › CLR & Runtime | .NET | CLR & Runtime | Advanced |
| 295 | How do type annotations (introduced in Java 8, JSR 308) differ from traditional declaration annotations, and what new locations can they target? Java › Annotations | Java | Annotations | Advanced |
| 296 | How would you implement a custom enum that also functions as a lookup table (mapping an external code to a constant), such as parsing an HTTP status code string into an enum constant, handling unknown values gracefully? Java › Enums | Java | Enums | Advanced |
| 297 | How does a lambda expression capture variables from its enclosing scope, and why must captured local variables be effectively final? Java › Functional Interfaces & Method References | Java | Functional Interfaces & Method References | Advanced |
| 298 | How does Java's type inference determine the target type for a lambda expression in an ambiguous overload scenario, and what happens when a lambda could match multiple overloaded methods accepting different functional interfaces? Java › Functional Interfaces & Method References | Java | Functional Interfaces & Method References | Advanced |
| 299 | How would you correctly handle character encoding when reading a text file whose encoding isn't known in advance (or might not be UTF-8), and what pitfalls exist with relying on the JVM's platform default charset? Java › I/O & NIO | Java | I/O & NIO | Advanced |
| 300 | How would you use a CTE combined with a window function to identify and remove duplicate rows from a table? SQL Server › Common Table Expressions (CTEs) | SQL Server | Common Table Expressions (CTEs) | Advanced |
| 301 | How would you configure full text search to handle different languages correctly, including proper word breaking and stemming? SQL Server › Full Text Search | SQL Server | Full Text Search | Advanced |
| 302 | What migration steps and limitations should you consider when converting an existing disk based table to a memory optimized table? SQL Server › In-Memory OLTP (Memory-Optimized Tables) | SQL Server | In-Memory OLTP (Memory-Optimized Tables) | Advanced |
| 303 | How does a CROSS JOIN work, and what are some legitimate use cases for it despite the risk of accidentally creating a huge result set? SQL Server › Joins | SQL Server | Joins | Advanced |
| 304 | How would you decide on an appropriate partitioning strategy, including the partition key and boundary values, for a very large table in a new system? SQL Server › Partitioning | SQL Server | Partitioning | Advanced |
| 305 | How do CASE expressions work in T-SQL, and how can they be used to implement conditional logic directly within a SELECT statement? SQL Server › T-SQL Fundamentals & Syntax | SQL Server | T-SQL Fundamentals & Syntax | Advanced |
| 306 | How does the ROWS versus RANGE frame specification within an OVER clause affect the result of a window function like a running total? SQL Server › Window Functions | SQL Server | Window Functions | Advanced |
| 307 | How would you troubleshoot a query that is unexpectedly using a slow hash join when a much faster index seek and nested loop join should be possible? SQL Server › Hash Indexes & Hash Join Operations | SQL Server | Hash Indexes & Hash Join Operations | Advanced |
| 308 | How does the internal listpack encoding for small hashes affect memory usage, and at what point does Redis switch to a different, less compact encoding? Redis › Hashes in Redis | Redis | Hashes in Redis | Advanced |
| 309 | What are the limitations of HyperLogLog that make it unsuitable for certain use cases, even though it is excellent for approximate unique counting? Redis › HyperLogLog in Redis | Redis | HyperLogLog in Redis | Advanced |
| 310 | How does the internal encoding of Redis lists change as they grow, and what performance implications does this have? Redis › Lists in Redis | Redis | Lists in Redis | Advanced |
| 311 | How would you design a strategy to significantly reduce memory usage for an application storing millions of small, similarly structured objects in Redis? Redis › Redis Memory Optimization | Redis | Redis Memory Optimization | Advanced |
| 312 | How does memory efficiency compare between Redis and Memcached for storing large numbers of small key value pairs? Redis › Redis vs Memcached | Redis | Redis vs Memcached | Advanced |
| 313 | What are the performance and memory considerations when storing very large or deeply nested JSON documents using RedisJSON? Redis › RedisJSON | Redis | RedisJSON | Advanced |
| 314 | How does RedisTimeSeries handle labels and how can you use them to query across multiple related time series at once? Redis › RedisTimeSeries | Redis | RedisTimeSeries | Advanced |
| 315 | How would you use sorted sets to implement a simple tag based content recommendation system, finding content similar to a given item? Redis › Sets & Sorted Sets in Redis | Redis | Sets & Sorted Sets in Redis | Advanced |
| 316 | What internal memory encoding does Redis use for small sets and sorted sets, and how does this affect performance and memory usage as they grow? Redis › Sets & Sorted Sets in Redis | Redis | Sets & Sorted Sets in Redis | Advanced |
| 317 | How would you design a robust event sourcing system using Redis Streams as the primary event log? Redis › Streams | Redis | Streams | Advanced |
| 318 | How would you use bitmap operations like BITOP to combine multiple daily activity bitmaps and answer questions like how many users were active on both of two specific days? Redis › Strings & Bitmaps in Redis | Redis | Strings & Bitmaps in Redis | Advanced |