IBM DB2 11 Fundamentals for z/OS - C2090-320 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

A stored procedure needs to issue a dynamic SQL statement (SELECT) at runtime. The stored procedure's owner ID must be used for the authorization check (whether or not the SELECT is allowed).
Which BIND parameter setting can you use to accomplish this ?

A. DYNAMICRULES(INVOKERUN) B. DYNAMICRULES(RUN) C. DYNAMICRULES(DEFINEBIND) D. DYNAMICRULES(BIND)

Discussion 0

Correct Answer: D Vote an answer

Question 2

Which DB2 address space manages DB2 locking?

A. MSTR B. DIST C. IRLM D. DBM1

Discussion 0

Correct Answer: C Vote an answer

Question 3

Which of the following SQL constructs does NOT provide information about the success or failure of the SQL statement that was just executed?

A. SQLSTATE B. SQLCODE C. SQLCA D. SQLDA

Discussion 0

Correct Answer: D Vote an answer

Question 4

A summary table can be easily maintained using which of the following?

A. A partitioned table B. A materialized query table C. An auxiliary table D. A bi-temporal table

Discussion 0

Correct Answer: B Vote an answer

Question 5

How can a user-defined function (UDF) be invoked?

A. Directly via a RUN PROGRAM command B. Via a CALL statement using SPUFI C. Via a CALL statement from within an application program D. Via an SQL SELECT statement

Discussion 0

Correct Answer: B Vote an answer

Question 6

Which isolation level is described by the following?
The ISOLATION (..) option allows maximum concurrency with data integrity. Under the ISOLATION (..) option, a transaction holds locks only on its uncommitted changes and on the current row of each of its cursors.

A. RS B. UR C. RR D. CS

Discussion 0

Correct Answer: D Vote an answer