Q31. Explain TCP congestion control.
TCP congestion control keeps the sender from overwhelming the network. The sender maintains a congestion window, cwnd, and sends at most the minimum of cwnd and the recei...
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 (59 available).
Active:
Tag: performance ×
Q32. 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...
Q33. What is memoization?
Memoization is a functional programming technique which attempts to increase a function’s performance by caching its previously computed results. Each time a memoized fun...
Q34. What is IndexedDB?
IndexedDB is a low-level API for client-side storage of larger amounts of structured data, including files/blobs. This API uses indexes to enable high-performance searche...
Q35. How to apply validation on props in React?
When the application is running in _development mode_, React will automatically check all props that we set on components to make sure they have _correct type_. If the ty...
Q36. What are the advantages of React?
Below are the list of main advantages of React, 1. Increases the application's performance with _Virtual DOM_. 2. JSX makes code easy to read and write. 3. It renders bot...
Q37. Why do you need web storage?
Web storage is more secure, and large amounts of data can be stored locally, without affecting website performance. Also, the information is never transferred to the serv...
Q38. 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...
Q39. Can a view be based on another view?
**Yes**, a view can be defined on top of another existing view (known as a **nested view**): ```sql CREATE VIEW us_customers AS SELECT * FROM Customers WHERE country = 'U...
Q40. What are React Server components?
React Server Component is a way to write React component that gets rendered in the server-side with the purpose of improving React app performance. These components allow...