Final Flashcards
(106 cards)
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
