MIS Midterm Chapter 4

Which of the following is an example of a database management system?

Access

Which of the following is a reason for the term elastic being used to define the cloud?

Computing resources can be increased or decreased dynamically in cloud-based hosting.

A(n) ________ is a program used to create, process, and administer a database.

DBMS

Which of the following is an international standard language for processing a database?

SQL

Which of the following statements is true about cloud computing?

The elastic leasing of pooled computer resources over the Internet is called the cloud.

________ are the final judges as to what data the database should contain and how the records in that database should be related to one another.

Users

A primary key used in a database is a ________.

column or group of columns that identifies a unique row in a table

In a database, when data items disagree with one another, it leads to a(n) ________.

data integrity problem

Metadata are ________.

data that describe data

A ________ is a collection of forms, reports, queries, and programs that serves as an intermediary between users and database data.

database application

The columns in a database are called ________.

fields

The tables that appear in a database are known as ________.

files

Columns that are keys to different tables than the ones in which they reside are called ________.

foreign keys

Relational databases represent relationships using ________.

foreign keys

A database is required instead of a spreadsheet when ________.

lists involve data with multiple themes

Sireus Corp. is availing a cloud-based service. It plans to install a software package that will offer cloud services to its users. If it would like to avoid installing an operating system on the server, which of the following services should it choose?

platform as a service (PaaS)

Which of the following services provides hardware, an operating system, and a database management system (DBMS) on a cloud-based offering?

platform as a service (PaaS)

Albert creates a relational database to store employee performance statistics. He stores each employee's data in independent rows and creates a column named "Employee Number" to assign unique numbers to each employee. This column is referred to as a(n) ________.

primary key

When you modify or delete data present in a database, you are ________.

processing the database

A(n) ________ is a request for data from a database.

query

Brenda, the sales manager of a firm, wants to generate a particular report containing sales analyses of the second and third quarter of the year. She should use a ________ to obtain the information that she wants from the database.

query

The rows in a database are called ________.

records

If an organization opts for software as a service (SaaS), it will have to ________.

transfer data and develop procedures

Identify the open source DBMS product among the following.

MySQL

Which of the following is true of MySQL?

It is license-free for most applications.