IBM 000-541 問題集

質問 1：
You want to federate communication between two databases. What are two key requirements? (Choose two.)
A. Enable the client for federation.
B. Enable the server for federation.
C. Define nicknames for the tables of a federated server.
D. Use the JDBC Type 4 driver.
正解：B,C

質問 2：
You want to grant user BOB the ability to create tables in table space PLANS and to grant this privilege to others Which command would you use?
A. GRANT USE AND GRANT FOR plans TABLESPACE TO bob
B. GRANT USE OF TABLESPACE plans TO bob WITH GRANT OPTION
C. GRANT USE AND GRANT FOR TABLESPACE plans TO bob
D. GRANT USE OF plans TABLESPACE TO bob WITH GRANT OPTION
正解：B

質問 3：
Which privilege will allow a user to extract AUDIT data into delimited files for analysis?
A. EXECUTE
B. CREATE AUDIT
C. AU DI T_D E LI M_EXT R AC T
D. AUDIT
正解：A

質問 4：
Which statement is correct about informational constraints?
A. The database manager uses an informational constraint to enforce the uniqueness of the key during changes to the columns of the unique constraint.
B. An informational constraint specifies that every row that is inserted or updated in the table must conform to the definition of the table.
C. An informational constraint is a column or combination of columns that has the same properties as a unique constraint.
D. An informational constraint can be used by the SQL compiler to improve the access to data and query performance.
正解：D

質問 5：
Click the Exhibit button.

What does the SQL in the exhibit show?
A. The SQL shows the most frequently used indexes on the SYSIBM.SYSTABLES table since the last database activation.
B. THE SQL shows indexes on SYSIBM.SYSINDEXES table that have not been used since the last database activation.
C. The SQL shows indexes on the SYSIBM.SYSTABLES table that are used for index-only access.
D. The SQL shows the most frequently used indexes on the SYSIBM.SYSINDEXES table since the last database activation
正解：A

質問 6：
Click the Exhibit button.

IBM 000-541: Practice Exam
Refer to the logging configuration parameters shown in the exhibit.
What will happen if there are currently 100 active log files and DB2 needs to create log file 101?
A. The database will appear to be hung since the active log space is full and the BLK_LOG_DSK_FUL parameter is set to YES.
B. At least one application will receive a "log full" error and at least one transaction will be rolled back because the active log space is full.
C. Log file 101 will go into the OVERFLOWLOGPATH directory since the active log space is full and infinite logging has been enabled.
D. Log file 101 will be successfully created in the primary log path since infinite logging has been enabled. Applications will continue processing normally.
正解：D

質問 7：
A file named db2advise.in contains the text shown below:
--#SET FREQUENCY 100
SELECT COUNTO FROM employee;
SELECT * FROM employee WHERE lastname='HAAS';
What does the line -#SET FREQUENCY 100 convey when this file is used as input for the Design
Advisor?
A. Executes both SQL statements in the workload file 100 times.
B. Executes up to 100 combinations of optimizations for both SQL statements in the workload file
C. Executes the first SOL statement in the workload file 100 times.
D. Executes an index analysis for the first SQL statement in the workload file 100 times.
正解：A

質問 8：
Which two tasks can DB2 Workload Management do? (Choose two.)
A. Automatically change DB2dbm and db configuration.
B. Audit users, who did what and when.
C. Limit the number of disruptive database activities that can run concurrently
D. Stop the execution of activities that exceed defined boundaries.
正解：C,D