CGS-Ch 11

25 July 2022
4.7 (114 reviews)
41 test answers

Unlock all answers in this set

Unlock answers (37)
question
Which of the following is a program with which users interact that generally has a more user-friendly interface than a DBMS?
answer
front end
question
Which of the following is a collection of data organized in a manner that allows access, retrieval, and use of that data?
answer
database
question
Many database programs perform which of the following in order to analyze entered data to help ensure that it is correct?
answer
validity check
question
A user of a database such as that pictured in the accompanying figure refers to a file as what?
answer
table
question
Which of the following, with regard to the entire database, should be made on a regular basis?
answer
backup
question
In managing a company's database, which of the following roles requires a technical inside view of data?
answer
administrator
question
Which of the following consists of rules and standards that define how a database organizes data?
answer
data model
question
In a database such as that pictured in the accompanying figure, which of the following is a connection within the data?
answer
relationship
question
What is the process of comparing data with a set of rules or values to find out if the data is correct?
answer
validation
question
Which of the following is a request for specific data from a database?
answer
query
question
Which of the following languages consists of simple, English-like statements that allow users to specify the data to display, print, or store?
answer
query
question
Which of the following kinds of backup are used by organizations such as hospitals, communications companies, and financial institutions?
answer
continuous
question
Which of the following privileges for data involve establishing who can enter new data, change existing data, delete unwanted data, and view data?
answer
access
question
Which of the following kind of checks is a validity check performed on data, like that in the accompanying figure, which ensures users enter only alphabetic data into a field?
answer
alphabetic
question
Which of the following kinds of values is the one that a DBMS initially displays in a field?
answer
default
question
Which of the following is a huge database that stores and manages the data required to analyze historical and current transactions?
answer
data warehouse
question
In a database such as that pictured in the accompanying figure, users can set up a relationship between tables at any time, but the tables must have which of the following in common?
answer
a column
question
A user of a database such as that pictured in the accompanying figure refers to a field as what?
answer
column
question
Which of the following stores data in objects?
answer
OODB
question
Which of the following is a number(s) or character(s) that is appended to or inserted into a primary key field?
answer
check digit
question
Most of this kind of database products for servers and mainframes include SQL, an example of which is shown in the accompanying figure. What kind of database product is this?
answer
relational
question
Which of the following kind of checks is a validity check on data like that in the accompanying figure, which determines whether a number is within a specified group of numbers?
answer
range
question
Which of the following is a window on the screen that provides areas for entering or changing data in a database?
answer
form
question
Which of the following identifies the quality of data in a database?
answer
data integrity
question
In what kind of recovery does the DBMS use the log to undo any changes made to a database during a certain period?
answer
backward
question
Which of the following is a collection of related records, as shown in the accompanying figure, stored on storage media such as a hard drive or optical disc?
answer
file
question
Which of the following kind of checks is a validity check performed on data, like that in the accompanying figure, which ensures users enter only numeric data into a field?
answer
numeric
question
Which of the following kinds of programs interacts with a DBMS, which in turn interacts with the database?
answer
front end
question
A form that sends entered data across a network or the Internet is called which of the following terms?
answer
e-form
question
An application that supports a front-end program sometimes is called which of the following?
answer
back end
question
Most DBMSs include a feature, as shown in the middle image within the accompanying figure, which has a graphical user interface to assist users with retrieving data. What is this feature called?
answer
QBE
question
Which of the following refers to the procedures that keep data current?
answer
file maintenance
question
Which of the following is an item that contains data, as well as the actions that read or process the data?
answer
object
question
Which of the following is a database that stores data in tables that consist of rows and columns?
answer
relational
question
A checkout clerk with this level of privileges to the email addresses in a discount warehouse database could view the addresses but not change them. What is this level of privileges called?
answer
read-only
question
In the database pictured in the accompanying figure, 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?
answer
field
question
In a relational database, where does the only data redundancy exist?
answer
in the fields
question
A DBMS uses which of the following to perform validation checks?
answer
data dictionary
question
Which of the following is true in a relational database?
answer
Each row has a primary key and each column has a unique name.
question
The developer of a relational database refers to a record as which of the following?
answer
tuple
question
As shown in the accompanying figure, which of the following is a query language that allows users to manage, update, and retrieve data?
answer
SQL