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