26.
Which of the following tasks can NOT be performed using the Developer Workbench?
- A.Develop and debug an SQL stored procedure
- B.Develop and debug a user-defined data type
- C.Develop and debug a user-defined function
- D.Develop and run XML queries
- Answer
- Report
Answer : [B]
27.
Which of the following tools can be used to automate table reorganization operations?
- A.Control Center
- B.Command Center
- C.Command Line Processor
- D.Task Center
- Answer
- Report
Answer : [D]
28.
Which of the following can be viewed with the Journal?
- A.Historical information about tasks, database changes, messages, and notifications
- B.Information about licenses associated with each DB2 9 product installed on a particular system
- C.Graphical representations of data access plans chosen for SQL statements
- D.Warning and alarm thresholds for database indicators
- Answer
- Report
Answer : [A]
29.
Which of the following is NOT a characteristic of a data warehouse?
- A.Summarized queries that perform aggregations and joins
- B.Granular transactionsHeterogeneous data sources
- C.Voluminous historical data
- D.Sub-second response time
- Answer
- Report
Answer : [D]
30.
Which of the following products is used to shred extensible markup language documents?
- A.DB2 AVI Extender
- B.DB2 Text Extender
- C.DB2 XML Extender
- D.DB2 Spatial Extender
- Answer
- Report
Answer : [C]
|
|
||||||||||||||||||||||||||||
