WGU C175 Pre-Assessment Key Questions with
100% Correct Answers.
Practice questions for this set
Learn 1/ 7 Study with Learn
Raw facts that are captured on printed or digital media
Choose matching term
Which SQL statement will retrieve rows for all stores in Atlanta or Los Angeles or New
1
York?
Refer to the given SQL statement.
SELECT COMMPERCT, YEARHIRE
FROM SALESPERSON
2
WHERE SPNUM=22;
How should this statement be altered to retrieve the entire record instead of the
commission percentage and year of hire?
Sales data, detailing the customer names, products sold, and salespersons, is kept in a
database.
3
, Which kind of data in this database would qualify as intersection data related to both
the product and salesperson entities?
4 What is a broad definition of data?
Don't know?
Terms in this set (50)
What is a broad definition Raw facts that are captured on printed or digital media
of data?
What are data? Facts that are collected and stored in a database system
What is a determining It does not follow a data model.
characteristic of
unstructured data?
Which is true about flat They contain no internal hierarchical organization.
files?
Which technology has no Flat files
internal hierarchy?
How were data retrieved Sequentially from simple files
before database
management systems?
- It enables data sharing,
In which two ways does a
- It permits storage of vast volumes of data.
database management
system environment
increase effectiveness in
working with data?
100% Correct Answers.
Practice questions for this set
Learn 1/ 7 Study with Learn
Raw facts that are captured on printed or digital media
Choose matching term
Which SQL statement will retrieve rows for all stores in Atlanta or Los Angeles or New
1
York?
Refer to the given SQL statement.
SELECT COMMPERCT, YEARHIRE
FROM SALESPERSON
2
WHERE SPNUM=22;
How should this statement be altered to retrieve the entire record instead of the
commission percentage and year of hire?
Sales data, detailing the customer names, products sold, and salespersons, is kept in a
database.
3
, Which kind of data in this database would qualify as intersection data related to both
the product and salesperson entities?
4 What is a broad definition of data?
Don't know?
Terms in this set (50)
What is a broad definition Raw facts that are captured on printed or digital media
of data?
What are data? Facts that are collected and stored in a database system
What is a determining It does not follow a data model.
characteristic of
unstructured data?
Which is true about flat They contain no internal hierarchical organization.
files?
Which technology has no Flat files
internal hierarchy?
How were data retrieved Sequentially from simple files
before database
management systems?
- It enables data sharing,
In which two ways does a
- It permits storage of vast volumes of data.
database management
system environment
increase effectiveness in
working with data?
