Which group of memory consumers can be adjusted by the Self-Tuning Memory Manager (STMM)?
A. buffer pools, utility heap, sort memory, package cache
B. bufferpools, lock memory, sort memory, package cache
C. buffer pools, database heap, utility heap, package cache
D. buffer pools, database heap, utility heap, lock memory
正解:B
質問 2:
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) CHECK (resume IS VALIDATED)
D. ALTER TABLE applicant ADD COLUMN resumeXML(1000) WITH DEFAULT
正解:A
質問 3:
Which three table features can be used concurrently in the same table? (Choose three.)
A. partitioned tables
B. MDC tables
C. range-clustered tables
D. local indexes
E. primary key index
正解:A,B,D
質問 4:
A database named PAYROLL was backed up on Sunday. On Tuesday, a table space in the PAYROLL database was renamed from TBSP1 to EMPINFO_TBSP. On Thursday, the database was restored from the backup image created on Sunday. Which command must be issued to roll the renamed table space forward to the current date and time?
A. ROLLFORWARD DATABASE payroll TO END OF LOGS AND STOPTABLESPACE(empinfo_tbsp)
B. ROLLFORWARD DATABASE payroll TO END OF LOGS AND STOPTABLESPACE(tbspl)
C. ROLLFORWARD DATABASE payroll TO END OF LOGS AND STOPTABLESPACE(tbsp 1 TO empinfo_tbsp)
D. ROLLFORWARD DATABASE payroll TO END OF LOGS AND STOPTABLESPACE(tbsp 1 RENAME empinfo_tbsp)
正解:A
質問 5:
Click the Exhibit button.
IBM 000-541: Practice Exam
What is the result after executing the SELECT statement shown below?
SELECT COUNTO FROM applicant WHERE gender='C'
A. 0
B. 4
C. 3
D. 7
正解:A