← Back to exam page

Free C2090-320 – DB2 11 Fundamentals for z/OS Practice Test Question

Free demo downloads

Loading demo links...

Showing 7–9 of 10 questions

Question 7

The following warning message is issued when the last available active log data set is 5% full:

DSNJ110E – LAST COPY n ACTIVE LOG DATA SET IS nnn PERCENT FULL

What will happen if you ignore this message?

Select an option, then click Submit answer.

  • ○

    DB2 will shut down if it reaches the 100% full condition
  • ○

    DB2 will overwrite the oldest archive log without archiving
  • ○

    DB2 will stop any activity that requires log writes if it reaches the 100% full condition
  • ○

    DB2 will automatically allocate more active log data sets as long as there are still less than 93 of them
Question 8

Given the following CREATE TABLE statement, and a unique index on column EMPID, which set of SQL statements is valid?

Select an option, then click Submit answer.

  • ○

    Option A
  • ○

    Option B
  • ○

    Option C
  • ○

    Option D
Question 9

Which of the following is a characteristic of a stand-alone utility?

Select an option, then click Submit answer.

  • ○

    It can only be executed using JCL
  • ○

    It can only be executed by a user with SYSADM
  • ○

    It can only be executed if no other utilities are running
  • ○

    It can only be executed in a non-data sharing environment