Sign in to save your progress, vote, and build your own decks.Sign in
MIS 2223 Chapter 11
44 cards·by amcloopy
Which of the following kinds of backup are used by organizations such as hospitals,
communications companies, and financial institutions?
continuous
Which of the following consists of rules and standards that define how a database organizes
data?
data model
Which recovery technique is more expensive, but provides recovery of damaged data in a matter
of seconds?
continuous backup
Data in a database is more vulnerable than data in file processing systems.
true
What is the process that large databases use to find patterns and relationships among data?
data mining
It often is easier and faster to develop programs that use the database approach.
true
If you are running a check that applies a formula to the primary key, what kind of check are you
running?
check digit
Which of the following statements best describes a form?
a window on the screen that provides areas for entering or modifying data in a database
which of the following is a combination of one or more related characters or bytes and is the
smallest unit of data a user accesses?
field
Which of the following is a number(s) or character(s) that is appended to or inserted into a
primary key field?
check digit
Which term does a user of a relational database use to refer to a record?
row
While working with a database, you encounter a wizard. What best describes the purpose of
awizard?
guides you through the steps of creating a database object
Verifiable information can be proven as correct or incorrect.
true
Which of the following is an advantage of a multidimensional database?
It can consolidate data much faster than a relational database.
A data model defines how users view the organization of data.
true
Which of the following is a process designed to ensure the data within the relations (tables)
contains the least amount of duplication?
normalization
Compared with relational databases, which of the following is NOT true of object-oriented
databases?
they store unstructured information less efficiently
With a distributed database, the data is accessible through a single server.
true
Query by example uses a graphical user interface that assists users with retrieving data.
true
To assist with sound decision making, the information must have value.
true
Object-oriented and object-relational databases often use a query language to manipulate
and retrieve data. What is the name of this query l
OQL
A user can override the default value.
true
Which of the following kinds of values is the one that a DBMS initially displays in a field?
default
To reduce data entry errors, well-designed forms should validate data as it is entered.
true
you instruct the DBMS to use the log to reenter any changes made to the database since the last
save or backup. What backup is this?
forward backup
If you are running a check to ensure that a required field contains data, or the correct minimum
number of characters, what kind of check?
completeness
What company did Larry Ellison help found?
Oracle
What does the S in SQL stand for?
structured
Your database was damaged due to hardware failure. What can you use to restore it?
a backup
For a computer to produce correct information, the data that is input into a database must have
integrity.
true
A smaller version of a data warehouse is the data mart.
true
Timely information has an age suited to its use.
true
The data in a database is independent of programs that access that data.
true
In a rollbackward, the DBMS uses the log to undo any changes made to the database during a
certain period.
true
Key fields link data together in a database.
true
Which of the following identifies the quality of data in a database?
data integrity
Which of the following contains a database that helps a group or department make decisions?
data mart
What is the term for the process of comparing data with a set of rules or values to find out if the
data is correct?
validation
Which of the following languages consists of simple, English-like statements that allow
users to specify the data to display, print, store?
query
Which of the following refers to the procedures that keep data current?
file maintenance
A DBMS uses which of the following to perform validation checks?
data dictionary
Query by example uses a graphical user interface that assists users with retrieving data.
true
CAE aids in the development and testing of product designs, and often includes CAD.
true
You store all of your photographs on a website that uses a database to store the photos users
post. What is this type of database called?
collaborative database