Looking for 000-730 cram materials? Do you have unsolved questions. Our DB2 9 Fundamentals 000-730 practice questions provide you everything you will need to take your 000-730 test and go beyond the exam 000-730 passing score. The 000-730 Exam details are researched and produced by Professional Certification Experts who are constantly using industry experience to produce precise, logical and verified answers. 000-730 Questions.
1. A user invoking a user-defined function requires which DB2 privilege?
A. CALL
B. USAGE
C. EXECUTE
D. REFERENCES
Answer: CÂ
2. Which of the following statements is used to prevent user TOM from adding and deleting data in table TAB1?
A. REVOKE ADD, DELETE FROM USER tom ON TABLE tab1
B. REVOKE ADD, DELETE ON TABLE tab1 FROM USER tom
C. REVOKE INSERT, DELETE FROM USER tom ON TABLE tab1
D. REVOKE INSERT, DELETE ON TABLE tab1 FROM USER tom
Answer: DÂ
3. Which of the following privileges permits a user to update the comment on a sequence?
A. CONTROL
B. UPDATE
C. USAGE
D. ALTER
Answer: DÂ
4. Which of the following statements is used to revoke all DML privileges on table EMPLOYEE from user TOM?
A. REVOKE ALL PRIVILEGES FROM USER tom
B. REVOKE ALL ON EMPLOYEE FROM USER tom
C. REVOKE EXECUTE ON EMPLOYEE FROM USER tom
D. REVOKE PRIVILEGES ON EMPLOYEE FROM USER tom
Answer: B
No Responses Comments and Pings closed