IBM C2090-541 Actual Free Exam Questions & Community Discussion

Exam Code/Number: C2090-541
Exam Name/Title: DB2 9.7 DBA for Linux UNIX and Windows
Certification Provider: IBM
Corresponding Certification: IBM certifications I

Exam Questions: 104
Updated On: May 30, 2026

Question #19

For which two purposes would you run the db2look tool? (Choose two.)

A. To extract the data offline from a given page in a table and store the data in a delimited file.

B. To extract the data from several tables in a database, ready to be imported or loaded.

C. To extract the definition of objects in a database and generate DDL statements to recreate them.

D. To extract the statistics information for a series of objects in a database and generate UPDATE statements to manually update the statistics

Discussion 0

Correct Answer: C,D Vote an answer

Question #20

Which command is used to configure the administrative task scheduler to execute tasks?

A. db2set D B 2_EXE C_S C H E D U LE_E NAB LE=YE S

B. db2setDB2 SCHEDULE ENABLE=YES

C. db2set D B 2_AT S_E NAB LE=YE S

D. db2set D B 2_EXE C_AT S_E NAB LE=YE S

Discussion 0

Correct Answer: C Vote an answer

Question #21

Which two plug-in types does the DB2 database system provide? (Choose two.)

A. Encryption authentication

B. Group retrieval

C. Server authentication

D. Kerberos authentication

Discussion 0

Correct Answer: B,C Vote an answer

Question #22

When using SQU and JDBC applications to connect to the host DB2 database, which software license must be registered?

A. DB2 Connect

B. DB2WSE

C. IBM Data Server Driver for JDBC and SQU

D. DB2 ESE

Discussion 0

Correct Answer: A Vote an answer

Question #23

Given a table that is already compressed, if you create a new index on that table, when will the index be compressed?

A. after running the ALTER INDEX... COMPRESS command

B. immediately after running the CREATE INDEX command

C. after running the REORG command against the table and index

D. after running the ALTER INDEX... COMPRESS command and the REORG command

Discussion 0

Correct Answer: B Vote an answer

Question #24

You want to estimate the potential index compression savings for existing indexes on a table What do you use to obtain this information?

A. ADMIN_GET_INDEX_COMPRESS_INFO table function

B. INSPECT

C. RUNSTATS

D. ADMIN_ESTIMATE_COMPRESS_INFO table function

Discussion 0

Correct Answer: A Vote an answer

Question #25

What is the purpose of the XMLPARSE() function?

A. To retrieve an XML document from a table and convert it to a character string value.

B. To perform "shredding" operationsthat were done with the XML Extender prior to version 9.7.

C. To produce a well-formed XML document from a character string value.

D. To convert XML Extender Document Type Definition files (DTD files) topureXML schema files (XSD files)

Discussion 0

Correct Answer: C Vote an answer

Question #26

Which two operations allow you to control the creation of the compression dictionary using the KEEPDICTIONARY/RESETDICTIONARY options? (Choose two.)

A. REORG

B. LOAD

C. TRUNCATE

D. IMPORT

Discussion 0

Correct Answer: A,B Vote an answer

Question #27

You have a new table created with COMPRESS YES and a delimited ASCII file. You use the LOAD utility to load the data from the ASCII file into the table. When will all of the rows in the table be compressed?

A. after running INSPECT

B. after a table REORG

C. during the DELETE phase

D. during the BUILD phase

Discussion 0

Correct Answer: B Vote an answer

Download Free IBM C2090-541 Demo

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