MIS 200- Exam 2 Latest Questions
with Correct/Revised Solutions 2026
Updated.
you are the database admin for the University of Alabama's student operations. you are asked
to pull up the unique identifier or "key" for all students in the student table. what would be the
primary key? - Answer CWID
A spreadsheet contains a single theme of data, while a database contains multiple themes. what
is another word that describes a theme? - Answer entity
Collecting records of documents and images would most likely be used in what type of
database? - Answer non-relational
This is best described as "data about data" or the properties of date with in a database - Answer
metadata
cardinality can be expressed in how many different ways? select all that apply. - Answer
optional, mandatory, one, many
The mainframe era and the cloud era have this in common. choose one: - Answer processing
power can be remote
of the many benefits of using the cloud, what does the term "elastic" mean? - Answer
organizations only pay for what is used based on changing utilization
In the late 90's during the rise of distributed content delivery networks (CDNs), Mr. Miesse
describes a large percentage of web hosting (traditional delivery) could be found in what city? -
Answer New York City
service level agreements (SALs) are important for vendor support. what reasons apply? -
Answer Agreements on service up time, legal standing for unmet obligations, and security
At home your *public* IP address is given to you by your ISP (internet service provider).
However all of the devices connected to your home network are private. what technology
allows your private network connected devices to communicate through your public IP and to
the internet? - Answer Network Adress Translation (NAT)
, Computer Hardware - Answer consists of electronic components and related gadgetry that
input, process, output, and store data according to instructions encoded in computer programs
or software
CPU (Central Processing Unit) - Answer the portion of the computer that selects instructions,
processes them, performs arithmetic and logical comparisons, and store results of operations in
memory
RAM (main memory) - Answer Memory that works in conjunction with the CPU: stores data
and instruction read by the CPU and stores the results of the CPU's computations
Storage Hardware - Answer Hardware that saves data and programs. Magnetic disks are by
far the most common storage device, although optical disks, such as CDs and DVDs, also are
popular.
Solid State Drive (SSD) - Answer Is much faster than traditional magnetic storage because it
stores information using non-volatile electronic circits
volatile storage - Answer Temporary storage, such as in random access memory. When the
power is off, the data in volatile storage is cleared out. (cache, main memory)
non-volatile - Answer Storage which does not lose its contents when the power is lost.
(thumb drives, CD/DVDs, magnetic tape)
Byte - Answer a group of 8 bits
Bit - Answer A single unit of binary (single unit of info) consisting of only one place whose
value can be 0 or 1.
impact of industrial internet of things (IIOT) and machine to machine communication on
businesses - Answer can result in edge computing which reduces the amount of data
transmitted, stored, and processed in the cloud
Machine to Machine (M2M) - Answer refers to devices that connect directly to other devices
IoT (Internet of Things) - Answer The network of physical devices connected to the Internet.
It typically refers to smart devices with an IP address, such as wearable technology and home
automation systems.
with Correct/Revised Solutions 2026
Updated.
you are the database admin for the University of Alabama's student operations. you are asked
to pull up the unique identifier or "key" for all students in the student table. what would be the
primary key? - Answer CWID
A spreadsheet contains a single theme of data, while a database contains multiple themes. what
is another word that describes a theme? - Answer entity
Collecting records of documents and images would most likely be used in what type of
database? - Answer non-relational
This is best described as "data about data" or the properties of date with in a database - Answer
metadata
cardinality can be expressed in how many different ways? select all that apply. - Answer
optional, mandatory, one, many
The mainframe era and the cloud era have this in common. choose one: - Answer processing
power can be remote
of the many benefits of using the cloud, what does the term "elastic" mean? - Answer
organizations only pay for what is used based on changing utilization
In the late 90's during the rise of distributed content delivery networks (CDNs), Mr. Miesse
describes a large percentage of web hosting (traditional delivery) could be found in what city? -
Answer New York City
service level agreements (SALs) are important for vendor support. what reasons apply? -
Answer Agreements on service up time, legal standing for unmet obligations, and security
At home your *public* IP address is given to you by your ISP (internet service provider).
However all of the devices connected to your home network are private. what technology
allows your private network connected devices to communicate through your public IP and to
the internet? - Answer Network Adress Translation (NAT)
, Computer Hardware - Answer consists of electronic components and related gadgetry that
input, process, output, and store data according to instructions encoded in computer programs
or software
CPU (Central Processing Unit) - Answer the portion of the computer that selects instructions,
processes them, performs arithmetic and logical comparisons, and store results of operations in
memory
RAM (main memory) - Answer Memory that works in conjunction with the CPU: stores data
and instruction read by the CPU and stores the results of the CPU's computations
Storage Hardware - Answer Hardware that saves data and programs. Magnetic disks are by
far the most common storage device, although optical disks, such as CDs and DVDs, also are
popular.
Solid State Drive (SSD) - Answer Is much faster than traditional magnetic storage because it
stores information using non-volatile electronic circits
volatile storage - Answer Temporary storage, such as in random access memory. When the
power is off, the data in volatile storage is cleared out. (cache, main memory)
non-volatile - Answer Storage which does not lose its contents when the power is lost.
(thumb drives, CD/DVDs, magnetic tape)
Byte - Answer a group of 8 bits
Bit - Answer A single unit of binary (single unit of info) consisting of only one place whose
value can be 0 or 1.
impact of industrial internet of things (IIOT) and machine to machine communication on
businesses - Answer can result in edge computing which reduces the amount of data
transmitted, stored, and processed in the cloud
Machine to Machine (M2M) - Answer refers to devices that connect directly to other devices
IoT (Internet of Things) - Answer The network of physical devices connected to the Internet.
It typically refers to smart devices with an IP address, such as wearable technology and home
automation systems.
