Multiple choice technology databases

When is the authorization check on DB2 objects done?

  1. at BIND time

  2. at RUN time

  3. at Execution time

  4. at End time
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

DB2 performs authorization checks at runtime when the actual SQL statement is executed. BIND time is when the application plan is created and optimized, but authorization is verified later when the plan runs. 'Execution time' and 'End time' are not the correct DB2 terminology.

AI explanation

In DB2, authorization to use most objects (tables, views, etc.) is checked at RUN time — the moment the SQL statement actually executes and touches the object. This is distinct from BIND time, which is when a plan or package's executive authority (the privilege to run that particular bound plan/package) is verified, not authority over the underlying data objects themselves. 'Execution time' and 'End time' are not standard DB2 authorization-checking phases; they're distractors that sound plausible but aren't the terminology DB2 uses. So the marked answer, RUN time, correctly describes when DB2 validates a user's privileges against the objects a statement references.

Keep practicing — related questions