Q1. What is the difference between ViewChild and ContentChild?
Both are query decorators, but they search different places. @ViewChild queries the component's own template, while @ContentChild queries content projected into the compo...
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 (7 available).
Active:
Tag: queries ×
Q2. 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...
Q3. 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...
Q4. Row comparison operators with subqueries?
`IN`, `ANY`, `ALL`, `EXISTS`, `NOT EXISTS`, and standard comparison operators (`=`, `>`, `=`, ` ALL (SELECT salary FROM employees WHERE dept = 'Sales') WHERE salary > ANY...
Q5. Clustered vs Non-Clustered?
- **Clustered**: Determines physical storage order. One per table. The data IS the index. - **Non-Clustered**: Separate structure with pointers to data. Multiple allowed ...
Q6. What is SQL Injection?
A code injection attack where malicious SQL is inserted via user input. Prevention: 1. **Parameterized queries** (prepared statements) 2. **Input validation** 3. **ORM fr...
Q7. Advantages of views?
1. **Simplify complex queries** — hide JOINs and aggregations 2. **Security** — expose only specific columns/rows 3. **Logical independence** — shield apps from schema ch...