CIS 111 Chapter 11

Total Flash Cards » 100
Text Size » S M L     
 
1. 
OQL stands for_______
 
object query language
 
2. 
_____ databases are better at handling unstructured data such as audio clips, video clips, and pictures.
 
object-oriented
 
3. 
An expert system and a natrual language processing system are both:
 
knowledge-based systems
 
4. 
A video clip would be stored in a _____ field in a database.
 
object
 
5. 
Which of the following is NOT a database component?
 
list
 
6. 
In a_____ relationship, records in one table can be related to mulitple records in a second table.
 
many-to-many
 
7. 
In a_____ relationship, a single record in one table has many corresponding records in another related table.
 
one-to-many
 
8. 
In a transaction processing system, if transaction data is accumulated until a certain point and then many transactions are processed all at once, this is called:
 
batch processing
 
9. 
For a simple task, there is no need for a database. A simple _____ is sufficient.
 
list
 
10. 
Because objects contain both data and _____ for processing or manipulating that data, object-oriented database store more types of data than relational databases and access that data faster.
 
methods
 
11. 
A _____ is a collection of related data that can be stored, sorted, and queried.
 
database
 
12. 
Which of the following is NOT true about text fields?
 
They are used to hold long passages of text.
 
13. 
By maintaining information in only one place, _____ helps to ensure data integrity.
 
data centralization
 
14. 
The process of eliminating repetitive information within a database is called _____.
 
normalization
 
15. 
In a database, _____ fields are numeric fields that store the contents of a calculation.
 
computational and computed
 
16. 
When data mining, _____ is used to organize data into similar subgroups.
 
clustering
 
17. 
_____ is used to analyze large amounts of data and identify unseen patterns or trends.
 
data mining
 
18. 
In a transaction processing system (TPS), if the TPS database is queried and updated while the transaction is taking place, this is called:
 
real-time processing
 
19. 
A _____ database stores data in many dimensions, as opposed to relational databases, which store data in two-dimensional tables.
 
multidimensional
 
20. 
Data _____ means that the data contained in a database is accurate and reliable.
 
integrity
 
21. 
When data mining, managers can use _____ to determine what data goes together.
 
affinity grouping and association rules
 
22. 
Businesses typically use _____ processing to update their records once the business day has ended.
 
batch
 
23. 
_____ means that for each value in the foreign key of one table, there is a corresponding value in the primary key of another table.
 
referential integrity
 
24. 
Databases help reduce duplicate data, which is also referred to as data _____.
 
redundancy
 
25. 
SQL uses _____ to extract records from a database by using English-like expressions that have variables and operations.
 
relational algebra
 
26. 
If all students at a college were from New Jersey, the "State" field could be set to a:
 
default value
 
27. 
Which of the following is NOT a possible primary key?
 
street address
 
28. 
Oracle Database 11g is an example of which type of database?
 
multidimensional database
 
29. 
_____ is the process of ensuring that the data contained in a database is accurate and reliable.
 
validation
 
30. 
Video clips, pictures, and extremely large documents are in the _____ data type category.
 
BLOB and binary large object
 
31. 
In Access, the Simple Query Wizard uses _____ to create a query.
 
SQL
 
32. 
A _____ links two tables using a common field in both tables and extracts the relevant data from each.
 
join query
 
33. 
When creating a database with a DBMS, you must create a description of the data called the:
 
data dictionary
 
34. 
BLOB stands for _____.
 
binary large object
 
35. 
In a database, a group of related records is called a _____.
 
table and file
 
36. 
_____ databases can easily be customized to provide information to a variety of users (bases on their need) and can process data much faster than pure relational databases.
 
multidimensional
 
37. 
When you want to extract data from two or more tables, you use a _____ query.
 
join
 
38. 
A group of related fields is called a _____.
 
record
 
39. 
A text field capable of holding complete paragraphs is referred to as a _____ field.
 
memo
 
40. 
Data in multidimensional database is organized in a _____ format.
 
cube
 
41. 
A _____ check confirms that only numbers are entered in a field.
 
numeric
 
42. 
The field of computer science that tries to develop computers with the same reasoning ability and intelligence that humans have is called _____.
 
artificial intelligence
 
43. 
Each record in a database should have one field that has a value unique to that record. This is called the:
 
primary key and key field
 
44. 
The most commonly used type of database in the market today is the _____ database.
 
relational
 
45. 
The process of reducing data redundancy by recording data only once is called:
 
normalization
 
46. 
The field _____ defines the maximum number of characters or numbers that a particular field can hold.
 
size
 
47. 
Iin a data warehouse, data gathered from sales, billing, and inventory departments are examples of _____ sources.
 
internal data
 
48. 
A _____ relationship indeicates that for a record in one table, there are many related records in another table.
 
one-to-many
 
49. 
A category of information stored in a column of a database is called a:
 
field
 
50. 
A _____ relationship indicates that for each record in a table, there is only one corresponding record in a related table.
 
one-to-one
 
51. 
Management information systems provide reports that show conditions that are unusual or need attention by users or the system. These reports are called:
 
exception reports
 
52. 
An individual trained in the design and building of databases is called a database:
 
administrator
 
53. 
A data dictionary is also called a:
 
database schema
 
54. 
What does the acronym DBMS stand for?
 
data browsing and managament system
 
55. 
A _____ check confirms that only textual characters are entered in a field.
 
alphabetic
 
56. 
A person who designs and builds databases is referred to as a database _____.
 
administrator and designer
 
57. 
_____ data includes nontraditional data such as audio clips, video clips, and pictures.
 
unstructured
 
58. 
Which of the following is the largest measure of data storage?
 
exabyte
 
59. 
Microsoft Office's speech-recognition feature is an example of a:
 
natural language processing (NLP) system.
 
60. 
In a database table that stores name and address information, "State" would be an example of a:
 
field name
 
61. 
Exception reports and summary reports are part of a:
 
management information system
 
62. 
Databases allow data to be maintained in only one place. This is referred to as _____.
 
data centralization
 
63. 
A spreadsheet you create in Microsoft Excel that contains the supplies needed to start the semester is an example of a:
 
list
 
64. 
If a numeric field has a size of 7, which is the highest number it can hold?
 
9999999
 
65. 
AI stands for _______.
 
artificial intelligence
 
66. 
In a database, a field is a:
 
category of information
 
67. 
In a database, _____ fields store numbers used to perform calculations.
 
numeric
 
68. 
If a college's database maintains a student's major and GPA information in only one place, this is an example of:
 
data centralization
 
69. 
_____ are a way of breaking down large data warehouse into smaller, more manageable pieces.
 
data marts
 
70. 
Which of the following is a reason for creating a list instead of creating a database?
 
to organize data for simple tasks
 
71. 
Which of the following statements about object-oriented databases is FALSE?
 
They store data in table format.
 
72. 
Microsoft _____ is a database management system.
 
Access
 
73. 
At a college, tuition payments would probably be tracked by a:
 
transaction processing system
 
74. 
Classification, clustering, and estimation are _____ methods used by managers to make their data more meaningful.
 
data mining
 
75. 
_____ defines the maximum number of characters or numbers that a particular field can hold.
 
Field size
 
76. 
In a relational database, a _____ relationship indicates that for each record in a table there is a single corresponding record in a related table.
 
one-to-one
 
77. 
Another name for the primary key is the key_____.
 
field
 
78. 
The type of information system that uses model management systems is a:
 
decision support system
 
79. 
Unstructured data such as video clips and pictures are known as _____ because of the way they are encoded.
 
binary large objects (BLOBs)
 
80. 
SQL stands for _____.
 
structured query language
 
81. 
Although relational databases have the largest share of the market today, the use of _____ databases is growing.
 
multidimensional
 
82. 
Nontraditional data such as audio clips, video clips, pictures, and very large documents are called:
 
unstructured data
 
83. 
A _____ is the primary key of another table that is included for purposes of establishing relationships.
 
foreign key
 
84. 
When data is changed or modified, failure to update the data in all appropriate places reults in _____.
 
data inconsistency
 
85. 
To access and manage data, many object-oriented databases use a _____, which is similar to SQL.
 
OQL and object query language
 
86. 
_____ means that for each value in the foreign key of one table, there is a corresponding value in the primary key of the related table.
 
referential integrity
 
87. 
A large-scale electronic repository of data that contains and organizes all an organization's data in one place is called _____.
 
warehouse
 
88. 
_____, not lists, are the best way to manage large amounts of information.
 
databases
 
89. 
Customer demographic data purchases from third parties or statistics compiled by the federal goverment would be considered:
 
external data
 
90. 
One of the purposes of _____ is to describe data so that managers can visualize it.
 
data mining
 
91. 
Which type of database excels in the storage of structured (analytical) data?
 
relational
 
92. 
A database _____ instructs a database to search for particular pieces of data.
 
query
 
93. 
Computational fields are a type of database field used to store:
 
formulas
 
94. 
All modern database management systems contain a _____ language that the software uses to retrieve and display records.
 
query
 
95. 
When creating a data warehouse, _____ is used; this extracts data from source databases, reformats the data, and stores it in the warehouse.
 
data staging
 
96. 
In a database, a record is a:
 
group of related fields
 
97. 
If a college keeps two lists, one for registration and one for overdue library books, both containing name and address information, this is an example of data:
 
redundancy
 
98. 
Data that describes other data is known as _____.
 
metadata
 
99. 
To store a Web address, use a _____ field in a database.
 
hyperlink
 
100. 
Reordering records in a database is called:
 
sorting