Data Management Foundation C175 WGU
1.An associative entity is an element of the entity-relationship model. All
relationships for the associative entity should be many.: Associative Entity
2.An attribute is a property or characteristic of an entity.: Attribute
3.A binary relationship is a relationship between two entity types.: Binary
relationship
4.Is any column or a combination of columns that can qualify as unique key in
database.: Candidate Key
5.Cardinality represents the maximum number of entities that can be involved in a
particular relationship.: Cardinality
6.Usually the result of a missing join condition or a method of expanding the data of
1 table by the number of rows in the second table.: Cartesian product
7.Will delete all records that reference the primary key: Cascade Delete
8.Returns a single column of one or more values.: column subquery
9.When data is encrypted, it is changed, bit by bit or character by character, into a
form that looks totally garbled. It can and must be reconverted, or decrypted, back
to its original form to be of use.: data encryption
10.Is a methodology for organizing attributes into tables so that redundancy among
the non-key attributes is eliminated.: Data normalization
11.Describes how often stored data is updated.: Data volatility
12.Understanding of how much data will be in a database or a table within a
database: Data Volume Assessment
13.A database is a collection of information that is organized so that it can easily
be accessed, managed, and updated.: Database
14.Data control language is used to control access to data stored in a data- base.:
DCL
15.Data definition language - involves instructing the DBMS software on what tables
will be in the database, what attributes will be in the tables, which attributes will be
indexed, and so forth.: DDL
16.Definer is a MySQL term where AuthID is the same for another DBMS: De- finer
17.The act of duplicating data in a database for performance or the preserva- tion of
historical information: Denormalization
18.Involves rebuilding an entire information system or significant parts of one after a
catastrophic natural disaster such as a hurricane, tornado, earthquake, building
collapse, or even a major fire.: disaster recovery
19.Data manipulation language refers to the four basic operations that can and
must be performed on data stored in any DBMS: data retrieval, data update,
insertion of new records, and deletion of existing records.: DML
1/
5
, Data Management Foundation C175 WGU
20.An E-R model is a data model for describing a database in an abstract way.:
E-R model
21.The SELECT command is embedded within the lines of a higher-level
language program and functions as an input or "read" statement for the
program.: embedded mode
22.An entity is an object or event in our environment that we want to keep track
of.: Entity
23.Is a field (or collection of fields) in one table that uniquely identifies a row of
another table.: Foreign Key
24.Used to help a DBMS find data quickly: Index
25.Shows row that have matches in both tables: Inner Join
26.Intersection Data associated with the concatenation of two segments.: In-
tersection Data
27.Joins 2 tables together: Join
28.Is a mapping onto a physical table or tables that allows an end user to access
only a specified portion of data.: logical view
29.Modality represents the minimum number of entity occurrences that can be
involved in a relationship.: Modality
30.Shows rows in one table that have no match in the other table. Two kinds of
outer joins are left and right joins.: outer join
31.Uniquely identifies each record in the table.: Primary Key
32.The command goes directly to the relational DBMS, which evaluates the query
and processes it against the database.: query mode
33.Referential integrity is a database concept that ensures that relationships between
tables remain consistent.: Referential Integrity
34.Enforces rules to guarantee that the foreign key relationship stays intact with no
mismatches.: referential integrity
35.Is the delay from the time that the Enter Key is pressed to execute a query until
the result appears on screen.: Response time
36.Will not allow deletes if the primary key is referenced: Restrict Delete
37.Returns a single row of one or more values.: row subquery
38.is the most restrictive subquery because it produces only a single value-
: scalar subquery
39.Will set values to null when primary key is deleted: Set-to-Null on Delete
40.Is a comprehensive database management language which incorporates DML
and DDL: SQL
41.One SELECT statement is "nested" within another.: subquery
42.Returns a table of one or more rows of one or more columns.: table sub- query
2/
5
1.An associative entity is an element of the entity-relationship model. All
relationships for the associative entity should be many.: Associative Entity
2.An attribute is a property or characteristic of an entity.: Attribute
3.A binary relationship is a relationship between two entity types.: Binary
relationship
4.Is any column or a combination of columns that can qualify as unique key in
database.: Candidate Key
5.Cardinality represents the maximum number of entities that can be involved in a
particular relationship.: Cardinality
6.Usually the result of a missing join condition or a method of expanding the data of
1 table by the number of rows in the second table.: Cartesian product
7.Will delete all records that reference the primary key: Cascade Delete
8.Returns a single column of one or more values.: column subquery
9.When data is encrypted, it is changed, bit by bit or character by character, into a
form that looks totally garbled. It can and must be reconverted, or decrypted, back
to its original form to be of use.: data encryption
10.Is a methodology for organizing attributes into tables so that redundancy among
the non-key attributes is eliminated.: Data normalization
11.Describes how often stored data is updated.: Data volatility
12.Understanding of how much data will be in a database or a table within a
database: Data Volume Assessment
13.A database is a collection of information that is organized so that it can easily
be accessed, managed, and updated.: Database
14.Data control language is used to control access to data stored in a data- base.:
DCL
15.Data definition language - involves instructing the DBMS software on what tables
will be in the database, what attributes will be in the tables, which attributes will be
indexed, and so forth.: DDL
16.Definer is a MySQL term where AuthID is the same for another DBMS: De- finer
17.The act of duplicating data in a database for performance or the preserva- tion of
historical information: Denormalization
18.Involves rebuilding an entire information system or significant parts of one after a
catastrophic natural disaster such as a hurricane, tornado, earthquake, building
collapse, or even a major fire.: disaster recovery
19.Data manipulation language refers to the four basic operations that can and
must be performed on data stored in any DBMS: data retrieval, data update,
insertion of new records, and deletion of existing records.: DML
1/
5
, Data Management Foundation C175 WGU
20.An E-R model is a data model for describing a database in an abstract way.:
E-R model
21.The SELECT command is embedded within the lines of a higher-level
language program and functions as an input or "read" statement for the
program.: embedded mode
22.An entity is an object or event in our environment that we want to keep track
of.: Entity
23.Is a field (or collection of fields) in one table that uniquely identifies a row of
another table.: Foreign Key
24.Used to help a DBMS find data quickly: Index
25.Shows row that have matches in both tables: Inner Join
26.Intersection Data associated with the concatenation of two segments.: In-
tersection Data
27.Joins 2 tables together: Join
28.Is a mapping onto a physical table or tables that allows an end user to access
only a specified portion of data.: logical view
29.Modality represents the minimum number of entity occurrences that can be
involved in a relationship.: Modality
30.Shows rows in one table that have no match in the other table. Two kinds of
outer joins are left and right joins.: outer join
31.Uniquely identifies each record in the table.: Primary Key
32.The command goes directly to the relational DBMS, which evaluates the query
and processes it against the database.: query mode
33.Referential integrity is a database concept that ensures that relationships between
tables remain consistent.: Referential Integrity
34.Enforces rules to guarantee that the foreign key relationship stays intact with no
mismatches.: referential integrity
35.Is the delay from the time that the Enter Key is pressed to execute a query until
the result appears on screen.: Response time
36.Will not allow deletes if the primary key is referenced: Restrict Delete
37.Returns a single row of one or more values.: row subquery
38.is the most restrictive subquery because it produces only a single value-
: scalar subquery
39.Will set values to null when primary key is deleted: Set-to-Null on Delete
40.Is a comprehensive database management language which incorporates DML
and DDL: SQL
41.One SELECT statement is "nested" within another.: subquery
42.Returns a table of one or more rows of one or more columns.: table sub- query
2/
5
