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-614 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

That's the end of the Preview

Create a free account to unlock all questions for this exam.

Log In / Sign Up

Page 1 of 4 • Questions 1-25 of 97

1 2 3 4

→

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

Which constraints are used to tell the DB2 Optimizer to consider business rules that are not enforced by the database manager?

A Check constraints
B Default constraints
C Informational constraints
D Referential integrity constraints

The following message is frequently seen in the DB2 Diagnostics Log file (db2diag.log):
MESSAGE:

ADM5502W -
The escalation of "28581" locks on table "TEST.TABLE1" to lock intent "X" was successful.
Which two database configuration parameter settings should be checked? (Choose two.)

A LOCKLIST
B MAXAPPLS
C MAXLOCKS
D MAXAGENTS
E LOCKTIMEOUT

Consider the following statement:

Question Image

Which indexes should be created for optimal query performance?

A CREATE INDEX emp_idx ON employee (workdept); CREATE INDEX dept_idx ON department (deptno);
B CREATE INDEX emp_idx ON employee (workdept) CLUSTER; CREATE INDEX dept_idx ON department (deptname, deptno);
C CREATE INDEX emp_idx ON employee (workdept, lastname, job); CREATE INDEX dept_idx ON department (deptname, deptno);
D CREATE INDEX emp_idx ON employee (lastname, job, workdept) CLUSTER;

What will occur when a database administrator adds a new automatic storage path to an existing storage group?

A New table spaces will start consuming storage on the new path.
B Existing table spaces will not consume storage on the new path.
C The storage group will be placed in "Rebalance Pending" mode.
D DB2 will verify that space is available on the storage path specified.

Which monitoring tool can be used to obtain stripe set information for database managed storage table spaces?

A The MON_GET_CONTAINER table function.
B The SNAP_GET_TBSP_PART table function.
C The SNAPTBSP_RANGE administrative view.
D The TS_GET_CONTAINER administrative view.

Which statement about value compression is correct?

A To use value compression, you must have a license for the DB2 Storage Optimization Feature.
B Value compression uses a page-level dictionary-based compression algorithm to compress data based on repetition of values found in a single column.
C Value compression involves removing duplicate entries for a value, only storing one copy, and keeping track of the location of any references to the stored copy.
D When value compression is used, the byte count of compressed NULLs, zeros, and blanks might be larger than that of the uncompressed version of the same

Which statement about compression dictionaries is FALSE?

A Page-level dictionaries are stored in hidden rows within the table.
B Table-level dictionaries are stored in hidden rows within the table.
C Page-level dictionaries are automatically created or recreated by the database manager as pages are filled.
D Table-level dictionaries are automatically created or recreated as by the database manager as pages are filled.

What advantage do block-based buffer pools offer compared to regular buffer pools?

A They improve the performance of sequential prefetching by reading contiguous pages from disk and writing them into contiguous pages in a buffer pool.
B They improve the performance of random I/O by reading non-contiguous pages from disk and writing them into near-contiguous free space in a buffer pool.
C They improve the performance of vectored reads by retrieving non-contiguous pages from disk, combining them into extent-sized blocks, and writing the blocks into contiguous pages in a buffer pool.
D They improve the performance of scattered writes by retrieving non-contiguous pages from a buffer pool, combining them into extent-sized blocks, and writing

The following query is executed frequently against the SALES table:
SELECT sales_person, region FROM sales WHERE region = 'Quebec'
Which statement will create an index for optimal query performance?

A CREATE INDEX sales_idx ON sales (region)
B CREATE INDEX sales_idx ON sales (sales_person)
C CREATE INDEX sales_idx ON sales (region, sales_person)
D CREATE INDEX sales_idx ON sales (region) INCLUDE (sales_person)

Which monitoring tool can be used to find out how many data pages have been read from the table space containers for regular, large, and temporary table spaces?

A The MON_DB_SUMMARY administrative view.
B The MON_BP_UTILIZATION administrative view.
C The MON_GET_ACTIVITY_DETAILS table function.
D The MON_GET_EXTENT_MOVEMENT_STATUS table function.

What is the FAILARCHPATH database configuration parameter used for?

A To specify a path that DB2 will use to look for archive log files that are needed for a roll forward recovery operation.
B To specify a path to which DB2 will attempt to store a copy of archive log files to protect against accidental deletion.
C To specify a path to which DB2 will attempt to store a copy of both active and archive log files to protect against disk failure and power outages.
D To specify a path to which DB2 will attempt to store archive log files if they cannot be written to the primary or secondary archive destination because of a

An auxiliary HADR standby database must use which HADR sync mode?

A SYNC
B ASYNC
C NEARSYNC
D SUPERASYNC

What is the recommended method for removing old backup images and log files for a DB2 10.1 database?

A Manually delete old backups and logs.
B Utilize the PRUNE LOGFILE PRIOR TO command to remove old backups and logs.
C Utilize the PRUNE HISTORY AND DELETE command to remove old backups and logs.
D Set the DB2PRUNE_ACTION_LOG configuration parameter to a desired date before generating a new backup.

Which diagnostic tool can be used to collect metrics on individual SQL statement executions?

A db2dart
B A snapshot monitor
C A statement event monitor
D The MON_GET_UNIT_OF_WORK_DETAILS table function

Which statement about DB2 Merge Backup is FALSE?

A It can be used to merge offline backups to build full offline table space backups.
B It can be used to merge SNAPSHOT and TSM tape backup images to create a full database backup image.
C It can be used merge multiple offline database backups to build a cumulative single offline database backup.
D It can be used to merge backups on a machine that is different from the machine where the backup has been created in stand-alone mode.

What two types of information can be obtained with the MON_GET_TABLESPACE monitor table function? (Choose two.)

A Table space available space
B Table space read and write activity
C Table space container assignments
D Table level activity within a table space
E Table space backup and recovery information

Which Workload Manager (WLM) objects can the COLLECT ACTIVITY DATA clause be used with?

A Data class, work class, and a limit
B Data class, action class, and a threshold
C Service subclass, action class, and a limit
D Service subclass, work class, and a threshold

Where is the HADR_TARGET_LIST configuration parameter set?

A On the primary database only.
B On all participating databases.
C On the tertiary standby databases.
D On the auxiliary standby databases only.

What is the default user workload class that is created for each database table?

A DEFAULT_USER
B SYSUSERDEFAULTWLM
C SYSDEFAULTUSERWORKLOAD
D SYS_DEFAULT_USER_WORKLOAD

Which statement about dropped table recovery is correct?

A Multiple dropped tables can be recovered with a single table space-level restore operation.
B By default, the DROPPED TABLE RECOVERY option is off when a new table space is created.
C The dropped table recovery feature lets you recover only dropped table data with a database-level restore operation.
D For a dropped table to be recoverable, the table space in which the table resides must have the DROPPED TABLE RECOVERY option turned on.