IBM C2090-544 Actual Free Exam Questions & Community Discussion

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 28, 2026

Question #28

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 compressed since the table it is associated with is compressed; the ALTER INDEX command does not have to be executed.

B. 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.

C. 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.

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: A Vote an answer

Question #29

Click the Exhibit button.

In a DB2 Connect scenario between a Windows client and a z/OS server, the commands in the exhibit produced an SQL30061N error while trying to connect to the BIGDB001 database in the DB2T subsystem on the z/OS server: SQL30061N The database alias or database name name was not found at the remote node.
Explanation:
The database name is not an existing database at the remote database node. The statement cannot be processed. The z/OS DBA has confirmed that the LOCATION NAME is DB2T. Which change would enable the command in the exhibit to execute correctly?

A. CATALOG DCS DATABASE db2t AS dsample

B. CATALOG DATABASE db2t AS dsample AT NODE node001 AUTHENTICATION DCS

C. CATALOG DATABASE bigdb001 AS dsample AT NODE db2t AUTHENTICATION DCS

D. CATALOG DCS DATABASE dsample AS db2t

Discussion 0

Correct Answer: D Vote an answer

Question #30

At which two levels can events be audited? (Choose two.)

A. Instance level

B. Database level

C. Node level

D. Server level

E. Operating System level

Discussion 0

Correct Answer: A,B Vote an answer

Question #31

Given a SHEAPTHRES value of 2560, in which two cases will a SHEAPTHRES_SHR value of 1024 be meaningful? (Choose two.)

A. MAX_CONNECTIONS 2000, MAX_COORDAGENTS 100

B. MAX_AGENTS 100, MAX_CONNECTIONS 2000

C. INTRA_PARALLEL NO

D. INTRA_PARALLEL YES

E. MAX_CONNECTIONS 500, MAX_COORDAGENTS 1000

Discussion 0

Correct Answer: A,D Vote an answer

Question #32

A journaling application inserts data with continually increasing sequential keys while a clean up process randomly deletes erroneous rows. What can be done to maximize insert performance?

A. Issue an ALTER TABLESPACE EXTEND statement.

B. Issue a db2set DB2SKIPDELETED=ON command.

C. Issue a db2set DB2MAXFSCRSEARCH=1024 command.

D. Issue an ALTER TABLE APPEND ON statement.

Discussion 0

Correct Answer: D Vote an answer

Question #33

Which command will back up a database named SAMPLE to a TSM server using two concurrent TSM client sessions?

A. BACKUP DATABASE sample USE TSM OPEN 2 SESSIONS WITH 4 BUFFERS

B. BACKUP DATABASE sample USE TSM OPEN 2 SERVERS WITH 4 BUFFERS

C. BACKUP DATABASE sample USE TSM OPEN 4 SERVERS WITH 2 BUFFERS

D. BACKUP DATABASE sample USE TSM OPEN 4 SESSIONS WITH 2 BUFFERS

Discussion 0

Correct Answer: A Vote an answer

Question #34

Which command would be used to obtain the name of the first active log file for a database with log retain enabled?

A. GET CURRENT ACTIVE LOGFILE

B. LIST LOGFILES

C. GET DATABASE CONFIGURATION

D. LIST INDOUBT TRANSACTIONS

Discussion 0

Correct Answer: C Vote an answer

Question #35

Which registry variable allows you to limit the size of individual containers for automatic storage table spaces?

A. DB2_ALLOCATION_SIZE

B. DB2_LIMIT_AS_CONTAINER_BLOCKS

C. DB2_TRUNCATE_AS_STORAGE

D. DB2_SET_MAX_CONTAINER_SIZE

Discussion 0

Correct Answer: D Vote an answer

Question #36

A database recovery operation (RECOVER DATABASE) failed during the roll forward phase. The DBA wants to force the RECOVER DATABASE to redo the restore phase. What must occur to accomplish this?

A. The RECOVER DATABASE operation must be terminated and a new RECOVER DATABASE command must be issued.

B. A RECOVER DATABASE command must be issued with the TO END OF LOGS option specified.

C. A RECOVER DATABASE command must be re-issued with the REPLACE option specified.

D. A RECOVER DATABASE command must be issued with the RESTART option specified.

Discussion 0

Correct Answer: D 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.