CGS2060 Chapter 11 – Flashcards

Which of the following kinds of backup are used by organizations such as hospitals, communications companies, and financial institutions?

Which of the following privileges for data involve establishing who can enter new data, change existing data, delete unwanted data, and view data?

In what kind of recovery does the DBMS use the log to reenter changes made to a database since the last save or backup?

Which of the following languages consists of simple, English-like statements that allow users to specify the data to display, print, or store?

Which of the following is a collection of data organized in a manner that allows access, retrieval, and use of that data?

Which of the following, with regard to the entire database, should be made on a regular basis?

A DBMS uses which of the following to perform validation checks?

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?

The developer of a relational database refers to a field as which of the following?

What is the process of comparing data with a set of rules or values to find out if the data is correct?

Compared with relational databases, which of the following is NOT true of object-oriented databases?

The developer of a relational database refers to a file as which of the following?

The developer of a relational database refers to a record as which of the following?

Which of the following is a database that stores data in tables that consist of rows and columns?

n what kind of recovery does the DBMS use the log to undo any changes made to a database during a certain period?

Which of the following is an item that contains data, as well as the actions that read or process the data?

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?

Which of the following is a program with which users interact that generally has a more user-friendly interface than a DBMS?

Which of the following identifies the quality of data in a database?

An application that supports a front-end program sometimes is called which of the following?

Which of the following kinds of values is the one that a DBMS initially displays in a field?

Which of the following is a huge database that stores and manages the data required to analyze historical and current transactions?

In managing a company's database, which of the following roles requires a technical inside view of data?

Object-oriented and object-relational databases often use a query language to manipulate and retrieve data. What is the name of this query language?

Which of the following refers to the procedures that keep data current