CIS275 - Chapter 10: Complex Data Types

Question 1

Answer 1

Question 2

Answer 2

Question 3

Answer 3

Question 4

Answer 4

Question 5

Answer 5

Question 6

1. A SET is defined with the SET keyword followed by a list of elements.
2. SET values are specified as strings containing elements separated by commas. The string cannot contain blanks.

Answer 6

3. SET values can be compared with string functions.

Question 7

Answer 7

Question 8

1. The QuarterlySales column is an array of four integers, representing employee sales in each of four quarters.
2. Array values are specified as elements separated by commas and within braces.

Answer 8

3. QuarterlySales[2] refers to the second element of each value in the QuarterlySales column.

Question 9

Answer 9

Question 10

Answer 10

Question 11

Answer 11

Question 12

Answer 12

Question 13

1. The Library table contains a Book column with JSON type.
2. JSON_OBJECT() converts element names and data to a JSON document, stored in the internal MySQL format.
3. The SELECT statement retrieves JSON documents. Each document appears on one line.

Answer 13

4. The SELECT statement uses JSON_EXTRACT() to extract data from the Book column. Only “Tom Sawyer” has a Pages element.

Question 14

Answer 14

Question 15

1. A point in two dimensions has X and Y coordinates. POINT(22 8) is WKT format.
2. A WKT linestring is a series of connected line segments. Points are separated by commas.

Answer 15

3. A WKT polygon is a series of points, separated by commas and enclosed in an extra set of parentheses.
4. WKT polygons can have holes. The first polygon is the outer boundary and the second is a hole.

Question 16

Answer 16

Question 17

Answer 17

Question 18

1. Location is a spatial column. Coordinates are latitude and longitude in spatial reference system 4326.
2. INSERT statement converts WKT to internal format with ST_POINTFROMTEXT(), which requires an SRID parameter.

Answer 18

3. SELECT statement converts internal format to WKT with ST_ASTEXT().

Question 19

Answer 19

Question 20

1. The Capital table contains state capitals. Location values are latitude and longitude in spatial reference system 4326.
2. ST_DISTANCE() computes each capital’s distance in meters to 40° latitude and -100° longitude. MySQL uses the British spelling ‘metre’ rather than the American spelling ‘meter’.

Answer 20

3. The WHERE clauses uses ST_X() to get the Location’s X-coordinate. Spatial data must be converted to numeric data to use a comparison operator.
4. Sacramento and Des Moines both have X-coordinates < 42. Distance is displayed in meters.

Question 21

Answer 21

Question 22

Answer 22

Question 23

Answer 23

Question 24

Answer 24

Question 25

Answer 25

Question 26

1. The supertype must specify NOT FINAL to allow subtypes. 2. GlobalAddressType is a subtype of AddressType with an additional property. 3. GlobalAddressType overrides the FormatAddress function.

Answer 26

4. The global FormatAddress function adds the country the formatted address.

Question 27

Answer 27