Tag: databases

Questions Related to databases

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?
technology databases

  1. DB2 Connect Enterprise Edition

  2. DB2 Workgroup Server Edition

  3. DB2 Workgroup Server Edition and DB2 Connect Enterprise Edition

  4. DB2Enterprise Server Edition and DB2 Connect Enterprise Edition

Show answer
Correct Option: D

Which of the following is the lowest cost DB2 product that can be legally installed on an HP-UX server?
technology databases

  1. DB2 Express-C

  2. DB2 Express

  3. DB2 Personal Edition

  4. DB2Enterprise Server Edition

Show answer
Correct Option: D

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?
technology databases

  1. DB2Enterprise Server Edition

  2. DB2 Personal Developer's Edition

  3. DB2 Universal Developer's Edition

  4. DB2 Universal Database Enterprise Edition and DB2 Connect Enterprise Edition

Show answer
Correct Option: C

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

  1. DB2 for z/OS

  2. DB2 for i5/OS

  3. DB2 Data Warehouse Edition

  4. DB2Enterprise Server Edition

Show answer
Correct Option: B

What is the purpose of the Design Advisor?
technology databases

  1. To analyze workloads and make recommendations for indexes and MQTs

  2. To present a graphical representation of a data access plan and recommend design changes that will improve performance

  3. To replicate data between a DB2 database and another relational database

  4. To configure clients so they can access databases stored on remote servers

Show answer
Correct Option: A

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

technology databases

  1. Visual Explain

  2. Alert Center

  3. Journal

  4. Configuration Assistant

Show answer
Correct Option: A

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

  1. SQL Assist

  2. Control Center

  3. Command Editor

  4. Developer Workbench

Show answer
Correct Option: D

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

technology databases

  1. Task Center

  2. Visual Explain

  3. Configuration Assistant

  4. Satellite Administration Center

Show answer
Correct Option: C

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

technology databases

  1. DB2 Everyplace

  2. DB2 Express Edition

  3. DB2 Workgroup Server Edition

  4. DB2 Enterprise Server Edition

Show answer
Correct Option: B

Which of the following is the lowest cost DB2 product that can be legally installed on an HP-UX server?

technology databases

  1. DB2 Express-C

  2. DB2 Express

  3. DB2 Personal Edition

  4. DB2 Enterprise Server Edition

Show answer
Correct Option: D