WGU C170 Top Exam Question with
accurate answers, 100% Accurate, rated
A+
Access plan - ✔✔A set of instructions generated at application compilation time that is created and
managed by a DBMS. The access plan pred
...
WGU C170 Top Exam Question with
accurate answers, 100% Accurate, rated
A+
Access plan - ✔✔A set of instructions generated at application compilation time that is created and
managed by a DBMS. The access plan predetermines how an application's query will access the
database at run time.
Alias - ✔✔An alternative name for a column or table in a SQL statement.
ALTER TABLE - ✔✔The SQL command used to make changes to table structure. When the command is
followed by a keyword (ADD or MODIFY), it adds a column or changes column characteristics.
AREA - ✔✔In DB2, a named section of permanent storage space that is reserved to store the database.
Atomic attribute - ✔✔An attribute that cannot be further subdivided to produce meaningful
components. For example, a person's last name attribute cannot be meaningfully subdivided.
Atomicity - ✔✔The transaction property that requires all parts of a transaction to be treated as a single,
indivisible, logical unit of work. All parts of a transaction must be completed or the entire transaction is
aborted.
automatic query optimization - ✔✔A method by which a DBMS finds the most efficient access path for
the execution of a query.
B-tree index - ✔✔An ordered data structure organized as an upside-down tree.
Base tables - ✔✔Tables on which the view is based
batch update routine - ✔✔A routine that pools transactions into a single batch to update a master table
in a single operation.
BETWEEN - ✔✔In SQL, a special comparison operator used to check whether a value is within a range of
specified values.
binary relationship - ✔✔An ER term for an association (relationship) between two entities. For example,
PROFESSOR teaches CLASS.
Bitmap index - ✔✔An index that uses a bit array (0s and 1s) to represent the existence of a value or
condition.
Boolean Algebra - ✔✔A branch of mathematics that uses the logical operators OR, AND, and NOT.
Boyce-Codd Normal Form (BCNF) - ✔✔A special type of third normal form (3NF) in which every
determinant is a candidate key. A table in BCNF must be in 3NF. See also determinant.
Candidate Key - ✔✔A minimal superkey; that is, a key that does not contain a subset of attributes that is
itself a superkey.
Cardinality - ✔✔A property that assigns a specific value to connectivity and expresses the range of
allowed entity occurrences associated with a single occurrence of the related entity.
Cascading order sequence - ✔✔A nested ordering sequence for a set of rows, such as a list in which all
last names are alphabetically ordered and, within the last names, all first names are ordered.
Closure - ✔✔A property of relational operators that permits the use of relational algebra operators on
existing tables (relations) to produce new relations.
Composite Attribute - ✔✔An attribute that can be further subdivided to yield additional attributes. For
example, a phone number such as 615-898-2368 may be divided into an area code (615), an exchange
number (898), and a four-digit code (2368). Compare to simple attribute.
Composite Entity - ✔✔An entity designed to transform an M:N relationship into two 1:M relationships.
The composite entity's primary key comprises at least the primary keys of the entities that it connects.
Also known as a bridge entity. See also linking table.
Composite Identifier - ✔✔In ER modeling, a key composed of more than one attribute.
Composite Key - ✔✔A multiple-attribute key.
Correlated Subquery - ✔✔A subquery that executes once for each row in the outer query.
COUNT - ✔✔A SQL aggregate function that outputs the number of rows containing not null values for a
given column or expression, sometimes used in conjunction with the DISTINCT clause.
CREATE INDEX - ✔✔A SQL command that creates indexes on the basis of a selected attribute or
attributes.
CREATE TABLE - ✔✔A SQL command that creates a table's structures using the characteristics and
attributes given.
CREATE VIEW - ✔✔A SQL command that creates a logical, "virtual" table based on stored end-user
tables. The view can be treated as a real table.
Cross Join - ✔✔A join that performs a relational product (or Cartesian product) of two tables.
Data Cache - ✔✔A shared, reserved memory area that stores the most recently accessed data blocks in
RAM. Also called buffer cache.
Data Sparsity - ✔✔A column distribution of values or the number of different values a column can have.
database performance tuning - ✔✔A set of activities and procedures designed to reduce the response
time of a database system—that is, to ensure that an end-user query is processed by the DBMS in the
minimum amount of time.
database statistics - ✔✔In query optimization, measurements about database objects, such as the
number of rows in a table, number of disk blocks used, maximum and average row length, number of
columns in each row, and number of distinct values in each column. Such statistics provide a snapshot of
database characteristics.
DBMS performance tuning - ✔✔Activities to ensure that clients' requests are addressed as quickly as
possible while making optimum use of existing resources.
DELETE - ✔✔A SQL command that allows data rows to be deleted from a table.
Denormalization - ✔✔A process by which a table is changed from a higher-level normal form to a lowerlevel normal form, usually to increase processing speed. Denormalization potentially yields data
anomalies.
dependency diagram - ✔✔A representation of all data dependencies (primary key, partial, or transitive)
within a table.
dependent - ✔✔An attribute whose value is determined by another attribute.
derived attribute - ✔✔An attribute that does not physically exist within the entity and is derived via an
algorithm. For example, the Age attribute might be derived by subtracting the birth date from the
current date.
Determinant - ✔✔Any attribute in a specific row whose value directly determines other values in that
row.
Determination - ✔✔The role of a key. In the context of a database table, the statement "A determines
B" indicates that knowing the value of attribute A means that the value of attribute B can be looked up.
DIFFERENCE - ✔✔A SQL clause that produces only a list of values that are different from one another.
Domain - ✔✔In data modeling, the construct used to organize and describe an attribute's set of possible
values.
DROP INDEX - ✔✔A SQL command used to delete database objects such as tables, views, indexes, and
users.
DROP TABLE - ✔✔A SQL command used to delete database objects such as tables, views, indexes, and
users.
dynamic query optimization - ✔✔The process of determining the SQL access strategy at run time, using
the most up-to-date information about the database.
dynamic statistical generation mode - ✔✔In a DBMS, the capability to automatically evaluate and
update the database access statistics after each data access operation.
Entity Integrity - ✔✔The property of a relational table that guarantees each entity has a unique value in
a primary key and that the key has no null values.
Equijoin - ✔✔A join operator that links tables based on an equality condition that compares specified
columns of the tables.
existence-dependent - ✔✔A property of an entity whose existence depends on one or more other
entities. In such an environment, the existence-independent table must be created and loaded first
because the existence-dependent key cannot reference a table that does not yet exist.
existence-independent - ✔✔A property of an entity that can exist apart from one or more related
entities. Such a table must be created first when referencing an existence-dependent table.
EXISTS - ✔✔In SQL, a comparison operator that checks whether a subquery returns any rows.
Extents - ✔✔In a DBMS environment, refers to the ability of data files to expand in size automatically
using predefined increments.
1NF - ✔✔The first stage in the normalization process. It describes a relation depicted in tabular format,
with no repeating groups and a primary key identified. All nonkey attributes in the relation are
dependent on the primary key.
Flags - ✔✔Special codes implemented by designers to trigger a required response, alert end users to
specified conditions, or encode values. Flags may be used to prevent nulls by bringing attention to the
absence of a value in a table.
foreign key (FK) - ✔✔An attribute or attributes in one table whose values must match the primary key in
another table or whose values must be null. See key.
4NF - ✔✔A table is in this form if it is in 3NF and contains no multiple independent sets of multivalued
dependencies
full functional dependence - ✔✔A condition in which an attribute is functionally dependent on a
composite key but not on any subset of the key.
Functional dependence - ✔✔Within a relation R, an attribute B is functionally dependent on an attribute
A if and only if a given value of the attribute A determines exactly one value of the attribute B. The
relationship "B is dependent on A" is equivalent to "A determines B" and is written as A B.
Granularity - ✔✔The level of detail in the model or the decision-making process
GROUP BY - ✔✔A SQL clause used to create frequency distributions when combined with any of the
aggregate functions in a SELECT statement.
hash index - ✔✔An index based on an ordered list of hash values.
HAVING - ✔✔A clause applied to the output of a GROUP BY operation to restrict selected rows.
homonymns - ✔✔The use of the same name to label different attributes. Homonyms generally should
be avoided. Some relational software automatically checks for homonyms and either alerts the user to
their existence or automatically makes th
[Show More]