31.
Which of the following is the major difference between relational data and XML data?
- A.Relational data is self-describing; XML data is not
- B.Relational data has inherent ordering; XML data does not
- C.Relational data must be tabular; XML data does not have to be tabular
- D.Relational data is comprised of entities; XML data is comprised of numbers, characters, and dates
- Answer
- Report
Answer : [C]
32.
Which product must be installed on z/OS to allow a COBOL program running on that machine to access data on a remote DB2 for z/OS server?
- A.DB2 for z/OS
- B.DB2 Run-Time Client for z/OS
- C.DB2 Connect Enterprise Edition for z/OS
- D.Current and projectedz/OS Application Connectivity to DB2 for z/OS and OS/390
- Answer
- Report
Answer : [A]
33.
Which of the following tools can make recommendations for indexes and/or MQTs to improve the performance of DB2 applications?
- A.Design Advisor
- B.Visual Explain
- C.Performance Advisor
- D.What are the total sales for each of the last 6 months?Configuration Assistant
- Answer
- Report
Answer : [A]
34.
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]
35.
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/li>
- D.DB2 Performance Monitor
- Answer
- Report
Answer : [C]
|
|
||||||||||||||||||||||||||||
