WGU - INTRO TO IT - D322 SECTIONS 4,6,8 STUDY GUIDE QUESTIONS & ANSWERS PASSED ALREADY GRADED A+

WGU - INTRO TO IT - D322 SECTIONS 4,6,8 STUDY
GUIDE QUESTIONS & ANSWERS PASSED
ALREADY GRADED A+
1. Why is it important to ensure that data sup- To aid in making strategic
decisions
port business goals?

To provide opportunities for
communica- tion
To ensure raw data is
captured To establish needs
of users
To aid in making strategic decisions

2. In which category of the Data, Knowledge
Informa- tion, Knowledge, Wisdom
(DIKW) hierarchy would business
intelligence be located?

Data
Informatio
n
Knowledg
e Wisdom Primary key

3. Which field must contain a unique
value in order for a relational
database table to function?

Record number
ID number
Primary key
Name


,WGU - INTRO TO IT - D322 SECTIONS 4,6,8 STUDY
GUIDE QUESTIONS & ANSWERS PASSED
ALREADY GRADED A+
4. What are the three main categories of data- Flat file, relational, hierarchal
bases?

Relation, join, project
Flat file, relational, hierarchal






,WGU - INTRO TO IT - D322 SECTIONS 4,6,8 STUDY
GUIDE QUESTIONS & ANSWERS PASSED
ALREADY GRADED A+
Spreadsheet, simple,
complex Table, query,
report
FROM
5. Which SQL clause is used to inform
the database management system
(DBMS) which tables should be
interrogated by the query?

WHERE
FROM
HERE
SELECT

6. Which is true of databases and the applica- Applications are interdependent of
the
tions that interact with them? database.

The database can support at most one ap-
plication.
The database determines the application
classes.
Applications store data in their own files.
Applications are interdependent of
the database.

7. What is the collection of names, addresses, Database
and account balances of all the
patients of Mei's office more
technically known as?



,WGU - INTRO TO IT - D322 SECTIONS 4,6,8 STUDY
GUIDE QUESTIONS & ANSWERS PASSED
ALREADY GRADED A+
File
Key field
Database
Record