Final Flashcards
Out of the following choices, the least critical aspect of good information:
A.) data accuracy
B.) sufficiency of data
C.) timeliness of data
D.) additional data
E.) elevance of data
D.) additional Data
Dr. Guo emphasized in his lectures the importance of ____ because it is the bridge between the computer side and the human side in the five-component model.
Data
Automation is represented in the IS model as moving the work being done from:
A.) the digital mode to the analog mode
B.) processing to storage
C.) processes to procedures
D.) the human side to the computer side
E.) procedures to people
D.) the human side to the computer side
Tomas requests a report from HR that shows the rate employees quit over the last three months, but HR instead sends him a report that shows the salary details of new hires over the last three months. The data HR sent is missing which of the five characteristics of good information?
A.) uncleaned
B.) miscalculated
C.) not timely
D.) not relevant
E.) inaccurate
D.) not relevant
Sam is on a team that will implement an entirely new information system at his company. When they implement the new information system, which of the following actions will be the most difficult?
A.) training the employees to use and manage the new system
B.) changing the structure of existing databases that reflect supplier and customer data
C.) writing the programs to create the software
D.) upgrading the computer systems used by the retail chain
E.) installing new transaction processing hardware
A.) training the employees to use and manage the new system
Which of the following statements is TRUE of data characteristics within the context of information systems?
A.) Data generated should be in excess of what is required.
B.) An appropriate relationship should exist between the cost of data and its value.
C.) Freely available data is always accurate and timely.
D.) Data should be relevant to the context, not necessarily to the subject.
E.) Larger data sets yield more accurate information.
B.) An appropriate relationship should exist between the cost of data and its value.
Caroline asks her secretary to send information on the meetings that she needs to attend next month. Her secretary, Joanne, provides her with the details immediately, but leaves out certain additional details that are irrelevant to Caroline’s requirements. Which of the following statements is TRUE about this scenario?
A.) The information that Caroline obtained through Joanne was not accurate.
B.) The information that Joanne gave was accurate and sufficient for Caroline’s purpose.
C.) The information that Joanne provided was partly good, as it was timely but inaccurate.
D.) The information that Caroline obtained through Joanne was not timely or worth its cost.
E.) Joanne provided adequate and timely information, but the information was of no value to Caroline.
B.) The information that Joanne gave was accurate and sufficient for Caroline’s purpose.
Leon follows a set of instructions to create a custom Web site for a team assignment in his MIS course. The set of instructions Leon followed are an example of the ________ component of an information system.
software
Amber needed to improve the efficiency of her eBay shop, so she designed a relational database. She
made sure to include ____________ to figure out how many orders are associated with each customer.
A. A primary key
B. A foreign key
C. A crow’s Foot Cardinality as the maximum cardinality
D. Cardinalities
E. A Cardinality as the minimum cardinality
C. A crow’s Foot Cardinality as the maximum cardinality
In Figure 1, a(n) ________ symbol in the minimum position on the line symbol means that an instance
of that type is mandatory.
A. oval
B. arrow
C. bar
D. crow’s foot
E. Cardinality
C. bar
In Figure 1, the square symbols each represent a(n) _____.
A. cardinality
B. entity
C. relationship
D. table
E. attribute
B. entity
In Figure 1, the consist of the small vertical bar, small oval, and crow’s foot symbols.
A. cardinalities
B. entities
C. relationships
D. tables
E. attributes
A. cardinalities
In a database built based on the ERD shown in Figure 2, the logical association between Major and
Student is created when the ________ of Major is posted into Student where it plays the part of a(n)________ .
A. primary key, foreign key
B. primary key, non-key attribute
C. foreign key, primary key
D. foreign key, non-key attribute
A. primary key, foreign key
When querying a database built based on the ERD shown in Figure 2, you want the output that shows
how many students there are for one major. Which of the following clauses should be added to the
query to produce the desired output?
SELECT MajorCode, COUNT(SID)
FROM Student ____________________ ;
A. WHERE SID IS NOT NULL
B. GROUP BY MajorCode
C. AS “Total Number of Students”
D. ORDER BY SID
E. ORDER BY MajorCode
B. GROUP BY MajorCode
When querying a database built based on the ERD shown in Figure 2, which of the following options
should be entered into the blank to correctly complete this FROM clause?
FROM Major JOIN Student ON Major.MajorCode = ________
A. Product.SaleProdID
B. Student.SID
C. Major.SID
D. Student.MajorCode
E. Student.Decl_Date
D. Student.MajorCode
When querying a database built based on the ERD shown in Figure 2, if we know that the students are from various countries including the USA, which of the following statements about the query output
will be TRUE when we run the following query?
SELECT SID, Name, Country
FROM Student
WHERE Country = “USA”;
A. The number of records in the query output will be more than as in the student table.
B. The number of records in the query output will be the same as in the Student table.
C. The number of records in the query output will be less than as in the Student table.
D. None of the above.
E. A & C are correct.
C. The number of records in the query output will be less than as in the Student table.
You are querying a database built based on the ERD shown in Figure 2. The Student table contains multiple records with same names, such as Garcia, Smith, etc., so if you wish each unique name to be listed only once in the query output, which of the following SELECT clauses should you choose?
A. SELECT Name DISTINCT FROM Student;
B. SELECT DISTINCT Name FROM Student;
C. SELECT UNIQUE Name FROM Student;
D. SELECT Name UNIQUE FROM Student;
E. SELECT Name FROM Student;
B. SELECT DISTINCT Name FROM Student;
Which of the following terms refers to a very large collection of servers
that a company with needs beyond those supplied by a single server may choose
to maintain?
a. server farm
b. server database
c. firmware
d. parallel nodes
a. server farm - all the other things are not revlevent
________ is a category of cloud hosting where vendors provide not only
hardware infrastructure and an operating system but application programs and
databases as well.
a. PaaS
b. BaaS
c. SaaS
d. IaaS
c. SaaS - sofware as a service; encopuses everything-not just hardware but
software too
ABC Inc. wants to securely share electronic documents internally with the
employees. Which of the following is the best way to implement this strategy?
a. create a private cloud
b. use an access point
c. create a bridge
d. send documents via interoffice mail
e. use Google docs
a. create a private cloud - keyword in this question is security and private cloud
gives you the max amount of security
Compared to in-house hosting, cloud-based hosting ________.
a. requires significant development effort
b. provides greater control over the location of data
c. provides better visibility of security and disaster preparedness
capabilities
d. minimizes the risk of investing in technology that will soon become
obsolete
e. requires a significant amount of capital
d. minimizes the risk of investing in technology that will soon become
obsolete - keyword is in-house
The resources that are part of a Cloud-based service agreement are
described as being “pooled” which means organizations ________.
a. offer their services to each other free of charge, in a give-and-
take arrangement
b. share the same physical address range
c. share the same physical hardware through virtualization
d. use the public Internet to create the appearance of a private
connection
e. use open source standards that enable users to modify a program’s
source code
c. share the same physical hardware through virtualization - virtualization
is the keyword
Virtualization is the process by which ________.
a. one physical computer hosts many different virtual computers within it
b. a single operating system is licensed for multiple computers
c. a single server is used to host the operations of a workstation
d. a single operating system is shared by multiple users
a. one physical computer hosts many different virtual computers within
it - run many virtual computers within one laptop
One disadvantage of entering into a Cloud-based service agreement is:
a. significant development effort
b. loss of control over data location
c. increased management requirements
d. ongoing support costs
b. loss of control over data location - hosted by an external company so in
some sense you lose control over your data based off of location
The term ________ means that the computing resources leased can be
increased or decreased dynamically in a short span of time and that organizations pay for just the resources that they use.
a. portable
b. pooled
c. programmatic
d. elastic
e. incremental
d. elastic - cloud service can be as big or small as you want and can
go back to its original
TCP stands for _________ and IP stands for ________.
a. Transaction Control Protocol/Internet Protocol
b. Tranfer Control Protocol/Internet Protocol
c. Transportation Control Protocol/Intranet Protocol
d. Transportation Control Protocol/Internet Protocol
d. Transportation Control Protocol/Internet Protocol
Which of the following is an example of IaaS?
a. Apple iCloud
b. Microsoft Azure
c. Office 365
d. Amazon S3
e. Google Drive
d. Amazon S3
Jerry wants to use ________ so that he can add his own application on top
of the hosted platform.
a. Apple iCloud
b. Amazon S3
c. Microsoft Azure
d. Office 365
e. Skype
c. Microsoft Azure - PaaS
Layla runs a startup that makes custom engraved floor tiles. Her business is growing rapidly and she needs a cloud vendor to provide her with an operating system and a database management system. In this scenario, which of the following services will the vendor provide?
a. e-cloud
b. PaaS
c. IaaS
d. SaaS
e. Website hosting
b. PaaS
LAN stands for _____________.
A. Local Area Netzone
B. Local Access Node
C. Local Access Network
D. Local Area Network
E. Local Area Node
D. Local Area Network
Which of the following companies produce CPU chips?
A. Microsoft
B. Apple
C. Amazon
D. Intel
E. TikTok
D. Intel
A ________ is the basic form of data exchange in TCP/IP networks.
A. packet
B. kilobyte
C. gigabyte
D. megabyte
E. zettabyte
A. packet
Which size of main memory is the largest?
A. kilobyte
B. gigabyte
C. exabyte
D. terabyte
E. petabyte
C. exabyte
Which of the following is a characteristic of volatile memory?
A. Processor heats up during the operation.
B. Files are stored permanently.
C. Processing of data is very slow.
D. Contents are lost when power is off.
E. It should be purged at least once a year
D. Contents are lost when power is off.
Bits are grouped into 8-bit chunks called ________.
A. switches
B. strings
C. bytes
D. kilobytes
E. nibbles
C. bytes
Which of the following devices is an example of a storage hardware device?
A. barcode scanner
B. central processing unit
C. optical disk
D. random access memory
E. the system bus
C. optical disk
Which of the following is defined as the elastic leasing of pooled
computer resources over the Internet?
A. broadband
B. wiki
C. the cloud
D. Bluetooth
E. SSD
C. the cloud
Dr. Guo emphasized that when it comes to the scope of services provided,
the correct ranking order for IaaS, PaaS, and SaaS is _____________. (>
means having greater scope than)
A. SaaS > PaaS > IaaS
B. IaaS > PaaS > SaaS
C. SaaS > IaaS > PaaS
D. PaaS > SaaS > IaaS
E. SaaS > IaaS > PaaS
A. SaaS > PaaS > IaaS
Which of the following refers to a small, portable storage device that
can be used to back up data and transfer it from one computer to another?
A USB flash drive
B projector
C mouse
D barcode scanner
E Bluetooth speaker
A. USB flash drive
A ________ is also called “the brain” of the computer.
A network card
B motherboard
C thumb drive
D central processing unit
E CMOS
D central processing unit
Vivian wants to book a suite at Baron & Olufsen, a luxury hotel chain in
Europe, for her brief stay in Austria. When she visits the Web page, the
address bar reads http://www.baron-olufsen.com/. This information is the
________ of the Web page.
A) URL
B) IP address
C) protocol
D) email ID
E) MAC address
A) URL
A ________ is a worldwide-unique term that is affiliated with a public IP
address.
A) URL
B) domain name
C) packet
D) hyperlink
E) DNF
B) domain name