WGU C175 Pre-Assessment
Questions with Accurate Answers
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? correct answer AND
CUSTNUM>1000;
A product-marketing company publishes an Internet-based newsletter
about their new products to increase their customer base.
What is an advantage that this company will gain from investing in a
relational database management system that will store customer
information? correct answer Improved query response times
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? correct
answer Many-to-many
During which step in the extract, transform, load (ETL) process are raw
data sets aggregated? correct answer Transformation
How is prediction distinguished from estimation in data mining? correct
answer Prediction classifies objects according to an expected future
behavior.
How were data retrieved before database management systems?
correct answer Sequentially from simple files
ID Contract Code
1 Vinod 091
2 Rajiv 091
Code City Country
091 Bangalore India
The primary key in the first table is ID, and the primary key in the
second is Code.
Questions with Accurate Answers
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? correct answer AND
CUSTNUM>1000;
A product-marketing company publishes an Internet-based newsletter
about their new products to increase their customer base.
What is an advantage that this company will gain from investing in a
relational database management system that will store customer
information? correct answer Improved query response times
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? correct
answer Many-to-many
During which step in the extract, transform, load (ETL) process are raw
data sets aggregated? correct answer Transformation
How is prediction distinguished from estimation in data mining? correct
answer Prediction classifies objects according to an expected future
behavior.
How were data retrieved before database management systems?
correct answer Sequentially from simple files
ID Contract Code
1 Vinod 091
2 Rajiv 091
Code City Country
091 Bangalore India
The primary key in the first table is ID, and the primary key in the
second is Code.
