Q11. Which are valid SQL comments?
SQL supports both single-line and multi-line commenting syntax across relational database engines: ### 1. Single-Line Standard Comment (`--`): The official ANSI SQL stand...
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 (116 available).
Active:
Tag: dbms ×
Q12. Which SQL statement extracts data?
`SELECT`. Optional clauses: `WHERE`, `GROUP BY`, `HAVING`, `ORDER BY`, `LIMIT`, `JOIN`. ```sql SELECT name AS full_name, salary * 12 AS annual_salary FROM employees WHERE...
Q13. How to select all records from table Products?
```sql SELECT * FROM products; ``` ⚠️ *Interview tip*: Always follow up with "But in production, I list explicit columns to reduce network overhead and prevent breaking i...
Q14. Can we rename a column in output?
Yes, using `AS` (alias): ```sql SELECT first_name AS fname, last_name AS lname FROM customers; -- AS is optional but recommended for readability: SELECT first_name fname ...
Q15. How to select FirstName from Customers?
To retrieve only the `FirstName` column from the `Customers` table, use the standard `SELECT` projection statement: ```sql SELECT FirstName FROM Customers; ``` ### Perfor...
Q16. What does the FROM clause do?
The **`FROM`** clause identifies the source table(s), views, joined tables, or subqueries from which data is to be retrieved, filtered, and aggregated. ### Logical SQL Pr...
Q17. 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; ```
Q18. Display distinct cities in ADDRESSES(id, street_name, number, city, state)?
To retrieve a list of unique cities without duplicates from the `ADDRESSES` table, use the **`DISTINCT`** keyword: ```sql SELECT DISTINCT city FROM addresses ORDER BY cit...
Q19. Select all records where FirstName is "John"?
To retrieve all columns for records where `FirstName` equals 'John', combine `SELECT *` with a `WHERE` equality filter: ```sql SELECT * FROM Customers WHERE FirstName = '...
Q20. OR vs AND?
`AND` requires ALL conditions to be true. `OR` requires ANY to be true. Use parentheses to control precedence — `AND` binds tighter than `OR`. ```sql -- Without parenthes...