Exit demo C2090-730 DB2 9 Family Fundamentals PDF format · free preview

IBM C2090-730 - Questions & Answers

Free preview · every answer includes a full explanation

Product page: https://prepkeys.com/c2090-730.html

Question 1
Single choice

Which of the following is the lowest cost DB2 product that can be legally installed on a Windows server that has 2 CPUs?

A.

DB2 Everyplace

B.

DB2 Express Edition

C.

DB2 Workgroup Server Edition

D.

DB2Enterprise Server Edition

Question 2
Single choice

Which of the following products is allowed to access other DB2 servers, but cannot accept requests from other remote clients?

A.

DB2 Personal Edition

B.

DB2 Workgroup Server Edition

C.

DB2Enterprise Server Edition

D.

DB2 Data Warehouse Edition

Question 3
Single choice

A client application on z/OS must access a DB2 database on a Solaris Server.
At a minimum, which of the following products must be installed on the Solaris workstation?

A.

DB2 ConnectEnterprise Edition

B.

DB2 Workgroup Server Edition

C.

DB2 Workgroup Server Edition and DB2 ConnectEnterprise Edition

D.

DB2Enterprise Server Edition and DB2 Connect Enterprise Edition

Question 4
Single choice

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

Question 5
Single choice

Which of the following products must be installed on an AIX server in order to build an application for AIX that will access a DB2 for z/OS database?

A.

DB2Enterprise Server Edition

B.

DB2 Personal Developer's Edition

C.

DB2 Universal Developer's Edition

D.

DB2 Universal DatabaseEnterprise Edition and DB2 Connect Enterprise Edition

Question 6
Single choice

Which of the following DB2 products can only be installed on a System i server?

A.

DB2 for z/OS

B.

DB2 for i5/OS

C.

DB2 Data Warehouse Edition

D.

DB2Enterprise Server Edition

Question 7
Single choice

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

Question 8
Single choice

Which of the following tools can be used to catalog a database?

A.

Visual Explain

B.

Alert Center

C.

Journal

D.

Configuration Assistant

Question 9
Single choice

Which of the following is used to create and debug user-defined functions?

A.

SQL Assist

B.

Control Center

C.

Command Editor

D.

Developer Workbench

Question 10
Single choice

Which of the following DB2 tools allows a user to set DB2 registry parameters?

A.

Task Center

B.

Visual Explain

C.

Configuration Assistant

D.

Satellite Administration Center

Showing 10 of 302 questions · Unlock the full set