Is this exam completely free?

ExamCademy offers a free preview for every exam, covering around 20% of the total questions. Full access to all questions is available for free by signing up for an account. Optional supporters unlock AstroTutor (AI tutor) and advanced study modes.

Can I practice IT certification exams from Microsoft, AWS, or CompTIA?

Yes! ExamCademy supports a wide range of IT certification exams including Microsoft Azure, AWS Cloud Practitioner, and CompTIA A+ and Security+.

How accurate are the mock exams?

Our practice questions are community-created and moderator-reviewed to align with realistic exam objectives, style, and difficulty.

C2090-612 by IBM - Page 1 | ExamCademy

Mode Selection

Sort:

Question 1

Question 2

Question 3

Question 4

Question 5

Question 6

Question 7

Question 8

Question 9

Question 10

Question 11

Question 12

Question 13

Question 14

Question 15

Question 16

Question 17

Question 18

Question 19

Question 20

Question 21

Question 22

Question 23

Question 24

Question 25

Page 1 of 6 • Questions 1-25 of 126

1 2 3 4 5

→

Know a question that should be here? Contribute to this exam

Workload Manager (WLM) manages how many concurrent stored procedures can run in an address space and the number of concurrent stored procedures in an address space cannot exceed the value of the NUMTCB parameter. Which statement about the value of NUMTCB is correct?

A NUMTCB parameter must be set to 1 for Java stored procedures.
B NUMTCB parameter must be set to 1 for REXX stored procedures.
C NUMTCB parameter can be a value greater than 1 for native SQL stored procedures.
D NUMTCB parameter can be a value greater than 1 when a stored procedure invokes DB2 utilities.

Which two of the following DB2 performance features will ignore clustering in favor of faster insert performance? (Choose two.)

A Append
B Inline LOBs
C Member cluster
D Volatile table
E Include columns

When is a merge scan join a well performing access path?

A When the number of qualifying rows of the inner and outer table are both large.
B When the query references at least two dimensions and the STARJOIN subsystem parameter is 1.
C When the number of rows in the outer table is small and the number of pages accessed in the inner table is small.
D When the matching columns of the inner table are in a non-clustering index or the outer table has duplicate qualifying rows.

What trace class will show deadlock information?

A Audit class 3.
B Statistic class 3.
C Accounting class 1.
D Performance class 8.

Which DSNZPARM will define the number of RID Blocks in the RID Pool?

A NUMTCB
B MAXRBLK
C CONDBAT
D URLGWTH

When DB2 detects at runtime requiring a large amount of data to be read, which prefetch method is used more often?

A List prefetch
B Dynamic prefetch
C Sequential prefetch
D Skip sequential prefetch

In order to retain an access path across a rebind which of the following commands could be used?

A BIND PLAN
B REBIND PACKAGE(PK1) REOPT(ONCE)
C BIND PACKAGE (PK1) EXPLAIN(YES)
D REBIND PACKAGE (PK1) PLANMGMT(BASIC)

The available window to reorganize table spaces is being reduced. What data can provide information to allow for a priority list of candidate table spaces for reorganization based on recent activity with no recent RUNSTATS execution?

A SYSIBM.SYSCOPY
B SYSIBM.SYSTABLES
C SYSIBM.SYSINDEXES
D SYSIBM.SYSTABLESPACESTATS

Which DB2 trace is utilized to capture overall subsystem virtual memory consumption?

A The DB2 audit trace.
B The DB2 statistics trace.
C The DB2 connection trace.
D The DB2 accounting trace.

What is a consideration when specifying DATA CAPTURE CHANGES?

A Can be specified for capturing changes to an XML object.
B To minimize logging, specify NOT LOGGED when DATA CAPTURE CHANGES is specified.
C REFRESH TABLE statement is not allowed with a table defined with DATA CAPTURE CHANGES.
D You cannot turn on DATA CAPTURE CHANGES if the table space is in advisory REORGpending.

In using plan stability, what storage space requirement should be of carefully monitored?

A MINSTOR
B DSNDB07
C DSNDB01.SPT01
D DSN_STATEMNT_TABLE

What two parameters allow DB2 to keep a copy of a dynamically prepared statement in the cache?

A KEEPDYNAMIC(YES) and CACHEDYN=YES
B KEEPDYNAMIC(NO) and CACHEDYN=NO
C KEEPDYNAMIC(NO) and REOPT(ALWAYS)
D KEEPDYNAMIC(YES) and REOPT(ALWAYS)

What START TRACE command provides detailed lock suspend and lock contention trace information?

A START TRACE(AUDIT)
B START TRACE(STATS) CLASS(1)
C START TRACE(PERFM) CLASS(30) IFCID(44,45)
D START TRACE(ACCTG) CLASS(1,2,3) DEST(SMF)

When converting a multiple table segmented table space to partition-by-growth table spaces, which statement is correct?

A DSMAX may have to be increased.
B Storage requirements for EDMDBDC will decrease.
C Storage requirements for some applications will increase.
D The dynamic statement cache should be increased to handle the additional SQL statements.

What would be a reason for altering the clustering index of a table?

A To increase free space.
B Because the clustering index has to match the primary index.
C To choose a clustering index to favor batch sequential processing.
D To choose a clustering index to promote sequential inserts at the end of the table space.

What is the DSNZPARM that determines the maximum amount of temporary storage in the work file data base for a single user at any given time?

A MAXRBLK
B MAXDBAT
C MAXKEEPD
D MAXTEMPS

In the CFRM policy, what is the purpose of the PREFLIST?

A To identify the size of the structure.
B To identify all the DB2 members in the group.
C To identify the preferences for DB2 restart in the event of a disconnection.
D To identify the preferences for structure rebuild/reallocation during a coupling facility failure.

What DB2 command when issued displays what migration mode the catalog is in?

A DSNC DISPLAY
B DISPLAY GROUP
C MODIFY irlmproc,STATUS
D DISPLAY DATABASE (DSNDB06)

Which authority level allows a user to run utilities that change the data in an application database?

A DBCTRL
B SYSOPR
C DBMAINT
D INSTALL SYSOPR

Which trace gives information about frequent log space shortages?

A Audit trace class(8)
B Statistics trace class(3)
C Accounting trace class(10)
D Performance trace class(4)

When creating a stored procedure that will access non DB2 resources using the authorization ID of the user invoking the stored procedure, what value must the
SECURITY clause specify?

A DB2
B RACF
C USER
D DEFINER

Row and column level security can be implemented using mask and permissions. Which two DB2 authorities are able to create a mask or permission? (Choose two.)

A SECADM authority.
B ACCESSCTRL authority.
C DATAACCESS authority.
D SYSADM authority when SEPARATE_SECURITY=NO.
E The owner of the object as he/she has that authority implicitly.

Which connection type can exploit trusted connections?

A IMS
B CAF
C CICS
D RRSAF

What should be implemented in order to audit all the activity of the install SYSADM?

A DATA CAPTURE CHANGES should be set on all tables.
B A DB2 audit policy should be established, identifying the SYSADM ID to be audited.
C The DB2 authorization exit should be modified to convert the install SYSADM ID to another ID
D Nothing can be done, the install SYSADM has the highest authority and is not controlled or monitored.

Which attribute(s) determine the absolute maximum number of partitions for a partition-by-growth table space?

A MAXPARTITIONS
B MAXPARTITIONS, DSSIZE
C MAXPARTITIONS, page size
D MAXPARTITIONS, DSSIZE, page size

C2090-612Preview