Which of the following is the lowest cost DB2 product that can be legally installed on an AIX server?
A. DB2 Express Edition
B. DB2 Personal Edition
C. DB2 Workgroup Server Edition
D. DB2Enterprise Server Edition
Which of the following DB2 tools allows a user to execute an SQL statement and view a graphical representation of the access plan?
A. Task Center
B. Command Editor
C. Developer Workbench
D. Command Line Processor
Which of the following DB2 products are required on an iSeries or System I server to enable an application running on that server to retrieve data from a DB2 database on a Linux server?
A. DB2 for i5/OS
B. DB2 Runtime Client
C. DB2 ConnectEnterprise Edition
D. DB2 for i5/OS SQL Development Kit
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
Which of the following is NOT true about XML columns?
A. Data can be retrieved by SQL.
B. Data can be retrieved byXQuery.
C. XML columns must be altered to accommodate additional parent and child relationships.
D. Access to any portion of an XML document can be direct, without reading the whole document.
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
Which of the following is the main feature of an OLTP application?
A. Summarized queries
B. Granular transactions
C. Voluminous historical data
D. Heterogeneous data sources
For which of the following is a data warehouse optimized?
A. Backup and recovery
B. Transactions
C. Security
D. Queries
Which of the following is the lowest cost DB2 product that can be legally installed on a Linux server that has 6 CPUs?
A. DB2 Express Edition
B. DB2 Personal Edition
C. DB2 Workgroup Server Edition
D. DB2Enterprise Server Edition
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. z/OS Application Connectivity to DB2 for z/OS and OS/390
Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only IBM exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your C2090-730 exam preparations and IBM certification application, do not hesitate to visit our Vcedump.com to find your solutions here.