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 (3 available).

Filters

Keyword Category Difficulty Type Sort by

Reset

Active: Tag: cte ×

SQL & Databases Easy technical

Q1. Which statement returns only different values?

`SELECT DISTINCT`. It operates on the *entire selected row*. ```sql -- Returns unique city-state combinations SELECT DISTINCT city, state FROM addresses; ```

0 Answer

SQL & Databases Easy technical

Q2. Which operator searches text patterns?

`LIKE` with wildcards `%` (zero or more chars) and `_` (single char). ```sql WHERE name LIKE 'A%' -- starts with A WHERE name LIKE '%a%' -- contains a WHERE name LIKE '_a...

1 Answer

SQL & Databases Easy technical

Q3. 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...

1 Answer