Free C2090-320 Exam Braindumps
DB2 11 Fundamentals for z/OS exam Questions 51–55 (page: 12)

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?

  1. UR
  2. RR
  3. CS
  4. RS

Answer(s): A


Reference:

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



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

  1. Compiler
  2. Linkage Editor
  3. Bind command
  4. 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



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

  1. SYSIBM.SYSTABLES
  2. SYSIBM.SYSINDEXES
  3. SYSIBM.SYSINDEXPART
  4. SYSIBM.SYSINDEXSPACESTATS
  5. SYSIBM.SYSTABLESPACESTATS

Answer(s): D,E



A clone table can only be created in which of the following?

  1. A simple table space
  2. A universal table space
  3. An auxiliary table space
  4. A classic segmented table space

Answer(s): B


Reference:

https://community.toadworld.com/platforms/ibmdb2/w/wiki/6841.clone-tables



Which privilege or authority is required to use the DSN command?

  1. None
  2. SYSADM
  3. SECADM
  4. EXECUTE

Answer(s): B


Reference:

https://www.ibm.com/support/knowledgecenter/en/SSEPEK_10.0.0/comref/src/tpc/ db2z_cmd_bindplan.html



Viewing page 12 of 26
Viewing questions 56 - 60 out of 124 questions


Post your Comments and Discuss IBM C2090-320 exam prep with other Community members:

AI Tutor AI Tutor 👋 I’m here to help!