IBM 000-541 問題集

質問 1：
What are three default service classes used by Work Load Management? (Choose three.)
A. SYSDEFAULTSYSTEMCLASS
B. SYSDEFAULTSERVICECU\SS
C. SYSDEFAULTWORKSET
D. SYSDEFAULTMAINTENANCECLASS
E. SYSDEFAULTUSERCLASS
正解：A,D,E

質問 2：
When are packages automatically rebound?
A. When invalid packages are executed.
B. When the DB2_AUTO_REBIND registry variable is set to YES.
C. When inoperative packages are executed.
D. When the DB2_AUTO_REBIND configuration parameter is set to ENABLED
正解：A

質問 3：
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

質問 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(tbsp 1 TO empinfo_tbsp)
C. ROLLFORWARD DATABASE payroll TO END OF LOGS AND STOPTABLESPACE(tbspl)
D. ROLLFORWARD DATABASE payroll TO END OF LOGS AND STOPTABLESPACE(tbsp 1 RENAME empinfo_tbsp)
正解：A

質問 5：
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

質問 6：
A database administrator created a new database from an existing full database backup image. If the original database resided on a 64-bit AIX server and the new database was created on a different 64-bit AIX server, which two statements are correct? (Choose two.)
A. Incremental backup images for the original database can be used to restore the new database.
B. Incremental backups are not allowed until a non-incremental backup is taken.
C. Existing packages will be copied to the new database and can be used immediately.
D. Existing SQL procedures must be dropped and re-created in the new database before they can be used.
正解：B,D

質問 7：
The SELF_TUNING_MEM database configuration (db cfg) parameter is set to ON.
Which three statements will cause the memory tuner to actively tune memory within the database? (Choose three.)
A. Any two of LOCKLIST, SHEAPTHRES_SHR,PCKCACHESZ are set to AUTOMATIC.
B. MAXLOCKS is set to AUTOMATIC.
C. At least one buffer pool has its size set to AUTOMATIC.
D. The SORTHEAP db cfg parameter is set to AUTOMATI
E. One dbcfg parameter is set to AUTOMATIC or the size of at least one buffer pool is set to AUTOMATIC, and the DAT ABAS E_M E M O R Y db cfg parameter is set to a numeric value or to AUTOMATIC.
正解：A,D,E

質問 8：
Which three commands will apply the specified action to all objects in schema PAY1 in database PRODDB? (Choose three.)
A. RUNSTATS ON SCHEMApayl D REORGCHK UPDATE STATISTICS ON SCHEMA payl
B. db2look-dproddb -z payl
C. GRANT SELECT ON TABLEpayl * TO USER userl
D. GRANT DROPIN ON SCHEMApayl TO USER userl
正解：B,D