Q541. 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`,...
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 (2,728 available).
Q542. What is pickling and unpickling?
Pickle module accepts any Python object and converts it into a string representation and dumps it into a file by using dump function, this process is called pickling. Whi...
Q543. What is semantic HTML?
Semantic HTML uses specific HTML elements to provide additional information about the structure and content of the page, making it more accessible and easy to read.
Q544. How do you define variables with specific types in TypeScript?
Variables with specific types in TypeScript can be defined using type annotations. For example, you can declare a variable with a specific type like this: `let myVariable...
Q545. What is the difference between == and === operators?
JavaScript provides two types of equality operators: - **Loose equality (`==`, `!=`)**: Performs type conversion if the types differ, comparing values after converting th...
Q546. What are props in React?
_Props_ are inputs to components. They are single values or objects containing a set of values that are passed to components on creation similar to HTML-tag attributes. H...
Q547. Write unit tests for a pricing function.
Given a pricing function, write focused tests with JUnit and AssertJ. ```java class PriceCalculator { BigDecimal finalPrice(BigDecimal base, int qty, boolean member) { if...
Q548. Compare ahead-of-time and just-in-time compilation.
Ahead-of-time, AOT, compilation translates the program to machine code before it runs, producing a native binary. Startup is fast, memory overhead is predictable and ther...
Q549. Compare optimistic and pessimistic locking.
Both approaches handle concurrent updates to the same data. Pessimistic locking assumes conflicts are likely, so it locks a row when read: `SELECT ... FOR UPDATE` or a sh...
Q550. How do you troubleshoot a network problem methodically?
Network troubleshooting is easier when you reason up the layers and use the right tool at each step. - `ping` checks reachability and round-trip time using ICMP and revea...