WGU - INTRODUCTION TO IT - D322 SECTION 6
REVIEW EXAM QUESTIONS & DETAILED PASSED
ANSWERS 100%
1. Why is it important to ensure that data To aid in making strategic
decisions
support business goals?
To provide opportunities for
communi- cation
To ensure raw data is
captured To establish needs
of users
To aid in making strategic decisions
2. In which category of the Data, categories of databases?
Infor- mation, Knowledge, Wisdom
(DIKW) hi- erarchy would business Relation, join, project
intelligence be located? Flat file, relational,
hierarchal
Data
Information
Knowledge
Wisdom
3. Which field must contain a unique
val- ue in order for a relational
database table to function?
Record number
ID number
Primary key
Name
4. What are the three main
1/
23
,WGU - INTRODUCTION TO IT - D322 SECTION 6
REVIEW EXAM QUESTIONS & DETAILED PASSED
ANSWERS 100%
Knowledge
Primary key
Flat file, relational, hierarchal
2/
23
, WGU - INTRODUCTION TO IT - D322 SECTION 6
REVIEW EXAM QUESTIONS & DETAILED PASSED
ANSWERS 100%
Spreadsheet, simple,
complex Table, query, report
5. Which SQL clause is used to inform the
FROM database management system
(DBMS) which tables should be
interrogated by
the query?
WHERE
FROM
HERE
SELECT
6. Which is true of databases and the Mei's office more tech-
ap- plications that interact with nically known as?
them?
File
The database can support at Key field
most one application.
The database determines the
applica- tion classes.
Applications store data in their
own files.
Applications are interdependent of
the database.
7. What is the collection of names,
ad- dresses, and account
balances of all the patients of
3/
23
REVIEW EXAM QUESTIONS & DETAILED PASSED
ANSWERS 100%
1. Why is it important to ensure that data To aid in making strategic
decisions
support business goals?
To provide opportunities for
communi- cation
To ensure raw data is
captured To establish needs
of users
To aid in making strategic decisions
2. In which category of the Data, categories of databases?
Infor- mation, Knowledge, Wisdom
(DIKW) hi- erarchy would business Relation, join, project
intelligence be located? Flat file, relational,
hierarchal
Data
Information
Knowledge
Wisdom
3. Which field must contain a unique
val- ue in order for a relational
database table to function?
Record number
ID number
Primary key
Name
4. What are the three main
1/
23
,WGU - INTRODUCTION TO IT - D322 SECTION 6
REVIEW EXAM QUESTIONS & DETAILED PASSED
ANSWERS 100%
Knowledge
Primary key
Flat file, relational, hierarchal
2/
23
, WGU - INTRODUCTION TO IT - D322 SECTION 6
REVIEW EXAM QUESTIONS & DETAILED PASSED
ANSWERS 100%
Spreadsheet, simple,
complex Table, query, report
5. Which SQL clause is used to inform the
FROM database management system
(DBMS) which tables should be
interrogated by
the query?
WHERE
FROM
HERE
SELECT
6. Which is true of databases and the Mei's office more tech-
ap- plications that interact with nically known as?
them?
File
The database can support at Key field
most one application.
The database determines the
applica- tion classes.
Applications store data in their
own files.
Applications are interdependent of
the database.
7. What is the collection of names,
ad- dresses, and account
balances of all the patients of
3/
23
