Q941. UNION vs UNION ALL?
| UNION | UNION ALL | |-------|-----------| | Removes duplicates | Keeps duplicates | | Slower (sort + dedup) | Faster | | Use when uniqueness matters | Use when sets are...
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).
Q942. Create a unicode string in Python with the string "This is a test string"?
In modern **Python 3**, **all strings are Unicode by default** (`str` type represents Unicode code points encoded in UTF-8): ```python # In Python 3, this is already a na...
Q943. What is the purpose of <legend> tag?
The `` tag provides semantic caption or title for a `` element. It is optional but better for better to have for accessibility.
Q944. Why do you need a promise?
Promises are **used to handle asynchronous operations**, especially in languages like JavaScript, which often work with non-blocking operations such as network requests, ...
Q945. Why should component names start with capital letter?
If you are rendering your component using JSX, the name of that component has to begin with a capital letter otherwise React will throw an error as an unrecognized tag. T...
Q946. How do you configure a custom Babel setup in Next.js?
By default, Next.js uses the high-performance Rust-based **SWC compiler**, which is up to 17x faster than Babel. However, if your project relies on legacy custom Babel pl...
Q947. What is dynamic route matching?
Sometimes it may be required to map routes to the same component based on a pattern. Let's take a user component with the mapped URLs like `/user/john/post/123` and `/use...
Q948. Which set operator for "searched but didn't buy"?
`MINUS` (Oracle) or `EXCEPT` (PostgreSQL/SQL Server): ```sql SELECT name FROM searchers WHERE product = 'X' EXCEPT SELECT name FROM buyers WHERE product = 'X'; ``` ---
Q949. What is the Python syntax for switch case statements?
Starting in **Python 3.10**, Python natively introduced the **`match / case`** statement (PEP 634 Structural Pattern Matching): ### Modern Python 3.10+ Pattern Matching: ...
Q950. What are HTML entities?
HTML entities are codes used to represent special characters in HTML that cannot be easily typed or displayed. Example: `&` represents (`&`)