Deck 11: Behind the Scenes: Databases and Information Systems

Question 1

Data in a multidimensional database is organized in a ________ format.

A) linear
B) modular
C) cube
D) cellular

Answer 1

C

Question 2

A ________ is a collection of related data that can be stored, sorted, organized, and queried.

A) database
B) document
C) memo
D) macro

Answer 2

A

Question 3

If a school keeps two lists, one for student registration and one for student financial information, both containing name and address information, this is an example of data ________.

A) integrity
B) redundancy
C) completeness
D) normalization

Answer 3

B

Question 4

In a Microsoft Access database, something like the Gettysburg Address would be stored in a(n) ________ field.

A) text
B) long text
C) short text
D) object

Question 5

________ databases are the most commonly used electronic databases.

A) Relational
B) Flat-file
C) Multidimensional
D) Object-oriented

Question 6

Nontraditional data in object-oriented databases such as audio clips, video clips, pictures, and very large documents are called ________ data.

A) enterprise
B) structured
C) unstructured
D) multidimensional

Question 7

You would use a ________ in a database to temporarily display records of residents for the city of Boston.

A) sieve
B) filter
C) validation rule
D) field constraint

Question 8

A ________ check would be used in a field to restrict the fines for speeding violations so that they fall between $50 and $250.

A) completeness
B) range
C) consistency
D) numeric

Question 9

Data ________ means that the data contained in a database is accurate and reliable.

A) efficiency
B) integrity
C) redundancy
D) consistency

Question 10

A ________ relationship indicates that for each record in a table, there is only a single corresponding record in a related table.

A) many-to-one
B) one-to-many
C) one-to-one
D) many-to-many

Question 11

Data ________ helps to ensure data integrity by maintaining information in only one place.

A) flexibility
B) redundancy
C) mapping
D) centralization

Question 12

A ________ check compares the values of data in two or more fields to see whether those values are reasonable.

A) correctness
B) range
C) consistency
D) numeric

Question 13

You can set a ________, which is automatically displayed in a field unless the user enters something different.

A) default value
B) relation
C) field type
D) numeric check

Question 14

In a database, a group of related records is referred to as a(n) ________.

A) memo
B) field
C) object
D) table

Question 15

________ means that for each value in the foreign key of one table, there is a corresponding value in the primary key of another table.

A) Referential integrity
B) Normalization
C) Database consistency
D) Record integrity

Question 16

________ is used to ensure that data is organized most efficiently in a database.

A) Consistency checking
B) Validation
C) Normalization
D) Range checking

Question 17

A(n) ________ check determines whether a required field such as LastName was filled in.

A) completeness
B) range
C) consistency
D) alphabetic

Question 18

Which of the following is a likely primary key in a student information record?

A) Last name
B) Date of birth
C) Student ID number
D) First name

Question 19

In a database, the term ________ is synonymous with a category of data.

A) field
B) record
C) row
D) table

Question 20

A(n) ________ is a way of retrieving information from one or more tables that defines a particular subset of data.

A) validation rule
B) field constraint
C) enquiry
D) query

Question 21

In a transaction-processing system (TPS), if the TPS database can be queried and updated while the transaction is taking place, this is called ________ processing.

A) direct
B) batch
C) real-time
D) immediate

Question 22

In a relational database, a(n) ________ relationship indicates that a record that appears only one time in a table, may appear multiple times in a related table.

Question 23

A data ________ is a large-scale collection of data that contains and organizes all of an organization's data in one place.

A) mart
B) chain
C) warehouse
D) storehouse

Question 24

Management information systems (MIS) provide ________ reports, which show conditions that are unusual or need attention from users of the system.

A) detail
B) summary
C) exception
D) expert

Question 25

In a Microsoft Access database, an active web page, e-mail address, or existing file is stored as a(n) ________ field.

Question 26

________ involves taking data from your database and putting it into an electronic file in a format that another external application or database can recognize.

A) Exporting
B) Importing
C) Enhancing
D) Extracting

Question 27

Big data analytics is usually associated with ________ services.

A) office support
B) data warehouse
C) management information
D) decision support

Question 28

Siri, the personal assistant application on Apple's iPhone is an example of a ________.

A) natural language processing (NLP) system
B) decision support system (DSS)
C) management information system (MIS)
D) database management system (DBMS)

Question 29

A database that allows data to be maintained in a single location provides data ________.

Question 30

A(n) ________ database stores data in more than two dimensions, as opposed to relational databases, which store data in two-dimensional tables.

Question 31

When working with a relational database, each record must have a(n) ________ key field, which has a value unique to that record.

Question 32

________ databases are better than relational databases at handling unstructured data such as audio clips, video clips, and pictures.

Question 33

A ________ displays a subset of data from a table (or tables) based on the specified criteria.

A) table query
B) join query
C) select query
D) criteria query

Question 34

A data dictionary is also referred to as a(n) ________.

Question 35

Data staging consists of all of the following steps, EXCEPT ________.

A) transforming the data
B) mining the data
C) storing the data in a warehouse
D) extracting the data

Question 36

In a database, another term for a table is a(n) ________.

Question 37

________ is the branch of computer science that attempts to create computers that think like humans.

A) Natural language processing
B) Expert systems
C) Artificial intelligence
D) Enterprise resource planning

Question 38

A group of related records is called a(n) ________.

Question 39

SQL uses ________ to extract records from a database by using English-like expressions that have variables and operations.

A) Boolean algebra
B) relational algebra
C) primary keys
D) foreign keys

Question 40

Data that describes other data is called ________.

Question 41

The data in a data warehouse is ________, meaning it does not all pertain to one period in time.

Question 42

In a relational database, when two tables have a common field, the link between the tables is known as a hyperlink.

Question 43

In an employee database, an employee's ID number, last name, first name, company position, address, city, state, and Zip Code make up a record.

Question 44

A(n) ________ is created from a large data business warehouse to analyze a single component of the business.

Question 45

A field ________ is a property that must be met before an entry can be accepted into the field.

Question 46

________ is used to analyze large amounts of data and identify unseen patterns or trends.

Question 47

A business that updates its records all at once at the end of the business day uses ________ processing.

Question 48

Referential integrity means that for each value in the ________ field of a table, there is a corresponding value in the primary key of the related table.

Question 49

________ is the process of ensuring that the data entered into a field meets specified guidelines.

Question 50

A(n) ________ provides a view of data fields to be filled in with appropriate labels to assist a user in entering data into the database.

Question 51

________ data is information about how users of a company's website move through the web pages.

Question 52

When using SQL, a(n) ________ query is used to extract data from two or more tables.

Question 53

Data redundancy ensures that the data contained in the database is accurate and reliable.

Question 54

Normalization means that there are no data entry errors in a database.

Question 55

A(n) ________ tries to replicate the decision-making processes of human experts to solve specific problems.

Question 56

A group of related records is called a table.

Question 57

A(n) ________ report provides a consolidated picture of detailed data and usually includes some calculation or visual displays of information and is generated by a MIS.

Question 58

A street address field is an example of a field that should have a default value.

Question 59

When creating a data warehouse, ________ is the process that extracts data from source databases, reformats the data, and stores them in the warehouse.

Question 60

To temporarily display records from a single table that match certain criteria, you would use a(n) ________.

Question 61

A summary report generated by an MIS provides a list of the transactions that occurred during a specified time period.

Question 62

Employees' last name would usually make an appropriate primary key field.

Question 63

Data mining analyzes and investigates large amounts of data with the intention of discovering significant patterns or trends.

Question 64

Most databases can import electronic data from other software applications.

Question 65

A database schema defines the name, data type, and length of each field in the database.

Question 66

Real-time processing means that transactions are updated when they occur.

Question 67

The information in a data mart spans an entire enterprise.

Question 68

A filter is limited to extracting data from a single table.

Question 69

When using Access, the text of the Declaration of Independence would be stored in a short text field.

Question 70

Small slices of a data mart are called data warehouses.