Question 1

Match between columns
                        Premises:  DBA
 Inheritance
 Occurrence
 Branch
 Database model
 Record
 Fully inverted file
 Trailer record
 Record key
 Field

Accepted Answer

The Answer of The connection between children and parent(s) in is...

Question 2

Listed below are ten examples of file organization.
Required: From the following three choices,match the file organization technique with each of the ten examples listed.All techniques will be used more than once.
S = Sequential
IS = Indexed-sequential
D = Direct access
________ 1.A large manufacturing company pays all employees once a week.
________ 2.The inventory system of a 24-hour grocery store automatically orders merchandise from vendors when the inventory level is low.
________ 3.A bank customer checking account file is online in an ATM network.The bank also uses the file each month to produce customer statements.
________ 4.An Internet retailer sells children's toys online.
________ 5.An airline reservation system answers customer inquiries about available flights and seats and makes customer reservations.
________ 6.Bookstore employees use an inventory file each week to prepare purchase orders for books.
________ 7.A plant assets file for a small manufacturer is used to prepare quarterly depreciation reports.It is used once a year to prepare a report for insurance purposes.
________ 8.Employees use a vendor application at a trucking company daily to answer questions and accrue accounts payable.The company writes checks to vendors once a week.
________ 9.A file of payables due to actors and writers is processed monthly to prepare royalty checks; it is also used once a year to prepare tax reports.
________ 10.A metropolitan branch library scans books to check them out,answers patron inquiries about available books,and mails monthly statements to patrons having overdue books.

Accepted Answer

The answer of Listed below are ten examples of file...

Question 3

A database management system is independent of the application software therefore permitting upgrading or modifying the eBusiness application without changing data or database software.This is referred to as database agnosticity.

Accepted Answer

A) True 
 B)False

Question 4

OLAP is a multidimensional generalization of the 3-dimensional relational table.

Accepted Answer

A) True 
 B)False

Question 5

The basic economics of file processing are largely determined by the activity ratio,which is the

Accepted Answer

A)  number of times a master file is accessed during a period. 
B)  average number of transactions contained in a transaction file. 
C)  number of accessed records times the number of records in the file. 
D)  number of accessed records divided by the number of records in the file.

Question 6

A database is a structured collection of data stored in a computer system or network.

Accepted Answer

A) True 
 B)False

Question 7

The "A" in ACID stands for ________.

Accepted Answer

The answer of The "A" in ACID stands for ________....

Question 8

A high activity ratio

Accepted Answer

A)  is typical of batch processing, such as a payroll application. 
B)  is characteristic of all file processing activities in a large corporation. 
C)  spreads the fixed costs of sequential processing over fewer transactions. 
D)  makes ISAM processing more economical if the files are not processed in low activity situations.

Question 9

A row in a relational database table is called a(n)________.

Accepted Answer

The answer of A row in a relational database table...

Question 10

Related groups of fields that repeat themselves in variable-length records are called repeated groups.

Accepted Answer

A) True 
 B)False

Question 11

Records are contiguous when they are physically next to each other on a disk.

Accepted Answer

A) True 
 B)False

Question 12

Individual logical expressions may be combined in a FROM clause with the Boolean operator AND in SQL.

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A)  STORE 
B)  CITY 
C)  VEND 
D)  STORE_NO

Question 14

A database dictionary is defined and controlled by

Accepted Answer

A)  the controller. 
B)  the owner. 
C)  DMA. 
D)  DBA.

Question 15

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.DBA
________ 2.Inheritance
________ 3.Occurrence
________ 4.Branch
________ 5.Database model
________ 6.Record
________ 7.Fully inverted file
________ 8.Trailer record
________ 9.Record key
________ 10.Field
A.The connection between children and parent(s)in a tree structure
B.Individual who has overall responsibility for database administration
C.The smallest block of data that will be stored and retrieved in the information system
D.A synonym for schema
E.A relationship created when an object class is divided into subclasses
F.A file in which all fields are indexed
G.A specific set of data values for a record
H.A logical grouping of fields (data items)that concern a certain entity
I.A data item or combination of data items that uniquely identify a particular record in a file
J.A fixed-length extension of a master record

Accepted Answer

The answer of Presented below is a list of terms...

Question 16

Fields associated with other fields in a logical grouping are known as

Accepted Answer

A)  elements. 
B)  records. 
C)  data items. 
D)  attributes.

Question 17

Database ________ permits upgrading or modifying the eBusiness application without changing data or database software.

Accepted Answer

The answer of Database ________ permits upgrading or modifying the...

Question 18

In an entity-relationship data model,the concepts of part number,type,and cost are known as

Accepted Answer

A)  entities. 
B)  attributes. 
C)  relations. 
D)  objects.

Question 19

The processing time required to maintain a fully inverted file

Accepted Answer

A)  is fast since the entire index can be loaded into primary memory. 
B)  is almost instantaneous because long indexes can be factored into subindexes. 
C)  is fast when two processors are used simultaneously to process the data and index files at the same time. 
D)  can be high since the indexes require more disk storage and must be updated whenever records are added, deleted, or changed.

Question 20

The purpose of the index in an ISAM file is to

Accepted Answer

A)  increase the time needed to write records on the prime area. 
B)  bump records to the overflow area when no prime space is available. 
C)  link the record key to the address. 
D)  search tracks for the desired record.

Exam 13: Data Management Concepts

Presented below is a list of terms relating to accounting information systems, followed by definitions of those terms. Match the appropriate term with each definition. Each answer will be used only once.

A database management system is independent of the application software therefore permitting upgrading or modifying the eBusiness application without changing data or database software.This is referred to as database agnosticity.

OLAP is a multidimensional generalization of the 3-dimensional relational table.

The basic economics of file processing are largely determined by the activity ratio,which is the

A database is a structured collection of data stored in a computer system or network.

The "A" in ACID stands for ________.

A high activity ratio

A row in a relational database table is called a(n)________.

Related groups of fields that repeat themselves in variable-length records are called repeated groups.

Records are contiguous when they are physically next to each other on a disk.

Individual logical expressions may be combined in a FROM clause with the Boolean operator AND in SQL.

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

A database dictionary is defined and controlled by

Fields associated with other fields in a logical grouping are known as

Database ________ permits upgrading or modifying the eBusiness application without changing data or database software.

In an entity-relationship data model,the concepts of part number,type,and cost are known as

The processing time required to maintain a fully inverted file

The purpose of the index in an ISAM file is to