Q1361. Process of finding a good query execution strategy?
**Query optimization**. The database's query optimizer generates multiple execution plans and picks the cheapest one based on statistics, indexes, and cost models. You ca...
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).
Q1362. Explain how to overload constructors (or methods) in Python.?
In Python, constructors cannot be overloaded by having multiple `def __init__` definitions (the last defined one overwrites earlier ones). Instead, constructor overloadin...
Q1363. What is the :active pseudo-class used for in CSS?
The **`:active`** pseudo-class represents an element in the process of being activated by the user. ### When Is It Triggered? - The moment a user presses and holds the pr...
Q1364. What is JSON?
JSON (JavaScript Object Notation) is a lightweight format that is used for data interchanging. It is based on a subset of JavaScript language in the way objects are built...
Q1365. Should I keep all component's state in Redux store?
**No.** In professional state architecture, keeping 100% of application state in a global Redux store is an anti-pattern. You should carefully separate **global server/cl...
Q1366. How do you handle API routes in the Next.js Pages Router?
By creating files in the `pages/api` directory, which will be treated as API endpoints. ```jsx // pages/api/hello.js export default function handler(req, res) { res.statu...
Q1367. How do you represent one way data flow in vuex?
Vue.js has a one-way data flow model, through the props property. The same concept can be represented in vuex has below, ****
Q1368. What is a trigger?
A stored procedure that automatically executes in response to a DML event (INSERT, UPDATE, DELETE) or DDL event (CREATE, ALTER, DROP). Components: **Event** (when), **Con...
Q1369. What is the difference between List & Tuple in Python.?
LIST vs TUPLES LIST TUPLES Lists are mutable i.e they can be edited. Tuples are immutable (tuples are lists which can't be edited). Lists are slower than tuples. Tuples a...
Q1370. What is the :lang() pseudo-class used for in CSS?
The lang() pseudo-class is used to target elements based on the language attribute of the HTML document. For example, you can use :lang(en) to target all elements in Engl...