CIS 111 Chapter 11

CIS 111 Chapt Er 11 Te
 
Created Nov 16, 2010
by
cpousima33
Table View
Download
Print

Flashcard Set Preview

Side ASide B
OQL stands for_______
object query language
_____ databases are better at handling unstructured data such as audio clips, video clips,...
object-oriented
An expert system and a natrual language processing system are both:
knowledge-based systems
A video clip would be stored in a _____ field in a database.
object
Which of the following is NOT a database component?
list
In a_____ relationship, records in one table can be related to mulitple records in a second...
many-to-many
In a_____ relationship, a single record in one table has many corresponding records in another...
one-to-many
In a transaction processing system, if transaction data is accumulated until a certain point...
batch processing
For a simple task, there is no need for a database. A simple _____ is sufficient.
list
Because objects contain both data and _____ for processing or manipulating that data, object-oriented...
methods
A _____ is a collection of related data that can be stored, sorted, and queried.
database
Which of the following is NOT true about text fields?
They are used to hold long passages of text.
By maintaining information in only one place, _____ helps to ensure data integrity.
data centralization
The process of eliminating repetitive information within a database is called _____.
normalization
In a database, _____ fields are numeric fields that store the contents of a calculation.
computational and computed
When data mining, _____ is used to organize data into similar subgroups.
clustering
_____ is used to analyze large amounts of data and identify unseen patterns or trends.
data mining
In a transaction processing system (TPS), if the TPS database is queried and updated while...
real-time processing
A _____ database stores data in many dimensions, as opposed to relational databases, which...
multidimensional
Data _____ means that the data contained in a database is accurate and reliable.
integrity
When data mining, managers can use _____ to determine what data goes together.
affinity grouping and association rules
Businesses typically use _____ processing to update their records once the business day has...
batch
_____ means that for each value in the foreign key of one table, there is a corresponding value...
referential integrity
Databases help reduce duplicate data, which is also referred to as data _____.
redundancy
SQL uses _____ to extract records from a database by using English-like expressions that have...
relational algebra
If all students at a college were from New Jersey, the "State" field could be set to a:
default value
Which of the following is NOT a possible primary key?
street address
Oracle Database 11g is an example of which type of database?
multidimensional database
_____ is the process of ensuring that the data contained in a database is accurate and reliable.
validation
Video clips, pictures, and extremely large documents are in the _____ data type category.
BLOB and binary large object
In Access, the Simple Query Wizard uses _____ to create a query.
SQL
A _____ links two tables using a common field in both tables and extracts the relevant data...
join query
When creating a database with a DBMS, you must create a description of the data called the:
data dictionary
BLOB stands for _____.
binary large object
In a database, a group of related records is called a _____.
table and file
_____ databases can easily be customized to provide information to a variety of users (bases...
multidimensional
When you want to extract data from two or more tables, you use a _____ query.
join
A group of related fields is called a _____.
record
A text field capable of holding complete paragraphs is referred to as a _____ field.
memo
Data in multidimensional database is organized in a _____ format.
cube
A _____ check confirms that only numbers are entered in a field.
numeric
The field of computer science that tries to develop computers with the same reasoning ability...
artificial intelligence
Each record in a database should have one field that has a value unique to that record. This...
primary key and key field
The most commonly used type of database in the market today is the _____ database.
relational
The process of reducing data redundancy by recording data only once is called:
normalization
The field _____ defines the maximum number of characters or numbers that a particular field...
size
Iin a data warehouse, data gathered from sales, billing, and inventory departments are examples...
internal data
A _____ relationship indeicates that for a record in one table, there are many related records...
one-to-many
A category of information stored in a column of a database is called a:
field
A _____ relationship indicates that for each record in a table, there is only one corresponding...
one-to-one
Management information systems provide reports that show conditions that are unusual or need...
exception reports
An individual trained in the design and building of databases is called a database:
administrator
A data dictionary is also called a:
database schema
What does the acronym DBMS stand for?
data browsing and managament system
A _____ check confirms that only textual characters are entered in a field.
alphabetic
A person who designs and builds databases is referred to as a database _____.
administrator and designer
_____ data includes nontraditional data such as audio clips, video clips, and pictures.
unstructured
Which of the following is the largest measure of data storage?
exabyte
Microsoft Office's speech-recognition feature is an example of a:
natural language processing (NLP) system.
In a database table that stores name and address information, "State" would be an example of...
field name
Exception reports and summary reports are part of a:
management information system
Databases allow data to be maintained in only one place. This is referred to as _____.
data centralization
A spreadsheet you create in Microsoft Excel that contains the supplies needed to start the...
list
If a numeric field has a size of 7, which is the highest number it can hold?
9999999
AI stands for _______.
artificial intelligence
In a database, a field is a:
category of information
In a database, _____ fields store numbers used to perform calculations.
numeric
If a college's database maintains a student's major and GPA information in only one place,...
data centralization
_____ are a way of breaking down large data warehouse into smaller, more manageable pieces.
data marts
Which of the following is a reason for creating a list instead of creating a database?
to organize data for simple tasks
Which of the following statements about object-oriented databases is FALSE?
They store data in table format.
Microsoft _____ is a database management system.
Access
At a college, tuition payments would probably be tracked by a:
transaction processing system
Classification, clustering, and estimation are _____ methods used by managers to make their...
data mining
_____ defines the maximum number of characters or numbers that a particular field can hold.
Field size
In a relational database, a _____ relationship indicates that for each record in a table there...
one-to-one
Another name for the primary key is the key_____.
field
The type of information system that uses model management systems is a:
decision support system
Unstructured data such as video clips and pictures are known as _____ because of the way they...
binary large objects (BLOBs)
SQL stands for _____.
structured query language
Although relational databases have the largest share of the market today, the use of _____...
multidimensional
Nontraditional data such as audio clips, video clips, pictures, and very large documents are...
unstructured data
A _____ is the primary key of another table that is included for purposes of establishing relationships.
foreign key
When data is changed or modified, failure to update the data in all appropriate places reults...
data inconsistency
To access and manage data, many object-oriented databases use a _____, which is similar to...
OQL and object query language
_____ means that for each value in the foreign key of one table, there is a corresponding value...
referential integrity
A large-scale electronic repository of data that contains and organizes all an organization's...
warehouse
_____, not lists, are the best way to manage large amounts of information.
databases
Customer demographic data purchases from third parties or statistics compiled by the federal...
external data
One of the purposes of _____ is to describe data so that managers can visualize it.
data mining
Which type of database excels in the storage of structured (analytical) data?
relational
A database _____ instructs a database to search for particular pieces of data.
query
Computational fields are a type of database field used to store:
formulas
All modern database management systems contain a _____ language that the software uses to retrieve...
query
When creating a data warehouse, _____ is used; this extracts data from source databases, reformats...
data staging
In a database, a record is a:
group of related fields
If a college keeps two lists, one for registration and one for overdue library books, both...
redundancy
Data that describes other data is known as _____.
metadata
To store a Web address, use a _____ field in a database.
hyperlink
Reordering records in a database is called:
sorting


Upgrade and get a lot more done!
Upgrade    Cancel