Question 1

Match between columns
                        Premises:  A large manufacturing company pays all employees once a week.
 The inventory system of a 24-hour grocery store automatically orders merchandise from vendors when the inventory level is low.
 A bank customer checking account file is online in an ATM network. The bank also uses the file each month to produce customer statements.
 An Internet retailer sells children's toys online.
 An airline reservation system answers customer inquiries about available flights and seats and makes customer reservations.
 Bookstore employees use an inventory file each week to prepare purchase orders for books.
 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.
 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.
 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.
 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 Sequential and Indexed-sequential and Direct access is...

Question 2

Match between columns
                        Premises:  Ring structure
 Alias
 ISAM
 Relational algebra
 Tuple
 Activity ratio
 Variable-length record
 Normalization
 Disk access time
 Randomizing transformation

Accepted Answer

The Answer of A row in a relational table and is...

Question 3

Sequential-access files are useful

Accepted Answer

A)  when only a small number of records need to be accessed in a file containing a large number of records. 
B)  in batch processing. 
C)  when files are unsorted. 
D)  when a large accounts receivable master file is in random account number order. 
A)  when only a small number of records need to be accessed in a file containing a large number of records. 
B)  in batch processing. 
C)  when files are unsorted. 
D)  when a large accounts receivable master file is in random account number order.

Question 4

The logical structure of a database is called a schema.

Accepted Answer

A) True 
 B)False

Question 5

Using the direct-access method,congestion results when two or more records yield the same address.

Accepted Answer

A) True 
 B)False

Question 6

Which of the following is an alias?

Accepted Answer

A)  A file whose records consist of data item descriptions 
B)  The use of more than one name for the same field 
C)  The user having the final responsibility for a data item 
D)  The physical form in which data are stored in a database 
A)  A file whose records consist of data item descriptions 
B)  The use of more than one name for the same field 
C)  The user having the final responsibility for a data item 
D)  The physical form in which data are stored in a database

Question 7

Discuss the relative benefits and drawbacks of the following file organization methods:
a.sequential
b.indexed-sequential
c.direct

Accepted Answer

a.Sequential: This method has the adva

Question 8

In data management terminology,a record occurrence is a

Accepted Answer

A)  secondary sort key. 
B)  trailer record containing additional data. 
C)  method of specifying variable-length records. 
D)  specific example of a record structure. 
A)  secondary sort key. 
B)  trailer record containing additional data. 
C)  method of specifying variable-length records. 
D)  specific example of a record structure.

Question 9

The database structure which allows a child segment to have more than one parent is the

Accepted Answer

A)  network. 
B)  sequential. 
C)  tree. 
D)  object. 
A)  network. 
B)  sequential. 
C)  tree. 
D)  object.

Question 10

Third party reporting solutions can provide end users the ability to easily extract reports and queries from the application database.Examples of these reporting solutions include

Accepted Answer

A)  Crystal Reports. 
B)  MicroStrategy. 
C)  OLAP. 
D)  Crystal Reports and MicroStrategy are both examples of 3rd party reporting solutions. 
A)  Crystal Reports. 
B)  MicroStrategy. 
C)  OLAP. 
D)  Crystal Reports and MicroStrategy are both examples of 3rd party reporting solutions.

Question 11

High level query languages include the below except

Accepted Answer

A)  QBE. 
B)  NLDQ. 
C)  OQL. 
D)  SQL. 
A)  QBE. 
B)  NLDQ. 
C)  OQL. 
D)  SQL.

Question 12

In an SQL query,________ is the comparison operator used to specify "greater than."

Accepted Answer

A)  >= 
B)  => 
C)  > 
D)  =>> 
A)  >= 
B)  => 
C)  > 
D)  =>>

Question 13

What data are stored in the index of an indexed file?

Accepted Answer

A)  The keys and the disk addresses of the individual records 
B)  The disk addresses of the individual records 
C)  All essential fields for the individual records 
D)  The keys for the individual records 
A)  The keys and the disk addresses of the individual records 
B)  The disk addresses of the individual records 
C)  All essential fields for the individual records 
D)  The keys for the individual records

Question 14

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.Logical data structure
________ 2.Key
________ 3.Node
________ 4.DQL
________ 5.Element
________ 6.Hypertext systems
________ 7.DML
________ 8.SELECT
________ 9.First normal form
________ 10.DDL
A.Defines the logical structure of the database (schema)
B.A synonym for field
C.A synonym for record key
D.Systems that allow users to browse through databases in random fashion by selecting key words or objects
E.The rational manner in which records and fields in the database are structured and organized
F.Almost all statements in SQL begin with this word
G.The commands for updating,editing,manipulating,and extracting data from a database
H.A user-friendly language or interface that allows the user to request information from the database
I.Relational tables that do not contain any repeating groups
J.A synonym for repeated group

Accepted Answer

1.E,2.C,3.

Question 15

An index file is fully inverted when indexes exist for all of its fields.

Accepted Answer

A) True 
 B)False

Question 16

In some respects,the word "file" loses its meaning in a database environment.

Accepted Answer

A) True 
 B)False

Question 17

An advantage of OLAP is its fast response time.

Accepted Answer

A) True 
 B)False

Question 18

A data dictionary can only be used with a DBMS.

Accepted Answer

A) True 
 B)False

Question 19

A file that allows an individual to almost instantaneously retrieve records without the use of an index is a(n)________-access file.

Accepted Answer

The answer of A file that allows an individual to...

Question 20

Database dictionaries are defined and controlled by

Accepted Answer

A)  a DBA. 
B)  a DBMS. 
C)  the SQL DML component. 
D)  the organization's steering committee. 
A)  a DBA. 
B)  a DBMS. 
C)  the SQL DML component. 
D)  the organization's steering committee.

Sequential-access files are useful

The logical structure of a database is called a schema.

Using the direct-access method,congestion results when two or more records yield the same address.

Which of the following is an alias?

Discuss the relative benefits and drawbacks of the following file organization methods: a.sequential b.indexed-sequential c.direct

In data management terminology,a record occurrence is a

The database structure which allows a child segment to have more than one parent is the

Third party reporting solutions can provide end users the ability to easily extract reports and queries from the application database.Examples of these reporting solutions include

High level query languages include the below except

In an SQL query,________ is the comparison operator used to specify "greater than."

What data are stored in the index of an indexed file?

An index file is fully inverted when indexes exist for all of its fields.

In some respects,the word "file" loses its meaning in a database environment.

An advantage of OLAP is its fast response time.

A data dictionary can only be used with a DBMS.

A file that allows an individual to almost instantaneously retrieve records without the use of an index is a(n)________-access file.

Database dictionaries are defined and controlled by

Accounting Information Systems: An Overview

Systems Techniques and Documentation

Ebusiness and Ecommerce

Transaction Processing and the Internal Control Process

Fraud Examination and Fraud Management

Information Systems Security

Electronic Data Processing Systems

Revenue Cycle Processes

Procurement and Human Resources Business Processes

The Production Business Process

Systems Planning, analysis, and Design

Systems Project Management, implementation, operation, control

Auditing Information Technology

Filters

Exam 13: Data Management Concepts

Sequential-access files are useful

The logical structure of a database is called a schema.

Using the direct-access method,congestion results when two or more records yield the same address.

Which of the following is an alias?

Discuss the relative benefits and drawbacks of the following file organization methods: a.sequential b.indexed-sequential c.direct

In data management terminology,a record occurrence is a

The database structure which allows a child segment to have more than one parent is the

Third party reporting solutions can provide end users the ability to easily extract reports and queries from the application database.Examples of these reporting solutions include

High level query languages include the below except

In an SQL query,________ is the comparison operator used to specify "greater than."

What data are stored in the index of an indexed file?

An index file is fully inverted when indexes exist for all of its fields.

In some respects,the word "file" loses its meaning in a database environment.

An advantage of OLAP is its fast response time.

A data dictionary can only be used with a DBMS.

A file that allows an individual to almost instantaneously retrieve records without the use of an index is a(n)________-access file.

Database dictionaries are defined and controlled by

Accounting Information Systems: An Overview

Systems Techniques and Documentation

Ebusiness and Ecommerce

Transaction Processing and the Internal Control Process

Fraud Examination and Fraud Management

Information Systems Security

Electronic Data Processing Systems

Revenue Cycle Processes

Procurement and Human Resources Business Processes

The Production Business Process

Systems Planning, analysis, and Design

Systems Project Management, implementation, operation, control

Auditing Information Technology

Filters