21.
Which tool must be used to analyze all of the database operations performed by an application against a DB2 for i5/OS database?
- A.Visual Explain
- B.Activity Monitor
- C.SQL Performance Monitor
- D.DB2 Performance Monitor
- Answer
- Report
Answer : [C]
22.
Which of the following describes how DB2 9 stores an XML document if the XML Extender is not used?
- A.CLOB
- B.BLOB
- C.Hierarchically
- D.Rows and columns
- Answer
- Report
Answer : [C]
23.
Which of the following is the lowest cost DB2 product that can be legally installed on an HP-UX server?
- A.DB2 Express-C
- B.DB2 Express
- C.DB2 Personal Edition
- D.DB2Enterprise Server Edition
- Answer
- Report
Answer : [D]
24.
What is the purpose of the Design Advisor?
- A.To analyze workloads and make recommendations for indexes and MQTs
- B.To present a graphical representation of a data access plan and recommend design changes that will improve performance
- C.To replicate data between a DB2 database and another relational database
- D.To configure clients so they can access databases stored on remote servers
- Answer
- Report
Answer : [A]
25.
Which of the following tools can be used to catalog a database?
- A.Visual Explain
- B.Alert Center
- C.Journal
- D.Configuration Assistant
- Answer
- Report
Answer : [A]
|
|
||||||||||||||||||||||||||||
