MSIS 2103 OKSTATE FINAL QUESTIONS AND
ANSWERS
Which part of a URL identifies the protocol? - Answers :https
A service company that uses an enterprise information system will likely us a(n)
______. - Answers :CRM
A manufacturing company that uses an enterprise system will likely use a(n) _____. -
Answers :ERP
T/F: The DBMS is used to create application business rules. - Answers :False
Click-based advertising is one method that online businesses use to make money -
Answers :true
T/F: A relational database can have a many-to-many relationship between entities -
Answers :False
You are working on an excel spreadsheet and have discovered that your method of
solving a problem has created a circular reference. Excel has a solution to this problem.
You need to use _________. - Answers :Goal Seek
When working on WiFi, what does the router or access point use to identify you? -
Answers :Dynamic IP Address
One method of keeping information secure when sent over the Internet or stored on a
computer is ________. - Answers :Encryption
When you use the internet you run the risk of ______. - Answers :Identity theft, financial
theft, extortion, and blackmail.
You are being asked to join an organization. You are told that the members are very
friendly and everyone has a great time at events the organization holds. You conclude
that joining this organization will help you raise your GPA. Of what bias are you possibly
guilty? - Answers :Insensitive to predictability
T/F: an ERP can have a CRM module - Answers :true
T/F: the representative heuristic is one of the reasons that first impressions on meeting
someone are so important - Answers :True
In excel to select several cells or ranges that are not touching each other you would
________ while selecting. - Answers :Hold down the CTRL key
, Every table has a primary key. When the primary key of one table is in another table it is
called an _______ key. - Answers :Foreign
T/F: If a formula contains several nested functions, excel starts with the innermost
function and then moves outward - Answers :False
T/F: People are the greatest threat to the security of a business's information - Answers
:True
How can you recognize a phishing email? - Answers :It may have a link for you to click
to access a message.
A service company that uses an enterprise information system will likely use
a(n)________. - Answers :CRM
T/F: Google and Facebook store a very large amount of information. They use a
relational database to store and manage this information. - Answers :False
A retailer such as Walmart that uses an enterprise information system will likely us
a(n)______. - Answers :SCM
Someone is quiet and appears aloof. You predict that they would not have a successful
career as a comedian. What bias would potentially invalidate your prediction? - Answers
:Illusion of Validity
What is a common element between an ERP, a CRM, and an SCM? - Answers :They
all have a single database supporting applications
You always take exams wearing the same shirt, because when you wear that shirt you
make a good grade on the exam. This is an example of what bias? - Answers :Illusion-
correlation bias.
The third tenet of the CIA is _______. - Answers :Availability
T/F: Knowledge is defined as "facts, information, and skills acquired by a person
through experience or education; the theoretical or practical understanding of a subject."
The key element of knowledge is that it can be written and shared with others. -
Answers :false
T/F: In Excel, when you define a named range it can only be used in formulas on the
same spreadsheet as the named range. - Answers :False
You are saving $200 per month for a down payment on a house. Your bank pays 2%
APR interest. What function would you use to calculate the total amount in your savings
account in two years? - Answers :FV
ANSWERS
Which part of a URL identifies the protocol? - Answers :https
A service company that uses an enterprise information system will likely us a(n)
______. - Answers :CRM
A manufacturing company that uses an enterprise system will likely use a(n) _____. -
Answers :ERP
T/F: The DBMS is used to create application business rules. - Answers :False
Click-based advertising is one method that online businesses use to make money -
Answers :true
T/F: A relational database can have a many-to-many relationship between entities -
Answers :False
You are working on an excel spreadsheet and have discovered that your method of
solving a problem has created a circular reference. Excel has a solution to this problem.
You need to use _________. - Answers :Goal Seek
When working on WiFi, what does the router or access point use to identify you? -
Answers :Dynamic IP Address
One method of keeping information secure when sent over the Internet or stored on a
computer is ________. - Answers :Encryption
When you use the internet you run the risk of ______. - Answers :Identity theft, financial
theft, extortion, and blackmail.
You are being asked to join an organization. You are told that the members are very
friendly and everyone has a great time at events the organization holds. You conclude
that joining this organization will help you raise your GPA. Of what bias are you possibly
guilty? - Answers :Insensitive to predictability
T/F: an ERP can have a CRM module - Answers :true
T/F: the representative heuristic is one of the reasons that first impressions on meeting
someone are so important - Answers :True
In excel to select several cells or ranges that are not touching each other you would
________ while selecting. - Answers :Hold down the CTRL key
, Every table has a primary key. When the primary key of one table is in another table it is
called an _______ key. - Answers :Foreign
T/F: If a formula contains several nested functions, excel starts with the innermost
function and then moves outward - Answers :False
T/F: People are the greatest threat to the security of a business's information - Answers
:True
How can you recognize a phishing email? - Answers :It may have a link for you to click
to access a message.
A service company that uses an enterprise information system will likely use
a(n)________. - Answers :CRM
T/F: Google and Facebook store a very large amount of information. They use a
relational database to store and manage this information. - Answers :False
A retailer such as Walmart that uses an enterprise information system will likely us
a(n)______. - Answers :SCM
Someone is quiet and appears aloof. You predict that they would not have a successful
career as a comedian. What bias would potentially invalidate your prediction? - Answers
:Illusion of Validity
What is a common element between an ERP, a CRM, and an SCM? - Answers :They
all have a single database supporting applications
You always take exams wearing the same shirt, because when you wear that shirt you
make a good grade on the exam. This is an example of what bias? - Answers :Illusion-
correlation bias.
The third tenet of the CIA is _______. - Answers :Availability
T/F: Knowledge is defined as "facts, information, and skills acquired by a person
through experience or education; the theoretical or practical understanding of a subject."
The key element of knowledge is that it can be written and shared with others. -
Answers :false
T/F: In Excel, when you define a named range it can only be used in formulas on the
same spreadsheet as the named range. - Answers :False
You are saving $200 per month for a down payment on a house. Your bank pays 2%
APR interest. What function would you use to calculate the total amount in your savings
account in two years? - Answers :FV
