On which of the following database objects may the SELECT privilege be controlled?（）

单项选择题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?（）

A.User ID/password file
B.Communications layer
C.Client applications
D.Operating system

单项选择题Which of the following statements is used to grant user TOM and Application team APPGRP the ability to add data to table TAB1?（）

A.GRANT ADD DATA ON TABLE tab1 TO GROUP tom appgrp
B.GRANT INSERT TO USER tom, GROUP appgrp ON TABLE tab1
C.GRANT INSERT ON TABLE tab1 TO USER tom, GROUP appgrp
D.GRANT ADD DATA ON TABLE tab1 TO USER appgrp, GROUP tom

单项选择题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?（）

A.REFERENCES
B.SELECT
C.UPDATE
D.ALTER

单项选择题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?（）

A.REVOKE DROP ON t1 FROM PUBLIC
B.REVOKE UPDATE ON t1 FROM PUBLIC
C.REVOKE DELETE ON t1 FROM PUBLIC
D.REVOKE CONTROL ON t1 FROM PUBLIC

单项选择题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?（）

A.Table
B.Columns
C.Table and Alias
D.Columns and Alias