Exam 13: Data Management Concepts

The length of time the user must wait for the system to complete an operation is known as downtime.

An analyst has identified a certain database as "indexed-sequential." This is an example of defining database architecture at the

Many of the problems a database administrator faces within an organization are

In a relational database,tables that do not have any nonkey fields determining the values of other nonkey fields are said to be

In the object-oriented database modeling technique,an object class divided into subclasses represents an

Variable-length records are easier to manipulate than fixed-length records because the size of the variable-length record is generally smaller than the fixed-length record.

The basic DML statement used to modify the rows of tables in SQL is

Object-oriented modeling can be easily transformed into OO program code.

Presented below is a list of terms relating to accounting information systems,followed by definitions of those terms. Required: Match the letter next to each definition with the appropriate term.Each answer will be used only once. ________ 1.Ring structure ________ 2.Alias ________ 3.ISAM ________ 4.Relational algebra ________ 5.Tuple ________ 6.Activity ratio ________ 7.Variable-length record ________ 8.Normalization ________ 9.Disk access time ________ 10.Randomizing transformation A.A row in a relational table B.Both the number of fields and the length (character size)of each field are variable C.A list organization in which the last record in the ring points back to the first record D.Operations used to extract information from relational tables E.A widely used method of storing and locating records in a direct-access file F.The process of applying normal form rules in the relational database model G.A synonym for indexed-sequential file organization H.The length of time required for the CPU to retrieve a single block of data from the disk I.Different users call the same field different names J.The number of active records divided by the number of records in the file

OLAP uses complicated multidimensional "indexes" called

The "C" in ACID stands for

OLAP is a multidimensional generalization of the 2-dimensional ________ table.

Pointer fields are not used in

Below are three situations in which the Data Definition Language (DDL),the Data Manipulation Language (DML),or the Data Query Language (DQL)of a database management system will be used.Indicate on the line beside each situation which of the languages would likely be used. ________ A.A programmer uses COBOL to make revisions to the company's payroll application. ________ B.The zip code file in a customer master file is expanded to accommodate the nine digit "zip plus 4" zip codes. ________ C.The personnel director requests a special report regarding the number of employees in the company with a post-secondary education.

Network systems are pointer-based systems that allow users to browse through databases in random fashion by selecting keywords or objects.

Network,tree,and relational models are examples of database structure at which level?

It is useful to sort the records in a file so that they are either in ascending or descending order relative to the sort key.

Describe how list organization and multilist organization work in tree and network databases.Also,distinguish between a list structure and a ring structure in the implementation of tree and network structures.How does the list organization make database maintenance difficult? Under what circumstances is the list organization effective?

A database,together with database software,is

In the record format STORE (STORE_NO,CITY,VEND#1,VEND#2) Which field is the parent?