IBM DB2 9.7 DBA for Linux UNIX and Windows 認定 C2090-541 試験問題:

1. Which two data types can be in-lined to enhance compression? (Choose two.)

A) LONG VARCHAR
B) LOB
C) XML
D) GRAPHIC

2. Which three authorizations allow you to execute db2pd? (Choose three.)

A) SECADM authority level
B) SYSPERF authority level
C) SYSADM authority level
D) SYSCTRL authority level
E) SYSMON authority level

3. What are three system and database level authorizations available with DB2? (Choose three.)

A) SYSMON
B) DBADM
C) DBCTRL
D) SYS ADM
E) SYSMNT

4. Which statement is true about using the EXPORT utility with a table that contains XML data?

A) By default, XML documents will be written to the same file that contains the relational data exported unless the XMLFILE option is used.
B) By default, XML documents are written to a single, separate file, which is stored in the same location as the file that contains the relational data exported.
C) If the table being exported does not contain well-formed XML documents, the XMLSAVESCHEMA option must be provided with the EXPORT command used.
D) If you are exporting XML documents that are greater than 32 Kb in size, you must use the XMLINSEPFILES modifier to avoid truncation.

5. What are three default service classes used by Work Load Management? (Choose three.)

A) SYSDEFAULTUSERCLASS
B) SYSDEFAULTWORKSET
C) SYSDEFAULTSERVICECU\SS
D) SYSDEFAULTMAINTENANCECLASS
E) SYSDEFAULTSYSTEMCLASS

質問と回答：