Q401. What is database collation and how does it affect SQL queries?
Collation defines the **rules for comparing and sorting** characters. It works with the character set. - `utf8mb4_general_ci`: Case-insensitive, faster - `utf8mb4_unicode...
Technical Question Bank · Peer-Reviewed
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).
Collation defines the **rules for comparing and sorting** characters. It works with the character set. - `utf8mb4_general_ci`: Case-insensitive, faster - `utf8mb4_unicode...
The window.history object contains the browser's history. You can load previous and next URLs in the history using back() and next() methods. ```javascript function goBac...
React Router v6 provides below 4 `` components: 1. ``:Uses the HTML5 history API for standard web apps. 2. ``:Uses hash-based routing for static servers. 3. ``:Uses in-me...
Automatically generates sequential unique integers for a column, typically the PRIMARY KEY. ```sql CREATE TABLE users (id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(50)...
The `mouseEvent getModifierState()` is used to return a boolean value that indicates whether the specified modifier key is activated or not. The modifiers such as CapsLoc...
A history instance has two methods for navigation purpose. 1. `push()` 2. `replace()` If you think of the history as an array of visited locations, `push()` will add a ne...
A linear gradient creates a smooth transition between two or more colors in a straight line while the radial gradient creates a smooth transition between two or more colo...
The isNaN() function is used to determine whether a value is an illegal number (Not-a-Number) or not. i.e, This function returns true if the value equates to NaN. Otherwi...
There are three different ways to achieve programmatic routing/navigation within components. 1. **Using the `withRouter()` higher-order function:** The `withRouter()` hig...
The **`next/image`** component is an extension of the HTML `` element engineered to automatically optimize images for Core Web Vitals: ### Automatic Optimizations Perform...
HireXTech uses essential storage to remember your study preferences and third-party advertising cookies via Google AdSense in compliance with GDPR. You can choose to enable essential cookies only or accept all cookies. Read our Privacy Policy.