Free IBM C2090-546 Practice Test & Real Exam Questions

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

Question #9

You are creating a table with 1 LOB column. The size of the LOB column is less than the size of the LOB descriptor. When creating this table you did not specify an INLINE LENGTH. Which option is correct?

A. Both the LOB descriptor and the LOB data will be stored in the base table.

B. Only the LOB descriptor will be stored in base table and the LOB data will be stored in the LOB storage object.

C. The ALTER TABLE .. INLINE LENGTH .. command is required so the LOB data can be included in the base table.

D. Only the LOB data will be stored in the base table.

Discussion 0

Correct Answer: D Vote an answer

Question #10

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

A. Work Load Manager (WLM)

B. Kerberos Authentication

C. Connection Concentrator

D. High Availability Disaster Recovery (HADR)

Discussion 0

Correct Answer: C Vote an answer

Question #11

Which of the following SQL statements will return monitoring information of all indexes in the DB2USER schema that have greater than 100 index scans?

A. SELECT * FROM TABLE(mon_get_index(' ',100,-2))

B. SELECT * FROM TABLE(mon_get_index('DB2USER',100,-2))

C. SELECT * FROM TABLE(mon_get_index('DB2USER',' ',-2)) WHERE index_scans > 100

D. SELECT * FROM TABLE(mon_get_index(' ','DB2USER',-2)) WHERE index_scans > 100

Discussion 0

Correct Answer: C Vote an answer

Question #12

Which two authorities can grant SELECT privilege on a table? (Choose two.)

A. SYSADM authority on the instance.

B. DATAACCESS authority on the database.

C. DBADM authority on the database.

D. ACCESSCTRL authority on the database.

E. SECADM authority on the database.

Discussion 0

Correct Answer: D,E Vote an answer

Question #13

Which two workload management thresholds support priority aging by providing a remapping action? (Choose two.)

A. CPUTIMEINSC

B. ACTIVITYTOTALTIME

C. SQLROWSREADINSC

D. CONCURRENTDBCOORDACTIVITIES

E. REMAPACTIVITY

Discussion 0

Correct Answer: A,C Vote an answer

Question #14

Which db2val option will create a log file?

A. -r

B. -l

C. -o

D. -f

Discussion 0

Correct Answer: B Vote an answer

Question #15

You have created a Trusted Context by using following command:

What is the ENCRYPTION type for the '9.26.146.201' address, the AUTHENTICATION type for
PUBLIC, and is MYCTX enabled?

A. None, WITH AUTHENTICATION, No

B. High, WITH AUTHENTICATION, Yes

C. None, WITHOUT AUTHENTICATION, Yes

D. High, WITHOUT AUTHENTICATION, No

Discussion 0

Correct Answer: C Vote an answer

Question #16

Which statements about Explain administration authority (EXPLAIN) are true?

A. EXPLAIN authority allows a user to explain query plans by gaining limited access to data for a specific database. DBADM can grant this authority and this authority can be granted to PUBLIC.

B. EXPLAIN authority allows a user to explain query plans without gaining access to data for a specific database. SECADM and DBADM can grant this authority and this authority cannot be granted to PUBLIC.

C. EXPLAIN authority allows a user to explain query plans without gaining access to data for a specific database. SECADM can grant this authority and this authority can be granted to PUBLIC.

D. EXPLAIN authority allows a user to explain query plans by gaining limited access to data for a specific database. SECADM can grant this authority and this authority cannot be granted to PUBLI

Discussion 0

Correct Answer: C Vote an answer

Download Free IBM C2090-546 Demo

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