• Description:DB2 9 DBA for Linux, UNIX and Windows
• Passing Score:0%
• Practice Test - Number of questions:129 questions
• Simulation Test - Number of questions:129 questions
• Simulation Test Duration:120 minutes
• Has explanations:No

User USER1 writes a dynamic SQL application which reads data from table T1, inserts data into table T2 and reads data from table T3 in the database DB1. The following privileges have been granted: - INSERT on T2 is granted to USER1 - SELECT on T3 is granted to PUBLIC - CONNECT to DB1 is granted to PUBLIC - SELECT on T1 is granted to group GRP1 USER1 is a member of group GRP1. Which of the following will allow USER1 to successfully bind the application to database DB1?

Answer(s)

1. GRANT BIND ON db1 TO user1
2. GRANT SELECT ON t3 TO user1
3. GRANT BINDADD ON db1 TO user1
4. GRANT SELECT ON t3 AND t1 TO user1

GRANT BINDADD ON db1 TO user1