NEW
Font size
WorksheetsDatabase
Total questions: 15
Worksheet time: 8mins
"Each student has selected one of the college's T-shirt size. What if someone enters a nonexistent size? "
This situation is an example of _____________ in a database record.
data redundancy
data inconsistency
inappropriate data
incomplete data
"In a college database, each department that need the students' information accesses it from the same set of data."
This statement is referring to __________________ concept.
data integrity
data redundancy
normalization
data centralization
To prevent the entry of student ID 201910923 if there already existed a student with an ID of 201910923, a database practices _______________ concept.
data integrity
unstructured data
data centralization
Inappropriate data
Two students take the same course, but two different course names appear in a database that refers to the same course. This mistake is known as ______________.
data integrity
data redundancy
data inconsistency
data centralization
Which of the following is a likely primary key in a student information record?
Last name
Date of birth
Student ID number
First name
_______ is used to ensure that data is organized most efficiently in a database.
Consistency checking
Validation
Normalization
Range checking
A ________ relationship indicates that for each record in a table, there is only a single corresponding record in a related table.
many-to-one
one-to-one
many-to-many
one-to-many
A ________ check would be used in a field to restrict the fines for speeding violations so that they fall between $50 and $250.
completeness
range
consistency
numeric
A(n) ________ check determines whether a required field such as LastName was filled in.
completeness
range
consistency
alphabetic
A(n) ________ is a way of retrieving information from one or more tables that defines a particular subset of data.
validation rule
field constraint
enquiry
query
You would use a ________ in a database to temporarily display records of residents for the city of Boston.
sieve
filter
validation rule
field constraint
________ involves taking data from your database and putting it into an electronic file in a format that another external application or database can recognize.
Exporting
Importing
Enhancing
Extracting
A data ________ is a large-scale collection of data that contains and organizes all of an organization's data in one place.
mart
chain
warehouse
storehouse
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.
direct
batch
real-time
immediate
Which of the following data -mining techniques is used to determine which data goes well together?
classification
clustering
affinity grouping
visualization
