WGU D427 DATA MANAGEMENT
APPLICATIONS COMPREHENSIVE EXAM
SCRIPT VERIFIED QUESTIONS COMPLETE
ANSWERS GRADED APLUS
◉ Square Bracket []
Answer: optional language element
◉ Curly Braces {}
Answer: list of alternatives, one and only one option must be
selected
◉ Ellipsis ...
Answer: indicate that hte preceding language element may be
repeated
◉ Parentheses () and ,
Answer: literal symbols
◉ Data Independence
,Answer: Ability to change the organization of data on storage
devices, without affecting query results
◉ Data Types
Answer: Set of values from which column values are drawn. Integer,
Decimal, Character, Date and Time, Binary, Spatial, and Document.
◉ T/F The DROP TABLE statement only works if the table is empty
Answer: False
◉ ALTER TABLE
Answer: Adds, deletes, or modifies columns in an existing table.
ADD, CHANGE, and DROP. Including constraints (using CHANGE)
◉ BINARY
Answer: Store data exactly as the data appears in memory, bit for bit.
BLOB, BINARY, VARBINARY, and IMAGE.
◉ SPATIAL
Answer: Store geometric information. POLYGON, POINT, and
GEOMETRY.
◉ TINYINT
, Answer: 1 byte -128 to 127 or 0 to 255
◉ SMALLINT
Answer: 2 bytes -32,768 to 32,767 or 0 to 65,535
◉ MEDIUMINT
Answer: 3 bytes -8,388,608 to 8,388,607 or 0 16,777,215
◉ INT
Answer: 4 bytes -2,147,483,648 to 2,147,483,647 or 0 to
4,294,967,295
◉ BIGINT
Answer: 8 bytes -2^63 to 2^63-1 or 0 2^64-1
◉ FLOAT
Answer: 4 bytes wide range for decimals
◉ Arithemtic Operators
Answer: Compute numeric values from numeric operands. + - -
(unary) * / %
APPLICATIONS COMPREHENSIVE EXAM
SCRIPT VERIFIED QUESTIONS COMPLETE
ANSWERS GRADED APLUS
◉ Square Bracket []
Answer: optional language element
◉ Curly Braces {}
Answer: list of alternatives, one and only one option must be
selected
◉ Ellipsis ...
Answer: indicate that hte preceding language element may be
repeated
◉ Parentheses () and ,
Answer: literal symbols
◉ Data Independence
,Answer: Ability to change the organization of data on storage
devices, without affecting query results
◉ Data Types
Answer: Set of values from which column values are drawn. Integer,
Decimal, Character, Date and Time, Binary, Spatial, and Document.
◉ T/F The DROP TABLE statement only works if the table is empty
Answer: False
◉ ALTER TABLE
Answer: Adds, deletes, or modifies columns in an existing table.
ADD, CHANGE, and DROP. Including constraints (using CHANGE)
◉ BINARY
Answer: Store data exactly as the data appears in memory, bit for bit.
BLOB, BINARY, VARBINARY, and IMAGE.
◉ SPATIAL
Answer: Store geometric information. POLYGON, POINT, and
GEOMETRY.
◉ TINYINT
, Answer: 1 byte -128 to 127 or 0 to 255
◉ SMALLINT
Answer: 2 bytes -32,768 to 32,767 or 0 to 65,535
◉ MEDIUMINT
Answer: 3 bytes -8,388,608 to 8,388,607 or 0 16,777,215
◉ INT
Answer: 4 bytes -2,147,483,648 to 2,147,483,647 or 0 to
4,294,967,295
◉ BIGINT
Answer: 8 bytes -2^63 to 2^63-1 or 0 2^64-1
◉ FLOAT
Answer: 4 bytes wide range for decimals
◉ Arithemtic Operators
Answer: Compute numeric values from numeric operands. + - -
(unary) * / %
