Which of the following tools for DB2 V9 allows a user to create and debug a SQL stored procedure?（）

单项选择题In which situation is shredding XML data recommended?（）

A.When the data is naturally tabular
B.When the number of nodes are volatile
C.When the data by nature has sparse attributes
D.When the data is of low volume and requires a complex star-schema topology

单项选择题Which of the following is a typical data warehouse query?（）

A.What is this customers address?
B.Does this customer have any unpaid bills?
C.What is the balance in this customers account?
D.What are the total sales for each of the last 6 months?

单项选择题Which of the following tools is used to view historical information about tasks, database changes, messages, and notifications?（）

A.Journal
B.Task Center
C.Control Center
D.Activity Monitor

单项选择题Which of the following describes the model used by the Geodetic Extender?（）

A.Flat earth
B.3-D Square
C.Trapezoidal
D.Round earth

单项选择题Which of the following best describes the age of the data in an OLTP system?（）

A.Current
B.Projected
C.Historical
D.Current and projected