Q381. What is PL/SQL, and how is it different from SQL?
**PL/SQL** = Procedural Language extensions to SQL (Oracle-specific). It adds variables, loops, IF-ELSE, and exception handling. | SQL | PL/SQL | |-----|--------| | Singl...
Technical Question Bank · Peer-Reviewed
Job Interview Questions and Answers Directory
Search and filter frequently asked interview questions across technical, programming, and behavioral domains. Tailor your interview preparation by difficulty for freshers or experienced developers (2,728 available).
Q382. How does Python memory management work?
CPython combines: - Reference counting for immediate reclamation. Every object tracks how many references point to it; when the count hits zero it is freed. - A cyclic ga...
Q383. How does PHP handle errors and exceptions?
Modern PHP uses exceptions. Throwable is the root interface with two branches: Error (engine-level, e.g. TypeError, DivisionByZeroError) and Exception (application-level)...
Q384. How do you make a site accessible and responsive?
Accessibility essentials: - Use semantic elements and a logical heading order. - Provide alt text for meaningful images and empty alt for decorative ones. - Ensure colour...
Q385. What is structural typing and how does it differ from nominal typing?
TypeScript is structurally typed: compatibility is decided by the shape of a value, not by its declared name. If it has the required members, it is assignable. ```ts inte...
Q386. What is the purpose of the array splice method?
The `splice()` method in JavaScript is used to add, remove, or replace elements within an array. Unlike `slice()`, which creates a shallow copy and does not alter the ori...
Q387. When to use a Class Component over a Function Component?
After the addition of Hooks(i.e. React 16.8 onwards) it is always recommended to use Function components over Class components in React. Because you could use state, life...
Q388. How would you manage conflicting requirements from two powerful stakeholders?
I treat it as a prioritisation problem with an authority question, not a personality contest. First I meet each stakeholder separately to understand their requirement and...
Q389. How do you facilitate an effective retrospective?
A good retrospective is safe, focused and produces a small number of owned actions. I set the stage and remind everyone of the prime directive: we assume good intent and ...
Q390. How do you align engineering, design and business stakeholders?
I align people through a shared, visible goal and a clear decision making process, not through endless meetings. I start by understanding what each group cares about. Eng...