Scribd Logo
Upload

Welcome to Scribd!

  • 76 views

    DB2 Security: Sample Questions

    Uploaded by

    praveen123j
    This document contains 10 sample questions about DB2 security. It tests knowledge of privileges like DBADM, SYSADM, and CONTROL as well as commands for changing passwords, granting privileges, and catalog views for checking privileges. The answers are provided at the end.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PDF, TXT or read online from Scribd

    DB2 Security: Sample Questions

    Uploaded by

    praveen123j
    76 views3 pages
    This document contains 10 sample questions about DB2 security. It tests knowledge of privileges like DBADM, SYSADM, and CONTROL as well as commands for changing passwords, granting privileges, and catalog views for checking privileges. The answers are provided at the end.

    Original Title

    Db2cert2v8 Sample

    Copyright

    © Attribution Non-Commercial (BY-NC)

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document contains 10 sample questions about DB2 security. It tests knowledge of privileges like DBADM, SYSADM, and CONTROL as well as commands for changing passwords, granting privileges, and catalog views for checking privileges. The answers are provided at the end.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    76 views3 pages

    DB2 Security: Sample Questions

    Uploaded by

    praveen123j
    This document contains 10 sample questions about DB2 security. It tests knowledge of privileges like DBADM, SYSADM, and CONTROL as well as commands for changing passwords, granting privileges, and catalog views for checking privileges. The answers are provided at the end.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 3

    DB2 UDB V8.

    1 Family Fundamentals

    DB2 Security: Sample Questions

    1) Which of the following authority can be granted to the dba group using the
    GRANT statement?
    a. SYSADM
    b. SYSCTRL
    c. SYSMAINT
    d. DBADM
    2) Which of the following authority can access data in the database? Choose all that
    apply.
    a. DBADM
    b. SYSMAINT
    c. SYSCTRL
    d. SYSADM
    3) Which of the following DB2 command can be used to change bob’s password?
    a. CHANGE PASSWORD USER bob OLD bobpass NEW newpass
    b. CONNECT TO sample USER bob USING bobpass NEW newpass
    c. CONNECT TO sample USER bob USING bobpass NEW newpass
    CONFIRM newpass
    d. No DB2 command can be used to change the password of a user ID

    4) Which of the following is not a valid authentication type?


    a. CLIENT
    b. TRUST_ALLCLNTS
    c. KRB_SERVER_ENCRYPT
    d. KERBEROS

    5) Which of the following statement will fail? Choose all that apply.
    a. GRANT USE OF TABLESPACE syscatspace TO db2admin
    b. GRANT USE OF TABLESPACE tempspace1 TO PUBLIC
    c. GRANT UPDATE (salary, bonus) ON employee TO PUBLIC
    d. GRANT ALL PRIVILEGES ON TABLE employee TO user1

    6) After a database is created, which of the following is true?


    a. Grant CONNECT, CREATETAB, BINDADD, and IMPLICIT_SCHEMA
    privileges to PUBLIC
    b. Grant SELECT on system catalog tables to PUBLIC
    c. Grant USE privilege for table space USERSPACE1 to PUBLIC
    d. Grant BIND and EXECUTE privileges on each successfully bound utility
    to PUBLIC
    e. All of the above

    DB2 Security: Sample Questions 1


    DB2 UDB V8.1 Family Fundamentals

    7) Which of the following privilege is required to create a new package in a database?


    a. CONTROL
    b. BIND
    c. EXECUTE
    d. BINDADD

    8) Given that the following commands are issued:


    connect to sample user db2admin
    grant control on employee to db2user
    revoke control on employee from db2user

    What privileges on table employee does db2user retain? Choose all that apply.
    a. CONTROL
    b. UPDATE
    c. SELECT
    d. ALTER
    e. db2user does not have any privilege on the employee table

    9) Which of the following system catalog view contains the grantee information of
    the REFERENCE privilege on a view?
    a. SYSCAT.VIEWS
    b. SYSCAT.TABLES
    c. SYSCAT.DBAUTH
    d. SYSCAT.TABAUTH
    e. SYSCAT.REFERENCES

    10) Which of the following statement will NOT allow db2user to grant the privileges
    specified in the statement to others?
    a. GRANT INDEX ON employee TO db2user WITH GRANT OPTION
    b. GRANT UPDATE (salary, bonus) ON employee TO PUBLIC WITH
    GRANT OPTION
    c. GRANT CONTROL ON employee TO PUBLIC WITH GRANT
    OPTION
    d. GRANT ALTERIN, CREATEIN, DROPIN ON schema1 TO db2user
    WITH GRANT OPTION

    DB2 Security: Sample Questions 2


    DB2 UDB V8.1 Family Fundamentals

    Answers:
    1. d
    2. a,d
    3. c
    4. b
    5. a,b
    6. e
    7. d
    8. b,c,d
    9. d
    10. c

    DB2 Security: Sample Questions 3

    You might also like