MIS Quiz 3

_____ is responsible for overseeing every aspect of an organization's information resource.

CIO

_____ are the technology tools that directly support OLTP.

Databases and DBMS's

A report generator allows you to see the contents of a database file, make whatever changes you want, perform simple sorting, and query to find the location of specific information.

FALSE; A view allows you to see the contents of a database file, make whatever changes you want, perform simple sorting, and query to find the location of specific information.

Data administration is the function in an organization that is responsible for the more technical and operational aspects of managing the information contained in organizational information repositories.

FALSE; Database administration is the function in an organization that is responsible for the more technical and operational aspects of managing the information contained in organizational information repositories (databases, data warehouses, and data marts).

Databases and DBMSs are the technology tools that directly support OLAP.

FALSE; Databases and DBMSs are the technology tools that directly support OLTP.

What term is used to describe the use and distribution of information regardless of title or department?

Information sharing

Which data administration facility allows you to control who has access to what information and what type of access those people have?

Security management facilities; Security management facilities—allow you to control who has access to what information and what type of access those people have. Always remember CRUD—Create, Read, Update, and Delete. Identifying who can perform those functions on various database information is vitally important.

A _____ is a collection of information that you organize and access according to the logical structure of that information.

Database

The most popular database model is the hierarchical database model.

FALSE; Relational database model

SQL is:

A standardized fourth generation language found in most DBMS's.

Which of the following DBMS components allows you to quickly develop computer routines or tasks that will process your business transactions?

Application generation subsystem

Your student ID is an example of a(n) ____.

Attribute; Within each file, you can see specific pieces of information called attributes. For example, the Order file contains Order Number, Order Date, Customer Number, Delivery Address, Concrete Type, Amount (this is given in cubic yards), Truck Number, and Driver ID.

If you were working for a large pharmaceutical company and building a sales report on the current prescription writing habits of doctors, what type of information repository would you be most likely working with?

Data mart; A data mart is a subset of a data warehouse in which only a focused portion of the data warehouse information is kept.

A _____ is a special form of a database that contains information gathered from operational databases for the purpose of supporting decision-making tasks.

Data warehouse; A data warehouse is, in fact, a special form of a database that contains information gathered from operational databases for the purpose of supporting decision-making tasks.

Which organizational function is responsible for the more technical and operational aspects of managing information repositories?

Database administration; Database administration is the function in an organization that is responsible for the more technical and operational aspects of managing the information contained in organizational information repositories (databases, data warehouses, and data marts).

If your phone number was used in a clothing store to uniquely identify you as a customer, the phone number would be considered a(n) ____.

Primary key

What is the most popular model for creating databases?

Rational database model

f you were to perform a regression analysis, what type of data warehouse tool would it be?

Statistical tools help you apply various mathematical models to the information stored in a data warehouse to discover new information. For example, you can perform a time-series analysis to project future trends. You can also perform a regression analysis to determine the effect of one variable on another.

A foreign key is also a primary key.

TRUE

A primary key from one file and a foreign key from another file are used to create a relationship between two files in a relational database.

TRUE

Multidimensional analysis (MDA) tools are slice-and-dice techniques that allow you to view multidimensional information from different perspectives.

TRUE

When you build a data warehouse and use data-mining tools to manipulate the data warehouse's information, you are actively engaging in analytics.

TRUE

When you create a database, you must first use the data definition subsystem to create the data dictionary and define the structure of the files.

TRUE

A database management system contains five important software components. Which of the following components accepts and processes requests from the other four database components?

The DBMS engine accepts logical requests from the various other DBMS subsystems, converts them into their physical equivalent, and actually accesses the database and data dictionary as they exist on a storage device.

If you were a programmer and needed to view information as it was stored by the database, what type of database view would you see?

The physical view of information deals with how information is physically arranged, stored, and accessed on some type of storage device such as a hard disk.