| 1 | How do you create a Date object representing the current moment? JavaScript › Date, Time & Internationalization (Intl API) | JavaScript | Date, Time & Internationalization (Intl API) | Beginner |
| 2 | Why is Date.parse() considered unreliable for parsing date strings? JavaScript › Date, Time & Internationalization (Intl API) | JavaScript | Date, Time & Internationalization (Intl API) | Beginner |
| 3 | Why was the modern java.time API (introduced in Java 8) created to replace the legacy Date and Calendar classes, and what specific problems did the old classes have? Java › Java Date & Time API (java.time) | Java | Java Date & Time API (java.time) | Beginner |
| 4 | How would you get the current date and time, and how does specifying an explicit ZoneId (versus relying on the system default) affect the result of LocalDate.now() or LocalDateTime.now()? Java › Java Date & Time API (java.time) | Java | Java Date & Time API (java.time) | Beginner |
| 5 | 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 |
| 6 | How do you format a date or time value in PHP using the format method, and what do common format characters like Y, m, and d represent? PHP › Date & Time Handling | PHP | Date & Time Handling | Beginner |
| 7 | How do you format a date for a specific locale without a library? JavaScript › Date, Time & Internationalization (Intl API) | JavaScript | Date, Time & Internationalization (Intl API) | Intermediate |
| 8 | How do you calculate the difference between two dates in days? JavaScript › Date, Time & Internationalization (Intl API) | JavaScript | Date, Time & Internationalization (Intl API) | Intermediate |
| 9 | What is the difference between LocalDate, LocalTime, LocalDateTime, and ZonedDateTime, and when would you use each? Java › Java Date & Time API (java.time) | Java | Java Date & Time API (java.time) | Intermediate |
| 10 | 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 |
| 11 | 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 |
| 12 | How would you use TemporalAdjusters to compute dates like 'the next Monday' or 'the last day of the month' relative to a given LocalDate? Java › Java Date & Time API (java.time) | Java | Java Date & Time API (java.time) | Intermediate |
| 13 | What is the significance of storing date-time values in UTC in a database or when transmitting between systems, rather than storing them in a specific local timezone? Java › Java Date & Time API (java.time) | Java | Java Date & Time API (java.time) | Intermediate |
| 14 | 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 |
| 15 | How does PHP's DateTime class handle time zones, and why is explicitly setting a time zone important for applications serving users in different regions? PHP › Date & Time Handling | PHP | Date & Time Handling | Intermediate |
| 16 | How do you calculate the difference between two dates in PHP, and what information does the DateInterval object returned by the diff method provide? PHP › Date & Time Handling | PHP | Date & Time Handling | Intermediate |
| 17 | Why is manually working with time zones using the Date object error-prone? JavaScript › Date, Time & Internationalization (Intl API) | JavaScript | Date, Time & Internationalization (Intl API) | Advanced |
| 18 | Why does new Date(2026, 7, 8) represent August 8th, not July 8th? JavaScript › Date, Time & Internationalization (Intl API) | JavaScript | Date, Time & Internationalization (Intl API) | Advanced |
| 19 | How does the Instant class represent a point in time, and how does it differ fundamentally from ZonedDateTime in terms of what it actually represents and how it should be used? Java › Java Date & Time API (java.time) | Java | Java Date & Time API (java.time) | Advanced |
| 20 | How would you correctly handle daylight saving time (DST) transitions when performing date-time arithmetic with ZonedDateTime, and what specific pitfalls exist around the 'spring forward' and 'fall back' transitions? Java › Java Date & Time API (java.time) | Java | Java Date & Time API (java.time) | Advanced |
| 21 | 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 |
| 22 | How would you implement a custom TemporalAdjuster to calculate business-specific date logic (like 'the next business day, skipping weekends and holidays')? Java › Java Date & Time API (java.time) | Java | Java Date & Time API (java.time) | Advanced |
| 23 | How would you correctly serialize and deserialize java.time types (like LocalDateTime or ZonedDateTime) to/from JSON using a library like Jackson, and what common configuration pitfalls arise? Java › Java Date & Time API (java.time) | Java | Java Date & Time API (java.time) | Advanced |
| 24 | What is the difference between DateTime and DateTimeImmutable, and why might a codebase deliberately prefer the immutable version despite the extra verbosity? PHP › Date & Time Handling | PHP | Date & Time Handling | Advanced |
| 25 | How should an application handle daylight saving time transitions correctly when performing date arithmetic across such a transition? PHP › Date & Time Handling | PHP | Date & Time Handling | Advanced |
| 26 | What is the difference between a GraphQL scalar type and an object type, and how would you define a custom scalar (like DateTime) in a Node.js GraphQL server? Node.js › GraphQL | Node.js | GraphQL | Intermediate |
| 27 | What is the UI thread and why must UI updates happen on it? .NET MAUI › Concurrency & Threading | .NET MAUI | Concurrency & Threading | Beginner |
| 28 | What is the UI thread and why must UI updates happen on it? .NET MAUI › Concurrency & Threading | .NET MAUI | Concurrency & Threading | Beginner |
| 29 | How do you set and update state correctly inside a class component? React › Class Components & Legacy Lifecycle Methods | React | Class Components & Legacy Lifecycle Methods | Beginner |
| 30 | 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 |
| 31 | What is the Form widget in Flutter, and how does it let you properly group together several separate individual input fields to be validated and submitted all together as one single unit? Flutter › Forms & Input Validation in Flutter | Flutter | Forms & Input Validation in Flutter | Beginner |
| 32 | How do you properly create a table and perform basic insert, query, update, and delete operations using sqflite's own available methods? Flutter › SQLite & Local Databases (sqflite) | Flutter | SQLite & Local Databases (sqflite) | Beginner |
| 33 | How do you keep API calls off the UI thread and update the UI safely? .NET MAUI › Networking & APIs | .NET MAUI | Networking & APIs | Intermediate |
| 34 | How do you keep API calls off the UI thread and update the UI safely? .NET MAUI › Networking & APIs | .NET MAUI | Networking & APIs | Intermediate |
| 35 | Why does a long synchronous function block UI updates and event handling? JavaScript › Event Loop & Concurrency | JavaScript | Event Loop & Concurrency | Intermediate |
| 36 | How would you use a template literal type to validate that a string matches a specific structured pattern, like a hex color code? TypeScript › Template Literal Types | TypeScript | Template Literal Types | Intermediate |
| 37 | How do you validate configuration options at application startup to fail fast on misconfiguration? .NET › Configuration & Options | .NET | Configuration & Options | Intermediate |
| 38 | How do you validate that an API's actual behavior matches its published OpenAPI specification, preventing documentation drift? ASP.NET Core › API Documentation with Swagger/OpenAPI | ASP.NET Core | API Documentation with Swagger/OpenAPI | Intermediate |
| 39 | How do you configure a sunset date for a deprecated API version so clients receive a clear removal timeline? ASP.NET Core › API Versioning | ASP.NET Core | API Versioning | Intermediate |
| 40 | How do you validate an uploaded file's actual content type (not just its client-supplied extension or Content-Type header) to prevent malicious file uploads? ASP.NET Core › File Uploads & Streaming Large Files | ASP.NET Core | File Uploads & Streaming Large Files | Intermediate |
| 41 | Why is it important to validate a server's TLS certificate when making outbound HttpClient calls to external services, and what's the risk of disabling certificate validation? ASP.NET Core › HTTPS, Certificates & Transport Security | ASP.NET Core | HTTPS, Certificates & Transport Security | Intermediate |
| 42 | What is the Maven build lifecycle, and what do the common phases (validate, compile, test, package, install, deploy) each do? Java › Build Tools: Maven & Gradle | Java | Build Tools: Maven & Gradle | Intermediate |
| 43 | How would you cache the result of a database query in Node.js while ensuring the cache is properly invalidated when the underlying data changes? Node.js › Caching | Node.js | Caching | Intermediate |
| 44 | How would you validate and restrict uploaded file types and sizes using multer to prevent malicious or oversized uploads? Node.js › File Uploads & Media Processing | Node.js | File Uploads & Media Processing | Intermediate |
| 45 | How would you validate an uploaded image's actual dimensions and reject ones that don't meet minimum or maximum size requirements? Node.js › File Uploads & Media Processing | Node.js | File Uploads & Media Processing | Intermediate |
| 46 | How do you validate a JWT's claims (issuer, audience, expiration) beyond just verifying its cryptographic signature? Node.js › Authentication & Authorization (JWT, OAuth, Passport) | Node.js | Authentication & Authorization (JWT, OAuth, Passport) | Intermediate |
| 47 | How would you validate that all required environment variables are present and correctly typed at application startup, rather than discovering a missing one at runtime? Node.js › Environment Variables & Configuration | Node.js | Environment Variables & Configuration | Intermediate |
| 48 | How would you validate a form in React and show an error message to the user? React › Forms: Controlled & Uncontrolled Components | React | Forms: Controlled & Uncontrolled Components | Intermediate |
| 49 | What is incremental static regeneration and how does it solve the problem of static content becoming outdated? React › Static Site Generation (SSG) & Hydration | React | Static Site Generation (SSG) & Hydration | Intermediate |
| 50 | How would you use Angular's automatic update schematics to upgrade a project to a new major version? Angular › Angular Schematics & Custom Builders | Angular | Angular Schematics & Custom Builders | Intermediate |
| 51 | Why does mutating an array or object directly sometimes fail to trigger a component update when using OnPush? Angular › Change Detection | Angular | Change Detection | Intermediate |
| 52 | How do you format dates, numbers, and currency correctly for different locales in an Angular app? Angular › Internationalization (i18n) in Angular | Angular | Internationalization (i18n) in Angular | Intermediate |
| 53 | What does zoneless change detection mean, and how does Angular know when to update the screen without Zone.js? Angular › Zoneless Change Detection & Zone.js | Angular | Zoneless Change Detection & Zone.js | Intermediate |
| 54 | How would you validate that all required environment variables are present and correctly formatted before your app starts? Next.js › Environment Variables & Configuration Management | Next.js | Environment Variables & Configuration Management | Intermediate |
| 55 | How do you validate form data on the server before saving it, and show validation errors back to the user? Next.js › Form Handling & Validation in Next.js | Next.js | Form Handling & Validation in Next.js | Intermediate |
| 56 | How do you use revalidatePath to refresh the cache for a specific page after content changes? Next.js › On-Demand Revalidation Strategies | Next.js | On-Demand Revalidation Strategies | Intermediate |
| 57 | How do you use revalidateTag to refresh multiple related pieces of cached content at once? Next.js › On-Demand Revalidation Strategies | Next.js | On-Demand Revalidation Strategies | Intermediate |
| 58 | How do server actions automatically update the user interface after making a change to data? Next.js › Server Actions & Mutations | Next.js | Server Actions & Mutations | Intermediate |
| 59 | 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 |
| 60 | How often does a full text index need to be updated to reflect changes made to the underlying table's data? SQL Server › Full Text Search | SQL Server | Full Text Search | Intermediate |
| 61 | 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 |
| 62 | 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 |
| 63 | 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 |
| 64 | How do outdated or missing statistics affect the query optimizer's ability to choose an efficient execution plan? SQL Server › Query Optimization & Plans | SQL Server | Query Optimization & Plans | Intermediate |
| 65 | How do you monitor the health and latency of a transactional replication setup to ensure subscribers are staying reasonably up to date? SQL Server › Replication | SQL Server | Replication | Intermediate |
| 66 | 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 |
| 67 | 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 |
| 68 | How can an organization consolidate CloudTrail logging across multiple AWS accounts using AWS Organizations? AWS › AWS CloudTrail & Auditing | AWS | AWS CloudTrail & Auditing | Intermediate |
| 69 | How can consolidated billing within AWS Organizations help reduce overall costs across multiple accounts? AWS › AWS Cost Management & Billing | AWS | AWS Cost Management & Billing | Intermediate |
| 70 | How does Elastic Beanstalk handle application updates and deployment policies such as rolling and immutable deployments? AWS › AWS Elastic Beanstalk | AWS | AWS Elastic Beanstalk | Intermediate |
| 71 | How does Systems Manager Patch Manager automate the process of keeping instances up to date with the latest security patches? AWS › AWS Systems Manager | AWS | AWS Systems Manager | Intermediate |
| 72 | How does CloudFormation calculate and apply changes when you update an existing stack, and what is a change set? AWS › IaC (CloudFormation) | AWS | IaC (CloudFormation) | Intermediate |
| 73 | How does semantic versioning work, and how do Composer's version constraint operators like caret and tilde let you control which updates are automatically accepted? PHP › Composer | PHP | Composer | Intermediate |
| 74 | What steps are typically involved in a standard PHP application deployment process, from code changes to a live production update? PHP › Deployment & Hosting for PHP Applications | PHP | Deployment & Hosting for PHP Applications | Intermediate |
| 75 | How should you validate an uploaded file's type and size before accepting it, and why is checking only the file extension considered insufficient for security? PHP › File Upload Handling | PHP | File Upload Handling | Intermediate |
| 76 | How does PHP's filter_var function help validate and sanitize different types of user input, such as emails, URLs, and integers? PHP › Form Handling & Validation | PHP | Form Handling & Validation | Intermediate |
| 77 | How do Firestore's real time listeners, specifically using a StreamBuilder in Flutter, let your app's interface automatically update the moment underlying data changes? Flutter › Cloud Firestore & Firebase Storage | Flutter | Cloud Firestore & Firebase Storage | Intermediate |
| 78 | How should a Flutter app properly validate and sanitize any data received from a server, rather than blindly and unconditionally trusting that all incoming data is genuinely already safe and well formed? Flutter › Flutter App Security Best Practices | Flutter | Flutter App Security Best Practices | Intermediate |
| 79 | How does properly configuring your Flutter web app's own routing to correctly and consistently update the actual browser URL and page title for every single distinct page genuinely help both usability and overall search engine optimization together? Flutter › Flutter Web Performance & SEO | Flutter | Flutter Web Performance & SEO | Intermediate |
| 80 | What are the key lifecycle methods of a StatefulWidget's own associated State object, specifically initState, didUpdateWidget, and dispose, and when does each one actually genuinely get called? Flutter › Flutter Widgets Fundamentals (Stateless & Stateful) | Flutter | Flutter Widgets Fundamentals (Stateless & Stateful) | Intermediate |
| 81 | How do GraphQL subscriptions let a Flutter app receive genuinely real time updates whenever specific relevant data actually changes on the server, similar conceptually to how a Firestore real time listener already works? Flutter › GraphQL in Flutter | Flutter | GraphQL in Flutter | Intermediate |
| 82 | How should you properly listen to and correctly handle the ongoing purchase update stream provided by the in_app_purchase package, properly reacting appropriately to a pending, completed, or genuinely failed purchase status? Flutter › In App Purchases in Flutter | Flutter | In App Purchases in Flutter | Intermediate |
| 83 | How do you properly format dates, numbers, and currency values correctly according to a given user's own specific current locale, using the intl package? Flutter › Internationalization & Localization (i18n) | Flutter | Internationalization & Localization (i18n) | Intermediate |
| 84 | How should you properly write a genuinely comprehensive CHANGELOG.md file for your published package, and why does it genuinely matter quite a lot to consumers deciding whether to actually update to a genuinely newer version? Flutter › Publishing Packages on pub.dev | Flutter | Publishing Packages on pub.dev | Intermediate |
| 85 | How do you properly implement database migrations in sqflite, correctly handling a schema change such as adding a genuinely new column when a user actually updates to a newer version of your app? Flutter › SQLite & Local Databases (sqflite) | Flutter | SQLite & Local Databases (sqflite) | Intermediate |
| 86 | How does the flutter_bloc package's own BlocBuilder widget let your interface automatically and properly rebuild itself in direct response to a BLoC or Cubit emitting a genuinely new updated state? Flutter › State Management with BLoC & Cubit | Flutter | State Management with BLoC & Cubit | Intermediate |
| 87 | How can you properly implement pull to refresh functionality that correctly triggers a Riverpod provider to actually genuinely refetch its own underlying data using the ref.refresh or invalidate methods? Flutter › State Management with Riverpod | Flutter | State Management with Riverpod | Intermediate |
| 88 | How do you handle real-time updates (WebSockets/SignalR) in a MAUI app? .NET MAUI › Networking & APIs | .NET MAUI | Networking & APIs | Advanced |
| 89 | How do you implement over-the-air updates or feature flags in MAUI? .NET MAUI › Publishing & Deployment | .NET MAUI | Publishing & Deployment | Advanced |
| 90 | How do you efficiently update large observable collections? .NET MAUI › Advanced Data Binding & Collections | .NET MAUI | Advanced Data Binding & Collections | Advanced |
| 91 | How do you safely update collections bound to the UI from background threads? .NET MAUI › Concurrency & Threading | .NET MAUI | Concurrency & Threading | Advanced |
| 92 | How do you handle real-time updates (WebSockets/SignalR) in a MAUI app? .NET MAUI › Networking & APIs | .NET MAUI | Networking & APIs | Advanced |
| 93 | How do you implement over-the-air updates or feature flags in MAUI? .NET MAUI › Publishing & Deployment | .NET MAUI | Publishing & Deployment | Advanced |
| 94 | How do you efficiently update large observable collections? .NET MAUI › Advanced Data Binding & Collections | .NET MAUI | Advanced Data Binding & Collections | Advanced |
| 95 | How do you safely update collections bound to the UI from background threads? .NET MAUI › Concurrency & Threading | .NET MAUI | Concurrency & Threading | Advanced |
| 96 | How do you validate manifests before they reach the cluster (policy as code)? ArgoCD › GitOps Principles | ArgoCD | GitOps Principles | Advanced |
| 97 | How would you write a custom type guard that safely narrows an 'unknown' value into a specific, validated interface shape? TypeScript › Never, Unknown & Void Types | TypeScript | Never, Unknown & Void Types | Advanced |
| 98 | How would you implement a type-safe 'path getter' utility (like lodash's get()) using recursive template literal types to validate dot-separated property paths? TypeScript › Template Literal Types | TypeScript | Template Literal Types | Advanced |
| 99 | How do you safely validate that an enum value received from external input (like deserialized JSON or a database) is actually a DEFINED member, given that enums don't enforce this by default? C# › Enums & Flags | C# | Enums & Flags | Advanced |
| 100 | How would you write a decorator that validates a function's arguments against its type hints at RUNTIME, since Python doesn't enforce type hints by default? Python › Decorators | Python | Decorators | Advanced |
| 101 | How does the Generic Host's dependency validation (ValidateOnBuild and ValidateScopes) help catch DI configuration errors early? .NET › Generic Host | .NET | Generic Host | Advanced |
| 102 | How does JWT bearer authentication validate an incoming token, and what claims does TokenValidationParameters check? ASP.NET Core › Authentication | ASP.NET Core | Authentication | Advanced |
| 103 | How would you implement sign-out that properly invalidates both a cookie session and any associated server-side state? ASP.NET Core › Authentication | ASP.NET Core | Authentication | Advanced |
| 104 | How would you implement real-time UI updates in a Blazor Server component in response to a backend event, like a new order being placed elsewhere in the system? ASP.NET Core › Blazor Integration with ASP.NET Core | ASP.NET Core | Blazor Integration with ASP.NET Core | Advanced |
| 105 | How would you monitor and measure cache effectiveness (hit rate) in a production ASP.NET Core application to validate a caching strategy is actually helping? ASP.NET Core › Caching | ASP.NET Core | Caching | Advanced |
| 106 | How do you validate configuration options at application startup to fail fast on misconfiguration, using ValidateDataAnnotations and ValidateOnStart? ASP.NET Core › Configuration & Options Pattern | ASP.NET Core | Configuration & Options Pattern | Advanced |
| 107 | How do you write a custom IValidateOptions<T> implementation for validation logic beyond what DataAnnotations attributes can express? ASP.NET Core › Configuration & Options Pattern | ASP.NET Core | Configuration & Options Pattern | Advanced |
| 108 | How does ValidateOnBuild help catch dependency injection configuration errors immediately at application startup rather than at runtime? ASP.NET Core › Dependency Injection | ASP.NET Core | Dependency Injection | Advanced |
| 109 | How would you configure and validate that HTTP/2 (or HTTP/3) is actually being used end-to-end through a reverse proxy, rather than silently downgrading to HTTP/1.1? ASP.NET Core › Hosting Models: Kestrel, IIS & Reverse Proxies | ASP.NET Core | Hosting Models: Kestrel, IIS & Reverse Proxies | Advanced |
| 110 | How would you implement mutual TLS (mTLS) authentication in ASP.NET Core, where the server also validates a client-presented certificate? ASP.NET Core › HTTPS, Certificates & Transport Security | ASP.NET Core | HTTPS, Certificates & Transport Security | Advanced |
| 111 | How does JPMS's strong encapsulation interact with reflection-heavy frameworks and libraries that predate the module system, and what specific JVM flags (like --add-opens) exist as an escape hatch for cases where proper module declarations aren't feasible? Java › Java Platform Module System (JPMS) | Java | Java Platform Module System (JPMS) | Advanced |
| 112 | What is the 'stale-while-revalidate' caching strategy, and how would you implement it for an API response? Node.js › Caching | Node.js | Caching | Advanced |
| 113 | What is optimistic concurrency control, and how would you implement it to prevent lost updates when two users edit the same record simultaneously? Node.js › Databases | Node.js | Databases | Advanced |
| 114 | What is a Kubernetes Deployment's rolling update strategy, and how does it apply to updating a running Node.js application? Node.js › Docker & Deployment | Node.js | Docker & Deployment | Advanced |
| 115 | How would you implement Server-Sent Events (SSE) in Node.js to push real-time updates to a browser client over a single long-lived HTTP connection? Node.js › HTTP & Web Servers | Node.js | HTTP & Web Servers | Advanced |
| 116 | What is componentDidUpdate used for, and what mistake should you watch out for when using it? React › Class Components & Legacy Lifecycle Methods | React | Class Components & Legacy Lifecycle Methods | Advanced |
| 117 | How does SWR's stale while revalidate strategy work, and why is it useful? React › Data Fetching (React Query & SWR) | React | Data Fetching (React Query & SWR) | Advanced |
| 118 | How would you build a webhook endpoint that automatically revalidates your site whenever content changes in an external content management system? Next.js › On-Demand Revalidation Strategies | Next.js | On-Demand Revalidation Strategies | Advanced |
| 119 | What are the tradeoffs between using revalidatePath and revalidateTag for a large application with many interconnected pages? Next.js › On-Demand Revalidation Strategies | Next.js | On-Demand Revalidation Strategies | Advanced |
| 120 | How would you implement optimistic state updates for a feature like a like button, so the interface feels instant while a server action processes the actual update? Next.js › State Management in Next.js Apps | Next.js | State Management in Next.js Apps | Advanced |
| 121 | How would you create strongly typed server actions that validate their input and return a predictable, typed result? Next.js › TypeScript with Next.js | Next.js | TypeScript with Next.js | Advanced |
| 122 | Can a common table expression be used inside an UPDATE, DELETE, or MERGE statement, and how does that work? SQL Server › Common Table Expressions (CTEs) | SQL Server | Common Table Expressions (CTEs) | Advanced |
| 123 | How would you rewrite a common cursor based row by row update into an equivalent, much faster set based UPDATE statement? SQL Server › Cursors | SQL Server | Cursors | Advanced |
| 124 | How would you decide whether a specific table in your application is a good candidate for conversion to a memory optimized table? SQL Server › In-Memory OLTP (Memory-Optimized Tables) | SQL Server | In-Memory OLTP (Memory-Optimized Tables) | Advanced |
| 125 | How would you validate that a value stored in a column actually contains well formed JSON before allowing it to be inserted or updated? SQL Server › JSON Support in SQL Server | SQL Server | JSON Support in SQL Server | Advanced |
| 126 | How should an organization test and validate its disaster recovery plan to ensure it actually works during a real event? AWS › AWS Backup & Disaster Recovery | AWS | AWS Backup & Disaster Recovery | Advanced |
| 127 | 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 |
| 128 | How does Symfony's caching and configuration compilation process contribute to strong production performance, and what needs to happen when deploying an updated version of a Symfony application? PHP › Symfony Framework Essentials | PHP | Symfony Framework Essentials | Advanced |
| 129 | What is a phased or staged rollout, and how does gradually releasing an app update to an increasing percentage of the total user base help reduce the risk of a bad release affecting everyone at once? Flutter › App Deployment (Play Store & App Store) | Flutter | App Deployment (Play Store & App Store) | Advanced |
| 130 | How does the StreamBuilder widget in Flutter let you build a reactive user interface that automatically updates whenever a Stream emits a new value, without needing to manually manage the underlying subscription yourself? Flutter › Dart Streams & StreamControllers | Flutter | Dart Streams & StreamControllers | Advanced |
| 131 | What testing strategies help ensure deep links continue working correctly across app updates, especially as new screens and routes are added or existing route patterns change over time? Flutter › Deep Linking in Flutter | Flutter | Deep Linking in Flutter | Advanced |
| 132 | How should a subscription based app properly handle server side subscription status synchronization, ensuring a user's genuine subscription access remains fully accurate and properly up to date across several genuinely separate different devices? Flutter › In App Purchases in Flutter | Flutter | In App Purchases in Flutter | Advanced |
| 133 | How can you properly implement genuinely custom JSON converters specifically for a given specific type that json_serializable does not already directly know exactly how to properly handle by default, such as converting a DateTime value to and from a specific particular custom string format? Flutter › JSON Serialization & Deserialization | Flutter | JSON Serialization & Deserialization | Advanced |
| 134 | How do you properly implement optimistic updates using Riverpod, immediately updating your interface before an actual backend confirmation genuinely arrives, then properly rolling back that particular change if the request genuinely happens to fail? Flutter › State Management with Riverpod | Flutter | State Management with Riverpod | Advanced |
| 135 | How do you format numbers and currency for a locale using Intl.NumberFormat? JavaScript › Date, Time & Internationalization (Intl API) | JavaScript | Date, Time & Internationalization (Intl API) | Intermediate |
| 136 | How would you calculate a person's age or the number of days until a recurring annual event (like a birthday) using ChronoUnit, and what's a common pitfall with leap-year birthdays (February 29)? Java › Java Date & Time API (java.time) | Java | Java Date & Time API (java.time) | Intermediate |
| 137 | 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 |
| 138 | How do you sort an array of strings correctly for a given language using Intl.Collator? JavaScript › Date, Time & Internationalization (Intl API) | JavaScript | Date, Time & Internationalization (Intl API) | Advanced |
| 139 | What is the Temporal API and what problem does it solve? JavaScript › Date, Time & Internationalization (Intl API) | JavaScript | Date, Time & Internationalization (Intl API) | Advanced |
| 140 | How do you get a relative time string like '3 days ago' using built-in APIs? JavaScript › Date, Time & Internationalization (Intl API) | JavaScript | Date, Time & Internationalization (Intl API) | Advanced |
| 141 | How would you implement a recurring event scheduling system that correctly handles both fixed-instant recurrence (every exactly 24 hours) and calendar-based recurrence (every day at 9 AM local time), given these have meaningfully different behavior across DST transitions? Java › Java Date & Time API (java.time) | Java | Java Date & Time API (java.time) | Advanced |
| 142 | What values does JSON.stringify() silently drop or convert, and why does this matter? JavaScript › JSON & Data Serialization | JavaScript | JSON & Data Serialization | Intermediate |
| 143 | How does the reviver function in JSON.parse() work? JavaScript › JSON & Data Serialization | JavaScript | JSON & Data Serialization | Intermediate |
| 144 | What are named capture groups in a regular expression, and how do they improve the readability of extracted match data compared to using only numbered groups? PHP › Regular Expressions in PHP | PHP | Regular Expressions in PHP | Intermediate |
| 145 | How does the sprintf function let you build formatted strings with precise control over things like decimal places, padding, and alignment? PHP › Strings & String Functions | PHP | Strings & String Functions | Intermediate |