IBM C2090-541 問題集

質問 1：
Which SQL statement will execute successfully?
A. CREATE TABLE customer (custid INTEGER NOT NULL PRIMARY KEY, custinfo XML( 10000))
B. CREATE TABLE customer
(custid INTEGER NOT NULL PRIMARY KEY,
custinfo XML)
C. CREATE TABLE customer
(custid INTEGER,
custinfo XML NOT NULL PRIMARY KEY)
D. CREATE TABLE customer
(custid INTEGER,
custinfo XML(1 M) NOT NULL PRIMARY KEY)
正解：B

質問 2：
You have a new table created with COMPRESS YES and a delimited ASCII file. You use the LOAD utility to load the data from the ASCII file into the table. When will all of the rows in the table be compressed?
A. after running INSPECT
B. during the DELETE phase
C. after a table REORG
D. during the BUILD phase
正解：C

質問 3：
When using table partitioning, which three operations are valid? (Choose three.)
A. DETACH partition
B. REORG all partitions
C. ATTACH partition
D. partition level REORG
E. DROP partition
正解：A,C,D

質問 4：
Given the following CREATE TABLE statement:
CREATE TABLE applicant (id INTEGER NOT NULL PRIMARY KEY, lastname VARCHAR(50));
Which SQL statement will execute successfully?
A. ALTER TABLE applicant ADD COLUMN resume XML CHECK (resume IS VALIDATED)
B. ALTER TABLE applicant ADD COLUMNresume XML WITH DEFAULT
C. ALTER TABLE applicant ADD COLUMN resumeXML(1000) WITH DEFAULT
D. ALTER TABLE applicant ADD COLUMN resumeXML(1000) CHECK (resume IS VALIDATED)
正解：A

質問 5：
The event monitor for transactions has been replaced in DB2 9.7 with which tool?
A. MON_GET_ACTIVITY_DETAILS table function
B. db2evmonfmt
C. MON_GET_WORKLOAD table function
D. db2top
正解：C

質問 6：
Because of an application abend, a database named PAYROLL needs to be restored to approximately 9:26 am on June 1, 2009. After the database is restored from a backup image, the command shown below is executed: ROLLFORWARD DATABASE payroll TO 2009-06-01-09.26.44.609002 USING LOCAL TIME AND STOP
When this command is executed, the error shown below is generated:
SQL4970N Roll-forward recovery on database "PAYROLL" cannot reach the specified stop point (end-of-log or point-in-time) because of missing log file(s) on node(s) "0".
Which two commands could be used to resolve this error? (Choose two.)
A. ROLLFORWARD DATABASE payroll TO 2009-06-01-09.26.44.609002 USING LOCAL TIME AND STOP OVERFLOW LOG PATH /mnt/arclog
B. ROLLFORWARD DATABASE payroll TO 2009-06-01-09.26.44.609002 USING UTC TIME AND STOP NORETRIEVE MISSING RECORDS
C. ROLLFORWARD DATABASE payroll TO 2009-06-01-09.26.44.609002 USING UTC TIME AND STOP
D. ROLLFORWARD DATABASE payroll TO END OF LOGS AND STOP
正解：A,D