Deck 11: Behind the Scenes: Databases and Information Systems

Question 1

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

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

Answer 1

B

Question 2

________ databases are the most commonly used electronic databases.

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

Answer 2

A

Question 3

________ 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

Answer 3

A

Question 4

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 5

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 6

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 7

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 8

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 9

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 10

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 11

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

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

Question 12

Which of the following fields 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 13

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

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

Question 14

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

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

Question 15

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

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

Question 16

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

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

Question 17

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

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

Question 18

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 19

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

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

Question 20

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

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

Question 21

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 22

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 23

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

Question 24

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

Question 25

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

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

A) Natural language processing
B) Data warehousing
C) Artificial intelligence
D) Enterprise resource planning

Question 27

Big data analytics is usually associated with ________ services.

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

Question 28

In Microsoft Access, when you have the field name FirstName display as First Name, you are changing what field property?

A) Caption
B) Display As
C) Field Name
D) Name Property

Question 29

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 30

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

Question 31

Categories of data are called ________.

A) fields
B) records
C) tables
D) objects

Question 32

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 33

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 34

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

Question 35

Which of the following types of databases would be adequate for simple tasks?

A) flat
B) relational
C) object-oriented
D) cube

Question 36

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 37

A group of related records is called a table.

Question 38

Which field property dictates whether the completeness check will trigger an error?

A) Required
B) Validation Rule
C) Indexed
D) Validation Text

Question 39

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 40

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 41

The acronym BLOB stands for Bidirectional Large Objects.

Question 42

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

Question 43

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

Question 44

Detail forms are used to control how new data is entered into a database.

Question 45

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

Question 46

The information in a data mart spans an entire enterprise.

Question 47

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

Question 48

In an Access database, a filter is limited to extracting data from a single table.

Question 49

A table in Microsoft Word or a spreadsheet in Microsoft Excel, can be used as a flat database.

Question 50

In large organizations, a database administrator is responsible for designing, constructing, and maintaining the company's databases.

Question 51

Most databases can import electronic data from other software applications.

Question 52

Small slices of a data mart are called data warehouses.

Question 53

In an Access database, all field types include a field size property.

Question 54

A business intelligence system is form of business information system that is used primarily at the consumer level.

Question 55

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

Question 56

Primary keys must be numbers that already represent something (like a telephone number.)

Question 57

NoSQL databases are good for unstructured data.

Question 58

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

Question 59

When data is kept in one location, such as a database system, it is known as data centralization.

Question 60

A knowledge-based system is an analysis tool that, using internal and external data, provides a view of a particular business situation for the purposes of decision making.

Question 61

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

Question 62

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 63

Text is an example of unstructured data.

Question 64

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

Question 65

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

Question 66

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 67

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

Question 68

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

Question 69

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

Question 70

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

Question 71

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

Question 72

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

Question 73

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

Question 74

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

Question 75

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

Question 76

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

Question 77

Data that describes other data is called ________.

Question 78

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 79

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

Question 80

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