DB2 11 Fundamentals for z/OS exam (C2090-320) Free Practice Test

Question 1

How can a stored procedure be invoked?

A. Via a CALL statement from within an application program

B. Via a CALL statement using SPUFI

C. Directly via a RUN PROGRAM command

D. Via an SQL SELECT statement

Correct Answer: A

Question 2

Which of the following utilities CANNOT be executed from the DB2 utilities panel in DB2I?

A. BACKUP SYSTEM

B. REORG

C. COPY

D. STOSPACE

Correct Answer: A

Question 3

If a scrollable cursor is INSENSITIVE, which of the following applies?

A. The cursor is read only

B. The cursor has sensitivity to changes that are made to the database after the result table is materialized

C. The select-statement must not contain an SQL data change statement

D. WITH ROWSET POSITIONING is not allowed

Correct Answer: A

Question 4

Given the following INDEX definition, which attributes apply to this index? (Choose two.)

A. The index is partitioned

B. The maximum total size of the index is 1 GB

C. The index data sets are user-managed

D. The index is unique and in ascending order

E. The index data sets are DB2-managed

Correct Answer: A,C

Question 5

In order to evaluate the real-time relative disorganization of an index, which catalog table would you query?

A. SYSIBM.SYSINDEXPART

B. SYSIBM.SYSINDEXSPACESTATS

C. SYSIBM.SYSINDEXSTATS

D. SYSIBM.SYSINDEXES

Correct Answer: A

Question 6

You need to add the employee picture to the employee table. Which of the following is the appropriate built-in data type for storing images?

A. CLOB

B. DBCLOB

C. BLOB

D. VARGRAPHIC

Correct Answer: A

Question 7

Which catalog table contains the IN, OUT and INOUT parameters used in a stored procedure?

A. SYSIBM.SYSVARIABLES

B. SYSIBM.SYSROUTINES

C. SYSIBM.SYSSTMT

D. SYSIBM.SYSPARMS

Correct Answer: B

Welcome to TestSimulate

IBM DB2 11 Fundamentals for z/OS (C2090-320) Free Practice Test