IBM C2090-600 問題集

質問 1：
On Linux and Unix systems, which of the following will set the DB2_FMP COMM_HEAPSZ registry variable to 1 GB (or 256000 pages), only for the instance db2inst1?
A. As the db2 instance owner (db2inst1) execute the command:
db2set -i db2inst1 DB2_FMP COMM_HEAPSZ=256000
B. As the db2 instance owner (db2inst1) execute the command:
exportDB2_FMP COMM_HEAPSZ=256000
C. Add to the following line to the user profile (db2inst1): DB2_FMP COMM_HEAPSZ=256000
D. As the db2 instance owner (db2inst1) execute the command:
db2set -i DB2_FMP COMM_HEAPSZ=256000
正解：D

質問 2：
If the following SQL statements are executed:
CREATE DATABASE testdb AUTOMATIC STORAGE NO;
CONNECT TO testdb;
CREATE STOGROUP sgl ON '/datal';
CREATE STOGROUP ibmstogroup ON '/data2';
CREATE STOGROUP sg2 ON '/data3';
Which storage group is the default storage group for the TESTDB database?
A. IBM STOGROUP
B. SG1
C. SG2
D. IBM DEFAULTISG
正解：A

質問 3：
Which operation can be performed with trusted context privileges that are acquired through a role?
A. DDL operations
B. DML operations
C. Security administration operations
D. Server maintenance operations
正解：B

質問 4：
If the following SQL statements are executed:

How many rows will be added to the DEPARTMENT table?
A. 2
B. 3
C. 4
D. 1
正解：C

質問 5：
When the DB2_WORKLOAD registry variable is assigned the value ANALYTICS and then a new database is created, what happens? (Choose two.)
A. The DFT_TABLE_ORG database configuration parameter is set to COLUMN.
B. The INTRA_PARALLEL database manager configuration parameter is set to NO.
C. The AUTO_REORG database configuration parameter is set to NO.
D. The PAGESIZE database configuration parameter is set to 32K.
E. The DFT_EXTENT_SZ database configuration parameter is set to 8.
正解：A,B

質問 6：
Which statement about the DB2_BCKP COMPRESSION registry variable is TRUE?
A. It specifies the compression mode to use for DB2 backups.
B. It only has effect when applied to a database in which all tables have been compressed.
C. If set, backup images created with the BACKUP command are automatically compressed.
D. It does not apply to table space backups.
正解：C