Q31. Explain IDisposable, the using statement and finalizers.
`IDisposable` provides deterministic release of unmanaged resources through `Dispose()`. The `using` statement or declaration guarantees `Dispose` runs even if an excepti...
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 (55 available).
Active:
Tag: os ×
Q32. 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...
Q33. How do idempotency keys work for POST requests?
The client generates a unique key per logical operation and sends it in a header, typically `Idempotency-Key`. ```http POST /payments Idempotency-Key: 4d7c2e6a-2b1f-4f9a-...
Q34. How do you assess whether a company is financially healthy?
I look at profitability, liquidity, leverage and cash generation together, because any single ratio can mislead. Profitability: gross and net margin, and the trend over s...
Q35. How do you optimise BigQuery query cost and performance?
Cost in on-demand BigQuery is driven by bytes scanned, so reduce what each query reads. - Partition tables, usually by date, and add partition filters so only relevant pa...
Q36. How do you decide where to draw service boundaries?
Boundaries should follow the business domain, not technical layers. Techniques: - Domain-Driven Design bounded contexts: each context has its own model and ubiquitous lan...
Q37. What is GraphQL federation and when do you need it?
Federation lets several teams own separate GraphQL subgraphs and compose them into one graph for clients. Each subgraph declares the entities it owns with a key directive...
Q38. How would you design a test strategy for a microservices system?
Testing a distributed system needs a layered strategy, because full end-to-end coverage does not scale. - Unit tests per service for domain logic, run on every commit. - ...
Q39. How to select 10 random rows?
```sql -- MySQL SELECT * FROM tbl ORDER BY RAND() LIMIT 10; -- PostgreSQL SELECT * FROM tbl ORDER BY RANDOM() LIMIT 10; -- SQL Server SELECT TOP 10 * FROM tbl ORDER BY NE...
Q40. What are closures?
A closure is the combination of a function bundled(enclosed) together with its lexical environment within which that function was declared. i.e, It is an inner function t...