Which of the following statements allows USER1 to take away read access on the table ORG.TAB1 from USER2?
Which of the following statements allows USER1 to take away read access on the table
ORG.TAB1 from USER2?
Which of the following statements allows user USER1 to take the ability to create packages in a database named
Which of the following statements allows user USER1 to take the ability to create packages in a
database named SAMPLE away from user USER2?
Which of the following will provide user USER1 and all members of the group GROUP1 with the ability to perform
Which of the following will provide user USER1 and all members of the group GROUP1 with the
ability to perform DML, but no other operations on table TABLE1?
What does the following statement do?
What does the following statement do?
GRANT REFERENCES (col1, col2) ON TABLE table1 TO user1 WITH
GRANT OPTION
which of the following is the best way to remove all privileges user USER1 holds?
User USER1 is the owner of TABLE1. Assuming user USER1 only holds privileges for TABLE1,
which of the following is the best way to remove all privileges user USER1 holds?
Which of the following statement(s) can be used to accomplish this?
User USER1 has the privileges needed to invoke a stored procedure named GEN_RESUME.
User USER2 needs to be able to call the procedure – user USER1 and all members of the group
PUBLIC should no longer be allowed to call the procedure. Which of the following statement(s)
can be used to accomplish this?
Which of the following statements is USER1 authorized to execute?
A view named V.VIEW1 is based on a table named T.TABLE1. A user with DBADM authority
issues the following statement:
GRANT INSERT ON v.view1 TO user1 WITH GRANT OPTION
Which of the following statements is USER1 authorized to execute?
What does the following statement do?
What does the following statement do?
GRANT ALTER ON SEQUENCE gen_empid TO user1 WITH GRANT OPTION
which DB2 privilege?
A user invoking a user-defined function requires which DB2 privilege?
Which of the following statements is used to prevent user TOM from adding and deleting data in table TAB1?
Which of the following statements is used to prevent user TOM from adding and deleting data in
table TAB1?