WGU - D426: Objective Assessment
Complete Questions And Answers
\. != - Answer- Compares two values for inequality.
\. % (Modulo) - Answer- Divides one numeric value by another and returns the integer
remainder
\. ^ - Answer- Raises one numeric value to the power of another.
\. = - Answer- Compares two values for equality.
\. ABS(n) (Function) - Answer- Returns the absolute value of n. Distance from zero. Always a
positive number or zero.
\. Adding and Dropping Constraints - Answer- Constraints are added and dropped with the
ALTER TABLE TableName followed by an ADD, DROP, or CHANGE clause.
\. Aggregate - Answer- Computes functions over multiple table rows, such as sum and
count.
\. Aggregate (Function) - Answer- COUNT() counts the number of rows in the set.
MIN() finds the minimum value in the set.
MAX() finds the maximum value in the set.
,SUM() sums all the values in the set.
AVG() computes the arithmetic mean of all the values in the set.
\. ALTER TABLE - Answer- Statement that adds, deletes, or modifies columns on an existing
table.
\. Analysis - Answer- __________ develops an entity-relationship model, capturing data
requirements while ignoring implementation details.
\. Analysis Phase, Conceptual Design, Entity-Relationship Modeling (Database Design) -
Answer- This phase specifies database requirements without regard to a specific database
system. Requirements are represented as entities, relationships, and attributes. An entity is a
person, place, activity, or thing. A relationship is a link between entities, and an attribute is a
descriptive property of an entity.
\. Analysis Steps - Answer- 1. Discover entities, relationships, and attributes
2. Determine cardinality
3. Distinguish strong and weak entities
4. Create supertype and subtype entities
\. Application Programming Interface (API) - Answer- To simplify the use of SQL with a
general-purpose language, database programs typically use an ____________ _____________
_______________.
\. Artificial Key - Answer- An __________ _____ is a single-column primary key created by
the database designer when no suitable single-column or composite primary key exists. Usually
artificial key values are integers, generated automatically by the database as new rows are
inserted to the table. Artificial keys are stable, simple, and meaningless.
, \. AS (Alias) - Answer- A column name can be replaced with an alias. The alias follows the
column name, separated by an optional AS keyword.
\. Attribute - Answer- A descriptive property of an entity.
\. Attribute Instance - Answer- An attribute instance is an individual value.
\. Authorization - Answer- Many database users should have limited access to specific
tables, columns, or rows of a database. Database systems authorize individual users to access
specific data.
\. Auto-Increment - Answer- Database users occasionally make the following errors when
inserting primary keys:
Inserting values for auto-increment primary keys.
Omitting values for primary keys that are not auto-increment columns.
MySQL allows insertion of a specific value to an auto-increment column. However, overriding
auto-increment for a primary key is usually a mistake.
\. BETWEEN (Operator) - Answer- The ________ operator provides an alternative way to
determine if a value is between two other values.
\. BIGINT - Answer- 8 bytes
\. Binary Search - Answer- In a ________ search, the database repeatedly splits the index in
two until it finds the entry containing the search value:
\. Boyce-Codd normal form - Answer- _______________________ ___________ _______ is
ideal for tables with frequent inserts, updates, and deletes.
Complete Questions And Answers
\. != - Answer- Compares two values for inequality.
\. % (Modulo) - Answer- Divides one numeric value by another and returns the integer
remainder
\. ^ - Answer- Raises one numeric value to the power of another.
\. = - Answer- Compares two values for equality.
\. ABS(n) (Function) - Answer- Returns the absolute value of n. Distance from zero. Always a
positive number or zero.
\. Adding and Dropping Constraints - Answer- Constraints are added and dropped with the
ALTER TABLE TableName followed by an ADD, DROP, or CHANGE clause.
\. Aggregate - Answer- Computes functions over multiple table rows, such as sum and
count.
\. Aggregate (Function) - Answer- COUNT() counts the number of rows in the set.
MIN() finds the minimum value in the set.
MAX() finds the maximum value in the set.
,SUM() sums all the values in the set.
AVG() computes the arithmetic mean of all the values in the set.
\. ALTER TABLE - Answer- Statement that adds, deletes, or modifies columns on an existing
table.
\. Analysis - Answer- __________ develops an entity-relationship model, capturing data
requirements while ignoring implementation details.
\. Analysis Phase, Conceptual Design, Entity-Relationship Modeling (Database Design) -
Answer- This phase specifies database requirements without regard to a specific database
system. Requirements are represented as entities, relationships, and attributes. An entity is a
person, place, activity, or thing. A relationship is a link between entities, and an attribute is a
descriptive property of an entity.
\. Analysis Steps - Answer- 1. Discover entities, relationships, and attributes
2. Determine cardinality
3. Distinguish strong and weak entities
4. Create supertype and subtype entities
\. Application Programming Interface (API) - Answer- To simplify the use of SQL with a
general-purpose language, database programs typically use an ____________ _____________
_______________.
\. Artificial Key - Answer- An __________ _____ is a single-column primary key created by
the database designer when no suitable single-column or composite primary key exists. Usually
artificial key values are integers, generated automatically by the database as new rows are
inserted to the table. Artificial keys are stable, simple, and meaningless.
, \. AS (Alias) - Answer- A column name can be replaced with an alias. The alias follows the
column name, separated by an optional AS keyword.
\. Attribute - Answer- A descriptive property of an entity.
\. Attribute Instance - Answer- An attribute instance is an individual value.
\. Authorization - Answer- Many database users should have limited access to specific
tables, columns, or rows of a database. Database systems authorize individual users to access
specific data.
\. Auto-Increment - Answer- Database users occasionally make the following errors when
inserting primary keys:
Inserting values for auto-increment primary keys.
Omitting values for primary keys that are not auto-increment columns.
MySQL allows insertion of a specific value to an auto-increment column. However, overriding
auto-increment for a primary key is usually a mistake.
\. BETWEEN (Operator) - Answer- The ________ operator provides an alternative way to
determine if a value is between two other values.
\. BIGINT - Answer- 8 bytes
\. Binary Search - Answer- In a ________ search, the database repeatedly splits the index in
two until it finds the entry containing the search value:
\. Boyce-Codd normal form - Answer- _______________________ ___________ _______ is
ideal for tables with frequent inserts, updates, and deletes.
