Question 1

Object-oriented databases:

Accepted Answer

A)  include abstract data types 
B)  organize data in two-dimensional tables 
C)  are inferior to relational databases 
D)  are used by most organizations 
A)  include abstract data types 
B)  organize data in two-dimensional tables 
C)  are inferior to relational databases 
D)  are used by most organizations

Question 2

A secondary key uniquely identifies any row within a relational table.

Accepted Answer

A) True 
 B)False

Question 3

Which of the following is not a function that a database management system performs?

Accepted Answer

A)  Defining the data. 
B)  Defining the relations among data. 
C)  Interfacing with the operating system for storage of the data on the physical media. 
D)  Coordinating access to data stored in the applications programs. 
A)  Defining the data. 
B)  Defining the relations among data. 
C)  Interfacing with the operating system for storage of the data on the physical media. 
D)  Coordinating access to data stored in the applications programs.

Question 4

A scanner is used to access a database and to produce inquiry reports.

Accepted Answer

A) True 
 B)False

Question 5

A relation that is in ____ form contains repeating attributes within each row or record.

Accepted Answer

A)  unnormalized 
B)  first normal (1NF) 
C)  second normal (2NF) 
D)  third normal (3NF) 
A)  unnormalized 
B)  first normal (1NF) 
C)  second normal (2NF) 
D)  third normal (3NF)

Question 6

Decoupling the data from the system applications is a major difference between the centralized database approach and the applications approach and is known as:

Accepted Answer

A)  data independence 
B)  data manipulation 
C)  data redundancy 
D)  query language 
A)  data independence 
B)  data manipulation 
C)  data redundancy 
D)  query language

Question 7

A relation is in third normal form (3NF) if it is in first normal form and no nonkey attribute is dependent on only a portion of the primary key.

Accepted Answer

A) True 
 B)False

Question 8

A postal ZIP code is an example of which of the following coding schemes?

Accepted Answer

A)  block code 
B)  serial code 
C)  hierarchical code 
D)  significant digit code 
A)  block code 
B)  serial code 
C)  hierarchical code 
D)  significant digit code

Question 9

The principal difference between an executive information system (EIS) and a decision support system (DSS) is that an EIS:

Accepted Answer

A)  suggests to the user the best choice from among alternative courses of action whereas the DSS merely provides information that could assist in making the decision 
B)  is primarily about collecting and presenting information without doing additional processing or calculations 
C)  uses both external and internal data whereas a DSS does not 
D)  employs decision models whereas a DSS does not 
A)  suggests to the user the best choice from among alternative courses of action whereas the DSS merely provides information that could assist in making the decision 
B)  is primarily about collecting and presenting information without doing additional processing or calculations 
C)  uses both external and internal data whereas a DSS does not 
D)  employs decision models whereas a DSS does not

Question 10

Which of the following statements about expert systems (ES) is false:

Accepted Answer

A)  They can help provide a competitive advantage. 
B)  They are sometimes used as part of a down-sizing strategy. 
C)  They only work well for simple decisions. 
D)  They can be used to train new employees. 
A)  They can help provide a competitive advantage. 
B)  They are sometimes used as part of a down-sizing strategy. 
C)  They only work well for simple decisions. 
D)  They can be used to train new employees.

Question 11

A description of a portion of a schema is referred to as a subschema.

Accepted Answer

A) True 
 B)False

Question 12

In an entity-relationship diagram, ____ are used to show the characteristics of relationships.

Accepted Answer

A)  squares 
B)  circles 
C)  diamonds 
D)  parallelograms 
A)  squares 
B)  circles 
C)  diamonds 
D)  parallelograms

Question 13

Primary key ______________________________ in a relational table must be a unique identifier for a row.

Accepted Answer

The answer of Primary key ______________________________ in a relational table...

Question 14

In a hierarchical database model, a child record may only have one parent.

Accepted Answer

A) True 
 B)False

Question 15

List 1 shows the coding schemes discussed and illustrated in Chapter 5, while List 2 contains eight coding examples.
 $\begin{array}{c}
\begin{array}{lll}
\text{List 1 - Coding Schemes}\
\hline
A. \quad \text{Sequential (serial)}\
B.  \quad \text{Block}\
C.  \quad \text{Significant digit}\
\end{array}
\begin{array}{lll}
&&&
\end{array}
\begin{array}{lll}
\
D. \quad Hierarchica\
E. \quad Mnemonic\
F. \quad Check digit\
\end{array}
\end{array}$   Required:
On your solution sheet, list the numbers 1 through 8 from List 2. Next to each number, show the capital letter from List 1 that best describes the coding type represented by each example. HINT: Some letters from List 1 may be used for more than one coding example, while some letters may not be used at all.

Accepted Answer

None

Question 16

A neural network is a software program that may be integrated into DSS or other software tools.

Accepted Answer

A) True 
 B)False

Question 17

When different information about the same fact is stored in different files the integrity of the data is violated.

Accepted Answer

A) True 
 B)False

Question 18

A software program that may be integrated into DSS or other software tools is a(n):

Accepted Answer

A)  group support systems 
B)  executive information system 
C)  intelligent agent 
D)  neural networks 
A)  group support systems 
B)  executive information system 
C)  intelligent agent 
D)  neural networks

Question 19

Of the following options, a database that is in ____ form has the best design.

Accepted Answer

A)  unnormalized 
B)  first normal (1NF) 
C)  second normal (2NF) 
D)  third normal (3NF) 
A)  unnormalized 
B)  first normal (1NF) 
C)  second normal (2NF) 
D)  third normal (3NF)

Question 20

The traditional applications approach to business event processing concentrates on the process being performed.

Accepted Answer

A) True 
 B)False

Object-oriented databases:

A secondary key uniquely identifies any row within a relational table.

Which of the following is not a function that a database management system performs?

A scanner is used to access a database and to produce inquiry reports.

A relation that is in ____ form contains repeating attributes within each row or record.

Decoupling the data from the system applications is a major difference between the centralized database approach and the applications approach and is known as:

A relation is in third normal form (3NF) if it is in first normal form and no nonkey attribute is dependent on only a portion of the primary key.

A postal ZIP code is an example of which of the following coding schemes?

The principal difference between an executive information system (EIS) and a decision support system (DSS) is that an EIS:

Which of the following statements about expert systems (ES) is false:

A description of a portion of a schema is referred to as a subschema.

In an entity-relationship diagram, ____ are used to show the characteristics of relationships.

Primary key ______________________________ in a relational table must be a unique identifier for a row.

In a hierarchical database model, a child record may only have one parent.

A neural network is a software program that may be integrated into DSS or other software tools.

When different information about the same fact is stored in different files the integrity of the data is violated.

A software program that may be integrated into DSS or other software tools is a(n):

Of the following options, a database that is in ____ form has the best design.

The traditional applications approach to business event processing concentrates on the process being performed.

Introduction to Accounting Information Systems

Enterprise Systems

Electronic Business E-Business Systems

Documenting Information Systems

Relational Databases and SQL

Controlling Information Systems: Introduction to Enterprise Risk Management and Internal Control

Controlling Information Systems: Introduction to Pervasive Controls

Controlling Information Systems: Business Process and Application Controls

The Order Entrysales Oes Process

The Billingaccounts Receivablecash Receipts Barcr Process

The Purchasing Process

The Accounts Payablecash Disbursements Apcd Process

The Human Resources Process HR Management and Payroll Processes

Integrated Production Processes IPP

The General Ledger and Business Reporting GLBR Process

Acquiring and Implementing Accounting Information Systems

Filters

Exam 5: Database Management Systems

Object-oriented databases:

A secondary key uniquely identifies any row within a relational table.

Which of the following is not a function that a database management system performs?

A scanner is used to access a database and to produce inquiry reports.

A relation that is in ____ form contains repeating attributes within each row or record.

Decoupling the data from the system applications is a major difference between the centralized database approach and the applications approach and is known as:

A relation is in third normal form (3NF) if it is in first normal form and no nonkey attribute is dependent on only a portion of the primary key.

A postal ZIP code is an example of which of the following coding schemes?

The principal difference between an executive information system (EIS) and a decision support system (DSS) is that an EIS:

Which of the following statements about expert systems (ES) is false:

A description of a portion of a schema is referred to as a subschema.

In an entity-relationship diagram, ____ are used to show the characteristics of relationships.

Primary key ______________________________ in a relational table must be a unique identifier for a row.

In a hierarchical database model, a child record may only have one parent.

A neural network is a software program that may be integrated into DSS or other software tools.

When different information about the same fact is stored in different files the integrity of the data is violated.

A software program that may be integrated into DSS or other software tools is a(n):

Of the following options, a database that is in ____ form has the best design.

The traditional applications approach to business event processing concentrates on the process being performed.

Introduction to Accounting Information Systems

Enterprise Systems

Electronic Business E-Business Systems

Documenting Information Systems

Relational Databases and SQL

Controlling Information Systems: Introduction to Enterprise Risk Management and Internal Control

Controlling Information Systems: Introduction to Pervasive Controls

Controlling Information Systems: Business Process and Application Controls

The Order Entrysales Oes Process

The Billingaccounts Receivablecash Receipts Barcr Process

The Purchasing Process

The Accounts Payablecash Disbursements Apcd Process

The Human Resources Process HR Management and Payroll Processes

Integrated Production Processes IPP

The General Ledger and Business Reporting GLBR Process

Acquiring and Implementing Accounting Information Systems

Filters