IBM IBM Certifications C2090-320 Questions & Answers

• Question 31:

  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?

  A. DB2 will shut down if it reaches the 100% full condition

  B. DB2 will overwrite the oldest archive log without archiving

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

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

  Correct Answer: D

  Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPEK_10.0.0/msgs/src/tpc/dsnj110e.html

• Question 32:

  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(RUN)

  B. DYNAMICRULES(BIND)

  C. DYNAMICRULES(INVOKERUN)

  D. DYNAMICRULES(DEFINEBIND)

  Correct Answer: A

  Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPEK_10.0.0/sqlref/src/tpc/ db2z_sql_createproceduresqlnative.html

• Question 33:

  Which of the following table space types does NOT support the use of REORG TABLESPACE SHRLEVEL (NONE)?

  A. LOB

  B. Simple

  C. Partition-by-range

  D. Partition-by-growth

  Correct Answer: C

• Question 34:

  User1 creates table user1.customers in a partitioned-by-growth (PBG) table space DB1.TS1

  Which of the following operations CANNOT be performed by user1 with implicit owner privileges on the table?

  A. Run the LOAD utility to load data

  B. Create a VIEW on the customers table

  C. Run the REORG utility to reorganize the data

  D. Issue an SQL LOCK TABLE statement against the customers table

  Correct Answer: B

• Question 35:

  Which of the following utilities or utility control statements require datasets for execution?

  A. LISTDEF

  B. OPTIONS

  C. TEMPLATE

  D. CHECK LOB

  Correct Answer: A

• Question 36:

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

  A. SYSIBM.SYSINDEXES

  B. SYSIBM.SYSINDEXPART

  C. SYSIBM.SYSINDEXSTATS

  D. SYSIBM.SYSINDEXSPACESTATS

  Correct Answer: D

  Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPEK_12.0.0/wnew/src/tpc/ db2z_cataloghistorytables.html

• Question 37:

  An external stored procedure is invoked using a CALL :hv (host variable). Which special register identifies the location of the procedure?

  A. CURRENT PATH

  B. CURRENT SCHEMA

  C. CURRENT PACKAGESET

  D. CURRENT ROUTINE VERSION

  Correct Answer: A

  Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/sqlref/src/tpc/ db2z_sql_call.html

• Question 38:

  Which option is used with the RECOVER utility when the data sets of the target objects have already been restored to a point of consistency by another process offline?

  A. LOGONLY

  B. FROMDUMP

  C. TOLASTCOPY

  D. CURRENTCOPYONLY

  Correct Answer: A

  Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPEK_12.0.0/ugref/src/tpc/ db2z_recoversyntax.html

• Question 39:

  Which job generates the subsystem parameter module?

  A. DSNTIJIN

  B. DSNTIJID

  C. DSNTIJUZ

  D. DSNTIJEN

  Correct Answer: C

  Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/intro/src/tpc/ db2z_zparm.html

• Question 40:

  Your application has a read-only cursor. You cannot tolerate uncommitted data but want to make sure that it provides the best concurrency. Which of the following bind options would provide the locking you need with optimistic locking?

  A. ISOLATION(UR)

  B. ISOLATION(RS)

  C. ISOLATION(CS) CURRENTDATA(NO)

  D. ISOLATION(CS) CURRENTDATA(YES)

  Correct Answer: D

  Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/perf/src/tpc/ db2z_isocs.html