Filters
Question type
Study Flashcards

The use of a data warehouse in strategic decision making is often referred to as


A) business intelligence.
B) managerial accounting.
C) data analysis.
D) analytical modeling.

E) A) and C)
F) A) and B)

Correct Answer

verifed

verified

Explain the difference between file-oriented transaction processing systems and relational database systems.Discuss the advantages and disadvantages of each system.

Correct Answer

verifed

verified

In file-oriented approaches,different us...

View Answer

Seacrest Bedding is changing 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 a sales transaction.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.

Correct Answer

verifed

verified

Customer table; ID (primary key),name,st...

View Answer

The database design method in which a designer uses knowledge about business processes to create a diagram of the elements to be included in the database is called


A) normalization.
B) decentralization.
C) geometric data modeling.
D) semantic data modeling.

E) All of the above
F) A) and C)

Correct Answer

verifed

verified

The document that shows the items stored in a file,including the order and length of the data fields and the type of data stored is called


A) a data layout.
B) a logical layout.
C) a physical layout.
D) a record layout.

E) A) and B)
F) None of the above

Correct Answer

verifed

verified

Merlin Frodo has been doing custom piercings and tattoos for over thirty years.His home and place of business is a garage in the harbor district of Seattle,Washington.He keeps meticulous records of every job he has ever completed.These have been entered into a computerized accounting information system that his accountant refers to as a "data warehouse." Merlin is considering adding scarification to his service offerings and has asked his accountant to identify past customers who might be likely candidates for this service.Merlin wants his accountant to engage in


A) customer auditing.
B) customer resource management.
C) data mining.
D) enterprise resource planning.

E) A) and B)
F) All of the above

Correct Answer

verifed

verified

What are the two ways to query a database using Microsoft Access?

Correct Answer

verifed

verified

The two ways to query a databa...

View Answer

An attribute in a table that serves as a unique identifier in another table and is used to link the two tables is a


A) foreign key.
B) primary key.
C) relational key.
D) linkage key.

E) A) and C)
F) B) and C)

Correct Answer

verifed

verified

List the four DBMS "languages" and describe who uses each and for what purpose.

Correct Answer

verifed

verified

DDL is the data definition language used...

View Answer

The logical structure of a database is described by the


A) data dictionary.
B) schema.
C) database management system.
D) context diagram.

E) A) and D)
F) C) and D)

Correct Answer

verifed

verified

Describe a major advantage of database systems over file-oriented transaction processing systems.

Correct Answer

verifed

verified

Database systems separate logical and ph...

View Answer

Describe the differences between the data definition language (DDL),data manipulation language (DML),and the data query language (DQL).

Correct Answer

verifed

verified

The data definition language (DDL)builds...

View Answer

A data warehouse


A) is primarily used for analysis rather than transaction processing.
B) stores transaction processing records in hard copy.
C) replaces traditional transaction processing databases.
D) increases the speed of transaction processing.

E) A) and C)
F) None of the above

Correct Answer

verifed

verified

Using the database depicted above,"Item #" is best described as


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

E) A) and B)
F) A) and C)

Correct Answer

verifed

verified

Which of the statements below is incorrect?


A) Semantic data modeling facilitates the efficient design of databases.
B) Semantic data modeling facilitates communicating with the intended users of the system.
C) Semantic data modeling allows a database designer to use knowledge about business processes to design the database.
D) Semantic data modeling follows the rules of normalization in the design of a database.

E) B) and C)
F) A) and C)

Correct Answer

verifed

verified

The ________ is responsible for the database.


A) database master
B) database manager
C) database administrator
D) data coordinator

E) A) and C)
F) B) and C)

Correct Answer

verifed

verified

In a well-structured relational database,


A) foreign keys cannot be null.
B) there must be at least two foreign keys.
C) every column in a row must be single valued.
D) one table must be related to all other tables.

E) B) and C)
F) A) and D)

Correct Answer

verifed

verified

Describe the different schemas involved in a database structure.What is the role of accountants in development of schemas?

Correct Answer

verifed

verified

A schema describes the logical structure...

View Answer

Identify one potential outcome of the delete anomaly.


A) inconsistent data
B) inability to add new data
C) unintentional loss of data
D) none of the above

E) B) and D)
F) B) and C)

Correct Answer

verifed

verified

Which of the following is false regarding a well-structured relational database?


A) A foreign key cannot be null.
B) A primary key cannot be null.
C) Every column in a row must be single valued.
D) All nonkey attributes in a table must describe a characteristic of the object identified by the primary key.

E) A) and D)
F) None of the above

Correct Answer

verifed

verified

Showing 61 - 80 of 113

Related Exams

Exam 1

Conceptual Foundations of Accounting Information Systems

115 Questions

Exam 2

Overview of Transaction Processing and Enterprise Resource Planning Systems

107 Questions

Exam 3

Systems Documentation Techniques

108 Questions

Exam 5

Computer Fraud

83 Questions

Exam 6

Computer Fraud and Abuse Techniques

96 Questions

Exam 7

Control and Accounting Information Systems

132 Questions

Exam 8

Controls for Information Security

100 Questions

Exam 9

Confidentiality and Privacy Controls

61 Questions

Exam 10

Processing Integrity and Availability Controls

95 Questions

Exam 11

Auditing Computer-Based Information Systems

116 Questions

Exam 12

The Revenue Cycle: Sales to Cash Collections

108 Questions

Exam 13

The Expenditure Cycle: Purchasing to Cash Disbursements

108 Questions

Exam 14

The Production Cycle

95 Questions

Exam 15

The Human Resources Management and Payroll Cycle

86 Questions

Exam 16

General Ledger and Reporting System

83 Questions

Exam 17

Database Design Using the Rea Data Model

90 Questions

Exam 18

Implementing an Rea Model in a Relational Database

98 Questions

Exam 19

Special Topics in Rea Modeling

98 Questions

Exam 20

Introduction to Systems Development and Systems Analysis

124 Questions

Exam 21

Ais Development Strategies

117 Questions

Exam 22

Systems Design, implementation, and Operation

105 Questions

Show Answer