Q51. Inner join result?
An **`INNER JOIN`** returns only the subset of rows where the join predicate (`ON` condition) matches in **both** tables simultaneously: ### Visual Venn Diagram Concept: ...
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 (119 available).
Active:
Tag: sql ×
Q52. Can you join 3 tables with INNER JOIN?
Yes. There's no practical limit (though performance degrades with many joins). ```sql SELECT f.name, d.name AS division, c.name AS country FROM faculty f INNER JOIN divis...
Q53. Can you join a table to itself?
Yes — **SELF JOIN**. You must use aliases to distinguish the two instances. ```sql SELECT a.name AS employee, b.name AS manager FROM employees a, employees b WHERE a.mana...
Q54. What is true about Cartesian Products?
A Cartesian product occurs when tables are joined **without a condition**. Every row in Table A pairs with every row in Table B: `m × n` rows total. It's usually a bug, b...
Q55. INTERSECTION in relational algebra?
In relational algebra and set theory, the **INTERSECTION** of two sets $A \cap B$ yields only the tuples that appear in **both** relation sets simultaneously. ### SQL Imp...
Q56. UNION in relational algebra?
In relational algebra, the **UNION** of two sets $A \cup B$ combines all distinct tuples from both relations into a single unified relation. ### `UNION` vs `UNION ALL` in...
Q57. UNION vs UNION ALL?
| UNION | UNION ALL | |-------|-----------| | Removes duplicates | Keeps duplicates | | Slower (sort + dedup) | Faster | | Use when uniqueness matters | Use when sets are...
Q58. 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'; ``` ---
Q59. A SELECT statement whose results are used in filtering the main query is called?
A `SELECT` statement nested inside another SQL statement to supply values for filtering or computation is called a **subquery** (also known as an **inner query** or **nes...
Q60. Subqueries can be nested in...
Subqueries can be nested within virtually every major SQL clause and statement: 1. **`WHERE` Clause**: Filtering candidate rows (`WHERE id IN (SELECT ...)`) 2. **`FROM` C...