Q251. Current date in MySQL without time?
In MySQL, you retrieve the current date (year, month, day) without the time component using **`CURDATE()`** or **`CURRENT_DATE`**: ```sql SELECT CURDATE(); -- Example: '2...
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 (1,236 available).
Active:
Difficulty: easy ×
Q252. What is a service worker?
A Service worker is basically a script (JavaScript file) that runs in the background, separate from a web page and provides features that don't need a web page or user in...
Q253. How to change default port for a Next.js app?
You can change the port used by Next.js using several straightforward approaches: ### 1. In `package.json` Scripts (Recommended): Pass the `-p` (or `--port`) flag in your...
Q254. Keyword to retrieve maximum value?
The keyword and aggregate function used to retrieve the maximum value of a column is **`MAX()`**: ```sql SELECT MAX(salary) AS highest_salary FROM employees; ``` ### With...
Q255. What is namespace in TypeScript?
In TypeScript, a namespace is a way to organize and group related code elements such as classes, interfaces, functions, and variables under a single name. Namespaces prov...
Q256. How do you manipulate DOM using a service worker?
Service worker can't access the DOM directly. But it can communicate with the pages it controls by responding to messages sent via the `postMessage` interface, and those ...
Q257. What are stateless components?
If the behaviour of a component is independent of its state then it can be a stateless component. You can use either a function or a class for creating stateless componen...
Q258. What is Fast Refresh in Next.js?
**Fast Refresh** is Next.js's hot module replacement (HMR) experience that provides near-instantaneous visual feedback when you edit React components in development. ### ...
Q259. Function to count results?
`COUNT()`. `COUNT(*)` counts rows. `COUNT(column)` counts non-NULL values. ```sql SELECT COUNT(*) FROM orders; -- Total orders SELECT COUNT(shipped_date) FROM orders; -- ...
Q260. What is HTML5 web storage?
HTML5 Web Storage is a mechanism in modern web browsers that allows web applications to store data locally within the user's browser. It provides two storage options: Loc...