New Questions 2

Which of the following describes OLTP workload rather than an analytics workload?

A. Extreme data volume

B. Temporary or intermediate staging of data

C. Set-oriented processing and bulk operations

D. A large number of short, discrete, atomic transactions

View Answer

New Questions 3

While DSN is running, which of the following commands CANNOT be successfully executed?

A. u2013STOP DB2

B. u2013START DB2

C. u2013TERM UTILITY

D. u2013DISPLAY UTILITY

View Answer

New Questions 4

Which package level privileges does the user smith have when the following statement is executed? GRANT ALL ON PACKAGE clct1.pkg1 TO smith;

A. GRANT, COPY, BIND, RUN

B. BIND, EXECUTE, COPY, RUN

C. CREATE, COPY, RUN, EXECUTE

D. COPY, BINDADD, SQL, EXECUTE

View Answer

New Questions 5

Which of the following are contained in the PLAN_TABLE? (Choose two.)

A. RUNSTATS recommendations

B. Access to LOB values, which are stored separately from the base table

C. Access to parent or dependent tables needed to enforce referential constraints

D. Whether an index access or table space scan is used for each access to a table

E. The join methods and types that are used, and the order in which DB2 joins the tables

View Answer

New Questions 6

Which statement is TRUE regarding catalog table SYSIBM.SYSROUTINES?

A. Contains scheduled tasks for the administrative scheduler

B. Contains information about UDFs, BIFs and stored procedures

C. Contains information about bound packages

D. Contains information about UDFs and stored procedures

View Answer

New Questions 7

Which of the following statements concerning a bi-temporal table is TRUE?

A. It provides business history, but is not useful for audit purposes

B. It is defined with both an application period and a system period

C. It is useful for audit purposes, but is not useful for business history

D. It contains data reflecting two different times u2013 current time and one previous time

View Answer

New Questions 8

You want to limit the access of a table to allow users to only see certain columns and/or rows.

Which of the following options CANNOT be used to accomplish this?

A. A view

B. Multilevel security

C. An MQT (Materialized Query Table)

D. A combination of row permissions and column masks

View Answer

New Questions 9

Which component of the program preparation produces a DBRM (Database request Module)?

A. Compiler

B. Linkage Editor

C. Bind command

D. Precompiler/Coprocessor

View Answer

New Questions 10

Which of the following can be defined on the basis of a query?

A. An alias

B. A base table

C. An accelerator-only table

D. A materialized query table

View Answer

New Questions 11

In which address space would a native SQL stored procedure run?

A. WLM

B. DIST

C. DBM1

D. The address space of the calling program

View Answer