Free IBM C2090-544 Practice Test & Real Exam Questions

Exam Code/Number: C2090-544
Exam Name/Title: DB2 9.7 Advanced DBA for LUW
Certification Provider: IBM
Corresponding Certification: DB2

Exam Questions: 106
Updated On: May 27, 2026

Question #10

You have a database with eight partitions on a single server. Immediately after executing the following command:
CREATE BUFFERPOOL mybp DEFERRED SIZE 3000
How much memory is consumed by buffer pool MYBP on the server?

A. 24000 pages

B. 192000 pages

C. 3000 pages

D. 0 pages

Discussion 0

Correct Answer: D Vote an answer

Question #11

A DBA needs to create a federated database and configure access to join data from three Oracle instances and one DB2 database. Which objects are needed to establish the specified connections?

A. 1 Oracle server , 1 DB2 server , 1 Oracle wrapper , 1 DB2 wrapper , and nicknames for each database

B. 3 Oracle servers , 1 DB2 server , 1 Oracle wrapper , 1 DB2 wrapper , and nicknames for each database

C. 1 Oracle server , 1 DB2 server , 3 Oracle wrappers , and nicknames for each database

D. 3 Oracle servers , 1 DB2 server , 3 Oracle wrappers , 1 DB2 wrapper , and nicknames for each database

Discussion 0

Correct Answer: B Vote an answer

Question #12

If you know that the table space containers for your database reside on RAID-5 3+p arrays, which registry variable should be assigned the value *:3 to help improve performance?

A. DB2_EXTENDED_IO_FEATURES

B. DB2_APM_PERFORMANCE

C. DB2_PARALLEL_IO

D. DB2_RESOURCE_POLICY

Discussion 0

Correct Answer: C Vote an answer

Question #13

A DBA would like to examine repartitioning options for a partitioned database named PRODDB. Which tool can be used to provide recommendations on re-partitioning?

A. Configuration Advisor

B. Design Advisor

C. Partition Assistant

D. Workload Manager

Discussion 0

Correct Answer: B Vote an answer

Question #14

A database called PRODDB has a weekly full backup taken on Saturday, non-cumulative (delta) backups taken daily, and a midweek cumulative backup that is taken on Wednesday. A database crash occurs on a Saturday prior to the full backup being taken.
What is the fastest way to restore the database?

A. RESTORE DB proddb TAKEN AT (Saturday);
RESTORE DB proddb INCREMENTAL AUTOMATIC TAKEN AT (Monday);
RESTORE DB proddb INCREMENTAL AUTOMATIC TAKEN AT (Tuesday);
RESTORE DB proddb INCREMENTAL AUTOMATIC TAKEN AT (Wednesday);
RESTORE DB proddb INCREMENTAL AUTOMATIC TAKEN AT (Thursday);
RESTORE DB proddb INCREMENTAL AUTOMATIC TAKEN AT (Friday);

B. RESTORE DB proddb TAKEN AT (Saturday);
RESTORE DB proddb INCREMENTAL AUTOMATIC TAKEN AT (Friday);

C. RESTORE DB proddb TAKEN AT (Friday);
RESTORE DB proddb INCREMENTAL AUTOMATIC TAKEN AT (Saturday);

D. RESTORE DB proddb INCREMENTAL AUTOMATIC TAKEN AT (Friday);

Discussion 0

Correct Answer: D Vote an answer

Question #15

Which statement is true about clustering indexes in a partitioned database?

A. The partitioning key column(s) should be added immediately after the column in the clustering index with the highest cardinality.

B. The partitioning key column(s) should be added to the clustering index with the INCLUDE option.

C. The clustering index column(s) should be suffixed by the partitioning key column(s).

D. The clustering index column(s) should be prefixed by the partitioning key column(s).

Discussion 0

Correct Answer: D Vote an answer

Question #16

A table named TAB_A was created with the COMPRESS YES option specified and populated with 100,000 rows. If a DBA wants to create an index on table TAB_A, which statement is true?

A. The index will automatically be enabled for compression because the associated table is compressed; however, the index will not be compressed until it is REORGed.

B. The index will automatically be compressed since the table it is associated with is compressed; the ALTER INDEX command does not have to be executed.

C. In order for the index to be compressed, it must be enabled for compression by specifying the COMPRESS YES option with the CREATE INDEX statement that is used to create it.

D. In order for the index to be compressed, it must be enabled for compression by specifying the COMPRESS YES option in the CREATE INDEX statement used to create it; however, the index will not be compressed until the ALTER INDEX command is used to create an index compression dictionary.

Discussion 0

Correct Answer: B Vote an answer

Question #17

A partitioned instance named DB2INST1 uses the following db2nodes.cfg file:
If the CREATE DATABASE command is executed on server C, which partition will be the catalog partition?

A. 4

B. 6

C. 1

D. 0

Discussion 0

Correct Answer: A Vote an answer

Question #18

A user with Security Administrator (SECADM) authority executes the following statements:

If user USER2 queries the table S.TAB1, how many rows will be returned?

A. 2

B. 1

C. 3

D. 0

Discussion 0

Correct Answer: A Vote an answer

Download Free IBM C2090-544 Demo

Simply submit your e-mail address below to get started with our free demo of your IBM C2090-544 exam.