WGU C182 UPDATED CORE EXAM MANUAL QUESTIONS
AND ANSWERS MARKED A+
✔✔Informs the database what tables are to be interrogated and how will they be
combined if more than 1 table contains data of interest - ✔✔What does the FROM
statement do in a SQL query?
✔✔Informs the database of specific criteria the data should match and returned -
✔✔What does the WHERE statement do in a SQL query?
✔✔= equal to
<> not equal to
> greater than
< less than
>= greater or equal to
<= less or equal to - ✔✔What are 6 operators used in SQL commands?
✔✔Preliminary Investigation - ✔✔What is the first step in the SDLC?
✔✔System Development Life Cycle - ✔✔What does SDLC stand for?
✔✔Analysis - ✔✔What is the second step in the SDLC?
✔✔Logical Design - ✔✔What is the third step in the SDLC?
✔✔Physical Design - ✔✔What is the fourth step in the SDLC?
✔✔Implementation - ✔✔What is the fifth step in the SDLC?
✔✔Maintenance - ✔✔What is the sixth step in the SDLC?
✔✔Problem or opportunity, cost and benefits, feasibility, select development method -
✔✔What happens in the Preliminary Investigation stage of the SDLC?
✔✔User requirements, logical models to demonstrate relationships, look at security
concerns - ✔✔What happens in the Analysis stage of the SDLC?
✔✔Logical models of the previous step revised to ensure user needs of first step are
met - ✔✔What happens in the Logical Design stage of the SDLC?
✔✔Logical models are converted into physical models. These physical models are still
abstractions of the system that will be built later, but they are now more complete and
, may include network maps and descriptions of servers and other devices to be used in
the system. - ✔✔What happens in the Physical Design stage of the SDLC?
✔✔Programmers convert the models to actual system by creating databases, installing
hardware, testing and training - ✔✔What happens in the Implementation stage of the
SDLC?
✔✔Modifications and corrections are made - ✔✔What happens in the maintenance
stage of the SDLC?
✔✔Decimal - ✔✔What number system uses base 10?
✔✔Binary - ✔✔What number system uses base 2?
✔✔True - ✔✔TRUE or FALSE - In binary 1 means on, and 0 means off
✔✔Hexadecimal - ✔✔What number system uses base 16?
✔✔ASCII and Unicode - ✔✔What are 2 common forms of character representation?
✔✔Binary - ✔✔What number system is the foundation for machine language?
✔✔Octal - ✔✔What number system is used to make machine language easier to read
and uses base 8?
✔✔A program that takes a high-level language as input, and outputs machine language
- ✔✔What is a Language Translator?
✔✔Assemblers, Compilers, Interpreters - ✔✔What are the 3 types of language
translators?
✔✔Translates the entire program into an executable which can be run at a later time -
✔✔What does a compiler do?
✔✔Takes the most recently entered instruction, translates to machine language, and
executes it - ✔✔What does an interpreter do?
✔✔Interpreted - ✔✔Are scripting languages compiled or interpreted?
✔✔Every instruction is translated first, then executed. Every time. - ✔✔How is an
interpreted program run?
AND ANSWERS MARKED A+
✔✔Informs the database what tables are to be interrogated and how will they be
combined if more than 1 table contains data of interest - ✔✔What does the FROM
statement do in a SQL query?
✔✔Informs the database of specific criteria the data should match and returned -
✔✔What does the WHERE statement do in a SQL query?
✔✔= equal to
<> not equal to
> greater than
< less than
>= greater or equal to
<= less or equal to - ✔✔What are 6 operators used in SQL commands?
✔✔Preliminary Investigation - ✔✔What is the first step in the SDLC?
✔✔System Development Life Cycle - ✔✔What does SDLC stand for?
✔✔Analysis - ✔✔What is the second step in the SDLC?
✔✔Logical Design - ✔✔What is the third step in the SDLC?
✔✔Physical Design - ✔✔What is the fourth step in the SDLC?
✔✔Implementation - ✔✔What is the fifth step in the SDLC?
✔✔Maintenance - ✔✔What is the sixth step in the SDLC?
✔✔Problem or opportunity, cost and benefits, feasibility, select development method -
✔✔What happens in the Preliminary Investigation stage of the SDLC?
✔✔User requirements, logical models to demonstrate relationships, look at security
concerns - ✔✔What happens in the Analysis stage of the SDLC?
✔✔Logical models of the previous step revised to ensure user needs of first step are
met - ✔✔What happens in the Logical Design stage of the SDLC?
✔✔Logical models are converted into physical models. These physical models are still
abstractions of the system that will be built later, but they are now more complete and
, may include network maps and descriptions of servers and other devices to be used in
the system. - ✔✔What happens in the Physical Design stage of the SDLC?
✔✔Programmers convert the models to actual system by creating databases, installing
hardware, testing and training - ✔✔What happens in the Implementation stage of the
SDLC?
✔✔Modifications and corrections are made - ✔✔What happens in the maintenance
stage of the SDLC?
✔✔Decimal - ✔✔What number system uses base 10?
✔✔Binary - ✔✔What number system uses base 2?
✔✔True - ✔✔TRUE or FALSE - In binary 1 means on, and 0 means off
✔✔Hexadecimal - ✔✔What number system uses base 16?
✔✔ASCII and Unicode - ✔✔What are 2 common forms of character representation?
✔✔Binary - ✔✔What number system is the foundation for machine language?
✔✔Octal - ✔✔What number system is used to make machine language easier to read
and uses base 8?
✔✔A program that takes a high-level language as input, and outputs machine language
- ✔✔What is a Language Translator?
✔✔Assemblers, Compilers, Interpreters - ✔✔What are the 3 types of language
translators?
✔✔Translates the entire program into an executable which can be run at a later time -
✔✔What does a compiler do?
✔✔Takes the most recently entered instruction, translates to machine language, and
executes it - ✔✔What does an interpreter do?
✔✔Interpreted - ✔✔Are scripting languages compiled or interpreted?
✔✔Every instruction is translated first, then executed. Every time. - ✔✔How is an
interpreted program run?
