All fields

“Error Handling” in Information Technology

287 questions across 16 technologies.

Information Technology

287 questions in 16 technologies

#QuestionTechnologyTopicLevel
1How do you distinguish between transient errors (worth retrying) and permanent errors (should fail immediately) when designing error handling for calls to external dependencies? ASP.NET Core › Error HandlingASP.NET CoreError HandlingIntermediate
2How would you implement error handling for a GraphQL API in Node.js, given GraphQL's different error-response format compared to REST? Node.js › Error HandlingNode.jsError HandlingAdvanced
3Why is proper error handling important in a Flutter app, and what happens by default if an unhandled exception occurs somewhere within a running app? Flutter › Error Handling & Crash Reporting (Sentry & Crashlytics)FlutterError Handling & Crash Reporting (Sentry & Crashlytics)Beginner
4How do you properly set up Flutter's global error handling using FlutterError.onError and PlatformDispatcher.instance.onError to automatically capture every uncaught error and forward it to a crash reporting service? Flutter › Error Handling & Crash Reporting (Sentry & Crashlytics)FlutterError Handling & Crash Reporting (Sentry & Crashlytics)Intermediate
5How would you set up a comprehensive error handling strategy across a large Next.js application with many route segments? Next.js › Error Handling & Not Found PagesNext.jsError Handling & Not Found PagesAdvanced
6What role does the [ApiController] attribute play in automatically handling certain error scenarios without explicit exception handling code? ASP.NET Core › Error HandlingASP.NET CoreError HandlingIntermediate
7How does exception handling middleware interact with model validation errors, and why do they typically produce two entirely separate error response paths? ASP.NET Core › Error HandlingASP.NET CoreError HandlingAdvanced
8How would you design exception handling to support internationalized (localized) error messages returned to different clients in their preferred language? ASP.NET Core › Error HandlingASP.NET CoreError HandlingAdvanced
9What is a centralized error-handling middleware pattern in Express, and what advantages does it provide over handling errors in each individual route? Node.js › Error HandlingNode.jsError HandlingAdvanced
10What is the difference between a 4xx and 5xx HTTP status code from an error-handling perspective, and how should a Node.js API decide which to return? Node.js › Error HandlingNode.jsError HandlingAdvanced
11What happens by default in ASP.NET Core if you don't configure any global exception handling middleware at all? ASP.NET Core › Error HandlingASP.NET CoreError HandlingIntermediate
12How would you write an integration test verifying that your global exception handler produces the correct error response shape for a specific exception type? ASP.NET Core › Error HandlingASP.NET CoreError HandlingAdvanced
13What's the difference between a built-in Error and throwing a plain string or object? JavaScript › Error HandlingJavaScriptError HandlingBeginner
14What is the purpose of global exception handling middleware in an ASP.NET Core application? ASP.NET Core › Error HandlingASP.NET CoreError HandlingBeginner
15What is the difference between operational errors and programmer errors in Node.js, and why does this distinction matter? Node.js › Error HandlingNode.jsError HandlingBeginner
16What is the difference between throwing an error synchronously and calling a callback with an error as its first argument in Node.js? Node.js › Error HandlingNode.jsError HandlingBeginner
17How do you create a custom error class? JavaScript › Error HandlingJavaScriptError HandlingIntermediate
18How do you catch errors from a Promise chain versus async/await? JavaScript › Error HandlingJavaScriptError HandlingIntermediate
19What is error propagation, and how does an uncaught error in a nested function behave? JavaScript › Error HandlingJavaScriptError HandlingIntermediate
20How would you create and use custom Error subclasses in a Node.js application to represent different categories of application-specific errors? Node.js › Error HandlingNode.jsError HandlingIntermediate
21Why doesn't Express automatically catch errors thrown inside an async route handler in versions prior to Express 5, and how do you work around this? Node.js › Error HandlingNode.jsError HandlingIntermediate
22How do you correctly propagate and handle errors from a Node.js stream, given that stream errors aren't caught by a surrounding try/catch? Node.js › Error HandlingNode.jsError HandlingIntermediate
23What is the risk of exposing a raw error's stack trace in an API response, and how do you prevent it while still logging full details server-side? Node.js › Error HandlingNode.jsError HandlingIntermediate
24What is the difference between a validation error and a business-logic error, and how might a Node.js application handle each differently? Node.js › Error HandlingNode.jsError HandlingIntermediate
25What is the Error cause option and what problem does it solve? JavaScript › Error HandlingJavaScriptError HandlingAdvanced
26How do global error handlers like window.onerror and unhandledrejection work? JavaScript › Error HandlingJavaScriptError HandlingAdvanced
27Why can errors thrown inside a setTimeout callback NOT be caught by a surrounding try/catch? JavaScript › Error HandlingJavaScriptError HandlingAdvanced
28What is ProblemDetails (RFC 7807/9457), and how does ASP.NET Core support it for standardized error responses across an API? ASP.NET Core › Error HandlingASP.NET CoreError HandlingAdvanced
29What information should be excluded from error responses in production to avoid leaking sensitive implementation details? ASP.NET Core › Error HandlingASP.NET CoreError HandlingAdvanced
30What is error wrapping (or error chaining), and how does the Error class's 'cause' property support it in modern Node.js? Node.js › Error HandlingNode.jsError HandlingAdvanced
31How would you implement a global error boundary for an entire Node.js application to ensure no error type goes completely unhandled? Node.js › Error HandlingNode.jsError HandlingAdvanced
32How would you implement automatic error reporting to a service like Sentry in a Node.js application, and what data should be scrubbed before sending? Node.js › Error HandlingNode.jsError HandlingAdvanced
33How do you configure PDO's error handling mode to ensure database errors are properly reported as catchable exceptions rather than silently failing? PHP › PDO & DatabasesPHPPDO & DatabasesIntermediate
34How would you design a stored procedure to handle a complex business process involving multiple steps, proper error handling, and transaction management together? SQL Server › Stored Procedures & FunctionsSQL ServerStored Procedures & FunctionsAdvanced
35How would you write a T-SQL script that combines variables, control flow, and error handling together to perform a robust, multi step administrative task? SQL Server › T-SQL Fundamentals & SyntaxSQL ServerT-SQL Fundamentals & SyntaxAdvanced
36How does the IExceptionHandler interface (introduced in .NET 8) provide a more structured alternative to the UseExceptionHandler lambda approach? ASP.NET Core › Error HandlingASP.NET CoreError HandlingIntermediate
37How do you map different custom exception types to different HTTP status codes in a global exception handler? ASP.NET Core › Error HandlingASP.NET CoreError HandlingIntermediate
38How should a global exception handler differentiate between exceptions meant for client-facing details versus exceptions that should always show a generic message? ASP.NET Core › Error HandlingASP.NET CoreError HandlingIntermediate
39How does a try/catch block work? JavaScript › Error HandlingJavaScriptError HandlingBeginner
40What does the finally block do? JavaScript › Error HandlingJavaScriptError HandlingBeginner
41What is Dio, and what genuinely additional features does it provide beyond the more basic http package, such as built in interceptors and considerably more convenient error handling? Flutter › Networking with HTTP & DioFlutterNetworking with HTTP & DioBeginner
42How do you handle exceptions specifically within minimal API endpoints, given they don't use the traditional MVC exception filter pipeline? ASP.NET Core › Error HandlingASP.NET CoreError HandlingIntermediate
43What is the try/catch/finally pattern's 'finally' block used for, and how does it behave with async/await? Node.js › Error HandlingNode.jsError HandlingIntermediate
44How would you implement a global 'not found' (404) handler in Express for any route that doesn't match a defined endpoint? Node.js › Error HandlingNode.jsError HandlingIntermediate
45How does Step Functions handle error handling and automatic retries for failed steps within a workflow? AWS › AWS Step FunctionsAWSAWS Step FunctionsIntermediate
46How do you implement a retry-with-backoff pattern around a function that might throw? JavaScript › Error HandlingJavaScriptError HandlingAdvanced
47How do you write a generic Result<T, E> discriminated union type for functional-style error handling, and why is it preferred over throwing exceptions in some codebases? TypeScript › Discriminated Unions & Exhaustiveness CheckingTypeScriptDiscriminated Unions & Exhaustiveness CheckingAdvanced
48How do you handle exceptions that occur during response streaming, after the response has already partially started sending to the client? ASP.NET Core › Error HandlingASP.NET CoreError HandlingAdvanced
49How would you implement a circuit breaker pattern to prevent cascading failures when a downstream dependency is consistently failing? ASP.NET Core › Error HandlingASP.NET CoreError HandlingAdvanced
50How should an organization approach designing observability and error handling for a complex, multi function serverless architecture built on Lambda? AWS › Lambda & ServerlessAWSLambda & ServerlessAdvanced
51What is exception chaining in PHP, and how does the previous exception parameter help preserve the original context when re throwing an error? PHP › Error & Exception HandlingPHPError & Exception HandlingIntermediate
52How do you create a custom error page for a specific route segment in the App Router? Next.js › Error Handling & Not Found PagesNext.jsError Handling & Not Found PagesBeginner
53What error information functions are available inside a CATCH block to help you understand what went wrong? SQL Server › Error Handling with TRY CATCHSQL ServerError Handling with TRY CATCHBeginner
54What is the difference between a PHP error and a PHP exception? PHP › Error & Exception HandlingPHPError & Exception HandlingBeginner
55How does the global-error.js file differ from a regular error.js file in the App Router? Next.js › Error Handling & Not Found PagesNext.jsError Handling & Not Found PagesIntermediate
56How do you combine a TRY CATCH block with a transaction to ensure the database is properly rolled back if an error occurs partway through? SQL Server › Error Handling with TRY CATCHSQL ServerError Handling with TRY CATCHIntermediate
57What is the difference between using THROW and RAISERROR to raise a custom error in SQL Server? SQL Server › Error Handling with TRY CATCHSQL ServerError Handling with TRY CATCHIntermediate
58What types of errors cannot be caught by a TRY CATCH block in SQL Server? SQL Server › Error Handling with TRY CATCHSQL ServerError Handling with TRY CATCHIntermediate
59What is Sentry, and how does it compare to Firebase Crashlytics in terms of the additional contextual information and features it provides for diagnosing an error? Flutter › Error Handling & Crash Reporting (Sentry & Crashlytics)FlutterError Handling & Crash Reporting (Sentry & Crashlytics)Intermediate
60Why 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)FlutterError Handling & Crash Reporting (Sentry & Crashlytics)Intermediate
61How would you build a centralized, reusable error logging procedure that captures detailed error information whenever it is called from within a CATCH block? SQL Server › Error Handling with TRY CATCHSQL ServerError Handling with TRY CATCHAdvanced
62How do you set a global exception handler and error handler in PHP to consistently catch and log any uncaught exceptions or errors across an entire application? PHP › Error & Exception HandlingPHPError & Exception HandlingAdvanced
63What is the role of the [ApiController] attribute in automatically handling certain error scenarios without explicit exception handling code? .NET › Global Exception Handling & Middleware.NETGlobal Exception Handling & MiddlewareIntermediate
64How would you design a robust global exception handling middleware in ASP.NET Core to convert unhandled exceptions into consistent API error responses? C# › Exception HandlingC#Exception HandlingAdvanced
65How does exception handling middleware interact with model validation errors in ASP.NET Core, and how do they typically produce different error response paths? .NET › Global Exception Handling & Middleware.NETGlobal Exception Handling & MiddlewareAdvanced
66How would you design exception handling middleware to support internationalized (localized) error messages returned to clients in different languages? .NET › Global Exception Handling & Middleware.NETGlobal Exception Handling & MiddlewareAdvanced
67How does a try catch block work in PHP, and how do you catch and handle a specific exception that might be thrown? PHP › Error & Exception HandlingPHPError & Exception HandlingBeginner
68Why does React not catch errors that happen inside event handlers, like an onClick function, using error boundaries? React › Error BoundariesReactError BoundariesIntermediate
69How does the finally block work alongside try and catch, and what are appropriate use cases for it? PHP › Error & Exception HandlingPHPError & Exception HandlingIntermediate
70How do you properly handle errors when parsing potentially invalid JSON, and how does the JSON_THROW_ON_ERROR flag simplify this compared to manually checking json_last_error? PHP › JSON Handling in PHPPHPJSON Handling in PHPIntermediate
71How do you create a custom 404 not found page in Next.js? Next.js › Error Handling & Not Found PagesNext.jsError Handling & Not Found PagesBeginner
72How does a TRY CATCH block work in SQL Server, and why is it useful? SQL Server › Error Handling with TRY CATCHSQL ServerError Handling with TRY CATCHBeginner
73What is Firebase Crashlytics, and how does it automatically capture and report crashes that occur in your app once it is actually running on real users' devices? Flutter › Error Handling & Crash Reporting (Sentry & Crashlytics)FlutterError Handling & Crash Reporting (Sentry & Crashlytics)Beginner
74How do you write an integration test verifying that your global exception handler produces the correct error response shape? .NET › Global Exception Handling & Middleware.NETGlobal Exception Handling & MiddlewareIntermediate
75How would you manually trigger a not found response when a specific piece of data, like a product, does not exist? Next.js › Error Handling & Not Found PagesNext.jsError Handling & Not Found PagesIntermediate
76How do you create and throw a custom exception class in PHP, and why would you define your own exception types instead of using PHP's built in generic Exception class? PHP › Error & Exception HandlingPHPError & Exception HandlingIntermediate
77How do nested TRY CATCH blocks work, and when would you use them in a complex stored procedure? SQL Server › Error Handling with TRY CATCHSQL ServerError Handling with TRY CATCHAdvanced
78What best practices should guide how an application logs, reports, and responds to exceptions differently across development and production environments? PHP › Error & Exception HandlingPHPError & Exception HandlingAdvanced
79How can custom keys, breadcrumbs, and user context attached to a crash report help a development team dramatically speed up diagnosing and reproducing a genuinely difficult, hard to reproduce production issue? Flutter › Error Handling & Crash Reporting (Sentry & Crashlytics)FlutterError Handling & Crash Reporting (Sentry & Crashlytics)Advanced
80How should a team establish an alerting and triage process around crash reporting data, ensuring that a sudden meaningful spike in a specific crash's frequency is actually noticed and addressed quickly after a new release? Flutter › Error Handling & Crash Reporting (Sentry & Crashlytics)FlutterError Handling & Crash Reporting (Sentry & Crashlytics)Advanced
81How 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.jsNext.jsForm Handling & Validation in Next.jsIntermediate
82How would you design a custom exception HIERARCHY for an application, and why does this matter for how callers can catch errors at different granularities? Python › Exception HandlingPythonException HandlingAdvanced
83What is ProblemDetails (RFC 7807/9457), and how does ASP.NET Core support it for standardized error responses? .NET › Global Exception Handling & Middleware.NETGlobal Exception Handling & MiddlewareAdvanced
84What information should be excluded from error responses in production to avoid leaking sensitive implementation details? .NET › Global Exception Handling & Middleware.NETGlobal Exception Handling & MiddlewareAdvanced
85How do you convert a JSON formatted string back into a PHP array or object using json_decode? PHP › JSON Handling in PHPPHPJSON Handling in PHPBeginner
86How do you properly request and handle runtime camera and photo library permissions in a Flutter app, and what happens if a user denies that permission? Flutter › Camera & Media Handling in FlutterFlutterCamera & Media Handling in FlutterIntermediate
87Why does fetch() NOT reject its Promise for HTTP error responses like 404 or 500? JavaScript › Networking: Fetch, XHR, WebSockets & CORSJavaScriptNetworking: Fetch, XHR, WebSockets & CORSIntermediate
88How does exception handling work differently for Blazor components compared to a typical MVC controller action or minimal API endpoint? ASP.NET Core › Blazor Integration with ASP.NET CoreASP.NET CoreBlazor Integration with ASP.NET CoreIntermediate
89How do you handle and propagate errors in gRPC, given it doesn't use standard HTTP status codes the way REST does? ASP.NET Core › gRPC ServicesASP.NET CoregRPC ServicesIntermediate
90What happens when an EventEmitter emits an event that has an 'error' listener versus one that doesn't? Node.js › Events & EventEmitterNode.jsEvents & EventEmitterIntermediate
91How would you validate a form in React and show an error message to the user? React › Forms: Controlled & Uncontrolled ComponentsReactForms: Controlled & Uncontrolled ComponentsIntermediate
92How would you handle errors from an HTTP request in Angular, showing a friendly message to the user? Angular › HTTP Client & InterceptorsAngularHTTP Client & InterceptorsIntermediate
93What causes a hydration mismatch error, and how can you fix one? Next.js › Client Components & HydrationNext.jsClient Components & HydrationIntermediate
94What error does an application receive when its transaction is chosen as a deadlock victim, and how should the application respond? SQL Server › DeadlocksSQL ServerDeadlocksIntermediate
95How do you properly handle errors that occur during an asynchronous operation using a try catch block combined with async and await? Flutter › Dart Asynchronous Programming (Future & async/await)FlutterDart Asynchronous Programming (Future & async/await)Intermediate
96How should a form properly and clearly handle and display a genuine server side validation error, such as discovering that a specific chosen username is already actually taken, that genuinely cannot actually be determined purely through simple client side validation logic alone? Flutter › Forms & Input Validation in FlutterFlutterForms & Input Validation in FlutterIntermediate
97How do Dio interceptors let you centrally add a shared authentication header to every single outgoing request, or centrally handle a genuine expired token error consistently across your entire app? Flutter › Networking with HTTP & DioFlutterNetworking with HTTP & DioIntermediate
98How should you properly handle a genuine network timeout and other common network errors, such as no internet connectivity, when making a request using either the http or Dio packages? Flutter › Networking with HTTP & DioFlutterNetworking with HTTP & DioIntermediate
99How should you properly and correctly handle an error that genuinely occurs on the native side of a platform channel, and how does that particular error actually get properly reported back to your own Dart code? Flutter › Platform Channels (Native Android & iOS Integration)FlutterPlatform Channels (Native Android & iOS Integration)Intermediate
100How 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)FlutterSQLite & Local Databases (sqflite)Intermediate
101Why is manually working with time zones using the Date object error-prone? JavaScript › Date, Time & Internationalization (Intl API)JavaScriptDate, Time & Internationalization (Intl API)Advanced
102Why does JSON.stringify() throw a TypeError on objects with circular references, and how do you handle it? JavaScript › JSON & Data SerializationJavaScriptJSON & Data SerializationAdvanced
103How would you configure an API to return Problem Details (RFC 7807) formatted error responses consistently across all content types, not just JSON? ASP.NET Core › Content Negotiation & Output FormattersASP.NET CoreContent Negotiation & Output FormattersAdvanced
104How would you diagnose and resolve a scenario where an application works correctly when run directly with Kestrel locally but returns 502 Bad Gateway errors when deployed behind IIS or nginx in production? ASP.NET Core › Hosting Models: Kestrel, IIS & Reverse ProxiesASP.NET CoreHosting Models: Kestrel, IIS & Reverse ProxiesAdvanced
105How does the useFormState hook, sometimes called useActionState, let you show validation errors returned from a server action? React › Server Actions & Data MutationsReactServer Actions & Data MutationsAdvanced
106How would you handle errors gracefully inside a server action and display a meaningful message to the user? Next.js › Server Actions & MutationsNext.jsServer Actions & MutationsAdvanced
107How 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)FlutterDart Asynchronous Programming (Future & async/await)Advanced
108How should you properly design your app's own networking layer to genuinely support parallel loading of several genuinely independent pieces of data needed for a single given screen, while still properly and gracefully handling the case where just one of those particular requests genuinely happens to fail? Flutter › REST API Integration in FlutterFlutterREST API Integration in FlutterAdvanced
109How do you check for and handle stream errors? C++ › I/O StreamsC++I/O StreamsBeginner
110How do you safely retrieve values from superglobals like $_GET or $_POST to avoid undefined index errors and potential security issues? PHP › Constants & SuperglobalsPHPConstants & SuperglobalsIntermediate
111How do you write a custom 'type=' validation function for argparse that raises a properly-formatted error for invalid input? Python › Command-Line Interfaces (argparse)PythonCommand-Line Interfaces (argparse)Advanced
112How do you correctly cancel a running asyncio task, and how should the task itself handle the resulting CancelledError? Python › Concurrency (asyncio/threading/multiprocessing)PythonConcurrency (asyncio/threading/multiprocessing)Advanced
113How does @property's read-only behavior (no setter defined) actually raise an AttributeError, and how would you customize that error message? Python › Descriptors & PropertiesPythonDescriptors & PropertiesAdvanced
114How does logger.exception() differ from logger.error(), and when should you use it? Python › LoggingPythonLoggingAdvanced
115How does gRPC handle errors and status codes, and how does this differ from HTTP status codes in REST? .NET › gRPC Services.NETgRPC ServicesAdvanced
116How should a RESTful API be designed to handle complex error responses consistently, including validation errors affecting multiple fields at once? PHP › RESTful API Development with PHPPHPRESTful API Development with PHPAdvanced
117Why is Date.parse() considered unreliable for parsing date strings? JavaScript › Date, Time & Internationalization (Intl API)JavaScriptDate, Time & Internationalization (Intl API)Beginner
118How do you pause code execution at a specific line using the browser DevTools? JavaScript › Debugging, Testing & ToolingJavaScriptDebugging, Testing & ToolingBeginner
119What is the call stack? JavaScript › Event Loop & ConcurrencyJavaScriptEvent Loop & ConcurrencyBeginner
120What is a pure function? JavaScript › Functional ProgrammingJavaScriptFunctional ProgrammingBeginner
121How do you convert a JSON string back into a JavaScript object? JavaScript › JSON & Data SerializationJavaScriptJSON & Data SerializationBeginner
122What does Number.isInteger() check, and how is it different from typeof? JavaScript › Numbers, Math & BigIntJavaScriptNumbers, Math & BigIntBeginner
123What HTTP status code should an API return when it cannot produce a response in any format the client's Accept header requests? ASP.NET Core › Content Negotiation & Output FormattersASP.NET CoreContent Negotiation & Output FormattersBeginner
124What HTTP status code and response should be returned when an upload fails validation (wrong type, too large, missing file)? ASP.NET Core › File Uploads & Streaming Large FilesASP.NET CoreFile Uploads & Streaming Large FilesBeginner
125What HTTP status code does the health check middleware return by default for each status (Healthy, Degraded, Unhealthy)? ASP.NET Core › Health ChecksASP.NET CoreHealth ChecksBeginner
126What is the difference between checked and unchecked exceptions in Java, and how does the compiler treat each differently? Java › ExceptionsJavaExceptionsBeginner
127What is the basic syntax and control flow of a try-catch-finally block, and what determines which catch block (if multiple exist) handles a thrown exception? Java › ExceptionsJavaExceptionsBeginner
128What is a callback function in Node.js, and what is 'callback hell'? Node.js › Async PatternsNode.jsAsync PatternsBeginner
129What is a Promise in JavaScript, and what are its three possible states? Node.js › Async PatternsNode.jsAsync PatternsBeginner
130How do you connect a Node.js application to Redis using the official node-redis client? Node.js › Caching with RedisNode.jsCaching with RedisBeginner
131What is cross site scripting, often called XSS, and how does React protect against it by default? React › Security in React (XSS & dangerouslySetInnerHTML)ReactSecurity in React (XSS & dangerouslySetInnerHTML)Beginner
132Why is it risky to build a link's web address directly from user input without checking it first? React › Security in React (XSS & dangerouslySetInnerHTML)ReactSecurity in React (XSS & dangerouslySetInnerHTML)Beginner
133What are the main types of tests you would write for a Next.js application? Next.js › Testing Next.js ApplicationsNext.jsTesting Next.js ApplicationsBeginner
134What is dynamic SQL, and why would you need to build and execute a SQL statement as a string rather than writing it directly? SQL Server › Dynamic SQLSQL ServerDynamic SQLBeginner
135What is a transaction in SQL Server, and why is grouping multiple statements into one important? SQL Server › Transactions & ACIDSQL ServerTransactions & ACIDBeginner
136What is a trigger in SQL Server, and what kinds of events can cause one to run automatically? SQL Server › TriggersSQL ServerTriggersBeginner
137What is T-SQL, and how does it relate to standard SQL? SQL Server › T-SQL Fundamentals & SyntaxSQL ServerT-SQL Fundamentals & SyntaxBeginner
138What are magic methods in PHP, and how do the __construct and __destruct methods represent two of the most commonly used examples? PHP › Magic MethodsPHPMagic MethodsBeginner
139How does an API typically use HTTP status codes to communicate the result of a request, and what do common codes like 200, 404, and 500 represent? PHP › RESTful API Development with PHPPHPRESTful API Development with PHPBeginner
140What does declaring strict_types=1 at the top of a PHP file actually change about how type declarations are enforced? PHP › Type Declarations & Strict TypesPHPType Declarations & Strict TypesBeginner
141How do the async and await keywords let you write asynchronous code in Dart that reads and looks like simple, straightforward sequential code? Flutter › Dart Asynchronous Programming (Future & async/await)FlutterDart Asynchronous Programming (Future & async/await)Beginner
142What is a MethodChannel, and how does it let you actually invoke a specific native method from your Dart code and properly receive back its own returned result? Flutter › Platform Channels (Native Android & iOS Integration)FlutterPlatform Channels (Native Android & iOS Integration)Beginner
143How do you properly request notification permission from a user, and what genuinely differs between how Android and iOS each respectively handle this specific particular permission request? Flutter › Push Notifications in Flutter (FCM)FlutterPush Notifications in Flutter (FCM)Beginner
144What are matchers in Flutter testing, such as equals, isTrue, and throwsA, and how do they let you express several genuinely different kinds of specific assertions within a given test? Flutter › Unit Testing in FlutterFlutterUnit Testing in FlutterBeginner
145What does return() do on an async iterator? JavaScript › Async Iterators & StreamsJavaScriptAsync Iterators & StreamsIntermediate
146What is code coverage and why isn't 100% coverage the same as bug-free code? JavaScript › Debugging, Testing & ToolingJavaScriptDebugging, Testing & ToolingIntermediate
147Why are recursion and immutable data often used together in functional style, instead of loops with mutable counters? JavaScript › Functional ProgrammingJavaScriptFunctional ProgrammingIntermediate
148How do you document multiple response types (like 200, 400, 404) for a single endpoint in Swagger using ProducesResponseType? ASP.NET Core › API Documentation with Swagger/OpenAPIASP.NET CoreAPI Documentation with Swagger/OpenAPIIntermediate
149What is the difference between AuthorizeAttribute's behavior returning 401 versus 403, and what determines which one a client receives? ASP.NET Core › AuthorizationASP.NET CoreAuthorizationIntermediate
150How does ASP.NET Core decide which output format to use when a client's Accept header lists multiple acceptable types with quality values (q-values)? ASP.NET Core › Content Negotiation & Output FormattersASP.NET CoreContent Negotiation & Output FormattersIntermediate
151What is the [Produces] attribute, and how does it restrict which content types a specific action can return regardless of what the client's Accept header requests? ASP.NET Core › Content Negotiation & Output FormattersASP.NET CoreContent Negotiation & Output FormattersIntermediate
152How does route template precedence work when multiple routes could potentially match the same incoming URL? ASP.NET Core › Endpoint Metadata, Route Constraints & TemplatesASP.NET CoreEndpoint Metadata, Route Constraints & TemplatesIntermediate
153How 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 FilesASP.NET CoreFile Uploads & Streaming Large FilesIntermediate
154How would you write an integration test verifying that your health check endpoint correctly reports Unhealthy when a dependency is down? ASP.NET Core › Health ChecksASP.NET CoreHealth ChecksIntermediate
155What is the ASP.NET Core Module (ANCM), and what specific role does it play when hosting under IIS? ASP.NET Core › Hosting Models: Kestrel, IIS & Reverse ProxiesASP.NET CoreHosting Models: Kestrel, IIS & Reverse ProxiesIntermediate
156What causes a deadlock in multithreaded Java code, and what is the classic "lock ordering" strategy for preventing it? Java › Concurrency & ThreadsJavaConcurrency & ThreadsIntermediate
157What is the correct usage of try-with-resources, and how does it automatically ensure a resource's close() method is called even if an exception occurs? Java › ExceptionsJavaExceptionsIntermediate
158What is the finally block's execution guarantee, and what are the specific edge cases where a finally block might NOT execute? Java › ExceptionsJavaExceptionsIntermediate
159What is the multi-catch syntax (catch (IOException | SQLException e)) introduced in Java 7, and what restriction applies to the exception types combined in a single multi-catch block? Java › ExceptionsJavaExceptionsIntermediate
160How do you create and throw a custom exception class, and what constructors should a well-designed custom exception typically provide? Java › ExceptionsJavaExceptionsIntermediate
161What is the purpose of the finalize() method, and why has it been deprecated in favor of try-with-resources and Cleaner in modern Java? Java › Garbage CollectionJavaGarbage CollectionIntermediate
162What are the modern java.nio.file utility classes (Path, Files) introduced in Java 7 (NIO.2), and how do they improve on the older java.io.File class? Java › I/O & NIOJavaI/O & NIOIntermediate
163How would you use try-with-resources combined with multiple chained I/O wrapper classes (like FileInputStream wrapped in BufferedInputStream wrapped in GZIPInputStream) to correctly read a compressed file while ensuring all layers are properly closed? Java › I/O & NIOJavaI/O & NIOIntermediate
164How would you use an abstract class's constructor to enforce that certain validation or initialization logic always runs for every subclass, something an interface (lacking constructors entirely) cannot provide? Java › Interfaces & Abstract ClassesJavaInterfaces & Abstract ClassesIntermediate
165What is the difference between Dispose and Finalize in C#, and when should each actually be used? C# › Memory & Garbage CollectionC#Memory & Garbage CollectionIntermediate
166What is the Middleware (Chain of Responsibility) pattern as implemented by Express, and how does the 'next()' function drive it? Node.js › Architecture & Design PatternsNode.jsArchitecture & Design PatternsIntermediate
167What is the difference between Promise.all(), Promise.allSettled(), Promise.race(), and Promise.any()? Node.js › Async PatternsNode.jsAsync PatternsIntermediate
168How does async/await relate to Promises under the hood, and what does 'await' actually do to program execution? Node.js › Async PatternsNode.jsAsync PatternsIntermediate
169How do you implement a retry-with-exponential-backoff pattern for a flaky async operation in Node.js? Node.js › Async PatternsNode.jsAsync PatternsIntermediate
170What is job idempotency, and why is it critical when designing background job processing? Node.js › Background Jobs & QueuesNode.jsBackground Jobs & QueuesIntermediate
171How 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 › CachingNode.jsCachingIntermediate
172How do you gracefully terminate a worker thread, and what's the difference between worker.terminate() and letting it exit naturally? Node.js › Clustering & Worker ThreadsNode.jsClustering & Worker ThreadsIntermediate
173What does the node:assert module provide, and how does it differ in purpose from a full testing framework? Node.js › Core Node.js ModulesNode.jsCore Node.js ModulesIntermediate
174Why should sending an email typically happen in a background job rather than synchronously within an HTTP request handler? Node.js › Email & NotificationsNode.jsEmail & NotificationsIntermediate
175How would you safely check if a file exists in Node.js before attempting to read it, avoiding a race condition? Node.js › File System & File ProcessingNode.jsFile System & File ProcessingIntermediate
176What is the purpose of the 'flag' option in fs.writeFile(), and what's the difference between 'w', 'a', and 'wx' flags? Node.js › File System & File ProcessingNode.jsFile System & File ProcessingIntermediate
177How 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 ProcessingNode.jsFile Uploads & Media ProcessingIntermediate
178What is the purpose of GraphQL's non-null (!) type modifier, and what happens if a resolver for a non-null field returns null unexpectedly? Node.js › GraphQLNode.jsGraphQLIntermediate
179What is the difference between HTTP methods GET, POST, PUT, PATCH, and DELETE, and what does 'idempotent' mean in this context? Node.js › HTTP & Web ServersNode.jsHTTP & Web ServersIntermediate
180How do you correctly set an exit code from a Node.js CLI script to signal success or failure to the calling shell or CI pipeline? Node.js › CLI Tools & Scripting with Node.jsNode.jsCLI Tools & Scripting with Node.jsIntermediate
181How do you implement database transactions in Node.js using Sequelize to ensure multiple related writes succeed or fail together? Node.js › Databases & ORMs (MongoDB/Mongoose, SQL/Sequelize)Node.jsDatabases & ORMs (MongoDB/Mongoose, SQL/Sequelize)Intermediate
182What is source map support, and why is it important when debugging a transpiled or bundled Node.js application (like TypeScript compiled to JavaScript)? Node.js › Debugging & DiagnosticsNode.jsDebugging & DiagnosticsIntermediate
183How 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 & ConfigurationNode.jsEnvironment Variables & ConfigurationIntermediate
184How would you structure application configuration to support multiple environments (development, staging, production) cleanly? Node.js › Environment Variables & ConfigurationNode.jsEnvironment Variables & ConfigurationIntermediate
185What is the difference between fs.rename() and manually copying then deleting a file, particularly across different filesystems or drives? Node.js › File System (fs) ModuleNode.jsFile System (fs) ModuleIntermediate
186How do GraphQL Mutations differ from Queries, and how would you define one to create a new resource? Node.js › GraphQL with Node.jsNode.jsGraphQL with Node.jsIntermediate
187What is the difference between message acknowledgment modes (auto-ack vs manual ack) in a message queue, and why does manual ack matter for reliability? Node.js › Message Queues (RabbitMQ & Kafka)Node.jsMessage Queues (RabbitMQ & Kafka)Intermediate
188How do you prevent a form from reloading the page when it is submitted in React? React › Forms: Controlled & Uncontrolled ComponentsReactForms: Controlled & Uncontrolled ComponentsIntermediate
189How do you use the Components tab in React DevTools to inspect a component's current state? React › React DevTools & DebuggingReactReact DevTools & DebuggingIntermediate
190What is a catch-all route segment, and when would you use one? Next.js › Dynamic Routes & Catch-All SegmentsNext.jsDynamic Routes & Catch-All SegmentsIntermediate
191How do you access dynamic route parameters inside a route handler defined with a dynamic segment? Next.js › Route Handlers (API Route.js)Next.jsRoute Handlers (API Route.js)Intermediate
192How do you prevent a recursive common table expression from running forever if the underlying data accidentally contains a circular reference? SQL Server › Common Table Expressions (CTEs)SQL ServerCommon Table Expressions (CTEs)Intermediate
193What is a check constraint, and how do you use one to enforce a specific business rule at the database level? SQL Server › Constraints (Primary Key, Foreign Key, Check & Unique)SQL ServerConstraints (Primary Key, Foreign Key, Check & Unique)Intermediate
194What are the basic steps required to declare, open, use, and properly clean up a cursor? SQL Server › CursorsSQL ServerCursorsIntermediate
195How do you debug a dynamic SQL statement when it fails or does not produce the expected results? SQL Server › Dynamic SQLSQL ServerDynamic SQLIntermediate
196What is a deadlock, and how does SQL Server automatically handle one when it occurs? SQL Server › Isolation & LockingSQL ServerIsolation & LockingIntermediate
197How do you test and verify that a linked server connection is working correctly after it has been configured? SQL Server › Linked ServersSQL ServerLinked ServersIntermediate
198How do you safely test a MERGE statement before running it against real production data? SQL Server › Merge Statement (Upsert)SQL ServerMerge Statement (Upsert)Intermediate
199How do you configure a SQL Server Agent job to send an email alert if it fails? SQL Server › SQL Server Agent & Job SchedulingSQL ServerSQL Server Agent & Job SchedulingIntermediate
200How do you configure a job step to automatically retry if it fails, rather than immediately marking the entire job as failed? SQL Server › SQL Server Agent & Job SchedulingSQL ServerSQL Server Agent & Job SchedulingIntermediate
201How do you use output parameters in a stored procedure to return a value back to the calling code, in addition to or instead of a normal result set? SQL Server › Stored Procedures & FunctionsSQL ServerStored Procedures & FunctionsIntermediate
202How do you use a SAVE TRANSACTION savepoint within a larger transaction to allow partial rollback of just a portion of the work? SQL Server › Transactions & ACIDSQL ServerTransactions & ACIDIntermediate
203What is the difference between an implicit and an explicit transaction in SQL Server? SQL Server › Transactions & ACIDSQL ServerTransactions & ACIDIntermediate
204How do you check whether a transaction is currently active and view its properties within a session? SQL Server › Transactions & ACIDSQL ServerTransactions & ACIDIntermediate
205Why should triggers generally be designed to handle multiple affected rows at once rather than assuming only a single row was changed? SQL Server › TriggersSQL ServerTriggersIntermediate
206How do you capture detailed information about deadlocks that are happening on a server so you can investigate their root cause? SQL Server › DeadlocksSQL ServerDeadlocksIntermediate
207How do database transactions work in PDO, and why are they important for ensuring multiple related database operations either all succeed together or all fail together? PHP › PDO & DatabasesPHPPDO & DatabasesIntermediate
208How does a middleware pipeline execute multiple middleware in sequence, and how does the concept of calling the next middleware let each one decide whether to continue processing the request? PHP › Routing & MiddlewarePHPRouting & MiddlewareIntermediate
209What happens when a single class uses multiple traits that happen to define a method with the exact same name, and how can this naming conflict be resolved? PHP › TraitsPHPTraitsIntermediate
210What are nullable types and union types in PHP, and how do they let you express that a value could be one of several different possible types? PHP › Type Declarations & Strict TypesPHPType Declarations & Strict TypesIntermediate
211What is the difference between the Google Play Store's internal testing, closed testing, and production release tracks, and why would a team use them in that specific order? Flutter › App Deployment (Play Store & App Store)FlutterApp Deployment (Play Store & App Store)Intermediate
212How does Firestore's offline persistence feature let a Flutter app continue functioning, including reading previously cached data and queuing writes, even when the device temporarily has no internet connection? Flutter › Cloud Firestore & Firebase StorageFlutterCloud Firestore & Firebase StorageIntermediate
213What is the null assertion operator, written as an exclamation mark, and why should it generally be used carefully and only when you are genuinely certain a specific nullable value cannot actually be null at that particular point? Flutter › Dart Null SafetyFlutterDart Null SafetyIntermediate
214How does Dart's late keyword let you declare a non nullable variable that will genuinely be initialized before it is ever actually first used, even though it cannot be given an initial value immediately at the exact point of its declaration? Flutter › Dart Null SafetyFlutterDart Null SafetyIntermediate
215How should a background task properly handle a failure, such as a network request genuinely failing partway through, and what retry behavior does workmanager actually provide out of the box for this kind of situation? Flutter › Flutter Background Tasks & WorkManagerFlutterFlutter Background Tasks & WorkManagerIntermediate
216How can you use the debugger and breakpoints within an IDE like Visual Studio Code or Android Studio to actually step through your Flutter app's code line by line and inspect the exact current values of your variables? Flutter › Flutter DevTools & DebuggingFlutterFlutter DevTools & DebuggingIntermediate
217What is a GraphQL mutation, and how does it genuinely differ from a regular query specifically in terms of properly performing an action that actually genuinely changes data on the server? Flutter › GraphQL in FlutterFlutterGraphQL in FlutterIntermediate
218How 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 FlutterFlutterIn App Purchases in FlutterIntermediate
219How should an app properly handle restoring a user's own previously already made purchases, such as when they genuinely reinstall the app or properly switch over to using an entirely different new device? Flutter › In App Purchases in FlutterFlutterIn App Purchases in FlutterIntermediate
220How should you properly handle a genuinely nullable or optional field within your JSON deserialization logic, ensuring your app genuinely does not crash if a specific expected field happens to actually be missing from a given received response? Flutter › JSON Serialization & DeserializationFlutterJSON Serialization & DeserializationIntermediate
221How should you properly and correctly handle requesting location permissions across the several genuinely different possible permission states, including denied, granted, and permanently denied, using the geolocator or permission_handler packages? Flutter › Maps & Geolocation in FlutterFlutterMaps & Geolocation in FlutterIntermediate
222How should you properly and correctly avoid calling setState after a StatefulWidget's own associated State object has genuinely already been disposed of, such as after an asynchronous operation genuinely completes following a user having already navigated away? Flutter › State Management with setStateFlutterState Management with setStateIntermediate
223How should you properly implement automatic reconnection logic for a WebSocket connection that genuinely gets unexpectedly dropped, such as when a device briefly loses its internet connectivity or moves between different networks? Flutter › WebSockets & Real Time Data in FlutterFlutterWebSockets & Real Time Data in FlutterIntermediate
224How do you add a timeout to an async iterator's next() call? JavaScript › Async Iterators & StreamsJavaScriptAsync Iterators & StreamsAdvanced
225What is a static initialization block and why would you use one? JavaScript › Classes & Class SyntaxJavaScriptClasses & Class SyntaxAdvanced
226Why does new Date(2026, 7, 8) represent August 8th, not July 8th? JavaScript › Date, Time & Internationalization (Intl API)JavaScriptDate, Time & Internationalization (Intl API)Advanced
227What's the difference between end-to-end (E2E) tests and unit tests, and when do you use each? JavaScript › Debugging, Testing & ToolingJavaScriptDebugging, Testing & ToolingAdvanced
228How do you destructure nested objects and arrays in one statement? JavaScript › Destructuring, Spread & RestJavaScriptDestructuring, Spread & RestAdvanced
229Why must the rest element be the LAST element in a destructuring pattern? JavaScript › Destructuring, Spread & RestJavaScriptDestructuring, Spread & RestAdvanced
230How do you use generator.throw() and generator.return() to control a running generator externally? JavaScript › Iterators & GeneratorsJavaScriptIterators & GeneratorsAdvanced
231How would you implement request retries with exponential backoff and a total timeout using fetch()? JavaScript › Networking: Fetch, XHR, WebSockets & CORSJavaScriptNetworking: Fetch, XHR, WebSockets & CORSAdvanced
232How do you correctly compare two floating-point numbers for 'close enough' equality? JavaScript › Numbers, Math & BigIntJavaScriptNumbers, Math & BigIntAdvanced
233How does ASP.NET Core API versioning handle a request that doesn't specify any version at all? ASP.NET Core › API VersioningASP.NET CoreAPI VersioningAdvanced
234How would you implement a background task queue accepting ad-hoc work items dynamically at runtime, rather than a fixed polling loop? ASP.NET Core › Background Tasks & Hosted ServicesASP.NET CoreBackground Tasks & Hosted ServicesAdvanced
235How does content negotiation handle the request body (input formatters) differently from the response body (output formatters)? ASP.NET Core › Content Negotiation & Output FormattersASP.NET CoreContent Negotiation & Output FormattersAdvanced
236How does java.util.concurrent's ReentrantLock differ from the synchronized keyword, and what additional capabilities does it provide (tryLock, fairness, interruptible locking)? Java › Concurrency & ThreadsJavaConcurrency & ThreadsAdvanced
237How do CompletableFuture's composition methods (thenApply, thenCompose, thenCombine) enable building asynchronous pipelines, and what's the difference between thenApply and thenCompose? Java › Concurrency & ThreadsJavaConcurrency & ThreadsAdvanced
238How does exception chaining (via the cause mechanism, initCause() or a constructor accepting a Throwable) preserve the original root-cause exception when wrapping and rethrowing a different exception type, and why does this matter for debugging? Java › ExceptionsJavaExceptionsAdvanced
239How would you design a custom exception hierarchy for an application, deciding when to create new exception classes versus reusing existing ones, and what fields/context should a well-designed custom exception carry? Java › ExceptionsJavaExceptionsAdvanced
240How would you use an abstract class combined with the Non-Virtual Interface (NVI) idiom to enforce that certain methods are always called in a specific pattern, even when subclasses override customizable parts? Java › Interfaces & Abstract ClassesJavaInterfaces & Abstract ClassesAdvanced
241What are Node.js's built-in diagnostic reports, and how do you generate one? Node.js › Advanced Node.jsNode.jsAdvanced Node.jsAdvanced
242What is a Circuit Breaker pattern, and why is it important when a Node.js service calls an unreliable downstream dependency? Node.js › Architecture & Design PatternsNode.jsArchitecture & Design PatternsAdvanced
243What is the difference between an unhandled promise rejection and an uncaught exception in Node.js, and how does Node handle each by default? Node.js › Async PatternsNode.jsAsync PatternsAdvanced
244What is a common pitfall when using async/await inside Array.prototype.forEach(), and how do you fix it? Node.js › Async PatternsNode.jsAsync PatternsAdvanced
245What is 'fire-and-forget' async code, and why is it generally discouraged in production Node.js applications? Node.js › Async PatternsNode.jsAsync PatternsAdvanced
246What is a dead-letter queue (DLQ), and how should a Node.js job-processing system use one? Node.js › Background Jobs & QueuesNode.jsBackground Jobs & QueuesAdvanced
247What is job de-duplication in a queue system, and how would you prevent the same logical job from being enqueued multiple times? Node.js › Background Jobs & QueuesNode.jsBackground Jobs & QueuesAdvanced
248How do you implement rate-limited job processing so a Node.js worker doesn't exceed a downstream third-party API's request limits? Node.js › Background Jobs & QueuesNode.jsBackground Jobs & QueuesAdvanced
249What is cache stampede (thundering herd), and how do you prevent it in a high-traffic Node.js service? Node.js › CachingNode.jsCachingAdvanced
250How do you handle an uncaught exception inside a specific cluster worker without taking down the entire application? Node.js › Clustering & Worker ThreadsNode.jsClustering & Worker ThreadsAdvanced
251What is the difference in behavior between the 'primary' and 'worker' role in Node's cluster module regarding which code paths execute? Node.js › Clustering & Worker ThreadsNode.jsClustering & Worker ThreadsAdvanced
252What is a database transaction, and how would you implement one in Node.js to ensure multiple related writes either all succeed or all fail together? Node.js › DatabasesNode.jsDatabasesAdvanced
253What is optimistic concurrency control, and how would you implement it to prevent lost updates when two users edit the same record simultaneously? Node.js › DatabasesNode.jsDatabasesAdvanced
254What is a database connection leak in a Node.js application, and how does it typically happen when using a connection pool? Node.js › DatabasesNode.jsDatabasesAdvanced
255What is a database deadlock, and how might it occur between two concurrent transactions in a Node.js application? Node.js › DatabasesNode.jsDatabasesAdvanced
256How do you write custom Express middleware that needs to perform asynchronous work, like checking a value against a database, before calling next()? Node.js › Express & MiddlewareNode.jsExpress & MiddlewareAdvanced
257How would you implement request validation middleware in Express using a schema-validation library like Zod or Joi? Node.js › Express & MiddlewareNode.jsExpress & MiddlewareAdvanced
258How would you implement a global request timeout middleware in Express to prevent a slow request from hanging indefinitely? Node.js › Express & MiddlewareNode.jsExpress & MiddlewareAdvanced
259How would you implement atomic file writes in Node.js to avoid leaving a file in a corrupted, half-written state if the process crashes mid-write? Node.js › File System & File ProcessingNode.jsFile System & File ProcessingAdvanced
260How would you implement file locking in Node.js to prevent two processes from writing to the same file simultaneously? Node.js › File System & File ProcessingNode.jsFile System & File ProcessingAdvanced
261How would you implement resumable/chunked file uploads in Node.js to handle very large files over unreliable network connections? Node.js › File Uploads & Media ProcessingNode.jsFile Uploads & Media ProcessingAdvanced
262How do you handle a child process that hangs or never terminates, and what's the correct way to enforce a timeout? Node.js › Child Processes & Process ManagementNode.jsChild Processes & Process ManagementAdvanced
263What are Node.js file descriptor limits, and how might a Node.js application unintentionally exhaust them? Node.js › File System (fs) ModuleNode.jsFile System (fs) ModuleAdvanced
264How would you implement a dead-letter exchange in RabbitMQ to handle messages that repeatedly fail processing? Node.js › Message Queues (RabbitMQ & Kafka)Node.jsMessage Queues (RabbitMQ & Kafka)Advanced
265How would you use an interceptor to automatically retry a failed HTTP request a few times before giving up? Angular › HTTP Client & InterceptorsAngularHTTP Client & InterceptorsAdvanced
266What are common use cases where parallel routes provide a better solution than simply rendering multiple components inside a single page? Next.js › Parallel Routes & Intercepting RoutesNext.jsParallel Routes & Intercepting RoutesAdvanced
267How would you add a new constraint to an existing table that already contains data, especially if some existing rows might violate that constraint? SQL Server › Constraints (Primary Key, Foreign Key, Check & Unique)SQL ServerConstraints (Primary Key, Foreign Key, Check & Unique)Advanced
268How 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 ServerSQL ServerJSON Support in SQL ServerAdvanced
269How would you troubleshoot a transactional replication setup where a subscriber has stopped receiving new changes entirely? SQL Server › ReplicationSQL ServerReplicationAdvanced
270How would you design a complex SQL Server Agent job with multiple steps that need to run conditionally based on the success or failure of previous steps? SQL Server › SQL Server Agent & Job SchedulingSQL ServerSQL Server Agent & Job SchedulingAdvanced
271How would you design an Extended Events session to monitor for a very specific, hard to reproduce issue, such as intermittent deadlocks, in a production environment? SQL Server › SQL Server Profiler & Extended EventsSQL ServerSQL Server Profiler & Extended EventsAdvanced
272How do nested and recursive triggers work in SQL Server, and what precautions should be taken to avoid unexpected behavior or infinite loops? SQL Server › TriggersSQL ServerTriggersAdvanced
273How does PHP's type coercion behave differently in strict types mode compared to the default coercive mode, and what are the implications for function argument and return type validation? PHP › Basics & TypesPHPBasics & TypesAdvanced
274How should an application handle database connection failures gracefully, including implementing retry logic and connection health checks for a reliable production system? PHP › PDO & DatabasesPHPPDO & DatabasesAdvanced
275How can PHP's built in disabled functions setting and other server level configuration hardening reduce the impact of a successful attack against an application? PHP › SecurityPHPSecurityAdvanced
276What 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)FlutterApp Deployment (Play Store & App Store)Advanced
277How can a CI/CD pipeline automate the entire release process for a Flutter app, including automatically bumping the version number and generating meaningful release notes based on recent commits? Flutter › CI/CD Pipelines for Flutter AppsFlutterCI/CD Pipelines for Flutter AppsAdvanced
278How do iOS's specific background execution restrictions, particularly around limited genuine background task execution time, differ meaningfully from Android's own generally more permissive background task model? Flutter › Flutter Background Tasks & WorkManagerFlutterFlutter Background Tasks & WorkManagerAdvanced
279How can you use Flutter DevTools' dedicated network view together with proper logging to effectively debug a genuinely complex issue involving several separate related API calls happening across your application? Flutter › Flutter DevTools & DebuggingFlutterFlutter DevTools & DebuggingAdvanced
280How can you properly and safely use a BuildContext across an asynchronous gap, such as directly after an await statement, without genuinely risking using a context that has since actually genuinely become invalid because its own underlying widget was already disposed of in the meantime? Flutter › Flutter Widget Tree, Element Tree & BuildContextFlutterFlutter Widget Tree, Element Tree & BuildContextAdvanced
281How should you properly handle schema migration in Hive when you genuinely need to add, remove, or meaningfully change a specific field on an already existing HiveObject class after your app has genuinely already been released to real actual users? Flutter › Hive & NoSQL Local StorageFlutterHive & NoSQL Local StorageAdvanced
282How can you properly and safely migrate existing data already stored using SharedPreferences over to a genuinely more full featured local database such as Hive, once an app's own particular storage needs have genuinely grown beyond what simple key value storage alone can reasonably handle? Flutter › Local Data Storage with SharedPreferencesFlutterLocal Data Storage with SharedPreferencesAdvanced
283How can you properly implement an effective retry strategy with exponential backoff for a genuinely failed network request, meaningfully improving your app's own overall resilience against genuinely temporary, transient network issues? Flutter › Networking with HTTP & DioFlutterNetworking with HTTP & DioAdvanced
284How should you properly implement request and response logging for debugging purposes, while genuinely and carefully ensuring genuinely sensitive data, such as an authentication token or a password, is never actually accidentally logged in plain readable text? Flutter › Networking with HTTP & DioFlutterNetworking with HTTP & DioAdvanced
285How should you properly implement database transactions in sqflite to ensure several genuinely related separate operations either all fully succeed together, or all genuinely fail together entirely, maintaining your overall data's own genuine consistency? Flutter › SQLite & Local Databases (sqflite)FlutterSQLite & Local Databases (sqflite)Advanced
286How 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 RiverpodFlutterState Management with RiverpodAdvanced
287How should you properly design a message queuing and delivery confirmation system, ensuring a message genuinely sent while a WebSocket connection was temporarily disconnected is properly and reliably delivered once that particular connection actually genuinely reconnects? Flutter › WebSockets & Real Time Data in FlutterFlutterWebSockets & Real Time Data in FlutterAdvanced