Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

CP102 - Info Processing with Micros > Chapter 11 - Behind the Scenes: Databases and Information Systems > Flashcards

Chapter 11 - Behind the Scenes: Databases and Information Systems Flashcards

1
Q 
In a database, the term \_\_\_\_\_\_\_\_ is synonymous with a category of information.
A) field
B) record
C) row
D) table
A

A) field

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q 
In a database, a group of related records is referred to as a(n) \_\_\_\_\_\_\_\_.
A) memo
B) field
C) object
D) table
A

D) table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q 
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
A

B) long text

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q 
Which of the following is a likely primary key?
A) Last name
B) Date of birth
C) Student ID number
D) First name
A

C) Student ID number

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q 
\_\_\_\_\_\_\_\_ is used to ensure that data is organized most efficiently.
A) Consistency checking
B) Validation
C) Normalization
D) Range checking
A

C) Normalization

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q 
\_\_\_\_\_\_\_\_ databases are the most commonly used electronic databases.
A) Relational
B) Flat-file
C) Multidimensional
D) Object-oriented
A

A) Relational

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q 
\_\_\_\_\_\_\_\_ 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
A

A) Referential integrity

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q 
Nontraditional data such as audio clips, video clips, pictures, and very large documents are called \_\_\_\_\_\_\_\_ data.
A) enterprise
B) structured
C) unstructured
D) multidimensional
A

C) unstructured

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q 
Data in a multidimensional database is organized in a \_\_\_\_\_\_\_\_ format.
A) linear
B) modular
C) cube
D) cellular
A

C) cube

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q 
A \_\_\_\_\_\_\_\_ check would be used to restrict the fines for speeding violations from $50 to $250.
A) completeness
B) range
C) consistency
D) numeric
A

B) range

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q 
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
A

C) consistency

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q 
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
A

B) filter

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q 
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
A

D) query

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q 
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
A

C) select query

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q 
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
A

B) relational algebra

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q 
\_\_\_\_\_\_\_\_ 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
A

A) Exporting

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q 
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
A

C) warehouse

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q 
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
A

B) mining the data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q 
Big data analytics is usually associated with \_\_\_\_\_\_\_\_ services.
A) office support 
B) data warehouse
C) management information 
D) decision support
A

B) data warehouse

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q 
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
A

C) real-time

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q 
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
A

C) exception

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

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)

A

A) natural language processing (NLP) system

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

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

A

centralization

24
Q

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

A

table

25
Q

Data that describe other data are called ________.

A

metadata

26
Q

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

A

file

27
Q

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

A

hyperlink

28
Q

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

A

primary

29
Q

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.

A

one-to-many

30
Q

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.

A

foreign key

31
Q

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

A

Object-oriented

32
Q

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

A

multidimensional

33
Q

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

A

database schema

34
Q

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.

A

form

35
Q

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

A

Validation

36
Q

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

A

constraint

37
Q

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

A

filter

38
Q

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

A

join

39
Q

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

A

time-variant

40
Q

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

A

clickstream

41
Q

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

A

data staging

42
Q

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

A

data mart

43
Q

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

A

batch

44
Q

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

A

summary

45
Q

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

A

expert system

46
Q

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

A

Data mining

47
Q

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

A

FALSE

48
Q

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

A

FALSE

49
Q

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

A

TRUE

50
Q

Most databases can import electronic data from other software applications.

A

TRUE

51
Q

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

A

TRUE

52
Q

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

A

FALSE

53
Q 
Match each of the following terms to its definition:
I.	field
II.	database
III.	record
IV.	table
V.	primary key

A. a group of related fields
B. a category of information in a database
C. a collection of related data that can be stored, sorted, organized, and queried
D. a field that has a value unique to each record
E. a group of related records

A

B, C, A, E, D

54
Q 
) Match each of the following terms to its definition:
I.	data mining
II.	expert system
III.	data mart
IV.	artificial intelligence
V.	data staging

A. small slices of the data warehouse
B. includes transforming data to fit into a data warehouse
C. process by which great amounts of data are analyzed and investigated
D. software that tries to replicate the decision making of human specialists
E. attempts to create computers that think like humans

A

C, D, A, E, B

55
Q

Match each of the following terms to its definition:
I. office support system (OSS)
II. natural language processing (NLP)
III. management information system (MIS)
IV. decision support system (DSS)
V. enterprise resource planning (ERP) system

A. provides managers with timely and accurate information
B. software system that integrates multiple system data sources and ties together the various processes of an organization
C. helps managers develop solutions for specific problems
D. assists employees in day-to-day tasks and communication
E. communicates with computer systems using a natural spoken or written language

A

D, E, A, C, B

56
Q 
Match each of the following terms to its definition:
I.	data warehouse
II.	batch processing
III.	relational database
IV.	real-time processing
V.	data dictionary

A. when a database is queried and updated as a transaction is taking place
B. organizes data into various tables based on logical groupings
C. defines the name, data type, and length of each field in a database
D. large-scale repository of data
E. transaction data that are processed all at once

A

D, E, B, A, C

57
Q 
Match the following data checks to their definition:
I.	alphabetic
II.	numeric
III.	completeness
IV.	consistency
V.	range

A. ensures data entered into the database fall within a certain set of values
B. ensures that all required fields have data entered into them
C. confirms that only numbers are entered into a field
D. confirms that only textual characters are entered into a field
E. compares values in two or more fields to see whether the values are reasonable

A

D, C, B, E, A

CP102 - Info Processing with Micros (15 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions