True/False
Indicate whether the
statement is true or false.
|
|
|
1.
|
Object-oriented databases can store more types of
data than relational databases and access that data faster.
|
|
|
2.
|
Online transaction processing (OLTP) ensures that
data in the TPS is as up to date as possible.
|
|
|
3.
|
Text fields can contain numbers.
|
|
|
4.
|
Small slices of a data warehouse are called data
mines.
|
|
|
5.
|
Information systems are hardware-based solutions
that are used to gather and analyze information.
|
|
|
6.
|
The Intel Centrino is an operating system designed
specifically for PDAs.
|
|
|
7.
|
Cell phones cannot be affected by
viruses.
|
|
|
8.
|
PANs comprise large numbers of users that are miles
apart and linked together.
|
|
|
9.
|
The primary function of an application server is to
store and manage user files for network users.
|
|
|
10.
|
Fiber-optic cable is composed of a glass fiber that
comprises the core of the cable.
|
Multiple Choice
Identify the
choice that best completes the statement or answers the question.
|
|
|
11.
|
Properly designed databases cut down on _____ by
ensuring that relevant data is recorded in only one place.
a. | access time for retrieving data | c. | data redundancy | b. | the volume of
data | d. | user access
privileges |
|
|
|
12.
|
A category of information in a database is stored in a _____.
a. | table | c. | cell | b. | record | d. | field |
|
|
|
13.
|
In a database, an object field is used for storing _____.
a. | data about physical objects such as computers | c. | fixed-length text and
numbers | b. | variable-length text and numbers | d. | graphics and audio
content |
|
|
|
14.
|
The _____ uniquely identifies a record in a database.
a. | employee ID field | c. | primary key | b. | relation field | d. | name field |
|
|
|
15.
|
_____ databases are characterized by logical linkages between tables via primary
and foreign keys.
a. | Hierarchical | c. | Relational | b. | Key-based | d. | Object-oriented |
|
|
|
16.
|
The purpose of a data dictionary in a database is to _____.
a. | define all terms related to database terminology | c. | describe the structure and
organization of data in the database | b. | control and restrict access to the data in the
database | d. | distribute the
data content to multiple users in the organization |
|
|
|
17.
|
_____ are set up in the student database to alert the user if clearly wrong
entries are entered in a field.
a. | Consistency checks | c. | Completeness constraints | b. | Relational integrity
rules | d. | Validation
rules |
|
|
|
18.
|
SQL is a(n) _____.
a. | type of database architecture | c. | relational
database | b. | query language | d. | application programming language |
|
|
|
19.
|
When you want to extract data that is in two or more tables, you use a
_____.
a. | join query | c. | dimensional query | b. | relationship query | d. | group query |
|
|
|
20.
|
The process of eliminating data redundancy by ensuring that tables pertain to a
single topic is called _____.
a. | database administration | c. | data mining | b. | normalization | d. | integrity checking |
|
|
|
21.
|
Data warehouses contain _____.
a. | current values as well as historical data that does not
change over time | c. | data that is used by inventory
personnel to ensure that they have enough products to satisfy customer
demand | b. | data that is updated continuously each time an
organization conducts business transactions | d. | data pertaining to
the warehouses that a company possesses |
|
|
|
22.
|
All of the following are part of the process of data staging for a data
warehouse EXCEPT _____.
a. | storage | c. | transformation | b. | normalization | d. | extraction |
|
|
|
23.
|
Which of the following applications is considered an office support
system?
a. | Microsoft Office | c. | an ATM system | b. | a company’s expert
system | d. | Windows
XP |
|
|
|
24.
|
A characteristic of decision support systems is
that they assist decision makers via interaction with analysis tools called _____.
a. | business transactions | c. | relationships | b. | reports | d. | models |
|
|
|
25.
|
Which of the following is NOT a data-mining
technique?
a. | affinity grouping | c. | model management | b. | clustering | d. | classification |
|
|
|
26.
|
Databases that contain not only data but also
methods for processing or manipulating that data are called _____.
a. | object-oriented databases | c. | relational
databases | b. | object-relational databases | d. | query databases |
|
|
|
27.
|
To extract data from a database, you use
_____.
a. | relational algebra | c. | a query language | b. | structured analysis | d. | data staging |
|
|
|
28.
|
Which of the following is NOT an information
systems category?
a. | administration support system | c. | transaction processing
system | b. | office support system | d. | management information system |
|
|
|
29.
|
A(n) _____ check ensures that all database fields
defined as "required" have data entered into them.
a. | alphabetic | c. | completeness | b. | range | d. | numeric |
|
|
|
30.
|
It is widely accepted that the average business
doubles the amount of data it accumulates every _____.
a. | 5 to 12 months | c. | 12 to 18 months | b. | two years | d. | two to five
years |
|
|
|
31.
|
A peer-to-peer LAN is an appropriate network
architecture for _____.
a. | a network requiring a server with shared resources | c. | a home network | b. | a wide area
network | d. | the
Internet |
|
|
|
32.
|
The transmission medium used to connect nodes on wireless networks is
_____.
a. | metal | c. | infrared | b. | radio waves | d. | copper wire |
|
|
|
33.
|
An example of a UTP cable is _____.
a. | 802.11 | c. | RJ-45 | b. | coaxial | d. | Cat 6 |
|
|
|
34.
|
Denial of Service (DoS) is _____.
a. | the malicious destruction of data by accessing the
host's FAT table | c. | an act of bombarding a server with
high volumes of false requests | b. | a policy of
withholding service from users who abuse the Internet. | d. | a firewall
technique for blocking access to certain logical ports |
|
|
|
35.
|
_____ computing is an efficient way of effectively
linking millions of computers to perform complex calculations during lulls in their processing
cycles.
a. | Functional | c. | Automated | b. | Remote | d. | Grid |
|
|
|
36.
|
Which of the following is NOT a benefit of
networks?
a. | allow users to transfer files easily | c. | allow users to share an Internet
connection | b. | allow users to share monitors | d. | allow users to share
printers |
|
|
|
37.
|
Which of the following features would be more
likely found in tablet computers than in other mobile computing devices?
a. | wireless ports | c. | handwriting recognition | b. | disk
storage | d. | Internet
access |
|
|
|
38.
|
Read-only memory (ROM) contains the operating
system of a _____.
a. | tablet computer | c. | cell phone | b. | desktop computer | d. | laptop computer |
|
|
|
39.
|
Most portable e-mail devices now feature special
_____ technology to automatically deliver your e-mail to your phone so that your e-mail finds you
whether you're thinking about it or not.
|
|
|
40.
|
Which of the following would you expect to see
plugged into a hot-swappable bay?
a. | a cradle | c. | a DVD drive | b. | a printer | d. | an internal hard
drive |
|
|
|
41.
|
_____ is paving the way to enable anyone to create
a radio or television show at home and to distribute it easily to an audience.
a. | Peer-to-peer sharing | c. | Podcasting | b. | Hot-swapping | d. | Sampling |
|
|
|
42.
|
Which type of network is NOT highly scalable?
a. | client/server | c. | intranet | b. | Ethernet | d. | peer-to-peer |
|
|
|
43.
|
The geographical area for a LAN is most likely to be a _____.
a. | nation | c. | planet | b. | building | d. | city |
|
|
|
44.
|
Which of the following is NOT a component of a
client/server network?
a. | transmission media | c. | server | b. | network topology | d. | computer
manufacturer |
|
|
|
45.
|
Which network topology involves sharing a token
message among nodes?
|
|
|
46.
|
Which of the following types of medium has a copper
core and a layer of braided metal to reduce interference with signals traveling in the
core?
a. | coaxial | c. | fiber-optic | b. | Cat 5e | d. | power-line |
|
|
|
47.
|
The type of cable with the lowest installation cost
is _____.
a. | twisted pair | c. | 802.11 | b. | fiber-optic | d. | coaxial |
|
|
|
48.
|
Each _____ has its own media access control
address.
a. | router | c. | Internet node | b. | data packet | d. | network adapter |
|
|
|
49.
|
A _____ topology is the most widely deployed
client/server network layout in businesses today.
|
|
|
50.
|
Which of the following does NOT perform its
functions within a single network?
a. | switch | c. | hub | b. | repeater | d. | router |
|