Q1. SQL was developed as an integral part of...
Relational Database Management Systems (RDBMS). SQL is the ANSI-standard language for creating, querying, updating, and managing relational databases. Major implementatio...
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 (115 available).
Active:
Tag: rdbms ×
Q2. What does SQL stand for?
**SQL** stands for **Structured Query Language**. Originally developed at IBM by Donald D. Chamberlin and Raymond F. Boyce in the early 1970s, it was initially named **SE...
Q3. What type of language is SQL?
**Declarative (non-procedural)**. You state *what* result you want, not *how* to compute it. The database's **query optimizer** decides the "how" — which indexes to use, ...
Q4. Which is NOT a valid SQL command: SELECT, REMOVE, UPDATE, INSERT?
**REMOVE** is not valid. To delete rows, use `DELETE`. `DROP` removes objects (tables, databases). | Command | Purpose | |---------|---------| | SELECT | Read data | | IN...
Q5. What is MySQL, and how does it differ from SQL?
**SQL** is the *language* (like English). **MySQL** is a *database system* that *speaks* SQL (like a person who speaks English). Analogy: SQL is the recipe; MySQL is the ...
Q6. What is PL/SQL, and how is it different from SQL?
**PL/SQL** = Procedural Language extensions to SQL (Oracle-specific). It adds variables, loops, IF-ELSE, and exception handling. | SQL | PL/SQL | |-----|--------| | Singl...
Q7. What are the possible values for a BOOLEAN field in MySQL?
MySQL doesn't have a native `BOOLEAN` type. It uses `TINYINT(1)` where `0` = false, `1` = true, and any non-zero value is treated as true in conditions. ```sql CREATE TAB...
Q8. Which data type for distance rounded to the nearest mile?
When storing distance rounded to the nearest whole mile, an **integer data type** is the optimal choice: ```sql ALTER TABLE travel_logs ADD COLUMN distance_miles INT NOT ...
Q9. Which are valid SQL keywords?
`SELECT`, `FROM`, `WHERE`, `GROUP BY`, `HAVING`, `ORDER BY`, `JOIN`, `INSERT`, `UPDATE`, `DELETE`, `CREATE`, `ALTER`, `DROP`, `INDEX`, `UNION`, `LIMIT`, `DISTINCT`, `AS`,...
Q10. 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...