IBM A2090-611 問題集

質問 1：
Given the following command: LOAD FROM newrows.del OF DEL INSERT INTO mytab ALLOW READ ACCESS Which statement(s) must be executed before applications can query the newly loaded data?
A. SET INTEGRITY FOR mytab IMMEDIATE CHECKED
B. ALTER TABLE mytab ALLOW READ ACCESS IMMEDIATE CHECKED
C. ALTER TABLE mytab CHECK (COL IS VALIDATED)
D. ALTER TABLE mytab ALLOW READ ACCESS;
SET INTEGRITY FOR mytab IMMEDIATE UNCHECKED;
正解：A

質問 2：
If the following command is executed:

Which statement is true?
A. Rejected records will be inserted into the table SCHEMA2.E1
B. While the Load is executing, other transactions can both read and write into table SCHEMA6.T1
C. Any indexes defined on table SCHEMA6.T1 will be marked invalid upon completion of the Load.
D. If using a remote database connection, the file "/mnt/datafile.del" must be accessible to the database server host.
正解：A

質問 3：
Which command will define the alternate diagnostic data directory path as /db2data/db2dump2?
A. UPDATE DBM CFG USING SECONDARY_DIAGPATH /db2data/db2dump2
B. db2set ALT_DIAGPATH=/db2data/db2dump2
C. db2set SECONDARY_DIAGPATH=/db2data/db2dump2
D. UPDATE DBM CFG USING ALT_DIAGPATH /db2data/db2dump2
正解：D

質問 4：
Which statement about the db2pd tool is true?
A. It collects information from the log buffer and active log files.
B. It may retrieve data that is not completely accurate.
C. It ensures that information is not retrieved on changing data.
D. It collects information from the snapshot monitor and a predefined set of event monitors.
正解：B

質問 5：
Which administrative authority is needed to grant ACCESSCTRL, DATAACCESS, or SECADM authority to other users, groups, or roles?
A. DBADM
B. SECADM
C. SYSADM
D. SQLADM
正解：B

質問 6：
Which user-managed file system is required for DB2 pureScale deployments?
A. HPFS
B. JFS2
C. GPFS
D. NTFS
正解：C

質問 7：
What information can be obtained by analyzing EXPLAIN data?
A. Access type, index use, and work load
B. Work load, access type, and join methods
C. Join methods, index use, and access type
D. Index use, work load, and join methods
正解：C

質問 8：
Which statement about BEFORE triggers is FALSE?
A. A BEFORE trigger's action is executed for each row in the set of affected rows before the trigger event executes.
B. A BEFORE trigger's action is executed for each row in the set of affected rows instead of executing the trigger event.
C. A BEFORE trigger is used to perform validation of input data and to automatically generate values for newly inserted rows.
D. A BEFORE trigger cannot be used to modify data in a database because they are activated before the trigger event is applied to the database.
正解：B