Multiple choice technology databases

What one is valid special register?

  1. CURRENT_CLIENT_ACCT

  2. CURRENT_SCHEMA

  3. CURRENT_DATETIME

  4. CURRENT_PARTITION
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

In DB2 SQL, CURRENT_SCHEMA is a valid special register that returns the current schema name. CURRENT_CLIENT_ACCT, CURRENT_DATETIME, and CURRENT_PARTITION are not standard DB2 special registers (though similar registers like CURRENT_DATE, CURRENT_TIME exist with different names).

Keep practicing — related questions