Here is a question asked in a recent interview. What happens to DB2 pre compilation process, when DB2 is down?
The Correct Answer
In DB2, the pre-compilation is an inbuilt process. When DB2 is down, the DB2 resources may not be available, so pre-compilation will fail and BIND also will fail.
The answer for this question is pre-compilation process will not be successful.
Related Posts
-
FAANG-Style SQL Interview Traps (And How to Avoid Them)
SQL interviews at FAANG (Facebook/Meta, Amazon, Apple, Netflix, Google) are not about syntax. They are designed to test logical thinking, edge cases, execution order, and data correctness at scale. Many strong candidates fail—not because they don’t know SQL, but because they fall into subtle traps. In this blog, we’ll walk through real FAANG-style SQL traps,…
Srinimf 