Deck 11: Behind the Scenes: Databases and Information Systems

Question 1

Nontraditional data such as audio clips, video clips, pictures, and very large documents are called ________ data.

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

Answer 1

C

Question 2

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

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

Answer 2

B

Question 3

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

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

Answer 3

B

Question 4

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 5

A ________ check would be used to restrict the fines for speeding violations from $50 to $250.

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

Question 6

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

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

Question 7

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

Question 8

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

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

Question 9

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

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

Question 10

Which of the following is NOT a likely primary key?

A) Driver's license number
B) Date of birth
C) Student ID number
D) Social Security number

Question 11

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

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

Question 12

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 13

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

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

Question 14

________ is used to ensure that data is organized most efficiently.

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

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

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

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

Question 17

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 18

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 19

________ databases are the most frequently used electronic databases.

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

Question 20

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

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

Question 21

The Siri personal assistant application on Apple's iPhone 5s 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 22

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 23

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 24

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 25

In a Microsoft Access database, an active web address is stored as a(n) ________ field in a database.

Question 26

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

Question 27

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

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

Question 28

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 29

________ involves putting data into an electronic file in a format that another application can recognize.

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

Question 30

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

Question 31

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

Question 32

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 33

A(n) ________ is designed to improve communications and help employees complete their routine tasks.

A) office support system (OSS)
B) transaction-processing system (TPS)
C) management information system (MIS)
D) decision support system (DSS)

Question 34

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

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

Question 35

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

Question 36

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

Question 37

Data that describe other data are called________.

Question 38

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 39

________ 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 40

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

Question 41

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

Question 42

An employee's ID number, name, company position, address, city, state, and Zip Code make up a record.

Question 43

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

Question 44

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

Question 45

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

Question 46

When using Access, the text of the Gettysburg Address would be stored in a short text field.

Question 47

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

Question 48

A group of related records is called a table.

Question 49

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 50

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

Question 51

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

Question 52

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

Question 53

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

Question 54

The data in a data warehouse are ________, meaning they do not all pertain to one period in time.

Question 55

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

Question 56

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

Question 57

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

Question 58

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

Question 59

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

Question 60

A large data mart might require a database administrator to design, construct, and maintain it.

Question 61

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

Question 62

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

Question 63

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

Question 64

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

Question 65

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

Question 66

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

Question 67

Most databases can import electronic data from other software applications.

Question 68

The information in a data mart spans an entire enterprise.

Question 69

A last name field is an example of a field that should have a default value.

Question 70

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