IBM C2090-611 問題集

質問 1：
A table named SALES was created as follows:

If management wants to use Label-Based Access Control (LBAC) to protect individual rows in the SALES table, and the security policy needed (SEC_POLICY) has already been created, what must be done to protect the table as desired?
A. Add a SECURED WITH clause to every column in the SALES table and then associate the SEC_POLICY security policy with the SALES table.
B. Associate the SEC_POLICY security policy with the SALES table.
C. Add a column with the DB2SECURITYLABEL data type to the SALES table.
D. Add a column with the DB2SECURITYLABEL data type to the SALES table and then associate the SEC_POLICY security policy with the table.
正解：D

質問 2：
Which statement about referential constraints is true?
A. A referential constraint is used to enforce a logical rule about how values in one or more columns in a table should be referenced in a query.
B. A referential constraint can be defined against a catalog table.
C. A referential constraint can be defined on both tables and views.
D. A referential constraint is used to enforce a logical rule about values of one or more columns in one or more tables.
正解：D

質問 3：
You have just converted an existing database to an automatic storage database. What can you use to move data from an existing DMS table space to an automatic storage table space, while the data remains online and available for access?
A. The db2relocatedb command
B. The db2move command
C. The ADMIN_MOVE_TABLE procedure
D. The ADMIN_MOVE_TABLE_UTIL procedure
正解：C

質問 4：
If the current value for self-tuning memory is: Self Tuning Memory (SELF_TUNING_MEM) = ON (Inactive) Which statement is true?
A. Self-tuning is not occurring because it is waiting for the database to be recycled.
B. Self-tuning is not occurring because there are less than two memory consumers enabled.
C. The memory tuner is actively tuning the memory on the system.
D. Self-tuning is occurring only on the instance memory area.
正解：B

質問 5：
Which statement is true regarding the workload management dispatcher?
A. The workload management dispatcher monitors the allocation of CPU resources between service classes on a system.
B. The workload management dispatcher monitors work performed by entities executing in the DB2 system service class.
C. The workload management dispatcher monitors work performed by applications or middleware products that perform a portion of their workoutside of the DB2 database manager.
D. The workload management dispatcher monitors non-DB2 work performed in fenced mode processes such as fenced stored procedures.
正解：A

質問 6：
Which statement about triggers is FALSE?
A. A trigger's code block can be executed either before or after a triggering event.
B. A statement-level trigger fires only once for each SQL statement.
C. A row-level trigger fires once for each row that is affected by a triggering event.
D. A table-level trigger fires once for each table that is affected by a triggering event.
正解：D

質問 7：
Which data movement utility is suitable for moving and processing large amounts of real-time data without affecting availability?
A. INGEST
B. IMPORT WITH BUFFERED INSERT
C. LOAD WITH READ ACCESS
D. REPLICATION
正解：A

質問 8：
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 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 TABLEPACE my_ts MANAGED BY DATABASE;
ALTER TABLESPACE my_ts MANAGED BY AUTOMATIC STORAGE;
ALTER TABLESPACE my_ts REBALANCE;
D. 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;
正解：A

質問 9：
What can be used to provide input to the Design Advisor?
A. An XML file.
B. A query workload file.
C. The database manager configuration file.
D. The database configuration file.
正解：B