急，请问这道701题的答案？明天就要考了

cnufo

2.Given the dynamic SQL statement:
SELECT * FROM t1 WHERE customer = ?
Which two of the following tools can be used to examine the explain results for this statement?
A. Dynexpln.
B.db2exfmt.
C.db2expln.
D. Design Advisor.
E. Visual Explain.

我觉得应该是AE,不知对不对

cnufo

3.For messages written using the db2AdminMsgWrite API, the component listed in the notification log will be which of the following?
A. User Function
B. Application ID
C. User Application
D. Admin Message API

这道我觉得应该是C,但老师给的答案是D

lklgdkp

相信自己，不要理会所谓的答案。

lklgdkp

第二题：
If an entry in the administration notification log indicates that the DB2 UDB component that produced the entry was a user application that executed the db2AdminMsgWrite() API, a portion of the entry header will read "User Application."

gaozj

C,E

cnufo

19.How can the amount of data returned when listing the tables in the Control Center be limited?
A. Use the filter feature of the Details pane.
B. Use the filter feature of the Tables folder.
C. Create your tables in different table spaces.
D. Use the Customize Columns feature of the Details pane.
这道我选择的是A，不知道该选什么，老师也没给答案

cnufo

自己顶一下^_^

lklgdkp

第一题：
Both the db2expln tool and the dynexpln tool are designed to describe the final access plan chosen for a particular SQL statement, not to collect explain snapshot data. The db2exfmt tool, on the other hand, is designed to query the explain tables for information (i.e., Explain and/or Explain snapshot data that has already been collected), format the results, and produce a text-based report that can be displayed directly on the terminal or written to an ASCII file.