Q1151. NOT NULL constraint?
The **`NOT NULL`** constraint enforces that a column must always contain a valid data value and cannot accept `NULL`: ```sql CREATE TABLE employees ( id INT PRIMARY KEY, ...
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 (2,728 available).
The **`NOT NULL`** constraint enforces that a column must always contain a valid data value and cannot accept `NULL`: ```sql CREATE TABLE employees ( id INT PRIMARY KEY, ...
Use the `.lower()` or `.casefold()` string method in Python: ```python s = 'MYSTRING' print(s.lower()) # Output: 'mystring' ``` *Tip:* `.casefold()` is recommended for ca...
`flex-grow` is a property in Flexbox that specifies how much a flex item should grow relative to the other items in the container, while `flex-shrink` specifies how much ...
Global variables are those that are available throughout the length of the code without any scope. The var keyword is used to declare a local variable but if you omit it ...
You have to wrap your Route's in a `` block because `` is unique in that it renders a route exclusively. At first you need to add `Switch` to your imports: ```javascript ...
In professional Next.js architecture, separating **`pages`** (or `app`) from **`components`** is fundamental to project organization: | Aspect | `pages/` (or `app/`) | `c...
The functional components are just simple functions to create simple components just by passing a context. Every functional component follows two rules, 1. **Stateless:**...
To enforce that every value in a non-primary key column is unique, apply the **`UNIQUE`** constraint: ```sql CREATE TABLE users ( id INT PRIMARY KEY, email VARCHAR(255) U...
The most readable, pythonic, and performant way to check if substring A exists inside string B is using the **`in` operator**: ```python str_b = "HireXTech Interview Prep...
`flex-wrap: nowrap` prevents flex items from wrapping to the next line when they overflow the container, while `overflow: hidden` hides any content that overflows the con...
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.