A1: | Answer: B. Option B identifies the correct system authorities in the correct order. |
A2: | Answer: A. The statements in the other options are true. Option A is false because the security and authorization mechanisms that control access to DB2 data are both indirect and direct. An example of a direct security mechanism is that DB2 directly checks user IDs and passwords before users gain access to a DB2 subsystem. |
A3: | Answer: C. Options A, B, and D identify valid privileges, but operating system privileges are not relevant to DB2. |
A4: | Answer: D. Explicit privileges can be granted for JARs, schemas, and distinct types, but not for indexes. |
A5: | Answer: D. Options A, B, and C each identify things you can do with a GRANT statement. Option D mentions granting GLOBAL, which is not a valid option. |
A6: | Answer: D. DB2USER ID does not exist in the DB2 UDB for z/OS environment; the other options identify valid types of DB2 authorization IDs. |
3.142.156.202