C170 WGU ALREADY
PASSED
An entity is said to be X -dependent if it can exist in the database only when it is associated with
another related entity occurrence. - ✔✔existence
A table that has all key attributes defined has no repeating groups and all its attributes are
dependent on the primary key is said to be in X. - ✔✔1nf
A determinant is any attribute whose value determines other values within a column. - ✔✔F
X is a process that is used for changing attributes to entities. - ✔✔Normalization
Any attribute whose value determines other values within a row is known as a X. - ✔✔determinant
Data redundancy produces data anomalies - ✔✔T
Normalization is a very important database design ingredient and the highest level is always the most
desirable. - ✔✔T
A table that is in 2NF and contains no transitive dependencies is said to be in X. - ✔✔3NF
An attribute that cannot be further subdivided is said to be X. - ✔✔atomic
In the X no row may contain two or more multivalued facts about an entity. - ✔✔4NF (fourth normal
form)
When a table contains only one candidate key X are considered to be equivalent. - ✔✔3nf and bcnf
, All relational tables satisfy the X requirements. - ✔✔1NF (first normal form)
BCNF can be violated only if the table contains more than one X key. - ✔✔candidate
All relational tables satisfy the 1NF requirements. - ✔✔T
When designing a database you should X. - ✔✔make sure that the table entities are normalized
before table structures are created
Using the X command SQL indexes can be created on the basis of any selected attribute. - ✔✔CREATE
INDEX
A table can be deleted from the database by using the X statement. - ✔✔DROP TABLE
Most SQL implementations yield case-insensitive searches. - ✔✔F
To list the contents of a table you must use the DISPLAY command. - ✔✔F
The X clause of the GROUP BY statement operates very much like the WHERE clause in the SELECT
statement. - ✔✔HAVING
A X sequence is a multilevel ordered sequence that can be created easily by listing several attributes
separated by commas after the ORDER BY clause. - ✔✔cascading order
A X also known as a nested query or an inner query is a query that is embedded (or nested) inside
another query. - ✔✔subquery
The special operator used to check whether an attribute value matches a given string pattern is X -
✔✔LIKE
A X is a logical group of database objects such as tables and indexes that are related to each other. -
✔✔schema
PASSED
An entity is said to be X -dependent if it can exist in the database only when it is associated with
another related entity occurrence. - ✔✔existence
A table that has all key attributes defined has no repeating groups and all its attributes are
dependent on the primary key is said to be in X. - ✔✔1nf
A determinant is any attribute whose value determines other values within a column. - ✔✔F
X is a process that is used for changing attributes to entities. - ✔✔Normalization
Any attribute whose value determines other values within a row is known as a X. - ✔✔determinant
Data redundancy produces data anomalies - ✔✔T
Normalization is a very important database design ingredient and the highest level is always the most
desirable. - ✔✔T
A table that is in 2NF and contains no transitive dependencies is said to be in X. - ✔✔3NF
An attribute that cannot be further subdivided is said to be X. - ✔✔atomic
In the X no row may contain two or more multivalued facts about an entity. - ✔✔4NF (fourth normal
form)
When a table contains only one candidate key X are considered to be equivalent. - ✔✔3nf and bcnf
, All relational tables satisfy the X requirements. - ✔✔1NF (first normal form)
BCNF can be violated only if the table contains more than one X key. - ✔✔candidate
All relational tables satisfy the 1NF requirements. - ✔✔T
When designing a database you should X. - ✔✔make sure that the table entities are normalized
before table structures are created
Using the X command SQL indexes can be created on the basis of any selected attribute. - ✔✔CREATE
INDEX
A table can be deleted from the database by using the X statement. - ✔✔DROP TABLE
Most SQL implementations yield case-insensitive searches. - ✔✔F
To list the contents of a table you must use the DISPLAY command. - ✔✔F
The X clause of the GROUP BY statement operates very much like the WHERE clause in the SELECT
statement. - ✔✔HAVING
A X sequence is a multilevel ordered sequence that can be created easily by listing several attributes
separated by commas after the ORDER BY clause. - ✔✔cascading order
A X also known as a nested query or an inner query is a query that is embedded (or nested) inside
another query. - ✔✔subquery
The special operator used to check whether an attribute value matches a given string pattern is X -
✔✔LIKE
A X is a logical group of database objects such as tables and indexes that are related to each other. -
✔✔schema
