MSIS 2103 - Final Exam Review

Entity Relationship Diagram

A ----- shows the relationships between the tables in a relational database.

False

A URL has two parts. The first part is the protocol identifier, and the second is the domain name. A URL does not need to have an IP address associated with it.

False

Because a properly designed relational database only has single data entry, it is common to put calculated variables in the database.

False

Data is information put into context.

False

Distributed File Systems or NoSQL databases are available for purchase and are closed source systems.

Foreign

Every table has a primary key. When the primary key of one table is in another, it is _____.

False

Formatting data changes the appearance of data, and it changes the data itself.

False

Google Maps is a GPS system that utilizeds a GIS system to provide information about the physical world.

All of the above

How do businesses make money on the Internet?

True

If a formula contains several nested functions, Excel starts with the outermost function and then moves inward.

Click Wrap Text

If you have columns that are truncating your content (not showing all the content), but you cannot increase the width of the worksheet and be able to print on one page, a solution for making the text visible without losing data would be to

Click the arrow on the Paste button on the Standard toolbar, then click Values

If you want to paste a formula result, but not the underlying formula to another cell, you would copy the cell with the formula then place the insertion point in the cell you want to copy to. What next?

This is the number of the column within the selected table_array where the lookup result is located.

In a VLOOKUP formula, what does the argument "column_index_number" mean?

Tacit

In order to perform a skill, the knowledge must be internalized. This is called ----- knowledge.

False

Information is defined as facts, knowledge, and skills acquired by a person through experience or education.

True

TCP/IP defines how data is sent over the Internet.

False

The DBMS is used to create application business rules.

A tool used to summarize data.

What is a Pivot Table?

They all have a single database supporting applications.

What is a common element between an ERP, a CRM, and an SCM?

Create or select data that needs to be analyzed.

What is the first step for creating a Pivot Table?

On a server

When you access your University's Learning Management System (LMS), the LMS is where?

Providing content.

When you post a review on a business you are -----.

Dynamic, Static

When you sign onto a LAN through WiFi, you have a ----- IP address and the LAN router has a ----- IP address.

True

When you use a credit card, you are using several different companies' information systems.

It depends on whether you select to insert the Pivot Table in the current worksheet or a new worksheet and where your cursor is.

Where is a Pivot Table inserted?

Ribbon

Which is the part of the Excel screen where you can find all the commands or buttons, depending on the tab you selected before?

Format of date fields, required date fields, database business rules, number of characters in a text field.

Metadata defines the _____.

The number of transistors on a chip doubles every 18 to 24 months.

Moore's law states that -----.

True

One way to get data out of a relational database is to write a query using SQL or structured query language.

False

A business gives the employees access to the data they need to do their jobs. The employees use the DBMS to access the data.

1024 Terabytes

A kilobyte is 1024 bytes. A megabyte is 1024 kilobytes. A gigabyte is 1024 megabytes. What is a petabyte?

ERP

A manufacturing company that uses an enterprise information system will likely use a(n) -----.

Standard

A protocol is which of the following?

False

A relational database can have a many-to-many relationship between entities.

SCM

A retailer such as Walmart that uses an enterprise information system will likely use a(n) -----.

CRM

A service company that uses an enterprise information system will likely use a(n) -----.

1 second

According to the video "A Packet's Tale" what is the total time for the request and the webpage to be displayed?

False

All computer devices communicate over a network using computer languages such as Python or C#.

True

An ERP can have a CRM module.

False

Learning objective four is to develop skill in using Excel by applying it to solve problems.

Cellular radio

Through the use of apps (application software) your smart phone can access devices that are connected to a network. What technology does the smart phone use to connect to the network?

Hold down the CTRL key

To select several cells or ranges that are not touching each other, you would _____ while selecting.

Sort A to Z and Sort Z to A buttons

To sort data in an Excel worksheet you can use the -----.

You can lookup values located in a column to the left of the column that contains the lookup value.

Which of the following is NOT possible with VLOOKUP?

All of the above are jobs that companies hire MIS graduates to do.

Which of the following is not a job that companies hire MIS graduates to do

Adobe Photoshop

Which of the following is not open source application software?

They have one database.

Which of the following is the common element of enterprise systems?

=VLOOKUP(lookup_value, table_array, col_index_num, range_lookup)

Which of the formulas below contain the correct syntax (formula arguments) for the VLOOKUP function?

False

You have a LAN at home so all of your IoT devices can be reached through the Internet. All of the devices are connected by WiFi and have a static IP addresses.

bandwidth

Your Internet Service Provider (ISP) says that your network runs at 50 gigabit per second. This is the -----.