Question 1

A ____ describes a portion of a DBMS' configuration of record types and data items and the relationships among them.

Accepted Answer

A)  query language 
B)  Subschema 
C)  Schema 
D)  DML 
A)  query language 
B)  Subschema 
C)  Schema 
D)  DML B

Question 2

The computer-based system of hardware and software that mimics the human brain's ability to recognize patterns or predict outcomes using less-than-complete information is referred to as:

Accepted Answer

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

Question 3

The applications approach to business event processing:

Accepted Answer

A)  concentrates on integrated applications 
B)  uses a central database 
C)  has data redundancy 
D)  none of the above 
A)  concentrates on integrated applications 
B)  uses a central database 
C)  has data redundancy 
D)  none of the above C

Question 4

______________________________ is the process of capturing, storing, retrieving, and distributing the knowledge of the individuals in an organization for use by others in the organization to improve the quantity and efficiency of decision making.

Accepted Answer

Knowledge

Question 5

Analyzing collected historical data with multidimensional analytic tools and exploratory techniques is called ______________________________.

Accepted Answer

The answer of Analyzing collected historical data with multidimensional analytic...

Question 6

Each relationship has a characteristic, called a cardinality that shows the degree to which each entity participates in the relationship.

Accepted Answer

A) True 
 B)False

Question 7

Which of the following statements related to events-driven systems is false?

Accepted Answer

A)  In events-driven systems data is aggregated and maintained in its original form. 
B)  With an events-driven system management views information systems processing as a decision-support activity. 
C)  Organizations adopting an events-driven system are focused on capturing data for the purpose of generating reports. 
D)  Users should be able to access and manipulate data using their own models and their own data aggregations. 
A)  In events-driven systems data is aggregated and maintained in its original form. 
B)  With an events-driven system management views information systems processing as a decision-support activity. 
C)  Organizations adopting an events-driven system are focused on capturing data for the purpose of generating reports. 
D)  Users should be able to access and manipulate data using their own models and their own data aggregations.

Question 8

______________________________ is a method for freely and creatively generating as many ideas as possible without undue regard for their practicality or realism.

Accepted Answer

The answer of ______________________________ is a method for freely and...

Question 9

A database management system (DBMS) is a set of standalone programs designed to complicate the tasks of creating, accessing, and managing data.

Accepted Answer

A) True 
 B)False

Question 10

The database management system, containing data related to all an organization's applications, supports normal data processing needs and enhances the organization's management activities by providing data useful to managers.

Accepted Answer

A) True 
 B)False

Question 11

A(n) ______________________________ database model allows both simple and complex objects, including video clips and pictures, to be stored.

Accepted Answer

The answer of A(n) ______________________________ database model allows both simple...

Question 12

The model that includes abstract types that allow users to define data to be stored in the database is the:

Accepted Answer

A)  hierarchical database model 
B)  network database model 
C)  relational database model 
D)  object-oriented database model 
A)  hierarchical database model 
B)  network database model 
C)  relational database model 
D)  object-oriented database model

Question 13

A spreadsheet is a typical component of a decision support system.

Accepted Answer

A) True 
 B)False

Question 14

Business processes, such as hiring employees, purchasing inventory, and collecting cash from customers, are called events.

Accepted Answer

A) True 
 B)False

Question 15

The applications approach to data management decouples the data from the applications or other users of the data.

Accepted Answer

A) True 
 B)False

Question 16

The normalization process involves the application of various rules (called normal forms) that yields relational tables that are free of anomalies.

Accepted Answer

A) True 
 B)False

Question 17

The approach to business event processing in which facts are stored in a relational database is:

Accepted Answer

A)  the centralized database approach 
B)  the applications approach 
C)  the logical approach 
D)  none of the above 
A)  the centralized database approach 
B)  the applications approach 
C)  the logical approach 
D)  none of the above

Question 18

A data model depicts user requirements for data stored in a database.

Accepted Answer

A) True 
 B)False

Question 19

In a(n) ____ database model, records are organized in a pyramid structure.

Accepted Answer

A)  hierarchical 
B)  relational 
C)  network 
D)  object-oriented 
A)  hierarchical 
B)  relational 
C)  network 
D)  object-oriented

Question 20

A(n) ____ depicts user requirements for data stored in a database.

Accepted Answer

A)  data model 
B)  entity-relationship model 
C)  E-R diagram 
D)  all of the above 
A)  data model 
B)  entity-relationship model 
C)  E-R diagram 
D)  all of the above

A ____ describes a portion of a DBMS' configuration of record types and data items and the relationships among them.

The computer-based system of hardware and software that mimics the human brain's ability to recognize patterns or predict outcomes using less-than-complete information is referred to as:

The applications approach to business event processing:

______________________________ is the process of capturing, storing, retrieving, and distributing the knowledge of the individuals in an organization for use by others in the organization to improve the quantity and efficiency of decision making.

Analyzing collected historical data with multidimensional analytic tools and exploratory techniques is called ______________________________.

Each relationship has a characteristic, called a cardinality that shows the degree to which each entity participates in the relationship.

Which of the following statements related to events-driven systems is false?

______________________________ is a method for freely and creatively generating as many ideas as possible without undue regard for their practicality or realism.

A database management system (DBMS) is a set of standalone programs designed to complicate the tasks of creating, accessing, and managing data.

The database management system, containing data related to all an organization's applications, supports normal data processing needs and enhances the organization's management activities by providing data useful to managers.

A(n) ______________________________ database model allows both simple and complex objects, including video clips and pictures, to be stored.

The model that includes abstract types that allow users to define data to be stored in the database is the:

A spreadsheet is a typical component of a decision support system.

Business processes, such as hiring employees, purchasing inventory, and collecting cash from customers, are called events.

The applications approach to data management decouples the data from the applications or other users of the data.

The normalization process involves the application of various rules (called normal forms) that yields relational tables that are free of anomalies.

The approach to business event processing in which facts are stored in a relational database is:

A data model depicts user requirements for data stored in a database.

In a(n) ____ database model, records are organized in a pyramid structure.

A(n) ____ depicts user requirements for data stored in a database.

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

A ____ describes a portion of a DBMS' configuration of record types and data items and the relationships among them.

The computer-based system of hardware and software that mimics the human brain's ability to recognize patterns or predict outcomes using less-than-complete information is referred to as:

The applications approach to business event processing:

______________________________ is the process of capturing, storing, retrieving, and distributing the knowledge of the individuals in an organization for use by others in the organization to improve the quantity and efficiency of decision making.

Analyzing collected historical data with multidimensional analytic tools and exploratory techniques is called ______________________________.

Each relationship has a characteristic, called a cardinality that shows the degree to which each entity participates in the relationship.

Which of the following statements related to events-driven systems is false?

______________________________ is a method for freely and creatively generating as many ideas as possible without undue regard for their practicality or realism.

A database management system (DBMS) is a set of standalone programs designed to complicate the tasks of creating, accessing, and managing data.

The database management system, containing data related to all an organization's applications, supports normal data processing needs and enhances the organization's management activities by providing data useful to managers.

A(n) ______________________________ database model allows both simple and complex objects, including video clips and pictures, to be stored.

The model that includes abstract types that allow users to define data to be stored in the database is the:

A spreadsheet is a typical component of a decision support system.

Business processes, such as hiring employees, purchasing inventory, and collecting cash from customers, are called events.

The applications approach to data management decouples the data from the applications or other users of the data.

The normalization process involves the application of various rules (called normal forms) that yields relational tables that are free of anomalies.

The approach to business event processing in which facts are stored in a relational database is:

A data model depicts user requirements for data stored in a database.

In a(n) ____ database model, records are organized in a pyramid structure.

A(n) ____ depicts user requirements for data stored in a database.

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