QUESTION: 49

Which statement is TRUE regarding catalog table SYSIBM.SYSROUTINES?

Contains scheduled tasks for the administrative scheduler
Contains information about UDFs, BIFs and stored procedures
Contains information about bound packages
Contains information about UDFs and stored procedures

Answer(s): D

Reference:

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

Reveal Solution Next Question

QUESTION: 50

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

GET DIAGNOSTICS
DESCRIBE OUTPUT
DECLARE STATEMENT
SET CURRENT DEBUG MODE

Answer(s): A

Reference:

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

Reveal Solution Next Question

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?

UR
RR
CS
RS

Answer(s): A

Reference:

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

Reveal Solution Next Question

QUESTION: 52

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

Compiler
Linkage Editor
Bind command
Precompiler/Coprocessor

Answer(s): D

Reference:

https://www.ibm.com/support/knowledgecenter/en/SSGMGV_3.1.0/com.ibm.cics.ts31.doc/dfhtk/ dfh CK2 0.htm

Reveal Solution Next Question

Free C2090-320 Exam Braindumps (page: 14)

QUESTION: 49

Reference:

QUESTION: 50

Reference:

QUESTION: 51

Reference:

QUESTION: 52

Reference:

C2090-320 Exam Discussions & Posts