最新なIBM C2090-600問題集（60題）、真実試験の問題を全部にカバー！

質問 1：
What levels of authority are needed to create a storage group? (Choose two.)
A. SYSCTRL
B. SYSADM
C. SQLADM
D. SYSMAINT
E. DBADM
正解：A,B

質問 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. IBM DEFAULTISG
C. SG1
D. SG2
正解：A

質問 3：
A table named MYTABLE contains an XML column and an XML storage object dictionary already exists.
What is the effect of enabling compression and then running the command REORG TABLE mytable
KEEPDICTIONARY?
A. New and existing XML columns will be compressed but other columns remain unchanged.
B. Existing data will remain uncompressed because the RESETDICTIONARY option of the REORG command was not used.
C. Only new or updated data for XML columns will be compressed.
D. All data, both new and existing, will be compressed.
正解：B

質問 4：
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:
exportDB2_FMP COMM_HEAPSZ=256000
B. As the db2 instance owner (db2inst1) execute the command:
db2set -i db2inst1 DB2_FMP COMM_HEAPSZ=256000
C. As the db2 instance owner (db2inst1) execute the command:
db2set -i DB2_FMP COMM_HEAPSZ=256000
D. Add to the following line to the user profile (db2inst1): DB2_FMP COMM_HEAPSZ=256000
正解：C

質問 5：
Which of the following enables the user to connect to the HADR standby database and execute select statements?
A. DB2 - HADR- PEER - WAIT- LIMIT
B. HADR_SPOOL_LIMIT
C. DB2_HADR_SOSNDBUF
D. DB2_HADR_ROS
正解：D

質問 6：
The DBA is concerned about a new application potentially corrupting a set of tables in table space TS1 in database DB1. TAB1 is a table in TS1. The DBA performs the following commands before running the application. The first QUIESCE completes at time "pit".
BACKUP DATABASE DB1 TABLESPACE (TS1) ONLINE
QUIESCE TABLESPACES FOR TABLE tab1 EXCLUSIVE
QUIESCE TABLESPACES FOR TABLE tab1 RESET
Which of the following is TRUE?
A. The QUIESCE EXCLUSIVE is recorded in the History File once the QUIESCE RESET completes.
B. After application corruption, the DBA restores a backup of TS1 and issues ROLLFORWARD
DATABASE TO pit AND COMPLETE TABLESPACE (ts1) ONLINE. There might be some uncommitted data in TS1.
C. Once the first QUIESCE completes, there are no running transactions involving tab1, but there might be running transactions against other tables in TS1.
D. After application corruption, the DBA restores a backup of TS1 and issues ROLLFORWARD
DATABASE TO pit AND COMPLETE TABLESPACE (ts1) ONLINE. This ensures none of the application changes were applied.
正解：D