701的问题

justinchang

Which of the following is TRUE of Database Managed Space (DMS) table spaces?

A. Space is not allocated until required

B. DMS table spaces allow LOBs to be cached in the buffer pool

C. Containers may be on either system directories or raw devices

D. Tables in DMS table spaces may be split up by data type (LOBs, index, data)

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
C应该是一个，other is E?

Which of the following is TRUE of Database Managed Space (DMS) table spaces?

A. Space is not allocated until required

B. DMS table spaces allow LOBs to be cached in the buffer pool

C. Containers may be on either system directories or raw devices

D. Tables in DMS table spaces may be split up by data type (LOBs, index, data)
我认为是C

请各位说说答案，顺便求更多的701的自测题，多谢

daliwa

第一题：选D在DMS表空间中各种表对象是分开存储的

第二题：E当然也要算一个，试试就知道了。

第三题 ：c是错的，DMS表空间只能是文件或裸设备，不能是目录。

偶也在备考，可以多多交流！

lklgdkp

1.D.

justinchang

多谢，最后一题的答案我后来查到了。应该是D

newhu114

第一题明显是D