Question 1

Data dictionary can be used as part of the audit trail.

Accepted Answer

A) True 
 B)False

Question 2

Which of the following would not be true about the well-structured tables in a well-designed relational database used to generate this sales invoice?

Accepted Answer

A) Quantity would be generated from the Sales table. 
B) 34567 would be a primary key in the Sales table. 
C) Unit Price would be generated from the Inventory table. 
D) Hardware City is an example of a non-key data value in the Customer table.

Question 3

Identify one potential drawback in the design and implementation of database systems for accounting.

Accepted Answer

A) Double-entry accounting relies on redundancy as part of the accounting process, but well-designed database systems reduce and attempt to eliminate redundancy. 
B) Relational DBMS query languages will allow financial reports to be prepared to cover whatever time periods managers want to examine. 
C) Relational DBMS provide the capability of integrating financial and operational data. 
D) Relational DBMS can accommodate multiple views of the same underlying data; therefore, tables storing information about assets can include data about both historical and replacement costs.

Question 4

Which one of the following results corresponds to the query below?

Accepted Answer

A) 
 
B) 
 
C) 
 
D)

Question 5

Which statement is true regarding file systems?

Accepted Answer

A) Transaction files are similar to ledgers in a manual AIS. 
B) Multiple master files create problems with data consistency. 
C) Transaction files are permanent. 
D) Individual records are never deleted in a master file.

Question 6

Discuss redundancy as it applies to database design.

Accepted Answer

The answer of Discuss redundancy as it applies to database...

Question 7

The data dictionary usually is maintained

Accepted Answer

A) automatically by the DBMS. 
B) by the database administrator. 
C) by the database programmers. 
D) by top management.

Question 8

A low-level view of the database that describes how the data are actually stored and accessed is the

Accepted Answer

A) conceptual-level schema. 
B) subschema. 
C) internal-level schema. 
D) external-level schema.

Question 9

Using the database depicted above,"Unit Price" is best described as

Accepted Answer

A) an attribute. 
B) a primary key. 
C) a foreign key. 
D) A, B, and C

Question 10

Which statement below concerning the database management system (DBMS)is false?

Accepted Answer

A) The DBMS automatically creates application software for users, based on data dictionary parameters. 
B) The DBMS automatically maintains the data dictionary. 
C) Users' requests for information are transmitted to the DBMS through application software. 
D) The DBMS uses special languages to perform specific functions.

Question 11

Mara Kay is a system analyst for a national department store.She was tasked to identify previously unknown relationships in the company's sales data that can be used in future promotions.What technique would Mara most likely use?

Accepted Answer

A) Customer auditing 
B) Customer resource management 
C) Data exploring 
D) Data mining

Question 12

Which is probably the most immediate and significant effect of database technology on accounting?

Accepted Answer

A) Replacement of the double entry-system. 
B) Change in the nature of financial reporting. 
C) Elimination of traditional records such as journals and ledgers. 
D) Quicker access to and greater use of accounting information in decision-making.

Question 13

When the human resources manager wants to gather data about salary and start date by employees and by departments,the manager would use which language?

Accepted Answer

A) Data Manipulation Language 
B) Data Query Language 
C) Data Report Language 
D) Data Definition Language

Question 14

The ________ contains information about the structure of the database.

Accepted Answer

A) data definition language 
B) data dictionary 
C) data warehouse 
D) database management system

Question 15

Kitchen World is changing its inventory system from a file-oriented system to a relational database system.Identify and design at least three tables that would be needed to capture data for Kitchen World's inventory.Each table should include a primary key,three non-key attributes,and foreign keys as necessary.Make up data values for two records within each table.

Accepted Answer

The answer of Kitchen World is changing its inventory system...

Question 16

Using the database depicted above,how many foreign keys are in the database?

Accepted Answer

A) 0 
B) 3 
C) 4 
D) 5

Question 17

Identify the aspect of a well-structured database that is incorrect.

Accepted Answer

A) Data is consistent. 
B) Redundancy is minimized and controlled. 
C) All data is stored in one table or relation. 
D) The primary key of any row in a relation cannot be null.

Question 18

When the human resources manager wants to add a new employee to the sales department,the manager would use which language?

Accepted Answer