IFSM 201 Quiz Week 3

9/8/2019 Quiz - IFSM 201 6364 Concepts and Applications of Information Technology (2198) - UMUC Learning Management System

https://learn.umuc.edu/d2l/lms/quizzing/user/attempt/quiz_start_frame_auto.d2l?ou=416120&isprv=&drc=0&qi=1047975&cfql=0&dnb=0 1/7

Question 1 (0.25 points)

Question 2 (0.25 points)

Question 3 (0.25 points)

Question 4 (0.25 points)

Saved

Saved

Saved

Saved

Which of the following would not be counted in a list of goals for having and using a knowledge management system (KMS):

________ is the gathering, organizing, sharing, and analyzing of the data and information to which a business has access.

True or false? A record can contain only character data—letters, numbers, or special symbols.

A) True

B) False

True or false? Tables are composed of fields, and fields are composed of records.

Facilitating better, more informed decisions

Stimulating cultural change and innovation

Utilizing information technology to manage data and information

Impacting performance across an organization

Building knowledge that can be used to streamline operations and improve processes.

Data

Information

Knowledge management

Organizational memory

9/8/2019 Quiz - IFSM 201 6364 Concepts and Applications of Information Technology (2198) - UMUC Learning Management System

https://learn.umuc.edu/d2l/lms/quizzing/user/attempt/quiz_start_frame_auto.d2l?ou=416120&isprv=&drc=0&qi=1047975&cfql=0&dnb=0 2/7

Question 5 (0.25 points)

Question 6 (0.25 points)

Question 7 (0.25 points)

Saved

Saved

Saved

A) True

B) False

What is a DBMS wizard?

What is the software called that allows the user to create, access, and manage a database?

What are procedures that help keep a database current?

A) A form on the screen that allows the user to enter or modify data

B) A form that allows the user to retrieve data

C) A software application that allows a user to create tables, queries and reports within a database.

D) A type of hardware that allows you to create, access, and manage a database

A) DLP

B) DBMS

C) OO model

D) Relational Model

9/8/2019 Quiz - IFSM 201 6364 Concepts and Applications of Information Technology (2198) - UMUC Learning Management System

https://learn.umuc.edu/d2l/lms/quizzing/user/attempt/quiz_start_frame_auto.d2l?ou=416120&isprv=&drc=0&qi=1047975&cfql=0&dnb=0 3/7

Question 8 (0.25 points)

Question 9 (0.25 points)

Saved

Saved

Which of the following database model choices would be best for storing video clips organized by various vacations you have taken?

Which of the following would be an example of a loss of record integrity within a database?

A) Database query procedures

B) Report generation procedures

C) File maintenance procedures

D) Data entry procedures

A) Hierarchical

B) Flat-file

C) Object-oriented

D) Network

A) A faculty member posts the full names and final grades on the main page of the class's website.

B) Your online banking site tells you your password has expired and requests that you submit a new one to access your accounts.

C) Your bank statement is not reflecting a refund that you know was deposited in your account last week (your account balance does reflect the refund).

D) You are denied a new credit card because the credit card company checked your credit score and found that it did not meet its minimum standards for new accounts. Your credit report does not show any invalid records.

9/8/2019 Quiz - IFSM 201 6364 Concepts and Applications of Information Technology (2198) - UMUC Learning Management System

https://learn.umuc.edu/d2l/lms/quizzing/user/attempt/quiz_start_frame_auto.d2l?ou=416120&isprv=&drc=0&qi=1047975&cfql=0&dnb=0 4/7

Question 11 (0.25 points)

Question 12 (0.25 points)

Question 13 (0.25 points)

Question 10 (0.25 points) Saved

Saved

Saved

Saved

Cloud storage for database contents is more efficient in terms of easy access by employees anytime, anywhere. The updated information for the database is generated with real-time information sent to a central server within the company. Updates to the cloud are made every hour during normal working hours. This could be considered a potential database __________.

Your network administrator finds a virus in the network software. Fortunately, she was able to eliminate it before it resulted in a denial-of-

service attack, which would have prevented legitimate users of the networked database from gaining access to the records needed. It turns

out that the network software did not have adequate security protections in place. The fact that this virus was successfully inserted into the

network software points to a ______ the network software.

Joachim is frustrated at a lack of job advancement opportunities at his current job. Before resigning, he deletes a set of data records that cannot be restored because there is no database backup procedure in place. Which of the following best describes this data issue?

A staff/faculty member uses proprietary (owned and protected by the university) data from the university's student financial records database in a graph that is part of a presentation at a computer education conference. Which of the following best describes the data issue?

A) threat

B) vulnerability

A) threat to

B) vulnerability of

A) Intentional malicious data loss

B) Intentional malicious data leak

C) Accidental malicious data loss

D) Accidental malicious data leak

9/8/2019 Quiz - IFSM 201 6364 Concepts and Applications of Information Technology (2198) - UMUC Learning Management System

https://learn.umuc.edu/d2l/lms/quizzing/user/attempt/quiz_start_frame_auto.d2l?ou=416120&isprv=&drc=0&qi=1047975&cfql=0&dnb=0 5/7

Question 14 (0.25 points)

Question 15 (0.25 points)

Question 16 (0.25 points)

Question 17 (0.25 points)

Saved

Saved

Saved

Saved

(True/False). Because you have made it a practice to never access the internet while your personal database is open, you can rest assured that your database would likely not be vulnerable to any compromises.

A) True

B) False

(True/False). Risk assessment should cover personnel, as well as technical support such as firewalls, secure operating systems and networks, and antivirus protection.

A) True

B) False

Which of the following actions is not easily accomplished in an existing chart:

(True/False). You cannot format the data in an Excel spreadsheet to look like a table.

A) Malicious data loss

B) Intentional data leak

C) Accidental data loss

D) Malicious data leak

Alphabetize an set of axis labels in an existing chart.

Change the chart type

Insert a chart via the Recommended Charts option

Rearrange chart data via the switch rows/columns option

9/8/2019 Quiz - IFSM 201 6364 Concepts and Applications of Information Technology (2198) - UMUC Learning Management System

https://learn.umuc.edu/d2l/lms/quizzing/user/attempt/quiz_start_frame_auto.d2l?ou=416120&isprv=&drc=0&qi=1047975&cfql=0&dnb=0 6/7

Question 18 (0.25 points)

Question 19 (0.25 points)

Question 20 (0.25 points)

Saved

Saved

Saved

True

False

Once you have created a chart, you can change the type (for example, from a bar chart to a pie chart) by selecting the chart, then:

When creating a named range in Excel, which of the following rules does NOT apply:

Which of the following is a valid named range in Excel:

selecting Format, then selecting Arrange.

selecting Design, then selecting Change Chart Type.

selecting Format, selecting Change Chart Type.

The first character of a name must be a letter, an underscore character (_), or a backslash (\).

You cannot use the uppercase and lowercase characters "C", "c", "R", or "r" as a defined name.

Spaces are not allowed as part of a name.

The length of the name is restricted to 155 characters.

&ABCE

AVG Costs

My_Data

R

9/8/2019 Quiz - IFSM 201 6364 Concepts and Applications of Information Technology (2198) - UMUC Learning Management System

https://learn.umuc.edu/d2l/lms/quizzing/user/attempt/quiz_start_frame_auto.d2l?ou=416120&isprv=&drc=0&qi=1047975&cfql=0&dnb=0 7/7

Submit Quiz 20 of 20 questions saved