IBM IBM Certifications C2090-320 Questions & Answers

• Question 71:

  Which catalog tables are populated by RTS? (Choose two.)

  A. SYSIBM.SYSTABLES

  B. SYSIBM.SYSINDEXES

  C. SYSIBM.SYSINDEXPART

  D. SYSIBM.SYSINDEXSPACESTATS

  E. SYSIBM.SYSTABLESPACESTATS

  Correct Answer: DE

• Question 72:

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

  A. Compiler

  B. Linkage Editor

  C. Bind command

  D. Precompiler/Coprocessor

  Correct Answer: D

  Reference: https://www.ibm.com/support/knowledgecenter/en/SSGMGV_3.1.0/com.ibm.cics.ts31.doc/ dfhtk/dfhtk20.htm

• Question 73:

  Consider the following question: "What is the average salary by sex within education level?" An occasional uncommitted record can be tolerated in the average.

  Which of the following is the most appropriate isolation level for this?

  A. UR

  B. RR

  C. CS

  D. RS

  Correct Answer: A

  Reference: https://vdocuments.net/db2-app-dba-module-i.html

• Question 74:

  Which SQL statement can be used to provide diagnostic information about the last SQL statement that was executed?

  A. GET DIAGNOSTICS

  B. DESCRIBE OUTPUT

  C. DECLARE STATEMENT

  D. SET CURRENT DEBUG MODE

  Correct Answer: A

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

• Question 75:

  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

  Correct Answer: D

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

• Question 76:

  Which of the following tables can be used to set the default of the special register CURRENT APPLICATION COMPATIBILITY for remote users?

  A. The resource limit facility table authid.DSNRLMTxx

  B. The DB2 catalog table SYSIBM.SYSENVIRONMENT

  C. The profile table SYSIBM.DSN_PROFILE_ATTRIBUTES

  D. The communications database table SYSIBM.USERNAMES

  Correct Answer: C

• Question 77:

  What are two major encoding schemes? (Choose two.)

  A. UNIX

  B. Linux

  C. CCSID

  D. Unicode

  E. EBCDIC

  Correct Answer: DE

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

• Question 78:

  We want to increase the salary for each employee (EMP) in the department (WORKDEPT) D11 and we want to see the new salaries(SALARY) for each of them.

  Which single SQL statement will do this?

  

  A. B. C. D.

  Correct Answer: D

• Question 79:

  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

  Correct Answer: C

• Question 80:

  COL1 is defined as CHAR(05) and contains CHAR(`12345'). Which of the following expressions returns the digits 12345 for further calculation?

  A. HEX(COL1)

  B. DEC(COL1)

  C. PACK(COL1)

  D. DIGITS(COL1)

  Correct Answer: B