Tag: databases

Questions Related to databases

Which of the following best describes the difference between the DB2 Spatial Extender and the DB2 Geodetic Extender?

technology databases

  1. The DB2 Spatial Extender uses a latitude-longitude coordinate system; the DB2 Geodetic Extender uses a planar, x- and y-coordinate system

  2. The DB2 Geodetic Extender is used to describe points, lines, and polygons; the DB2 Spatial Extender is used to find area, endpoints, and intersects

  3. The DB2 Spatial Extender treats the world as a flat map; the DB2 Geodetic Extender treats the world as a round globe

  4. The DB2 Geodetic Extender can be used to manage information like the locations of office buildings or the size of a flood zone; the DB2 Spatial Extender can be used for calculations and visualizations in disciplines like military command/control and asset

Show answer
Correct Option: C

Which of the following is true about XML columns?
technology databases

  1. XML columns are used to store XML documents as a hierarchical set of entities

  2. Only XQuery can be used to retrieve an XML document from an XML column

  3. XML columns must be altered to accommodate additional parent/child relationships if they are used in referential constraints

  4. In order to access any portion of an XML document stored in an XML column, the entire document must be retrieved

Show answer
Correct Option: A

Which of the following is the major difference between relational data and XML data?

technology databases

  1. A. Relational data is self-describing; XML data is not

  2. B. Relational data has inherent ordering; XML data does not

  3. C. Relational data must be tabular; XML data does not have to be tabular

  4. D. Relational data is comprised of entities; XML data is comprised of numbers, characters, and dates

Show answer
Correct Option: C

Which of the following is the major difference between relational data and XML data?
technology databases

  1. A. Relational data is self-describing; XML data is not

  2. B. Relational data has inherent ordering; XML data does not

  3. C. Relational data must be tabular; XML data does not have to be tabular

  4. D. Relational data is comprised of entities; XML data is comprised of numbers, characters, and dates

Show answer
Correct Option: C

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

technology databases

  1. DB2 Personal Edition

  2. DB2 Workgroup Server Edition

  3. DB2 Enterprise Server Edition

  4. DB2 Data Warehouse Edition

Show answer
Correct Option: B

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. DB2 Enterprise Server Edition and DB2 Connect Enterprise Edition

Show answer
Correct Option: C

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. DB2 Enterprise 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 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 DB tools allow the user to execute an SQL statement and view a graphical representation of the access plan?
technology databases

  1. Task Center

  2. Command Editor

  3. Developer Workbench

  4. Command Line Processor

Show answer
Correct Option: B