WGU C175 Final+1+2
1. Raw facts that are captured on printed or digital media: What is a
broad definition of data?
2. Facts that are collected and stored in a database system: What are data?
3.It does not follow a data model.: What is a determining characteristic of
unstruc- tured data?
4. They contain no internal hierarchical organization.: Which is true about
flat files?
5. Flat files: Which technology has no internal hierarchy?
6. Sequentially from simple files: How were data retrieved before
database man- agement systems?
7. - It enables data sharing,
- It permits storage of vast volumes of data.: In which two ways does a
database management system environment increase effectiveness in
working with data?
8. Entity types: What is the uniquely identifiable element about which
data can be categorized in an entity-relationship diagram?
9. Intersection data: Which classification is correct for the box marked
"Quantity" in the given entity-relationship diagram?
10.Event: Which data classification is an entity?
11.Many-to-many: A salesperson is authorized to sell 12 products; a
product can be sold by 10 salespersons.
Which kind of binary relationship is described in this example?
12.Insert, Delete, Update: Which three kinds of rules for referential
integrity are provided by modern relational database management
systems?
13. Reference to data in one relation is based on values in another relation.:
What is an important aspect of "referential integrity"?
14.Customer names: Sales data, detailing the customer names,
products sold, and salespersons, is kept in a database.
Which kind of data in this database would qualify as intersection data
related to both the product and salesperson entities?
15.Primary key: What is an attribute or group of attributes that uniquely
identify a tuple in a relation?
16.A domain of values: What is necessary for a primary key in one
relation of a database to match with its corresponding foreign key in
another relation of the same database?
1/9
, WGU C175 Final+1+2
17.The alternate key: What uniquely identifies each entity in a collection
of entities but is not the primary key?
2/9
, WGU C175 Final+1+2
18.Candidate key: What is a term for a set of columns in a table that can
uniquely identify any record in that table without referring to other
data?
19.It is copied to the index.: What happens to the original data in
database indexing?
20.To retrieve data directly using a pointer.: Why are indexes created
in a physical database design?
21.To optimize data retrievals: Why is an index created on a database
column?
22.WHERE COMMPERCT=15;: Refer to the given SQL statement.
SELECT SPNUM, SPNAME
FROM SALESPERSON
What is the correct line to add to the end of this statement to find
salespersons with a commission percentage of 15?
23.Replace COMMPERCT, YEARHIRE with an asterisk: Refer to the given
SQL statement.
SELECT COMMPERCT, YEARHIRE
FROM SALESPERSON
WHERE SPNUM=22;
How should this statement be altered to retrieve the entire record
instead of the commission percentage and year of hire?
24.AND CUSTNUM>1000;: A manager asks an employee to list attributes
of the customers that are headquartered in Los Angeles and that have a
customer number higher than 1000. Refer to the given SQL statement
prepared by this employee.
SELECT CUSTNUM, CUSTNAME, HQCITY
FROM CUSTOMER
WHERE HQCITY='Los Angeles'
Which line should go at the end of this statement?
25.ORDER BY modifies the presentation of data results and DISTINCT
filters data results.: What is a key difference between the DISTINCT and
ORDER BY statements, in SQL SELECT commands?
26.ORDER BY SATCITY, CUSTNAME;: Which SQL statement
3/9
1. Raw facts that are captured on printed or digital media: What is a
broad definition of data?
2. Facts that are collected and stored in a database system: What are data?
3.It does not follow a data model.: What is a determining characteristic of
unstruc- tured data?
4. They contain no internal hierarchical organization.: Which is true about
flat files?
5. Flat files: Which technology has no internal hierarchy?
6. Sequentially from simple files: How were data retrieved before
database man- agement systems?
7. - It enables data sharing,
- It permits storage of vast volumes of data.: In which two ways does a
database management system environment increase effectiveness in
working with data?
8. Entity types: What is the uniquely identifiable element about which
data can be categorized in an entity-relationship diagram?
9. Intersection data: Which classification is correct for the box marked
"Quantity" in the given entity-relationship diagram?
10.Event: Which data classification is an entity?
11.Many-to-many: A salesperson is authorized to sell 12 products; a
product can be sold by 10 salespersons.
Which kind of binary relationship is described in this example?
12.Insert, Delete, Update: Which three kinds of rules for referential
integrity are provided by modern relational database management
systems?
13. Reference to data in one relation is based on values in another relation.:
What is an important aspect of "referential integrity"?
14.Customer names: Sales data, detailing the customer names,
products sold, and salespersons, is kept in a database.
Which kind of data in this database would qualify as intersection data
related to both the product and salesperson entities?
15.Primary key: What is an attribute or group of attributes that uniquely
identify a tuple in a relation?
16.A domain of values: What is necessary for a primary key in one
relation of a database to match with its corresponding foreign key in
another relation of the same database?
1/9
, WGU C175 Final+1+2
17.The alternate key: What uniquely identifies each entity in a collection
of entities but is not the primary key?
2/9
, WGU C175 Final+1+2
18.Candidate key: What is a term for a set of columns in a table that can
uniquely identify any record in that table without referring to other
data?
19.It is copied to the index.: What happens to the original data in
database indexing?
20.To retrieve data directly using a pointer.: Why are indexes created
in a physical database design?
21.To optimize data retrievals: Why is an index created on a database
column?
22.WHERE COMMPERCT=15;: Refer to the given SQL statement.
SELECT SPNUM, SPNAME
FROM SALESPERSON
What is the correct line to add to the end of this statement to find
salespersons with a commission percentage of 15?
23.Replace COMMPERCT, YEARHIRE with an asterisk: Refer to the given
SQL statement.
SELECT COMMPERCT, YEARHIRE
FROM SALESPERSON
WHERE SPNUM=22;
How should this statement be altered to retrieve the entire record
instead of the commission percentage and year of hire?
24.AND CUSTNUM>1000;: A manager asks an employee to list attributes
of the customers that are headquartered in Los Angeles and that have a
customer number higher than 1000. Refer to the given SQL statement
prepared by this employee.
SELECT CUSTNUM, CUSTNAME, HQCITY
FROM CUSTOMER
WHERE HQCITY='Los Angeles'
Which line should go at the end of this statement?
25.ORDER BY modifies the presentation of data results and DISTINCT
filters data results.: What is a key difference between the DISTINCT and
ORDER BY statements, in SQL SELECT commands?
26.ORDER BY SATCITY, CUSTNAME;: Which SQL statement
3/9
