C182 OBJECTIVE ASSESSMENT PREMIUM PREP
PACK 2026 FULLY SOLVED MATERIAL
◉ Web Server. Answer: Role is to respond to HTTP requests.
*Most HTTP requests are for HTML docs, but could include any web
accessible resource.
It's all combined into the URL.
**APACHE is most popular web server-can execute scripts for
dynamic pages, use security mechanisms, log request for trend
tracking.
◉ Proxy Server Answer: Acts as a giant cache and allows pages
accessed frequently in an organization to be accessed locally.
*Also provides degree of anonymity, since IP address recorded is for
proxy server and not individual client.
*Can also be used to block requests to certain servers (i.e Facebook)
*Can reject responses that contain certain content (i.e "porn")
**SQUID is most common, but APACHE can also be used as proxy
server.
◉ Database Server Answer: 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 Answer: 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 Answer: Computer with large hard disk storing files,
but can also store software to be run over network.
◉ Email Server Answer: Provides email service.
Accepts email request from clients.
IMAP,POPS,HTTP,MAPI,MIME
◉ String Data Answer: Alphanumeric or text
Ex: James (Last name)
623 Hill Street
◉ Number Integer Answer: Numeric data, whole numbers.
Ex: 4
◉ Floating Point Answer: Decimal.
,Ex: 4.2
◉ 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 Answer: 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 Answer: Commonly used network connection.
PACK 2026 FULLY SOLVED MATERIAL
◉ Web Server. Answer: Role is to respond to HTTP requests.
*Most HTTP requests are for HTML docs, but could include any web
accessible resource.
It's all combined into the URL.
**APACHE is most popular web server-can execute scripts for
dynamic pages, use security mechanisms, log request for trend
tracking.
◉ Proxy Server Answer: Acts as a giant cache and allows pages
accessed frequently in an organization to be accessed locally.
*Also provides degree of anonymity, since IP address recorded is for
proxy server and not individual client.
*Can also be used to block requests to certain servers (i.e Facebook)
*Can reject responses that contain certain content (i.e "porn")
**SQUID is most common, but APACHE can also be used as proxy
server.
◉ Database Server Answer: 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 Answer: 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 Answer: Computer with large hard disk storing files,
but can also store software to be run over network.
◉ Email Server Answer: Provides email service.
Accepts email request from clients.
IMAP,POPS,HTTP,MAPI,MIME
◉ String Data Answer: Alphanumeric or text
Ex: James (Last name)
623 Hill Street
◉ Number Integer Answer: Numeric data, whole numbers.
Ex: 4
◉ Floating Point Answer: Decimal.
,Ex: 4.2
◉ 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 Answer: 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 Answer: Commonly used network connection.
