Free C2090-546 Questions for IBM DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade C2090-546 Exam as PDF & Practice Test Engine

Exam Code/Number: C2090-546
Exam Name/Title: DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade
Certification Provider: IBM
Corresponding Certification: DB2

Exam Questions: 78
Updated On: Jun 03, 2026

Question #1

What DB2 feature must NOT be activated in order to enable Secure Sockets Layer (SSL) support?

A. High Availability Disaster Recovery (HADR)

B. Kerberos Authentication

C. Work Load Manager (WLM)

D. Connection Concentrator

Discussion 0

Correct Answer: D Vote an answer

Question #2

A database administrator wants to load XML data into the table DB2USER.T1 from the delimited ASCII file /home/user/xml/data1.del. Which command will load the XML data and validate it against a XML schema?

A. LOAD FROM data1.del OF DEL XML FROM /home/user/xml XMLVALIDATE USING XDS INSERT INTO db2user.t1

B. LOAD FROM data1.del OF DEL XML FROM /home/user/xml XMLSCHEMA USING XDS INSERT INTO db2user.t1

C. LOAD FROM data1.del OF DEL XML FROM /home/user/xml INSERT INTO db2user.t1

D. LOAD FROM data1.del OF DEL XML FROM /home/user/xml XMLVALIDATE USING XMLSCHEMA INSERT INTO db2user.t1

Discussion 0

Correct Answer: A Vote an answer

Question #3

The SALES database was created without AUTOMATIC STORAGE. If the following command is executed: ALTER DATABASE sales ADD STORAGE ON '/db2fs1', '/db2fs2' What is the expected result?

A. The SALES database is converted to AUTOMATIC STORAGE, all new table spaces will use the AUTOMATIC STORAGE paths, ALTER TABLESPACE statement is needed to convert existing table spaces.

B. The SALES database and all its table spaces are converted to AUTOMATIC STORAGE.

C. The SALES database is converted to AUTOMATIC STORAGE and all its existing DMS table spaces are in rebalance pending state.

D. The SALES database is converted to AUTOMATIC STORAGE, all new table spaces will use the AUTOMATIC STORAGE paths, existing table spaces need to be dropped and recreated.

Discussion 0

Correct Answer: A Vote an answer

Question #4

If table TAB_A is created as follows:

Assuming the cardinality of the columns is the same, which statement will create an index that will benefit the most from compression?

A. CREATE INDEX taba_idx ON tab_a (c2)

B. CREATE UNIQUE INDEX taba_idx ON tab_a (c2)

C. CREATE INDEX taba_idx ON tab_a (c4)

D. ALTER TABLE tab_a ADD PRIMARY KEY (c1)

Discussion 0

Correct Answer: A Vote an answer

Question #5

If table TAB_A has just been created as follows:

Which command will create a compression dictionary for table TAB_A?

A. DELETE FROM tab_a

B. LOAD FROM data.del OF DEL INSERT INTO tab_a

C. UPDATE tab_a SET c1 = c1*1.1

D. REORG TABLE tab_a

Discussion 0

Correct Answer: B Vote an answer

Question #6

Given the following DDL statements:

What is the end result of the CREATE INDEX statement?

A. TBSP21 will contain one index because NEW_IDX is not partitioned and will automatically go into the first index partition listed in the create table statement.

B. TBSP21 and TBSP22 will each contain one local index.

C. TBSP11 and TBSP12 will each contain one local index since the local indexes will physically reside in the same table space as the related data.

D. INDEX_TS will contain one non-partitioned index since the create index command is missing the PARTITION keyword.

Discussion 0

Correct Answer: B Vote an answer

Question #7

Given the following GRANT commands:

Assuming that user BOB belongs to the group STAFF and STAFF has no other privileges aside from what is defined above, what is the highest level of privilege that BOB has on the database?

A. CONNECT

B. DBADM

C. ACCESSCTRL

D. DATAACCESS

Discussion 0

Correct Answer: D Vote an answer

Question #8

Given the following SQL statement:

Assuming that a temporary table is created by DB2 to process this statement, when will it be eligible for compression?

A. If table T1 is compressed.

B. If any table referenced by the query is compressed.

C. If tables T1, T2, T3 and T4 are compressed.

D. All the time.

Discussion 0

Correct Answer: D Vote an answer

Free C2090-546 Questions for IBM DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade C2090-546 Exam as PDF & Practice Test Engine

Download Free IBM C2090-546 Demo