Results 1 to 3 of 3

Thread: certfication

  1. #1
    Join Date
    Oct 2003
    Location
    York UK
    Posts
    9

    Unanswered: certfication

    Could you please help me with following certification question. Tomorrow I am appearing for it.

    USER3 is running a program A.APP1 that calls stored procedure P.PROC1.
    As an administrator, which of the following statements should be executed to give USER3 the appropriate privilege to be able to execute the code found in stored procedure P.PROC1?

    A. GRANT EXECUTE ON PACKAGE a.app1 TO user3
    B. GRANT EXECUTE ON PROCEDURE a.app1 TO user3
    C. GRANT EXECUTE ON FUNCTION p.proc1 TO user3
    D. GRANT EXECUTE ON PROCEDURE p.proc1 TO user3

    ----------------


    Cataloging a remote database server from a Linux, UNIX, or Windows gateway is:

    A. performed to identify the location of the clients.
    B. performed to identify the server the DB2 database manager is on.
    C. never performed in DB2, as only one database per node is allowed, so cataloging a node automatically catalogs the database at that node.
    D. performed on a Linux, UNIX, or Windows machine to open the catalogs in the DB2 database server and present a user with a list of all accessible tables in that database.
    ----------------
    Given a read-only application that requires consistent data for every query, which of the following isolation levels should it use to provide the most concurrency with other applications doing updates?

    A. Read Stability
    B. Repeatable Read
    C. Cursor Stability
    D. Uncommitted Read

    Thanks for you help

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1

    Re: certfication

    Originally posted by rusiar
    Could you please help me with following certification question. Tomorrow I am appearing for it.
    May be you shouldn't then?

    I remember somebody already answered these same questions a couple of days ago.
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Oct 2003
    Posts
    18
    I have replied for ur questions..have a look...
    Did u prepare with Roger Sanders book?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •