Tag: databases

Quizzes (243) Questions (4862)

Questions Related to databases

Multiple choice technology databases

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

  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
Reveal answer Fill a bubble to check yourself
C Correct answer
Full explanation
Multiple choice technology databases

Which of the following is true about XML columns?

  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
Reveal answer Fill a bubble to check yourself
A Correct answer
Full explanation