which of the following DB2 objects?
A user utilizing an alias to update a subset of columns in a table must have
UPDATE privileges on which of the following DB2 objects?
which of the following statements would continue to permit any user to add rows to table T1, but not remove th
Assuming PUBLIC has been granted all privileges on table T1, which of the following statements
would continue to permit any user to add rows to table T1, but not remove them?
Which of the following statements is used to grant user TOM and Application team APPGRP the ability to add dat
Which of the following statements is used to grant user TOM and
Application team APPGRP the ability to add data to table TAB1?
Which of the following will be used to verify passwords?
A “trusted” client needs to communicate with a server that has been configured to use CLIENT
authentication. Which of the following will be used to verify passwords?
which of the following database objects may the SELECT privilege be controlled?
On which of the following database objects may the SELECT privilege be controlled?
which privilege is required on table T1 to create the trigger?
A user needs to create a trigger that will update table T2 whenever a row is added to table T1.
Assuming the user has all appropriate privileges for table T2, which privilege is required on table
T1 to create the trigger?
Which two of the following statements is user USER1 allowed to execute?
User USER1 holds CONTROL privilege on table TABLE1. Which two of the following statements
is user USER1 allowed to execute?
which of the following privileges?
A user wishing to invoke an SQL stored procedure that queries a table must have which of the
following privileges?
which of the following actions is user USER1 allowed to perform?
After the following SQL statement is executed:
GRANT ALL PRIVILEGES ON TABLE employee TO USER user1
Assuming user USER1 has no other authorities or privileges, which of the following actions is user
USER1 allowed to perform?
Which two of the following privileges is required in order to use a package?
Which two of the following privileges is required in order to use a package?