stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
Chapter 11: Databases and Information Systems Flashcards | StudBud
Explore
/
Chapter 11: Databases and Information Systems
Chapter 11: Databases and Information Systems
21 terms
·
StudBud Administration
·
128 plays
A Quiz for CIT at Fresno City College
Flashcards
21 cards
F
Practice quiz
P
Host live
L
Questions
21
Answers
1
Which of the following is a likely primary key in a student data record?
Student ID number
First name
Last name
Date of birth
2
MIS provide ________ reports, which show unusual conditions.
exception
summary
detail
expert
3
A ________ is a collection of related data that can be stored, sorted, organized, and queried.
database
memo
spreadsheet
macro
4
Employees' last names would usually make an appropriate primary-key field.
true
false
5
________ databases are the most commonly used electronic databases.
Flat-file
Relational
Object-oriented
Multidimensional
6
A group of related records is called a table.
true
false
7
In a database, a group of related records is referred to as a(n) ________.
field
object
memo
table
8
A summary report is a list of the transactions that occurred during a specific time period.
false
true
9
Data ________ helps to ensure data integrity by maintaining information in only one place.
flexibility
redundancy
centralization
mapping
10
Real-time processing means that transactions are updated when they occur.
false
true
11
A ________ is a way of retrieving information from tables that defines a subset of data.
enquiry
query
validation rule
field constraint
12
A(n) ________ check determines whether a required field such as LastName was filled in.
completeness
alphabetic
consistency
range
13
In a database, the term ________ is synonymous with a category of information.
field
row
record
table
14
A last name field is an example of a field that should have a default value.
false
true
15
If a school keeps two lists, both with name and address, this is an example of data ________.
normalization
redundancy
completeness
integrity
16
An employee's ID number, name, job position, address, city, state, and Zip make up a record.
true
false
17
_____ means that foreign and primary keys have corresponding values.
Record Integrity
Database Consistency
Normalization
Referential Integrity
18
You would use a ________ to temporarily display records of residents of the city of Boston.
validation rule
field constraint
sieve
filter
19
________ is the branch of computer science trying to create computers that think like humans.
Enterprise resource planning
Natural language processing
Artificial intelligence
Expert systems
20
Data ________ ensures that the data contained in a database is accurate and reliable.
consistency
redundancy
integrity
efficiency
21
Big data analytics is usually associated with ________ services.
decision support
office support
data warehouse
management information