MANG 3778 STUDY GUIDE WITH
COMPLETE SOLUTION
Quantum computing uses nanos which can be one, a zero, or something else,
all at the same time. - ANSWER False
Since information technology is stable and not improving much, it is
important for business to understand how to use IT. - ANSWER False
Moore's Law was first reported in _________________ - ANSWER 1965
Computing devices made from carbon nanotubes can be built in
_______________ architectures with many layers, creating very compact, fast
computers. - ANSWER three-dimensional
One technology that may provide even smaller devices in the future is
___________________. - ANSWER quantum technology
In a carbon nanotube the atoms of carbon are arranged in a special structure
resembling a tube. - ANSWER True
In 2018, Intel's processor technology made devices that were 14 nanometers
in size. About ______________ devices of this size can fit in the width of human
hair. - ANSWER 6,000
In 2019, computer chip technology has advanced to the point that leading
edge devices from Apple, Qualcomm and AMD use 70 nano-meter
technology. - ANSWER False
This new technology, currently in its infancy, promises vastly improved data
storage capability. - ANSWER DNA storage
,A nanometer is a trillionth of a meter. - ANSWER False
Moore's Law states that the number of transistors per square inch on a
microchip ________ every two years. - ANSWER doubles
One new approach to produce future 7 nanometer computer chips is 5G
technology. - ANSWER False
A music recording is digitized in two formats. Format A uses 22,000 samples
per second and 16 bits, while format B uses 44,000 samples per second and
32 bits. - ANSWER Format B is a better quality recording than format A.
_________ is the conversion of data from other formats into a binary format,
i.e. a language with two characters. - ANSWER Digitization
A physician checks patient files from her cellphone at home. This is an
example of ______________ - ANSWER ubiquity
A physician can check patient files at any location, whether at the clinic, at
home, or traveling. This is an example of _________________________. - ANSWER
ubiquitous computing
A bank uses IT to reduce the need for tellers at the counter. This is an
example of using IT for ___________. - ANSWER efficiency
____________ argued that IT may be over-hyped , and it may be possible for
most businesses to obtain IT int he manner of a utility (like electric power,
water), - ANSWER None of the above
The video lecture on Moodle is a digitized media file - ANSWER True
It is more difficult to search through digitized data than to search through
analog data. - ANSWER False
,A vinyl music album is an ______________ recording. - ANSWER analog
When a media file (for example, a book) is digitized, it can be ________________.
- ANSWER A, B, and C are all true
_______ means that an information system is available at all times and at all
locations. - ANSWER Ubiquity
It is easier to copy digital data than analog data. - ANSWER true
A business grows rapidly through many acquisitions. The IT systems are not
integrated and are disorganized. As a result, customer addresses are stored
in many different files, and often are not consistent. This is called data
___________________. - ANSWER none of the other choices
#Fileds : data time action protocol src-ip
This is an example of a CSV file. - ANSWER false
Some of the features of a DBMS are: - ANSWER it stores, modifies, and
extracts data from a database
Program data independence refers to ________________________. - ANSWER
programs use data from a common, independent database
(looks like an application )This is an example of a distributed database file -
ANSWER False
Match the following data sizes to the scenario.
1. Data collected by a large organization such as Walmart in its customer
database
2. Storage capability of personal use storage device such as a flash drive -
ANSWER 1. petabytes
, 2. gigabytes
A blockchain database can grow very large over time as new blocks are
added. - ANSWER True
The Hadoop Distributed File System stores data in small blocks and uses
replication to ensure that each small block is replicated in multiple locations
to enhance reliability and availability. - ANSWER true
The CREATE, DROP, ALTER, and RENAME commands in SQL are ___________
commands. - ANSWER DDL (Data Definition language)
The links between the tables in an RDBMS are called ________________. -
ANSWER relationships
A/an ______________ pre-calculates and stores summary data, such as sales data
for each customer, product, and time unit in a multi-dimensional form. -
ANSWER OLAP cube
_______________ is an automated approach to the transfer of data from other
formats into a binary format, i.e. a language with two characters. - ANSWER
None of the other choices
One feature of data quality is "completeness". A database which has this
feature ___________________. - ANSWER must contain all the necessary data
A comma separated value (CSV) file is an XML file. - ANSWER False
A company plans to capture business quality data in a new IT system. The
development team gathers requirements from the company and develops a
______________________ of the database to represent the data used by the
business and show the relationships between data items. - ANSWER logical
design
COMPLETE SOLUTION
Quantum computing uses nanos which can be one, a zero, or something else,
all at the same time. - ANSWER False
Since information technology is stable and not improving much, it is
important for business to understand how to use IT. - ANSWER False
Moore's Law was first reported in _________________ - ANSWER 1965
Computing devices made from carbon nanotubes can be built in
_______________ architectures with many layers, creating very compact, fast
computers. - ANSWER three-dimensional
One technology that may provide even smaller devices in the future is
___________________. - ANSWER quantum technology
In a carbon nanotube the atoms of carbon are arranged in a special structure
resembling a tube. - ANSWER True
In 2018, Intel's processor technology made devices that were 14 nanometers
in size. About ______________ devices of this size can fit in the width of human
hair. - ANSWER 6,000
In 2019, computer chip technology has advanced to the point that leading
edge devices from Apple, Qualcomm and AMD use 70 nano-meter
technology. - ANSWER False
This new technology, currently in its infancy, promises vastly improved data
storage capability. - ANSWER DNA storage
,A nanometer is a trillionth of a meter. - ANSWER False
Moore's Law states that the number of transistors per square inch on a
microchip ________ every two years. - ANSWER doubles
One new approach to produce future 7 nanometer computer chips is 5G
technology. - ANSWER False
A music recording is digitized in two formats. Format A uses 22,000 samples
per second and 16 bits, while format B uses 44,000 samples per second and
32 bits. - ANSWER Format B is a better quality recording than format A.
_________ is the conversion of data from other formats into a binary format,
i.e. a language with two characters. - ANSWER Digitization
A physician checks patient files from her cellphone at home. This is an
example of ______________ - ANSWER ubiquity
A physician can check patient files at any location, whether at the clinic, at
home, or traveling. This is an example of _________________________. - ANSWER
ubiquitous computing
A bank uses IT to reduce the need for tellers at the counter. This is an
example of using IT for ___________. - ANSWER efficiency
____________ argued that IT may be over-hyped , and it may be possible for
most businesses to obtain IT int he manner of a utility (like electric power,
water), - ANSWER None of the above
The video lecture on Moodle is a digitized media file - ANSWER True
It is more difficult to search through digitized data than to search through
analog data. - ANSWER False
,A vinyl music album is an ______________ recording. - ANSWER analog
When a media file (for example, a book) is digitized, it can be ________________.
- ANSWER A, B, and C are all true
_______ means that an information system is available at all times and at all
locations. - ANSWER Ubiquity
It is easier to copy digital data than analog data. - ANSWER true
A business grows rapidly through many acquisitions. The IT systems are not
integrated and are disorganized. As a result, customer addresses are stored
in many different files, and often are not consistent. This is called data
___________________. - ANSWER none of the other choices
#Fileds : data time action protocol src-ip
This is an example of a CSV file. - ANSWER false
Some of the features of a DBMS are: - ANSWER it stores, modifies, and
extracts data from a database
Program data independence refers to ________________________. - ANSWER
programs use data from a common, independent database
(looks like an application )This is an example of a distributed database file -
ANSWER False
Match the following data sizes to the scenario.
1. Data collected by a large organization such as Walmart in its customer
database
2. Storage capability of personal use storage device such as a flash drive -
ANSWER 1. petabytes
, 2. gigabytes
A blockchain database can grow very large over time as new blocks are
added. - ANSWER True
The Hadoop Distributed File System stores data in small blocks and uses
replication to ensure that each small block is replicated in multiple locations
to enhance reliability and availability. - ANSWER true
The CREATE, DROP, ALTER, and RENAME commands in SQL are ___________
commands. - ANSWER DDL (Data Definition language)
The links between the tables in an RDBMS are called ________________. -
ANSWER relationships
A/an ______________ pre-calculates and stores summary data, such as sales data
for each customer, product, and time unit in a multi-dimensional form. -
ANSWER OLAP cube
_______________ is an automated approach to the transfer of data from other
formats into a binary format, i.e. a language with two characters. - ANSWER
None of the other choices
One feature of data quality is "completeness". A database which has this
feature ___________________. - ANSWER must contain all the necessary data
A comma separated value (CSV) file is an XML file. - ANSWER False
A company plans to capture business quality data in a new IT system. The
development team gathers requirements from the company and develops a
______________________ of the database to represent the data used by the
business and show the relationships between data items. - ANSWER logical
design