46.
User USER1 wants to utilize an alias to remove rows from a table. Assuming USER1 has no authorities or privileges, which of the following privileges are needed?
- A.DELETE privilege on the table
- B.DELETE privilege on the alias
- C.DELETE privilege on the alias; REFERENCES privilege on the table
- D.REFERENCES privilege on the alias; DELETE privilege on the table
- Answer
- Report
Answer : [A]
47.
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
- Answer
- Report
Answer : [A]
48.
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
- Answer
- Report
Answer : [C]
49.
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 tomappgrp
- B.GRANT INSERT TO USER tom, GROUPappgrp ON TABLE tab1
- C.GRANT INSERT ON TABLE tab1 TO USER tom, GROUPappgrp
- D.GRANT ADD DATA ON TABLE tab1 TO USERappgrp, GROUP tom
- Answer
- Report
Answer : [C]
50.
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
- Answer
- Report
Answer : [D]
|
|
||||||||||||||||||||||||||||
