Multiple choice technology databases

Which of the following DB2 objects are publicly referenced names that require no special authority or privilege to use them?

  1. View

  2. Alias

  3. Table

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

An alias is a publicly referenced object name in DB2 that requires no privileges to use. Any user can reference an alias, as authorization checks are deferred to the underlying tables or views when SQL statements are compiled. View, Table, and Package require explicit access privileges.

Keep practicing — related questions