WGU C182 COMPREHENSIVE QUESTIONS
AND SOLUTIONS GRADED A+
◉ Date/Time
Answer: Type of Data
◉ Boolean/Logical
Answer: Type of Data.
Ex: True/False (in reply to active subscriber?)
Only two possible answers: yes/no or true/false
◉ Flat File Database
Answer: 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
Answer: 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
Answer: 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
Answer: Records represented by rows.
◉ Unshielded Twisted Pair (UTP)
Answer: Most commonly used network connections. Looks just as
it sounds, wires twisted together in a pair.
◉ Fiber Optic Cable
Answer: Transmits via light pulses as opposed to electromagnetic
ones.
◉ Twisted Pair
AND SOLUTIONS GRADED A+
◉ Date/Time
Answer: Type of Data
◉ Boolean/Logical
Answer: Type of Data.
Ex: True/False (in reply to active subscriber?)
Only two possible answers: yes/no or true/false
◉ Flat File Database
Answer: 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
Answer: 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
Answer: 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
Answer: Records represented by rows.
◉ Unshielded Twisted Pair (UTP)
Answer: Most commonly used network connections. Looks just as
it sounds, wires twisted together in a pair.
◉ Fiber Optic Cable
Answer: Transmits via light pulses as opposed to electromagnetic
ones.
◉ Twisted Pair
