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

May be you shouldn't then?

I remember somebody already answered these same questions a couple of days ago.

I have replied for ur questions..have a look...
Did u prepare with Roger Sanders book?