WGU C175 OBJECTIVE ASSESSMENT PRACTICE TEST ANSWERS| IT CIS111 TEST BANK 1

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?
17.The alternate key: What uniquely identifies each entity in a collection of entities but
is not the primary key?



1/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 alphabetizes cus-
tomer names within the same satellite-office city? ORDER or ALPHA?
27.WHERE SALESPERSON.SPNUM=SALES.SPNUM AND SALES.PROD-
NUM=PRODUCT.PRODNUM: The given SQL statement is intended to list the

2/9