| 1 | What are quick wins for improving MAUI list performance? .NET MAUI › Performance & Optimization | .NET MAUI | Performance & Optimization | Beginner |
| 2 | What are quick wins for improving MAUI list performance? .NET MAUI › Performance & Optimization | .NET MAUI | Performance & Optimization | Beginner |
| 3 | What is AOT compilation and how does it affect MAUI performance and size? .NET MAUI › Performance & Optimization | .NET MAUI | Performance & Optimization | Intermediate |
| 4 | What is AOT compilation and how does it affect MAUI performance and size? .NET MAUI › Performance & Optimization | .NET MAUI | Performance & Optimization | Intermediate |
| 5 | How do you profile a MAUI app to find performance bottlenecks? .NET MAUI › Performance & Optimization | .NET MAUI | Performance & Optimization | Advanced |
| 6 | How do you profile a MAUI app to find performance bottlenecks? .NET MAUI › Performance & Optimization | .NET MAUI | Performance & Optimization | Advanced |
| 7 | How do you reduce MAUI app startup time? .NET MAUI › Performance & Optimization | .NET MAUI | Performance & Optimization | Intermediate |
| 8 | How does the linker/trimming affect MAUI apps and how do you keep it safe? .NET MAUI › Performance & Optimization | .NET MAUI | Performance & Optimization | Intermediate |
| 9 | How do you diagnose and fix memory leaks in MAUI? .NET MAUI › Performance & Optimization | .NET MAUI | Performance & Optimization | Intermediate |
| 10 | How do you reduce MAUI app startup time? .NET MAUI › Performance & Optimization | .NET MAUI | Performance & Optimization | Intermediate |
| 11 | How does the linker/trimming affect MAUI apps and how do you keep it safe? .NET MAUI › Performance & Optimization | .NET MAUI | Performance & Optimization | Intermediate |
| 12 | How do you diagnose and fix memory leaks in MAUI? .NET MAUI › Performance & Optimization | .NET MAUI | Performance & Optimization | Intermediate |
| 13 | How do you optimize image loading and caching in MAUI? .NET MAUI › Performance & Optimization | .NET MAUI | Performance & Optimization | Advanced |
| 14 | How do you optimize image loading and caching in MAUI? .NET MAUI › Performance & Optimization | .NET MAUI | Performance & Optimization | Advanced |
| 15 | What is the difference between vertical and horizontal performance optimization strategies for a Node.js application, and how do you decide which to pursue first? Node.js › Performance Optimization & Profiling | Node.js | Performance Optimization & Profiling | Intermediate |
| 16 | What is JIT (Just-In-Time) compilation deoptimization in V8, and how can you detect when it's hurting a hot function's performance? Node.js › Performance Optimization & Profiling | Node.js | Performance Optimization & Profiling | Advanced |
| 17 | How should a team approach a comprehensive performance optimization effort for a PHP application experiencing slow response times under production load, prioritizing which areas to address first? PHP › Performance Optimization & OPcache | PHP | Performance Optimization & OPcache | Advanced |
| 18 | What is OPcache, and how does it improve PHP application performance by caching compiled bytecode? PHP › Performance Optimization & OPcache | PHP | Performance Optimization & OPcache | Beginner |
| 19 | What are some common, straightforward ways to identify performance bottlenecks in a PHP application before attempting to optimize it? PHP › Performance Optimization & OPcache | PHP | Performance Optimization & OPcache | Beginner |
| 20 | Why does using const constructors wherever genuinely possible throughout your Flutter code meaningfully help improve overall app performance? Flutter › Flutter Performance Optimization | Flutter | Flutter Performance Optimization | Beginner |
| 21 | How does the N plus one query problem impact performance, and what general strategies help identify and fix this common performance issue? PHP › Performance Optimization & OPcache | PHP | Performance Optimization & OPcache | Intermediate |
| 22 | How does using ListView.builder instead of manually constructing a plain ListView with a fully complete, fixed list of children genuinely improve performance specifically for a very long scrollable list? Flutter › Flutter Performance Optimization | Flutter | Flutter Performance Optimization | Intermediate |
| 23 | How can properly and effectively caching network images using a package like cached_network_image genuinely help meaningfully improve both your app's own overall performance and its actual data usage? Flutter › Flutter Performance Optimization | Flutter | Flutter Performance Optimization | Intermediate |
| 24 | How would you optimize a Node.js application's JSON serialization performance for API responses with very large or very frequent payloads? Node.js › Performance Optimization & Profiling | Node.js | Performance Optimization & Profiling | Advanced |
| 25 | How does OPcache's file validation and preloading feature work, and what performance benefit does preloading provide beyond standard bytecode caching? PHP › Performance Optimization & OPcache | PHP | Performance Optimization & OPcache | Advanced |
| 26 | What broader build performance optimizations, beyond just switching bundlers, can help speed up a large Next.js project's build times? Next.js › Turbopack & Build Performance | Next.js | Turbopack & Build Performance | Advanced |
| 27 | Why does a Flutter web app's initial loading performance genuinely require particular careful attention, given that it needs to actually download and properly initialize the Dart runtime before your app's own actual content can even begin to display at all? Flutter › Flutter Web Performance & SEO | Flutter | Flutter Web Performance & SEO | Beginner |
| 28 | What does frame rate genuinely mean in the context of a Flutter app, and why is consistently maintaining roughly sixty frames per second generally considered the ideal, genuinely smooth target for typical mobile devices? Flutter › Flutter Performance Optimization | Flutter | Flutter Performance Optimization | Beginner |
| 29 | How would you generate and interpret a CPU profile for a Node.js application using the built-in --prof flag? Node.js › Performance Optimization & Profiling | Node.js | Performance Optimization & Profiling | Intermediate |
| 30 | What is load testing, and how would you use a tool like autocannon or k6 to benchmark a Node.js API's throughput and latency? Node.js › Performance Optimization & Profiling | Node.js | Performance Optimization & Profiling | Intermediate |
| 31 | How do you use the useReportWebVitals hook to collect performance data from real visitors on your Next.js site? Next.js › Web Vitals & Performance Monitoring | Next.js | Web Vitals & Performance Monitoring | Intermediate |
| 32 | 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 |
| 33 | How does properly configuring PHP-FPM's process management settings, such as pm.max_children, affect an application's ability to handle concurrent traffic efficiently? PHP › Performance Optimization & OPcache | PHP | Performance Optimization & OPcache | Intermediate |
| 34 | How does lazy loading versus eager loading of resources and how minimizing unnecessary work within a request's critical path help improve overall PHP application response times? PHP › Performance Optimization & OPcache | PHP | Performance Optimization & OPcache | Intermediate |
| 35 | How does properly and correctly scoping a specific Provider or other state management listener to only genuinely rebuild the smallest, most narrowly necessary specific part of your widget tree help meaningfully avoid unnecessary, wasteful widget rebuilds? Flutter › Flutter Performance Optimization | Flutter | Flutter Performance Optimization | Intermediate |
| 36 | What strategies help further improve loading performance for image heavy pages beyond the default Image component behavior? Next.js › Image & Font Optimization | Next.js | Image & Font Optimization | Advanced |
| 37 | How would you measure and reduce the performance impact of multiple third party scripts on a page, such as analytics, ads, and chat widgets? Next.js › Third-Party Script Optimization | Next.js | Third-Party Script Optimization | Advanced |
| 38 | How does properly using RepaintBoundary strategically help isolate a frequently repainting specific part of your widget tree, genuinely preventing that repaint work from unnecessarily also affecting entirely unrelated sibling widgets nearby? Flutter › Flutter Performance Optimization | Flutter | Flutter Performance Optimization | Advanced |
| 39 | How do you properly use Flutter DevTools' dedicated memory profiler together with careful widget tree analysis to genuinely identify and meaningfully reduce an app's own excessive overall memory usage in a genuinely large, complex production application? Flutter › Flutter Performance Optimization | Flutter | Flutter Performance Optimization | Advanced |
| 40 | What is an execution plan in SQL Server, and how does it help you understand query performance? SQL Server › Query Optimization & Plans | SQL Server | Query Optimization & Plans | Beginner |
| 41 | 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 |
| 42 | What is parameter sniffing, and how can it sometimes lead to unexpectedly poor query performance? SQL Server › Query Optimization & Plans | SQL Server | Query Optimization & Plans | Intermediate |
| 43 | 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 |
| 44 | 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 |
| 45 | 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 |
| 46 | How do you use the SQL Server Query Store feature to identify and address query performance regressions over time? SQL Server › Query Optimization & Plans | SQL Server | Query Optimization & Plans | Advanced |
| 47 | 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 |
| 48 | How does the Cost Optimization pillar guide teams toward avoiding unnecessary spending while still meeting business and performance requirements? AWS › Well-Architected Framework | AWS | Well-Architected Framework | Intermediate |
| 49 | How do you optimize custom fonts in a Next.js application using next/font? Next.js › Image & Font Optimization | Next.js | Image & Font Optimization | Beginner |
| 50 | What is deferred loading in the specific context of a Flutter web app, and how does it let you meaningfully reduce your app's own initial download size by only actually loading certain specific code when it is genuinely actually needed? Flutter › Flutter Web Performance & SEO | Flutter | Flutter Web Performance & SEO | Beginner |
| 51 | How does the Image component handle responsive images that need to look good on different screen sizes? Next.js › Image & Font Optimization | Next.js | Image & Font Optimization | Intermediate |
| 52 | What do the different loading strategies like beforeInteractive, afterInteractive, and lazyOnload actually control? Next.js › Third-Party Script Optimization | Next.js | Third-Party Script Optimization | Intermediate |
| 53 | How do you run code after a third party script has finished loading? Next.js › Third-Party Script Optimization | Next.js | Third-Party Script Optimization | Intermediate |
| 54 | How do you properly measure and meaningfully improve a Flutter web app's own Core Web Vitals metrics, such as Largest Contentful Paint and Cumulative Layout Shift, which meaningfully affect both overall user experience and its actual search engine ranking? Flutter › Flutter Web Performance & SEO | Flutter | Flutter Web Performance & SEO | Advanced |
| 55 | What is caching, and why is it commonly used to improve the performance of a Node.js application? Node.js › Caching | Node.js | Caching | Beginner |
| 56 | What does the built-in Image component in Next.js do differently from a regular HTML img tag? Next.js › Image & Font Optimization | Next.js | Image & Font Optimization | Beginner |
| 57 | How do you set the page title and description for SEO in the Next.js App Router? Next.js › Metadata API & SEO Optimization | Next.js | Metadata API & SEO Optimization | Beginner |
| 58 | What is the next/script component, and why should you use it instead of a plain HTML script tag? Next.js › Third-Party Script Optimization | Next.js | Third-Party Script Optimization | Beginner |
| 59 | What are Core Web Vitals, and why do they matter for a Next.js application? Next.js › Web Vitals & Performance Monitoring | Next.js | Web Vitals & Performance Monitoring | Beginner |
| 60 | What is caching in a PHP application, and why is it important for improving performance? PHP › Caching Strategies in PHP | PHP | Caching Strategies in PHP | Beginner |
| 61 | What is Flutter DevTools, and what are some of the core debugging and performance analysis features it actually provides to help you build and troubleshoot a Flutter app? Flutter › Flutter DevTools & Debugging | Flutter | Flutter DevTools & Debugging | Beginner |
| 62 | What is event delegation and why is it a performance best practice? JavaScript › DOM & Events | JavaScript | DOM & Events | Intermediate |
| 63 | What is HTTP keep-alive, and how does it improve performance for a Node.js server handling many requests from the same client? Node.js › HTTP & Web Servers | Node.js | HTTP & Web Servers | Intermediate |
| 64 | What is an APM (Application Performance Monitoring) tool, and what capabilities does it typically add beyond basic logging? Node.js › Logging & Monitoring | Node.js | Logging & Monitoring | Intermediate |
| 65 | What specific techniques help improve the Largest Contentful Paint metric on a typical Next.js page? Next.js › Web Vitals & Performance Monitoring | Next.js | Web Vitals & Performance Monitoring | Intermediate |
| 66 | How do you use the MEMORY DOCTOR and MEMORY STATS commands to get recommendations and detailed insight into Redis's memory usage patterns? Redis › Redis Memory Optimization | Redis | Redis Memory Optimization | Intermediate |
| 67 | What is Swoole, and how does it extend PHP with built in support for coroutines and high performance networking? PHP › Asynchronous PHP (ReactPHP & Swoole) | PHP | Asynchronous PHP (ReactPHP & Swoole) | Intermediate |
| 68 | What is eager loading in Eloquent, and how does it help solve the N plus one query performance problem? PHP › Eloquent ORM & Doctrine ORM | PHP | Eloquent ORM & Doctrine ORM | Intermediate |
| 69 | How can you compress or resize an image captured by the camera before uploading it to a server, and why is this an important consideration for both performance and data usage? Flutter › Camera & Media Handling in Flutter | Flutter | Camera & Media Handling in Flutter | Intermediate |
| 70 | Why is properly implementing the shouldRepaint method on a CustomPainter important for performance, and what happens if it always incorrectly returns true? Flutter › Custom Painters & CustomPaint | Flutter | Custom Painters & CustomPaint | Intermediate |
| 71 | How does the Flutter DevTools performance timeline help you actually identify specific frames that are taking longer than the ideal sixteen milliseconds needed to maintain a genuinely smooth sixty frames per second animation? Flutter › Flutter DevTools & Debugging | Flutter | Flutter DevTools & Debugging | Intermediate |
| 72 | How can excessively calling setState too frequently, or calling it at too high a level within your widget tree, genuinely lead to noticeable performance problems within your app? Flutter › State Management with setState | Flutter | State Management with setState | Intermediate |
| 73 | How does the Performance panel in DevTools help diagnose a janky UI? JavaScript › Debugging, Testing & Tooling | JavaScript | Debugging, Testing & Tooling | Advanced |
| 74 | What is the difference between passive and non-passive event listeners for scroll performance? JavaScript › DOM & Events | JavaScript | DOM & Events | Advanced |
| 75 | What is monkey-patching in the context of Node.js APM (Application Performance Monitoring) tools, and what are its risks? Node.js › Advanced Node.js | Node.js | Advanced Node.js | Advanced |
| 76 | What is database indexing, and how does an index improve query performance in a Node.js application's database layer? Node.js › Databases | Node.js | Databases | Advanced |
| 77 | How would you use the 'clinic.js' toolset (clinic doctor, clinic flame) to diagnose a Node.js performance problem? Node.js › Debugging & Diagnostics | Node.js | Debugging & Diagnostics | Advanced |
| 78 | How would you reduce Cumulative Layout Shift on a page that loads ads, images, and web fonts asynchronously? Next.js › Web Vitals & Performance Monitoring | Next.js | Web Vitals & Performance Monitoring | Advanced |
| 79 | What is memory fragmentation in Redis, and how do you detect and address it? Redis › Redis Memory Optimization | Redis | Redis Memory Optimization | Advanced |
| 80 | What are the memory and performance tradeoffs of adding RedisSearch indexes to a large existing dataset in Redis? Redis › RedisSearch (Full Text Search) | Redis | RedisSearch (Full Text Search) | Advanced |
| 81 | How should a team decide between using an ORM like Eloquent or Doctrine versus writing raw SQL queries directly for a specific, particularly complex or performance sensitive part of an application? PHP › Eloquent ORM & Doctrine ORM | PHP | Eloquent ORM & Doctrine ORM | Advanced |
| 82 | What performance considerations arise when working with very large JSON payloads in PHP, and how do streaming JSON parsers help address them? PHP › JSON Handling in PHP | PHP | JSON Handling in PHP | Advanced |
| 83 | What is catastrophic backtracking in regular expressions, and how can a poorly constructed pattern cause a severe performance problem or even hang a PHP application? PHP › Regular Expressions in PHP | PHP | Regular Expressions in PHP | Advanced |
| 84 | How can a custom routing system be designed to support efficient route matching performance even as an application grows to have hundreds or thousands of defined routes? PHP › Routing & Middleware | PHP | Routing & Middleware | Advanced |
| 85 | How can regular string concatenation inside a large loop lead to performance problems, and what alternative approaches help avoid this issue when building up very large strings? PHP › Strings & String Functions | PHP | Strings & String Functions | Advanced |
| 86 | 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 |
| 87 | How can template caching and precompilation in Blade and Twig improve the performance of rendering templates on every incoming request? PHP › Template Engines (Blade & Twig) | PHP | Template Engines (Blade & Twig) | Advanced |
| 88 | What performance and caching considerations become especially important when developing a WordPress plugin that will run on a high traffic website? PHP › WordPress Plugin & Theme Development | PHP | WordPress Plugin & Theme Development | Advanced |
| 89 | What performance considerations become important when using CustomPaint for a complex, frequently redrawn custom drawing, such as a real time data visualization updating many times per second? Flutter › Custom Painters & CustomPaint | Flutter | Custom Painters & CustomPaint | Advanced |
| 90 | What are the performance and memory tradeoffs between using a List, a LinkedHashMap, and a HashSet in Dart when working with a genuinely very large collection of data? Flutter › Dart Collections & Generics | Flutter | Dart Collections & Generics | Advanced |
| 91 | What performance considerations become important when building a screen containing several simultaneous, continuously running animations, and how can Flutter DevTools help identify a genuine animation related performance problem? Flutter › Flutter Animations Basics | Flutter | Flutter Animations Basics | Advanced |
| 92 | What are the practical performance and native platform integration tradeoffs of Flutter desktop compared to a genuinely fully native desktop application built using a platform specific framework like WinUI or native macOS AppKit? Flutter › Flutter for Desktop (Windows, macOS, Linux) | Flutter | Flutter for Desktop (Windows, macOS, Linux) | Advanced |
| 93 | How does Flutter's CanvasKit rendering approach compare to its HTML renderer specifically in terms of actual visual rendering fidelity, overall initial download size, and genuine real world runtime performance for a web app? Flutter › Flutter for Web Development | Flutter | Flutter for Web Development | Advanced |
| 94 | What performance considerations become genuinely important when handling a very high frequency of continuous gesture events, such as a genuinely fast, continuous freehand drawing gesture, without noticeably introducing visible lag or dropped frames? Flutter › Flutter Gestures & Touch Handling | Flutter | Flutter Gestures & Touch Handling | Advanced |
| 95 | What performance considerations become genuinely important when building a genuinely very complex sliver based scrolling screen containing several different sliver types together, such as multiple grids, lists, and persistent headers all combined? Flutter › Flutter Slivers & Custom Scroll Effects | Flutter | Flutter Slivers & Custom Scroll Effects | Advanced |
| 96 | What performance considerations become genuinely important when a Hero animation involves a genuinely very large or complex specific widget, such as a high resolution image or a genuinely complex custom painted graphic? Flutter › Hero Animations & Page Transitions | Flutter | Hero Animations & Page Transitions | Advanced |
| 97 | What are the genuine practical performance tradeoffs of using several separate simpler implicit animations compared to using one single, considerably more complex coordinated explicit animation for a genuinely elaborate combined multi part visual effect? Flutter › Implicit vs Explicit Animations | Flutter | Implicit vs Explicit Animations | Advanced |
| 98 | How do you properly and correctly measure and profile genuine real world performance metrics, such as actual frame rendering time, directly from within an integration test using Flutter's own dedicated performance testing tools? Flutter › Integration Testing in Flutter | Flutter | Integration Testing in Flutter | Advanced |
| 99 | What are the practical performance considerations of parsing a genuinely very large JSON response, and how does moving that particular parsing work onto a genuinely separate isolate help meaningfully avoid causing your app's own visible interface to freeze? Flutter › JSON Serialization & Deserialization | Flutter | JSON Serialization & Deserialization | Advanced |
| 100 | What are the practical performance considerations of reading from SharedPreferences repeatedly throughout your app, and how does properly caching those particular values in memory help meaningfully avoid genuinely unnecessary repeated disk access? Flutter › Local Data Storage with SharedPreferences | Flutter | Local Data Storage with SharedPreferences | Advanced |
| 101 | How should you properly design a platform channel's own specific API to genuinely minimize the total number of separate individual round trips genuinely required between Dart and native code, meaningfully improving overall performance for a genuinely frequently used specific native capability? Flutter › Platform Channels (Native Android & iOS Integration) | Flutter | Platform Channels (Native Android & iOS Integration) | Advanced |
| 102 | What performance considerations become genuinely important when a given widget tree needs to conditionally render genuinely entirely different specific layouts based on screen size, ensuring this exact same conditional logic does not genuinely cause unnecessary, wasteful rebuilds or layout thrashing? Flutter › Responsive & Adaptive UI Design | Flutter | Responsive & Adaptive UI Design | Advanced |
| 103 | How can you properly optimize sqflite query performance for a genuinely large dataset using database indexes, and what genuine tradeoffs come together with actually adding an index to a given specific table? Flutter › SQLite & Local Databases (sqflite) | Flutter | SQLite & Local Databases (sqflite) | Advanced |
| 104 | What is the performance impact of using a cursor compared to a set based operation on a large table, and why does this difference occur? SQL Server › Cursors | SQL Server | Cursors | Intermediate |
| 105 | How do you identify unused or duplicate indexes that might be safely removed to improve write performance? SQL Server › Indexes | SQL Server | Indexes | Intermediate |
| 106 | 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 |
| 107 | How does partition elimination improve query performance for a partitioned table? SQL Server › Partitioning | SQL Server | Partitioning | Intermediate |
| 108 | How do you use Query Store to identify a query whose performance has regressed after a recent code deployment? SQL Server › Query Store | SQL Server | Query Store | Intermediate |
| 109 | How does SQL Server's memory architecture work, particularly regarding the buffer pool and how it affects performance? SQL Server › SQL Server Architecture & Editions | SQL Server | SQL Server Architecture & Editions | Intermediate |
| 110 | What is tempdb, and why is its configuration particularly important for overall SQL Server performance? SQL Server › SQL Server Architecture & Editions | SQL Server | SQL Server Architecture & Editions | Intermediate |
| 111 | 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 |
| 112 | Why can calling a scalar user defined function within a query against a large table cause significant performance problems? SQL Server › User Defined Functions | SQL Server | User Defined Functions | Intermediate |
| 113 | What improvements did SQL Server 2019 introduce for scalar function performance through a feature called scalar UDF inlining? SQL Server › User Defined Functions | SQL Server | User Defined Functions | Intermediate |
| 114 | What is an indexed view, and how can it improve the performance of complex, frequently run queries? SQL Server › Views | SQL Server | Views | Intermediate |
| 115 | How does the BUCKET_COUNT setting affect the performance of a hash index on a memory optimized table? SQL Server › Hash Indexes & Hash Join Operations | SQL Server | Hash Indexes & Hash Join Operations | Intermediate |
| 116 | What specific search engine optimization challenges does a Flutter web app typically face, given that Flutter renders its entire user interface using a canvas based drawing approach rather than genuinely standard semantic HTML? Flutter › Flutter for Web Development | Flutter | Flutter for Web Development | Intermediate |
| 117 | How does the CLR's Dynamic Profile-Guided Optimization (Dynamic PGO) improve JIT-compiled code quality at runtime? .NET › CLR & Runtime | .NET | CLR & Runtime | Advanced |
| 118 | What are the performance and storage considerations to keep in mind before enabling Change Data Capture on a very high volume table? SQL Server › Change Data Capture (CDC) | SQL Server | Change Data Capture (CDC) | Advanced |
| 119 | What are delta stores and rowgroups in the context of columnstore indexes, and how do they affect performance over time? SQL Server › Columnstore Indexes | SQL Server | Columnstore Indexes | Advanced |
| 120 | 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 |
| 121 | What are the performance tradeoffs of using dynamic SQL compared to static, precompiled SQL statements? SQL Server › Dynamic SQL | SQL Server | Dynamic SQL | Advanced |
| 122 | What performance considerations should you keep in mind when using MERGE against very large source and target tables? SQL Server › Merge Statement (Upsert) | SQL Server | Merge Statement (Upsert) | Advanced |
| 123 | What performance considerations should you keep in mind when using PIVOT or UNPIVOT on very large datasets? SQL Server › Pivoting & Unpivoting Data | SQL Server | Pivoting & Unpivoting Data | Advanced |
| 124 | How do you monitor and troubleshoot SQL Server Agent job performance and failures across an entire server with many scheduled jobs? SQL Server › SQL Server Agent & Job Scheduling | SQL Server | SQL Server Agent & Job Scheduling | Advanced |
| 125 | How would you plan a hardware and configuration strategy for a new SQL Server installation supporting a large, performance critical application? SQL Server › SQL Server Architecture & Editions | SQL Server | SQL Server Architecture & Editions | Advanced |
| 126 | What is the performance overhead comparison between SQL Server Profiler, server side traces, and Extended Events, and how should this inform monitoring decisions on a production system? SQL Server › SQL Server Profiler & Extended Events | SQL Server | SQL Server Profiler & Extended Events | Advanced |
| 127 | How does SQL Server compile and cache execution plans for stored procedures, and how does this affect performance compared to ad hoc queries? SQL Server › Stored Procedures & Functions | SQL Server | Stored Procedures & Functions | Advanced |
| 128 | How does tempdb contention affect the performance of applications that heavily rely on temporary tables, and what strategies help mitigate this? SQL Server › Temporary Tables & Table Variables | SQL Server | Temporary Tables & Table Variables | Advanced |
| 129 | What is the performance overhead of Transparent Data Encryption, and how does it compare across different SQL Server versions? SQL Server › Transparent Data Encryption | SQL Server | Transparent Data Encryption | Advanced |
| 130 | What are the performance implications of using triggers heavily on a busy, high transaction volume table? SQL Server › Triggers | SQL Server | Triggers | Advanced |
| 131 | What happens to the performance and correctness of a view if the underlying tables change significantly after the view was originally created? SQL Server › Views | SQL Server | Views | Advanced |
| 132 | How does an XML index improve query performance against large or frequently queried XML columns? SQL Server › XML Data Type & Querying | SQL Server | XML Data Type & Querying | Advanced |
| 133 | What happens when a hash join does not have enough memory available to build its hash table entirely in memory, and how does this affect performance? SQL Server › Hash Indexes & Hash Join Operations | SQL Server | Hash Indexes & Hash Join Operations | Advanced |
| 134 | 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 |
| 135 | What considerations are important when backing up a very large Redis dataset without significantly impacting production performance during the backup process? Redis › Redis Backup & Disaster Recovery | Redis | Redis Backup & Disaster Recovery | Advanced |
| 136 | What are the performance and memory considerations when storing very large or deeply nested JSON documents using RedisJSON? Redis › RedisJSON | Redis | RedisJSON | Advanced |
| 137 | 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 |
| 138 | Compare StackLayout, VerticalStackLayout, and HorizontalStackLayout. .NET MAUI › XAML & UI Layouts | .NET MAUI | XAML & UI Layouts | Beginner |
| 139 | How do you display a scrollable list of items? .NET MAUI › Controls & Views | .NET MAUI | Controls & Views | Beginner |
| 140 | What is the UI thread and why must UI updates happen on it? .NET MAUI › Concurrency & Threading | .NET MAUI | Concurrency & Threading | Beginner |
| 141 | Compare StackLayout, VerticalStackLayout, and HorizontalStackLayout. .NET MAUI › XAML & UI Layouts | .NET MAUI | XAML & UI Layouts | Beginner |
| 142 | How do you display a scrollable list of items? .NET MAUI › Controls & Views | .NET MAUI | Controls & Views | Beginner |
| 143 | What is the UI thread and why must UI updates happen on it? .NET MAUI › Concurrency & Threading | .NET MAUI | Concurrency & Threading | Beginner |
| 144 | What is the difference between fs.readFile() and fs.createReadStream() for reading a file in Node.js? Node.js › File System & File Processing | Node.js | File System & File Processing | Beginner |
| 145 | What key metrics should you monitor to keep track of a Redis instance's overall health? Redis › Redis Monitoring & Observability | Redis | Redis Monitoring & Observability | Beginner |
| 146 | What does asynchronous programming mean in PHP, and why is it different from PHP's traditional synchronous execution model? PHP › Asynchronous PHP (ReactPHP & Swoole) | PHP | Asynchronous PHP (ReactPHP & Swoole) | Beginner |
| 147 | What is the difference between file based caching and in memory caching using tools like Redis or Memcached? PHP › Caching Strategies in PHP | PHP | Caching Strategies in PHP | Beginner |
| 148 | What are the main hosting options available for deploying a PHP application, ranging from shared hosting to cloud based virtual servers? PHP › Deployment & Hosting for PHP Applications | PHP | Deployment & Hosting for PHP Applications | Beginner |
| 149 | What is PHP-FPM, and what role does it play in serving PHP applications through a web server like Nginx? PHP › Deployment & Hosting for PHP Applications | PHP | Deployment & Hosting for PHP Applications | Beginner |
| 150 | How do you read the contents of a file in PHP using functions like file_get_contents and fopen? PHP › File Handling & File System Functions | PHP | File Handling & File System Functions | Beginner |
| 151 | What is a generator in PHP, and how does the yield keyword let a function produce a sequence of values without building an entire array in memory at once? PHP › Generators & Iterators | PHP | Generators & Iterators | Beginner |
| 152 | What is a CustomPainter class, and how does its paint method let you actually issue the specific drawing instructions rendered by a CustomPaint widget? Flutter › Custom Painters & CustomPaint | Flutter | Custom Painters & CustomPaint | Beginner |
| 153 | What is the difference between extracting a piece of widget code into a separate build method within the same class versus extracting it into an entirely separate widget class? Flutter › Custom Widgets & Reusable Components | Flutter | Custom Widgets & Reusable Components | Beginner |
| 154 | What is an isolate in Dart, and how does it fundamentally differ from a traditional operating system thread used for genuine concurrent execution in many other programming languages? Flutter › Flutter Isolates & Multithreading | Flutter | Flutter Isolates & Multithreading | Beginner |
| 155 | What is the main isolate in a Flutter app, and why should genuinely expensive, computationally intensive work generally be avoided from running directly on it? Flutter › Flutter Isolates & Multithreading | Flutter | Flutter Isolates & Multithreading | Beginner |
| 156 | What is a sliver in Flutter, and how does using a CustomScrollView built from several individual slivers let you create a genuinely more complex, custom scrolling effect than a simple regular ListView could achieve on its own? Flutter › Flutter Slivers & Custom Scroll Effects | Flutter | Flutter Slivers & Custom Scroll Effects | Beginner |
| 157 | What is the build method in Flutter, and how frequently does Flutter actually call it to properly determine exactly what should genuinely be displayed on screen at any given specific moment? Flutter › Flutter Widgets Fundamentals (Stateless & Stateful) | Flutter | Flutter Widgets Fundamentals (Stateless & Stateful) | Beginner |
| 158 | How do CollectionView and ListView differ? .NET MAUI › Controls & Views | .NET MAUI | Controls & Views | Intermediate |
| 159 | How do you register and use HttpClient with IHttpClientFactory in MAUI? .NET MAUI › Dependency Injection & Services | .NET MAUI | Dependency Injection & Services | Intermediate |
| 160 | How do you trigger a redraw of a GraphicsView? .NET MAUI › Graphics & Drawing | .NET MAUI | Graphics & Drawing | Intermediate |
| 161 | How do you handle JSON serialization efficiently in MAUI? .NET MAUI › Networking & APIs | .NET MAUI | Networking & APIs | Intermediate |
| 162 | How do you keep API calls off the UI thread and update the UI safely? .NET MAUI › Networking & APIs | .NET MAUI | Networking & APIs | Intermediate |
| 163 | How do you read device sensors like the accelerometer? .NET MAUI › Device Features & Essentials | .NET MAUI | Device Features & Essentials | Intermediate |
| 164 | How do CollectionView and ListView differ? .NET MAUI › Controls & Views | .NET MAUI | Controls & Views | Intermediate |
| 165 | How do you register and use HttpClient with IHttpClientFactory in MAUI? .NET MAUI › Dependency Injection & Services | .NET MAUI | Dependency Injection & Services | Intermediate |
| 166 | How do you trigger a redraw of a GraphicsView? .NET MAUI › Graphics & Drawing | .NET MAUI | Graphics & Drawing | Intermediate |
| 167 | How do you handle JSON serialization efficiently in MAUI? .NET MAUI › Networking & APIs | .NET MAUI | Networking & APIs | Intermediate |
| 168 | How do you keep API calls off the UI thread and update the UI safely? .NET MAUI › Networking & APIs | .NET MAUI | Networking & APIs | Intermediate |
| 169 | How do you read device sensors like the accelerometer? .NET MAUI › Device Features & Essentials | .NET MAUI | Device Features & Essentials | Intermediate |
| 170 | Why does a long synchronous function block UI updates and event handling? JavaScript › Event Loop & Concurrency | JavaScript | Event Loop & Concurrency | Intermediate |
| 171 | What is the difference between the generational garbage collection strategy's 'young' and 'old' generations? JavaScript › Memory Management & Garbage Collection | JavaScript | Memory Management & Garbage Collection | Intermediate |
| 172 | What is the difference between running async operations sequentially with multiple awaits versus concurrently with Promise.all()? Node.js › Async Patterns | Node.js | Async Patterns | Intermediate |
| 173 | What is job concurrency in a worker process, and how do you configure it safely in BullMQ? Node.js › Background Jobs & Queues | Node.js | Background Jobs & Queues | Intermediate |
| 174 | How would you track and expose the progress of a long-running background job to the client that requested it? Node.js › Background Jobs & Queues | Node.js | Background Jobs & Queues | Intermediate |
| 175 | What HTTP caching headers (Cache-Control, ETag) can a Node.js/Express API use to let clients and CDNs cache responses? Node.js › Caching | Node.js | Caching | Intermediate |
| 176 | How would you implement a Least Recently Used (LRU) cache in Node.js, and why is eviction necessary for an in-memory cache? Node.js › Caching | Node.js | Caching | Intermediate |
| 177 | What is memoization, and how does it differ from a general-purpose external cache like Redis? Node.js › Caching | Node.js | Caching | Intermediate |
| 178 | Why does Node.js provide a cluster module, given that a single Node.js process is single-threaded? Node.js › Clustering & Worker Threads | Node.js | Clustering & Worker Threads | Intermediate |
| 179 | What is the difference between the number of CPU cores and the optimal number of cluster workers for a given Node.js application? Node.js › Clustering & Worker Threads | Node.js | Clustering & Worker Threads | Intermediate |
| 180 | How do you gracefully terminate a worker thread, and what's the difference between worker.terminate() and letting it exit naturally? Node.js › Clustering & Worker Threads | Node.js | Clustering & Worker Threads | Intermediate |
| 181 | What does the node:zlib module provide, and how would you use it to compress an HTTP response? Node.js › Core Node.js Modules | Node.js | Core Node.js Modules | Intermediate |
| 182 | What is a database connection pool, and why does a Node.js application need one rather than opening a new connection per request? Node.js › Databases | Node.js | Databases | Intermediate |
| 183 | What is database normalization, and what specific problems can over-normalization or under-normalization cause? Node.js › Databases | Node.js | Databases | Intermediate |
| 184 | What is the N+1 query problem, and how does it commonly arise in a Node.js application using an ORM? Node.js › Databases | Node.js | Databases | Intermediate |
| 185 | What is a multi-stage Docker build, and why is it commonly used for Node.js applications? Node.js › Docker & Deployment | Node.js | Docker & Deployment | Intermediate |
| 186 | What is the purpose of setting explicit CPU and memory resource requests and limits for a Node.js container in Kubernetes? Node.js › Docker & Deployment | Node.js | Docker & Deployment | Intermediate |
| 187 | What does 'non-blocking I/O' mean, and how does a Node.js function like fs.readFile() achieve it compared to fs.readFileSync()? Node.js › Event Loop & Non-blocking IO | Node.js | Event Loop & Non-blocking IO | Intermediate |
| 188 | How does setImmediate() differ from process.nextTick() in terms of timing and typical use cases? Node.js › Event Loop & Non-blocking IO | Node.js | Event Loop & Non-blocking IO | Intermediate |
| 189 | How does the event loop handle a large synchronous loop (like processing a huge array with a for loop), and what problem does this cause? Node.js › Event Loop & Non-blocking IO | Node.js | Event Loop & Non-blocking IO | Intermediate |
| 190 | How would you measure how 'busy' the event loop is in a running Node.js process using a simple technique? Node.js › Event Loop & Non-blocking IO | Node.js | Event Loop & Non-blocking IO | Intermediate |
| 191 | What is the difference between fs.appendFile() and opening a file with the 'a' flag and writing to it manually? Node.js › File System & File Processing | Node.js | File System & File Processing | Intermediate |
| 192 | How would you copy a large file efficiently in Node.js, and what's the difference between fs.copyFile() and manually piping streams? Node.js › File System & File Processing | Node.js | File System & File Processing | Intermediate |
| 193 | What is the difference between npm, Yarn, and pnpm as Node.js package managers, and what specific advantage does pnpm offer regarding disk space? Node.js › Git & Project Management | Node.js | Git & Project Management | Intermediate |
| 194 | What is the difference between HTTP/1.1 and HTTP/2, and how does Node.js support HTTP/2 via the node:http2 module? Node.js › HTTP & Web Servers | Node.js | HTTP & Web Servers | Intermediate |
| 195 | What is the purpose of the Content-Length and Transfer-Encoding: chunked headers, and why can't a response use both simultaneously? Node.js › HTTP & Web Servers | Node.js | HTTP & Web Servers | Intermediate |
| 196 | What Redis data structures beyond simple string values are useful for a Node.js application, and what are they typically used for? Node.js › Caching with Redis | Node.js | Caching with Redis | Intermediate |
| 197 | How would you read a large file efficiently using a stream rather than loading it entirely into memory with fs.readFile()? Node.js › File System (fs) Module | Node.js | File System (fs) Module | Intermediate |
| 198 | What is over-fetching and under-fetching in REST APIs, and how does GraphQL specifically address both? Node.js › GraphQL with Node.js | Node.js | GraphQL with Node.js | Intermediate |
| 199 | What is HTTP keep-alive, and how does Node's http.Agent manage connection reuse for outgoing requests? Node.js › HTTP & HTTPS Modules | Node.js | HTTP & HTTPS Modules | Intermediate |
| 200 | What is the V8 JavaScript engine, and what role does it play within the Node.js runtime? Node.js › Node.js Fundamentals & Runtime Architecture | Node.js | Node.js Fundamentals & Runtime Architecture | Intermediate |
| 201 | How do you search for keys matching a specific pattern in Redis, and why is the KEYS command generally discouraged in production? Redis › Redis CLI & Basic Commands | Redis | Redis CLI & Basic Commands | Intermediate |
| 202 | What is the difference between singleton and transient bindings in a service container, and when should each be used? PHP › Dependency Injection & Service Containers | PHP | Dependency Injection & Service Containers | Intermediate |
| 203 | What role does a reverse proxy like Nginx play in front of a PHP application in a typical production deployment architecture? PHP › Deployment & Hosting for PHP Applications | PHP | Deployment & Hosting for PHP Applications | Intermediate |
| 204 | How does PHP's session garbage collection work, and what settings control how long session data is kept before it is considered expired and eligible for cleanup? PHP › Sessions & Cookies | PHP | Sessions & Cookies | Intermediate |
| 205 | What is XPath, and how does it let you query and extract specific elements from an XML document using a powerful, standardized path based query syntax? PHP › XML Handling in PHP | PHP | XML Handling in PHP | Intermediate |
| 206 | How does properly using the child parameter, rather than a builder function, on a custom reusable widget let Flutter optimize rebuilds by reusing an already built widget subtree? Flutter › Custom Widgets & Reusable Components | Flutter | Custom Widgets & Reusable Components | Intermediate |
| 207 | How does Future.wait let you run several independent asynchronous operations concurrently and wait for all of them to complete together, rather than awaiting each one sequentially one after another? Flutter › Dart Asynchronous Programming (Future & async/await) | Flutter | Dart Asynchronous Programming (Future & async/await) | Intermediate |
| 208 | What is the difference between microtasks and the event queue in Dart's event loop, and how does this affect the precise order in which asynchronous code actually executes? Flutter › Dart Asynchronous Programming (Future & async/await) | Flutter | Dart Asynchronous Programming (Future & async/await) | Intermediate |
| 209 | How do commonly used higher order collection methods, such as map, where, and reduce, let you transform and filter Dart collections in a clean, declarative style? Flutter › Dart Collections & Generics | Flutter | Dart Collections & Generics | Intermediate |
| 210 | What is the difference between registerSingleton, registerLazySingleton, and registerFactory when registering a dependency with GetIt? Flutter › Dependency Injection in Flutter (GetIt & Service Locator) | Flutter | Dependency Injection in Flutter (GetIt & Service Locator) | Intermediate |
| 211 | Why is it valuable to log non fatal, caught errors to a crash reporting service, in addition to only tracking genuine fatal crashes that actually cause the app to fully close? Flutter › Error Handling & Crash Reporting (Sentry & Crashlytics) | Flutter | Error Handling & Crash Reporting (Sentry & Crashlytics) | Intermediate |
| 212 | How does the AnimatedBuilder widget let you efficiently rebuild only the specific part of your widget tree that actually needs to change on every single animation frame, rather than rebuilding an entire larger, unrelated widget subtree unnecessarily? Flutter › Flutter Animations Basics | Flutter | Flutter Animations Basics | Intermediate |
| 213 | How can code obfuscation help protect a Flutter app's actual business logic from being easily reverse engineered by an attacker who obtains a copy of the compiled release build? Flutter › Flutter App Security Best Practices | Flutter | Flutter App Security Best Practices | Intermediate |
| 214 | Why does a scheduled background task registered through workmanager not always execute at exactly its precisely specified interval, and what factors does the underlying operating system actually consider before genuinely allowing that background task to actually run? Flutter › Flutter Background Tasks & WorkManager | Flutter | Flutter Background Tasks & WorkManager | Intermediate |
| 215 | How does the DevTools memory view help you actually detect a genuine memory leak, such as one caused by forgetting to properly dispose of a controller or cancel an active stream subscription? Flutter › Flutter DevTools & Debugging | Flutter | Flutter DevTools & Debugging | Intermediate |
| 216 | How can you properly implement infinite scrolling or pagination within a sliver based scroll view, automatically loading additional new content as a user actively scrolls further down toward the very bottom of the currently loaded list? Flutter › Flutter Slivers & Custom Scroll Effects | Flutter | Flutter Slivers & Custom Scroll Effects | Intermediate |
| 217 | How does calling setState actually genuinely work internally, and why does Flutter genuinely require that you explicitly call it rather than simply automatically detecting a state change entirely on its own? Flutter › Flutter Widgets Fundamentals (Stateless & Stateful) | Flutter | Flutter Widgets Fundamentals (Stateless & Stateful) | Intermediate |
| 218 | How does GraphQL's own built in caching mechanism, typically provided through a normalized cache, genuinely help meaningfully reduce redundant, unnecessary network requests within a Flutter app? Flutter › GraphQL in Flutter | Flutter | GraphQL in Flutter | Intermediate |
| 219 | How can you properly combine a Hero animation together with a custom page transition, ensuring both effects genuinely work correctly together as one single unified, seamless overall screen transition experience? Flutter › Hero Animations & Page Transitions | Flutter | Hero Animations & Page Transitions | Intermediate |
| 220 | How do you properly implement a bottom navigation bar in Flutter, correctly switching between several genuinely separate main top level screens while properly preserving each individual tab's own current specific state? Flutter › Navigation & Routing in Flutter | Flutter | Navigation & Routing in Flutter | Intermediate |
| 221 | 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 |
| 222 | What is the difference between GetX's own GetBuilder and Obx widgets, and when would you genuinely reach for each one respectively for a given particular specific use case? Flutter › State Management with GetX | Flutter | State Management with GetX | Intermediate |
| 223 | What is the difference between context.watch, context.read, and context.select, and how does correctly choosing the genuinely appropriate one help meaningfully avoid unnecessary, wasteful widget rebuilds? Flutter › State Management with Provider | Flutter | State Management with Provider | Intermediate |
| 224 | Explain the measure and arrange layout cycle in MAUI. .NET MAUI › XAML & UI Layouts | .NET MAUI | XAML & UI Layouts | Advanced |
| 225 | What are compiled bindings and why use them? .NET MAUI › Data Binding & MVVM | .NET MAUI | Data Binding & MVVM | Advanced |
| 226 | How do you implement a messaging/event aggregator to decouple view models? .NET MAUI › Dependency Injection & Services | .NET MAUI | Dependency Injection & Services | Advanced |
| 227 | When would you integrate SkiaSharp instead of the built-in Microsoft.Maui.Graphics? .NET MAUI › Graphics & Drawing | .NET MAUI | Graphics & Drawing | Advanced |
| 228 | How do you create custom animations with the Animation class? .NET MAUI › Gestures & Animations | .NET MAUI | Gestures & Animations | Advanced |
| 229 | How do you keep animations smooth and avoid jank? .NET MAUI › Gestures & Animations | .NET MAUI | Gestures & Animations | Advanced |
| 230 | How do you efficiently update large observable collections? .NET MAUI › Advanced Data Binding & Collections | .NET MAUI | Advanced Data Binding & Collections | Advanced |
| 231 | How do compiled XAML (XamlC) and x:DataType improve XAML? .NET MAUI › XAML & Markup Extensions | .NET MAUI | XAML & Markup Extensions | Advanced |
| 232 | Explain the measure and arrange layout cycle in MAUI. .NET MAUI › XAML & UI Layouts | .NET MAUI | XAML & UI Layouts | Advanced |
| 233 | What are compiled bindings and why use them? .NET MAUI › Data Binding & MVVM | .NET MAUI | Data Binding & MVVM | Advanced |
| 234 | How do you implement a messaging/event aggregator to decouple view models? .NET MAUI › Dependency Injection & Services | .NET MAUI | Dependency Injection & Services | Advanced |
| 235 | When would you integrate SkiaSharp instead of the built-in Microsoft.Maui.Graphics? .NET MAUI › Graphics & Drawing | .NET MAUI | Graphics & Drawing | Advanced |
| 236 | How do you create custom animations with the Animation class? .NET MAUI › Gestures & Animations | .NET MAUI | Gestures & Animations | Advanced |
| 237 | How do you keep animations smooth and avoid jank? .NET MAUI › Gestures & Animations | .NET MAUI | Gestures & Animations | Advanced |
| 238 | How do you efficiently update large observable collections? .NET MAUI › Advanced Data Binding & Collections | .NET MAUI | Advanced Data Binding & Collections | Advanced |
| 239 | How do compiled XAML (XamlC) and x:DataType improve XAML? .NET MAUI › XAML & Markup Extensions | .NET MAUI | XAML & Markup Extensions | Advanced |
| 240 | What does the Intersection Observer API do and why is it preferred over scroll event listeners? JavaScript › Browser Storage & Web APIs | JavaScript | Browser Storage & Web APIs | Advanced |
| 241 | How would you break a large synchronous task into chunks to keep the UI responsive? JavaScript › Event Loop & Concurrency | JavaScript | Event Loop & Concurrency | Advanced |
| 242 | What's the relationship between requestAnimationFrame and the event loop's rendering step? JavaScript › Event Loop & Concurrency | JavaScript | Event Loop & Concurrency | Advanced |
| 243 | How do you implement a debounce function using closures, and how is it a functional programming technique? JavaScript › Functional Programming | JavaScript | Functional Programming | Advanced |
| 244 | What is the libuv library, and what specific role does it play inside Node.js? Node.js › Advanced Node.js | Node.js | Advanced Node.js | Advanced |
| 245 | How do you use the --inspect flag and Chrome DevTools to profile a running Node.js application in production? Node.js › Advanced Node.js | Node.js | Advanced Node.js | Advanced |
| 246 | What is V8's hidden class mechanism, and why does it matter for writing performant Node.js code? Node.js › Advanced Node.js | Node.js | Advanced Node.js | Advanced |
| 247 | What is backpressure in Node.js streams, and how do you handle it correctly when piping data? Node.js › Advanced Node.js | Node.js | Advanced Node.js | Advanced |
| 248 | How would you implement a concurrency-limited task queue in Node.js to process many async tasks without overwhelming a downstream resource? Node.js › Async Patterns | Node.js | Async Patterns | Advanced |
| 249 | How do you implement job prioritization in a Node.js queue system, and when is it necessary? Node.js › Background Jobs & Queues | Node.js | Background Jobs & Queues | Advanced |
| 250 | What is cache stampede (thundering herd), and how do you prevent it in a high-traffic Node.js service? Node.js › Caching | Node.js | Caching | Advanced |
| 251 | 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 |
| 252 | What is multi-tier caching (combining an in-memory L1 cache with a distributed L2 cache), and what problem does it solve? Node.js › Caching | Node.js | Caching | Advanced |
| 253 | How would you implement a write-behind (write-back) caching strategy, and what durability risk does it introduce? Node.js › Caching | Node.js | Caching | Advanced |
| 254 | What is auto-scaling, and what metrics commonly trigger scaling decisions for a Node.js service running in the cloud? Node.js › Cloud & DevOps | Node.js | Cloud & DevOps | Advanced |
| 255 | How do you use SharedArrayBuffer to share memory directly between Node.js worker threads, and what are the safety considerations? Node.js › Clustering & Worker Threads | Node.js | Clustering & Worker Threads | Advanced |
| 256 | What is a worker thread pool, and why would you build one rather than creating a new Worker for every task? Node.js › Clustering & Worker Threads | Node.js | Clustering & Worker Threads | Advanced |
| 257 | What does the node:perf_hooks module provide, and how would you use it to measure precise execution time of a code block? Node.js › Core Node.js Modules | Node.js | Core Node.js Modules | Advanced |
| 258 | What is database replication, and how does a Node.js application typically route reads to replicas while sending writes to a primary? Node.js › Databases | Node.js | Databases | Advanced |
| 259 | What is database sharding, and what problem does it solve that replication alone doesn't address? Node.js › Databases | Node.js | Databases | Advanced |
| 260 | What is a database connection leak in a Node.js application, and how does it typically happen when using a connection pool? Node.js › Databases | Node.js | Databases | Advanced |
| 261 | How would you optimize Docker layer caching in a Node.js Dockerfile to speed up repeated builds during development? Node.js › Docker & Deployment | Node.js | Docker & Deployment | Advanced |
| 262 | What is 'event loop lag' (or 'event loop delay'), and how would you monitor it in a production Node.js application? Node.js › Event Loop & Non-blocking IO | Node.js | Event Loop & Non-blocking IO | Advanced |
| 263 | What is the poll phase of the event loop, and under what specific conditions does it block waiting versus move on immediately? Node.js › Event Loop & Non-blocking IO | Node.js | Event Loop & Non-blocking IO | Advanced |
| 264 | How would you implement a request-logging middleware in Express that captures method, path, status code, and response time for every request? Node.js › Express & Middleware | Node.js | Express & Middleware | Advanced |
| 265 | How would you implement conditional middleware in Express that only applies to certain requests based on a runtime condition? Node.js › Express & Middleware | Node.js | Express & Middleware | Advanced |
| 266 | How would you implement a global request timeout middleware in Express to prevent a slow request from hanging indefinitely? Node.js › Express & Middleware | Node.js | Express & Middleware | Advanced |
| 267 | How would you implement a directory-size calculator in Node.js that recursively sums the size of all files within a directory tree? Node.js › File System & File Processing | Node.js | File System & File Processing | Advanced |
| 268 | What is the N+1 query problem in GraphQL specifically, and how does DataLoader solve it? Node.js › GraphQL | Node.js | GraphQL | Advanced |
| 269 | How would you implement query complexity analysis or depth limiting in a GraphQL API to prevent a maliciously deep or expensive query from overwhelming the server? Node.js › GraphQL | Node.js | GraphQL | Advanced |
| 270 | How would you implement HTTP/2 server push in Node.js, and why has server push become less commonly recommended over time? Node.js › HTTP & Web Servers | Node.js | HTTP & Web Servers | Advanced |
| 271 | How would you implement HTTP/2 or HTTP/1.1 connection pooling on the client side in Node.js when making many outgoing requests to the same downstream API? Node.js › HTTP & Web Servers | Node.js | HTTP & Web Servers | Advanced |
| 272 | How would you implement HTTP response streaming in Node.js to begin sending data to a client before the entire response is ready, such as for a large report? Node.js › HTTP & Web Servers | Node.js | HTTP & Web Servers | Advanced |
| 273 | What is the N+1 query problem in the context of an ORM like Mongoose or Sequelize, and how do you avoid it? Node.js › Databases & ORMs (MongoDB/Mongoose, SQL/Sequelize) | Node.js | Databases & ORMs (MongoDB/Mongoose, SQL/Sequelize) | Advanced |
| 274 | What does PM2's built-in monitoring dashboard (pm2 monit, or PM2 Plus) show, and what metrics are most useful for production operations? Node.js › Deployment & Process Managers (PM2) | Node.js | Deployment & Process Managers (PM2) | Advanced |
| 275 | What are Node.js file descriptor limits, and how might a Node.js application unintentionally exhaust them? Node.js › File System (fs) Module | Node.js | File System (fs) Module | Advanced |
| 276 | What is the N+1 query problem specific to GraphQL, and how does DataLoader solve it? Node.js › GraphQL with Node.js | Node.js | GraphQL with Node.js | Advanced |
| 277 | How would you implement HTTP/2 server push or basic HTTP/2 support in Node.js using the node:http2 module? Node.js › HTTP & HTTPS Modules | Node.js | HTTP & HTTPS Modules | Advanced |
| 278 | What strategies can reduce bundle size beyond basic code splitting? Next.js › Bundle Analysis & Code Splitting | Next.js | Bundle Analysis & Code Splitting | Advanced |
| 279 | What are best practices for managing a large number of redirects on a website that has gone through multiple redesigns over the years? Next.js › Redirects & Rewrites Configuration | Next.js | Redirects & Rewrites Configuration | Advanced |
| 280 | How does PHP handle array copying behavior, and when do arrays actually get passed by reference instead of by value? PHP › Arrays in PHP | PHP | Arrays in PHP | Advanced |
| 281 | What common pitfalls should developers be aware of when writing asynchronous PHP code with Swoole, particularly around shared state and blocking calls? PHP › Asynchronous PHP (ReactPHP & Swoole) | PHP | Asynchronous PHP (ReactPHP & Swoole) | Advanced |
| 282 | How does the cache stampede problem occur, and what strategies help prevent it in a high traffic PHP application? PHP › Caching Strategies in PHP | PHP | Caching Strategies in PHP | Advanced |
| 283 | How should a team design a comprehensive multi layer caching strategy for a high traffic PHP application, combining OPcache, application level caching, and a CDN? PHP › Caching Strategies in PHP | PHP | Caching Strategies in PHP | Advanced |
| 284 | How do generators help implement memory efficient data processing pipelines, chaining multiple transformation steps together without ever loading an entire dataset into memory at once? PHP › Generators & Iterators | PHP | Generators & Iterators | Advanced |
| 285 | How does Composer generate and optimize its autoloader for production, and what is the difference between the development autoloader and an optimized production autoloader? PHP › Namespaces & Autoloading | PHP | Namespaces & Autoloading | Advanced |
| 286 | How does connection pooling and persistent connections work with PDO, and what tradeoffs should be considered before enabling persistent connections? PHP › PDO & Databases | PHP | PDO & Databases | Advanced |
| 287 | What memory management considerations apply specifically to long running PHP CLI scripts, such as queue workers, that might process thousands of jobs without ever restarting? PHP › PHP CLI Scripting | PHP | PHP CLI Scripting | Advanced |
| 288 | How does running PHP within Docker containers in a production Kubernetes environment introduce additional considerations around health checks, resource limits, and horizontal scaling? PHP › PHP with Docker | PHP | PHP with Docker | Advanced |
| 289 | How does middleware priority and ordering affect application behavior when multiple middleware, such as authentication and rate limiting, are applied to the same route together? PHP › Routing & Middleware | PHP | Routing & Middleware | Advanced |
| 290 | What are the tradeoffs of using a heavier server side template engine like Blade or Twig compared to building a fully client side rendered frontend using a JavaScript framework consuming a PHP API? PHP › Template Engines (Blade & Twig) | PHP | Template Engines (Blade & Twig) | Advanced |
| 291 | How can you efficiently parse an extremely large XML file that would be too large to comfortably load entirely into memory at once, using a streaming based approach like XMLReader? PHP › XML Handling in PHP | PHP | XML Handling in PHP | Advanced |
| 292 | What strategies help manage memory usage effectively when a Flutter app needs to display many images at once, such as within a large scrolling photo gallery? Flutter › Camera & Media Handling in Flutter | Flutter | Camera & Media Handling in Flutter | Advanced |
| 293 | How can heavy image processing tasks, such as applying a filter or resizing a very large image, be moved off the main UI thread using isolates to avoid causing the app's interface to freeze or stutter? Flutter › Camera & Media Handling in Flutter | Flutter | Camera & Media Handling in Flutter | Advanced |
| 294 | How can build caching within a CI/CD pipeline significantly reduce the total time needed to complete each individual pipeline run for a Flutter project? Flutter › CI/CD Pipelines for Flutter Apps | Flutter | CI/CD Pipelines for Flutter Apps | Advanced |
| 295 | What strategies help minimize Firestore read and write costs in a high traffic Flutter application, given that Firestore's pricing is directly based on the actual number of document operations performed? Flutter › Cloud Firestore & Firebase Storage | Flutter | Cloud Firestore & Firebase Storage | Advanced |
| 296 | How can clipping and layering multiple CustomPaint widgets together help achieve more visually complex custom graphics, such as a custom chart with several distinct visual layers? Flutter › Custom Painters & CustomPaint | Flutter | Custom Painters & CustomPaint | Advanced |
| 297 | How can improper use of unawaited Futures introduce subtle bugs, such as a race condition or an unhandled error, into a Flutter application, and how does the unawaited function help make this deliberate choice explicit? Flutter › Dart Asynchronous Programming (Future & async/await) | Flutter | Dart Asynchronous Programming (Future & async/await) | Advanced |
| 298 | What are common StreamTransformer patterns, such as debounce and throttle, and how do they help control the actual rate at which a stream's events are processed, particularly for something like a rapidly typed search query? Flutter › Dart Streams & StreamControllers | Flutter | Dart Streams & StreamControllers | Advanced |
| 299 | What strategies help ensure a background task genuinely completes reliably and efficiently, particularly when the specific work involved, such as uploading several large files, could potentially take considerably longer than the platform's own available background execution time actually permits? Flutter › Flutter Background Tasks & WorkManager | Flutter | Flutter Background Tasks & WorkManager | Advanced |
| 300 | How can you use the DevTools widget rebuild profiler and the Flutter Inspector's own select widget mode together to actually diagnose a specific widget that is genuinely rebuilding far more frequently than it actually genuinely needs to? Flutter › Flutter DevTools & Debugging | Flutter | Flutter DevTools & Debugging | Advanced |
| 301 | How can you properly implement a genuinely custom gesture recognizer in Flutter when none of the existing built in gesture recognizers, such as tap, drag, or scale, actually adequately capture the exact very specific interaction pattern your particular app genuinely needs? Flutter › Flutter Gestures & Touch Handling | Flutter | Flutter Gestures & Touch Handling | Advanced |
| 302 | How does Dart's newer Isolate.run API simplify the process of running a specific one off computation on a separate isolate compared to the older, considerably more manual Isolate.spawn combined with ReceivePort approach? Flutter › Flutter Isolates & Multithreading | Flutter | Flutter Isolates & Multithreading | Advanced |
| 303 | What are isolate groups and Dart's newer experimental shared memory capabilities, and how might these genuinely eventually reduce the current overhead of passing genuinely very large amounts of data between two separate isolates? Flutter › Flutter Isolates & Multithreading | Flutter | Flutter Isolates & Multithreading | Advanced |
| 304 | How does Riverpod's autoDispose modifier genuinely help properly manage a provider's own specific lifecycle, automatically disposing of its underlying state once it is genuinely no longer actually being actively used or watched by anyone? Flutter › Flutter Riverpod Code Generation & Providers | Flutter | Flutter Riverpod Code Generation & Providers | Advanced |
| 305 | How do you properly build a genuinely fully custom sliver by directly extending RenderSliver, for a genuinely very specific custom scroll effect not already covered by any of Flutter's own existing built in sliver widgets? Flutter › Flutter Slivers & Custom Scroll Effects | Flutter | Flutter Slivers & Custom Scroll Effects | Advanced |
| 306 | How does Flutter's own element diffing algorithm actually efficiently determine exactly which specific parts of the widget tree genuinely need to be rebuilt after setState is actually called, avoiding needlessly rebuilding the entire tree completely from scratch every single time? Flutter › Flutter Widget Tree, Element Tree & BuildContext | Flutter | Flutter Widget Tree, Element Tree & BuildContext | Advanced |
| 307 | How can you properly and correctly implement the AutomaticKeepAliveClientMixin on a specific StatefulWidget to genuinely preserve its own current internal state even when it visually genuinely scrolls entirely off screen within a lazily built list such as one built using ListView.builder? Flutter › Flutter Widgets Fundamentals (Stateless & Stateful) | Flutter | Flutter Widgets Fundamentals (Stateless & Stateful) | Advanced |
| 308 | How can you properly implement request deduplication to prevent several genuinely separate identical simultaneous requests for exactly the same particular data from all actually and wastefully hitting your backend server together at once? Flutter › REST API Integration in Flutter | Flutter | REST API Integration in Flutter | Advanced |
| 309 | How should you properly structure a genuinely large app's own overall Provider architecture, deciding exactly where within the widget tree each individual specific provider should genuinely be scoped and properly placed? Flutter › State Management with Provider | Flutter | State Management with Provider | Advanced |