C2090-546最も有効な質問と解答で勉強

試験内容は2026年も随時見直されており、古い教材のままでは出題傾向とのずれが生じてしまいます。Tech4ExamのC2090-546練習問題は購入後365日間無料で更新されるため、IBM DB2 9.7 Database Administrator for Linux UNIX or Windows Upgradeの最新の出題内容に沿って学習を続けられます。

IBM C2090-546 試験概要:

IBM C2090-546 試験シラバストピック:

C2090-546試験のQ&A – 受験前に知っておきたいこと

IBM DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade 認定 C2090-546 試験問題：

問題 #1

A database administrator wants to prune the Recovery History file for the SAMPLE database so that all objects older than February 1, 2008 (including those marked DB2HISTORY_STATUS_DO_NOT_DELETE) are removed from the file. Which commands will ensure all related recovery objects are automatically removed by DB2?

A. UPDATE DB CFG FOR sample USING AUTO_DEL_REC_OBJ ON; PRUNE HISTORY 20080101 AND DELETE;
B. UPDATE DB CFG FOR sample USING AUTO_DEL_REC_OBJ OFF; PRUNE HISTORY 200801 WITH FORCE OPTION;
C. UPDATE DB CFG FOR sample USING AUTO_DEL_REC_OBJ OFF; PRUNE HISTORY 200801 WITH FORCE OPTION AND DELETE;
D. UPDATE DB CFG FOR sample USING AUTO_DEL_REC_OBJ ON; PRUNE HISTORY 200801 WITH FORCE OPTION AND DELETE;

問題 #2

Which of the following SQL statements will return monitoring information of tables in the DB2USER schema that begin with the letter 'A'?

A. SELECT * FROM TABLE(mon_get_table('DB2USER','',-2)) WHERE TABNAME LIKE 'A%'
B. SELECT * FROM TABLE(mon_get_table('DB2USER','A%',-2))
C. SELECT * FROM mon_get_table('DB2USER','A%',-2)
D. SELECT * FROM mon_get_table('DB2USER',",-2) WHERE TABNAME LIKE 'A%'

問題 #3

In a partitioned database environment, a table's distribution key can have:

A. An XML column with primary key defined on it.
B. An XML column with unique index defined on it.
C. An XML column with other non-XML columns.
D. Only XML columns with no primary key defined on it.

問題 #4

Which SQL statement must be executed in order to give a user named USER1 the ability to query the system catalog tables and views?

A. GRANT DATAACCESS ON DATABASE TO user1
B. GRANT ACCESSCTRL ON DATABASE TO user1
C. GRANT SQLADM ON DATABASE TO user1
D. GRANT WLMADM ON DATABASE TO user1

問題 #5

If table TAB_A has just been created as follows:

Which command will create a compression dictionary for table TAB_A?

A. UPDATE tab_a SET c1 = c1*1.1
B. DELETE FROM tab_a
C. REORG TABLE tab_a
D. LOAD FROM data.del OF DEL INSERT INTO tab_a

解説：