Which command will define the alternate diagnostic data directory path as /db2data/db2dump2?
A. UPDATE DBM CFG USING SECONDARY_DIAGPATH /db2data/db2dump2
B. db2set SECONDARY_DIAGPATH=/db2data/db2dump2
C. db2set ALT_DIAGPATH=/db2data/db2dump2
D. UPDATE DBM CFG USING ALT_DIAGPATH /db2data/db2dump2
正解:D
質問 2:
Which statement about updating index statistics with the RUNSTATS command is true?
A. It cannot be accomplished without scanning the associated table.
B. It must be executed against all indexes for the table.
C. It requires a full index scan.
D. It can be accomplished by sampling the index.
正解:D
質問 3:
Which statement about adaptive compression is true?
A. When you enable adaptive compression for a table, you enable it for the entire table, even if the table contains more than one partition.
B. Adaptive compression uses a page-level dictionary-based compression algorithm to compress data based on repeating patterns found within asampling of data from one extent.
C. Adaptive compression can only be used to compress base tables, partitioned tables, and temporary tables; MQTs, typed tables and stagingtables cannot be compressed.
D. You can specify that tables be compressed by using either a table-level dictionary only, page-level dictionaries only, or both table-level andpage-level dictionaries.
正解:A
質問 4:
If the following command is executed:
Which statement is true?
A. If using a remote database connection, the file "/mnt/datafile.del" must be accessible to the database server host.
B. Any indexes defined on table SCHEMA6.T1 will be marked invalid upon completion of the Load.
C. Rejected records will be inserted into the table SCHEMA2.E1
D. While the Load is executing, other transactions can both read and write into table SCHEMA6.T1
正解:C
質問 5:
Which statements will enable automatic storage in storage group SG_HOT for a given database managed table space MY_TS and remove all existing non-automatic storage containers from the table space?
A. ALTER TABLEPACE my_ts MANAGED BY DATABASE;
ALTER TABLESPACE my_ts MANAGED BY AUTOMATIC STORAGE;
ALTER TABLESPACE my_ts REBALANCE;
B. ALTER TABLESPACE my_ts MANAGED BY DATABASE USE STOGROUP sg_hot;
ALTER STOGROUP sg_hot DROP '/db2/filesystem1', '/db2/filesystem2';
ALTER TABLESPACE my_ts REBALANCE;
C. ALTER TABLESPACE my_ts MANAGED BY AUTOMATIC STORAGE USE
STOGROUP sg_hot;
ALTER STOGROUP sg_hot DROP '/db2/filesystem1', '/db2/filesystem2';
ALTER TABLESPACE my_ts REBALANCE;
D. ALTER TABLESPACE my_ts MANAGED BY AUTOMATIC STORAGE;
ALTER TABLESPACE my_ts REBALANCE;
正解:D
質問 6:
Which data movement utility is suitable for moving and processing large amounts of real-time data without affecting availability?
A. IMPORT WITH BUFFERED INSERT
B. INGEST
C. REPLICATION
D. LOAD WITH READ ACCESS
正解:B
質問 7:
Which administrative authority is needed to grant ACCESSCTRL, DATAACCESS, or SECADM authority to other users, groups, or roles?
A. SYSADM
B. SQLADM
C. SECADM
D. DBADM
正解:C
Kikuchi -
予備試験を目指す受験生でもいいし、A2090-611でもいい。
広い目で見ると、IBM試験にも役立つ知識を学習できるので、
IBM試験受験生でも、Pass4Test相当に役に立つ。