New Questions 3

In order to run a DB2 program, the user issues the following commands: TSO prompt: READY

USER enters: DSN SYS(SSTR)

USER enters: RUN PROGRAM(MYPROG)

USER enters: END What is the result?

A. DB2 does not allow these commands

B. DSN command can not be used to run a program

C. Start a DSN session with DB2 subsystem SSTR, run a program and end the DSN session

D. Start a DSN session with system parameters SSTR, run a program and end the DSN session

New Questions 4

Which statement is TRUE regarding ROLLBACK processing?

A. It only reads active logs

B. It always needs archive logs

C. It can never be processed just from memory

D. It uses output buffers, active and archive logs

New Questions 5

Which of the following statements about a system-period temporal table is TRUE?

A. Rows can be archived into a history table which is always read only

B. Every row has a pair of timestamps which is set and managed by the application

C. AN SQL query for auditing can be run against current data or history data, but not both

D. The table contains only the current active rows

New Questions 6

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

A. SQLCA

B. SQLDA

C. SQLCODE

D. SQLSTATE

New Questions 7

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

New Questions 8

Given the following table and index definitions, what type of index will be created?

A. Non-partitioned index

B. Non-partitioned secondary index

C. Data-partitioned secondary index

D. Data-partitioned partitioning index

New Questions 9

You want to see all messages that were generated by one specific DB2 subsystem such as log switches and timeout messages. Which job log would show all of these?

A. MSTR

B. DBM1

C. DIST

D. IRLM

New Questions 10

Which BIND option determines when DB2 will do authorization checking?

A. DEFER

B. DEPLOY

C. VALIDATE

D. CURRENTDATA

New Questions 11

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

New Questions 12

Which of the following can activate a trigger?

A. A row is inserted

B. A table or view is created

C. A check constraint is defined

D. A referential constraint is violated