A ECITCARP · 281C
★
Western Governors University
College of Information Technology
CHANGING LIVES
EST. 1997
C H A N G I N G L I V E S · C R E AT I N G P AT H W A Y S T O O P P O R T U N I T Y
WGU C182 Intro To IT - Practice Test A
D I KW · H A R D W A R E · S O F T W A R E · DATA B A S E S · N E T W O R KS · S E CU R I TY · S D LC
INSTITUTION Western Governors University COURSE CODE C182
PROGRAM Bachelor of Science — Information ACADEMIC YEAR
Technology
EXAM TITLE WGU C182 Intro To IT - Practice TOTAL QUESTIONS 96 Questions
Test A
COURSE TITLE Introduction to Information FORMAT Multiple Choice — Select the
Technology Single Best Answer
EXAMINATION INSTRUCTIONS
▸ Select the single best answer for each question.
▸ Questions cover DIKW, hardware, software, databases, networking, security, SDLC, cloud computing,
and project management.
▸ Understanding key terminology and professional roles is emphasized.
▸ Correct answers and rationales appear below each question for self-assessment.
▸ All content reflects WGU C182 Practice Test A learning objectives.
, SECTION I — IT FUNDAMENTALS, SDLC, DATABASES,
Questions 1 – 96
NET WORKS & SECURITY
1. The SELECT keyword in SQL is used to inform the DBMS:
A. what tables are to be interrogated by the query
B. what fields or attributes are of interest and where they are located
C. of the specific criteria the data should match
D. how tables should be joined together
CORRECT ANSWER B
RATIONALE SELECT specifies which columns (fields/attributes) to retrieve. FROM (A) specifies
which tables. WHERE (C) specifies filtering criteria. JOIN (D) combines tables.
2. Which type of database is the most common format for storing data, providing great
flexibility by allowing multiple tables (relations)?
A. Flat File
B. Hierarchical
C. Relational
D. Network
CORRECT ANSWER C
RATIONALE Relational databases use multiple interrelated tables, providing enormous
flexibility for querying, data integrity, and scalability. Flat file (A) uses one table.
Hierarchical (B) uses parent-child relationships.
,3. ________ occurs when the old system is turned off and the new system is turned on at a
specific date and time.
A. Parallel Conversion
B. Phased Conversion
C. Direct Conversion
D. Pilot Conversion
CORRECT ANSWER C
RATIONALE Direct conversion (big bang/plunge) switches entirely from old to new system at
once. Parallel (A) runs both simultaneously. Phased (B) gradually replaces
modules. Pilot tests in one area first.
4. The team will write a final report detailing the processes and outcomes of the project in
which project phase?
A. Initiation
B. Planning
C. Execution
D. Closing
CORRECT ANSWER D
RATIONALE The Closing phase finalizes all activities — delivering final reports, releasing
resources, and formally completing the project. Initiation (A) defines scope.
Planning (B) creates the roadmap.
, 5. A collection of organized databases is called:
A. a data lake
B. a data warehouse
C. a flat file
D. a relational database
CORRECT ANSWER B
RATIONALE A data warehouse integrates data from multiple databases and sources into a
unified repository for analysis and reporting. Data lakes (A) store raw,
unprocessed data.
6. The WHERE keyword in SQL is used to:
A. specify which fields to retrieve
B. specify which tables to query
C. inform the DBMS of the specific criteria the data should match to be returned
D. join multiple tables together
CORRECT ANSWER C
RATIONALE WHERE filters rows based on specified conditions — only records meeting the
criteria are returned. SELECT (A) specifies columns. FROM (B) specifies tables.
JOIN (D) combines tables.
★
Western Governors University
College of Information Technology
CHANGING LIVES
EST. 1997
C H A N G I N G L I V E S · C R E AT I N G P AT H W A Y S T O O P P O R T U N I T Y
WGU C182 Intro To IT - Practice Test A
D I KW · H A R D W A R E · S O F T W A R E · DATA B A S E S · N E T W O R KS · S E CU R I TY · S D LC
INSTITUTION Western Governors University COURSE CODE C182
PROGRAM Bachelor of Science — Information ACADEMIC YEAR
Technology
EXAM TITLE WGU C182 Intro To IT - Practice TOTAL QUESTIONS 96 Questions
Test A
COURSE TITLE Introduction to Information FORMAT Multiple Choice — Select the
Technology Single Best Answer
EXAMINATION INSTRUCTIONS
▸ Select the single best answer for each question.
▸ Questions cover DIKW, hardware, software, databases, networking, security, SDLC, cloud computing,
and project management.
▸ Understanding key terminology and professional roles is emphasized.
▸ Correct answers and rationales appear below each question for self-assessment.
▸ All content reflects WGU C182 Practice Test A learning objectives.
, SECTION I — IT FUNDAMENTALS, SDLC, DATABASES,
Questions 1 – 96
NET WORKS & SECURITY
1. The SELECT keyword in SQL is used to inform the DBMS:
A. what tables are to be interrogated by the query
B. what fields or attributes are of interest and where they are located
C. of the specific criteria the data should match
D. how tables should be joined together
CORRECT ANSWER B
RATIONALE SELECT specifies which columns (fields/attributes) to retrieve. FROM (A) specifies
which tables. WHERE (C) specifies filtering criteria. JOIN (D) combines tables.
2. Which type of database is the most common format for storing data, providing great
flexibility by allowing multiple tables (relations)?
A. Flat File
B. Hierarchical
C. Relational
D. Network
CORRECT ANSWER C
RATIONALE Relational databases use multiple interrelated tables, providing enormous
flexibility for querying, data integrity, and scalability. Flat file (A) uses one table.
Hierarchical (B) uses parent-child relationships.
,3. ________ occurs when the old system is turned off and the new system is turned on at a
specific date and time.
A. Parallel Conversion
B. Phased Conversion
C. Direct Conversion
D. Pilot Conversion
CORRECT ANSWER C
RATIONALE Direct conversion (big bang/plunge) switches entirely from old to new system at
once. Parallel (A) runs both simultaneously. Phased (B) gradually replaces
modules. Pilot tests in one area first.
4. The team will write a final report detailing the processes and outcomes of the project in
which project phase?
A. Initiation
B. Planning
C. Execution
D. Closing
CORRECT ANSWER D
RATIONALE The Closing phase finalizes all activities — delivering final reports, releasing
resources, and formally completing the project. Initiation (A) defines scope.
Planning (B) creates the roadmap.
, 5. A collection of organized databases is called:
A. a data lake
B. a data warehouse
C. a flat file
D. a relational database
CORRECT ANSWER B
RATIONALE A data warehouse integrates data from multiple databases and sources into a
unified repository for analysis and reporting. Data lakes (A) store raw,
unprocessed data.
6. The WHERE keyword in SQL is used to:
A. specify which fields to retrieve
B. specify which tables to query
C. inform the DBMS of the specific criteria the data should match to be returned
D. join multiple tables together
CORRECT ANSWER C
RATIONALE WHERE filters rows based on specified conditions — only records meeting the
criteria are returned. SELECT (A) specifies columns. FROM (B) specifies tables.
JOIN (D) combines tables.
