Practice Questions


Question 1

Which of the following is NOT a valid method of authentication that can be used by DB2 UDB Version 8.x?

  • A. SERVER

  • B. SERVER_ENCRYPT

  • C. CLIENT

  • D. DCS

Question 2

Assuming USER1 has no authorities or privileges, which of the following will ONLY allow USER1 to add data to table EMPLOYEE?

  • A. CONTROL

  • B. INSERT

  • C. UPDATE

  • D. INSERT WITH GRANT OPTION

Question 3

In a client-server environment, which two of the following can be used to verify passwords?

  • A. System Catalog

  • B. Client Applications

  • C. Client Operating System

  • D. DB2 Database Manager

  • E. Application Server

Question 4

A table called DEPARTMENT has the following columns :


DEPT_ID
DEPT_NAME
MANAGER

Which of the following will ONLY allow USER1 to modify the DEPT_NAME column?

  • A. GRANT ALTER ON TABLE department TO user1

  • B. GRANT ALTER (dept_name) ON TABLE department TO user1

  • C. GRANT UPDATE ON TABLE department TO user1

  • D. GRANT UPDATE (dept_name) ON TABLE department TO user1

Question 5

An index named EMPID_X exists for a table called EMPLOYEE. Which of the following will allow USER1 to drop the index?

  • A. GRANT DELETE ON TABLE employee TO user1

  • B. GRANT DELETE ON INDEX empid_x TO user1

  • C. GRANT INDEX ON TABLE employee TO user1

  • D. GRANT CONTROL ON INDEX empid_x TO user1

Question 6

USER1 holds CONTROL privilege on table TABLE1. Which two of the following statements is USER1 allowed to execute?

  • A. GRANT CONTROL ON table1 TO user2

  • B. GRANT LOAD ON table1 TO user2

  • C. GRANT INSERT, UPDATE ON table1 TO user2 WITH GRANT OPTION

  • D. GRANT BINDADD ON table1 TO PUBLIC

  • E. GRANT ALL PRIVILEGES ON table1 TO PUBLIC

Question 7

A user with SYSADM authority issues the following statement:

GRANT ALL PRIVILEGES ON TABLE payroll.employee TO user1 WITH GRANT OPTION

Which of the following statements is USER1 authorized to execute?

  • A. GRANT CONTROL ON TABLE payroll.employee TO user2

  • B. GRANT UPDATE ON TABLE payroll.employee TO user2

  • C. GRANT CREATE_EXTERNAL_ROUTINE ON TABLE payroll.employee TO user2

  • D. GRANT LOAD ON TABLE payroll.employee TO user2

Question 8

A user-defined function named U.UDF1 that takes an input parameter of type INTEGER has been created by USER1. Which two of the following statements would give USER2 the privileges needed to use function U.UDF1 in a query?

  • A. GRANT USE ON FUNCTION u.udf1 TO user2

  • B. GRANT EXECUTE ON FUNCTION u.udf1 TO user2

  • C. GRANT USE ON FUNCTION u.udf1 (INTEGER) TO user2

  • D. GRANT EXECUTE ON PACKAGE u.udf1 (INTEGER) TO user2

  • E. GRANT EXECUTE ON FUNCTION u.* TO user2

Question 9

What does the following statement do?

GRANT REFERENCES (col1, col2) ON TABLE table1 to user1 WITH GRANT OPTION

  • A. Gives USER1 the ability to refer to COL1 and COL2 of table TABLE1 in queries, along with the ability to give this authority to other users and groups.

  • B. Gives USER1 the ability to refer to COL1 and COL2 of table TABLE1 in views, along with the ability to give this authority to other users and groups.

  • C. Gives USER1 the ability to define a referential constraint on table TABLE1 using columns COL1 and COL2 as the parent key of the constraint.

  • D. Gives USER1 the ability to define a referential constraint on table TABLE1 using columns COL1 and COL2 as the foreign key of the constraint.

Question 10

USER1 is the owner of TABLE1. Assuming USER1 only holds privileges for TABLE1, which of the following is the best way to remove all privileges USER1 holds?

  • A. REVOKE CONTROL ON table1 FROM user1

  • B. REVOKE ALL PRIVILEGES ON table1 FROM user1

  • C. REVOKE CONTROL ON table1 FROM user1

    REVOKE ALL PRIVILEGES ON table1 FROM user1

  • D. REVOKE ALL ON table1 FROM user1

Question 11

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?

  • A. GRANT INSERT ON t.table1 TO user2

  • B. GRANT CONTROL ON v.view1 TO user2

  • C. GRANT ALL PRIVILEGES ON v.view1 TO user2

  • D. GRANT INSERT ON v.view1 TO user2

Question 12

Which of the following will provide all users with the ability to perform DDL, but not DML, operations on table T.TABLE1?

  • A. GRANT ALL PRIVILEGES ON t.table1 TO ALL USERS

  • B. GRANT ALTER, INDEX ON t.table1 TO ALL USERS

  • C. GRANT ALL PRIVILEGES ON t.table1 TO PUBLIC

  • D. GRANT ALTER, INDEX ON t.table1 TO PUBLIC



DB2 Universal Database V8.1 Certification Exam 700 Study Guide
DB2 Universal Database V8.1 Certification Exam 700 Study Guide
ISBN: 0131424653
EAN: 2147483647
Year: 2003
Pages: 68

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net