WGU C182 UPDATED EXAM SCRIPT QUESTIONS AND
ANSWERS MARKED A+
✔✔Database Server - ✔✔Permits dB access across a network.
Performs tasks such as data analysis, data manipulation, security,and archiving.
May/may not store database itself.
**MySQL is popular.
✔✔FTP Server - ✔✔Hosts files and allows clients access to files.
Access is in form of uploading/downloading files.
Requires either user has an account or logs in as anonymous user.
✔✔File Server - ✔✔Computer with large hard disk storing files, but can also store
software to be run over network.
✔✔Email Server - ✔✔Provides email service.
Accepts email request from clients.
IMAP,POPS,HTTP,MAPI,MIME
✔✔String Data - ✔✔Alphanumeric or text
Ex: James (Last name)
623 Hill Street
✔✔Number Integer - ✔✔Numeric data, whole numbers.
Ex: 4
✔✔Floating Point - ✔✔Decimal.
Ex: 4.2
✔✔Date/Time - ✔✔Type of Data
✔✔Boolean/Logical - ✔✔Type of Data.
Ex: True/False (in reply to active subscriber?)
Only two possible answers: yes/no or true/false
✔✔Flat File Database - ✔✔One large single table without relations between tables.
*Most common is CSV file (files separated by comma)
*Flat file is used if amount of data is fairly small.
Ex: Spreadsheet
✔✔Relational Database - ✔✔Most common structure for database.
*Distinguished by multiple tables with interrelated fields.
*When queried, data can be pulled form any # of relations that may be contained in
multiple databases.
*Provides lots of flexibility.
, ✔✔Hierarchical Database - ✔✔Organizes data by using tree-like or organizational chart
type structure.
*Main data points can have multiple sub-data points (Parent/child structure)-Subpoints
can only have one main data point.
* Records can be broken up so one portion is in one location and another is in another
section.
Ex: Employee database could list all employees, but a child relation could contain info
about employee position, pay level, responsibilities. Another child relation could include
info about employee projects. Sub data is always specific to main data point.
✔✔Tuples - ✔✔Records represented by rows.
✔✔Unshielded Twisted Pair (UTP) - ✔✔Most commonly used network connections.
Looks just as it sounds, wires twisted together in a pair.
✔✔Fiber Optic Cable - ✔✔Transmits via light pulses as opposed to electromagnetic
ones.
✔✔Twisted Pair - ✔✔Network connection commonly used in the past. It is still seen a lot
today because it was used extensively in the phone systems. Is cheap and and already
in place.
**transmits using electromagnetic waves.
✔✔Coaxial Cable - ✔✔Commonly used network connection.
*Transmits using electromagnetic waves.
✔✔Bandwidth - ✔✔Transfer rate permissible over the media, and is described as bps or
b/s (bits per second).
**Modern bandwidth is described in millions/billions bits per second (i.e. Mbps or Gbps)
*Older tech limited to thousands, (i.e. 56 Kbps)
✔✔Network Hub - ✔✔Device that connects multiple computers together.
*Broadcasts to all connected devices, even if message is intended for just one.
✔✔Network Switch - ✔✔Device that connects multiple computers together.
**Able to broadcast to just one if message is intended for one, but has ability to send
message to all if needed.
✔✔Router - ✔✔Used to connect multiple networks together.
**Has decision making abilities, can purposefully drop messages if message traffic
exceeds capacity. In the event multiple messages are sent, router can make the
decision to determine which message is sent first.
✔✔Transmission - ✔✔Last step network performs when sending a message.
ANSWERS MARKED A+
✔✔Database Server - ✔✔Permits dB access across a network.
Performs tasks such as data analysis, data manipulation, security,and archiving.
May/may not store database itself.
**MySQL is popular.
✔✔FTP Server - ✔✔Hosts files and allows clients access to files.
Access is in form of uploading/downloading files.
Requires either user has an account or logs in as anonymous user.
✔✔File Server - ✔✔Computer with large hard disk storing files, but can also store
software to be run over network.
✔✔Email Server - ✔✔Provides email service.
Accepts email request from clients.
IMAP,POPS,HTTP,MAPI,MIME
✔✔String Data - ✔✔Alphanumeric or text
Ex: James (Last name)
623 Hill Street
✔✔Number Integer - ✔✔Numeric data, whole numbers.
Ex: 4
✔✔Floating Point - ✔✔Decimal.
Ex: 4.2
✔✔Date/Time - ✔✔Type of Data
✔✔Boolean/Logical - ✔✔Type of Data.
Ex: True/False (in reply to active subscriber?)
Only two possible answers: yes/no or true/false
✔✔Flat File Database - ✔✔One large single table without relations between tables.
*Most common is CSV file (files separated by comma)
*Flat file is used if amount of data is fairly small.
Ex: Spreadsheet
✔✔Relational Database - ✔✔Most common structure for database.
*Distinguished by multiple tables with interrelated fields.
*When queried, data can be pulled form any # of relations that may be contained in
multiple databases.
*Provides lots of flexibility.
, ✔✔Hierarchical Database - ✔✔Organizes data by using tree-like or organizational chart
type structure.
*Main data points can have multiple sub-data points (Parent/child structure)-Subpoints
can only have one main data point.
* Records can be broken up so one portion is in one location and another is in another
section.
Ex: Employee database could list all employees, but a child relation could contain info
about employee position, pay level, responsibilities. Another child relation could include
info about employee projects. Sub data is always specific to main data point.
✔✔Tuples - ✔✔Records represented by rows.
✔✔Unshielded Twisted Pair (UTP) - ✔✔Most commonly used network connections.
Looks just as it sounds, wires twisted together in a pair.
✔✔Fiber Optic Cable - ✔✔Transmits via light pulses as opposed to electromagnetic
ones.
✔✔Twisted Pair - ✔✔Network connection commonly used in the past. It is still seen a lot
today because it was used extensively in the phone systems. Is cheap and and already
in place.
**transmits using electromagnetic waves.
✔✔Coaxial Cable - ✔✔Commonly used network connection.
*Transmits using electromagnetic waves.
✔✔Bandwidth - ✔✔Transfer rate permissible over the media, and is described as bps or
b/s (bits per second).
**Modern bandwidth is described in millions/billions bits per second (i.e. Mbps or Gbps)
*Older tech limited to thousands, (i.e. 56 Kbps)
✔✔Network Hub - ✔✔Device that connects multiple computers together.
*Broadcasts to all connected devices, even if message is intended for just one.
✔✔Network Switch - ✔✔Device that connects multiple computers together.
**Able to broadcast to just one if message is intended for one, but has ability to send
message to all if needed.
✔✔Router - ✔✔Used to connect multiple networks together.
**Has decision making abilities, can purposefully drop messages if message traffic
exceeds capacity. In the event multiple messages are sent, router can make the
decision to determine which message is sent first.
✔✔Transmission - ✔✔Last step network performs when sending a message.
