Question 1

Enterprise systems are integrated software packages designed to provide complete integration of:

Accepted Answer

A) an organization's accounting information system 
B) an organization's business data 
C) an organization's business information processing systems and all related data 
D) an organization's management 
A) an organization's accounting information system 
B) an organization's business data 
C) an organization's business information processing systems and all related data 
D) an organization's management C

Question 2

The relationship that relates to the specification of how many occurrences of an entity can participate in the given relationship with any one occurrence of the other entity in the relationship is referred to as ______________________________.

Accepted Answer

cardinality constraint

Question 3

Which of the following is the entity or agent?

Accepted Answer

A) client 
B) client number 
C) client name 
D) client street address 
A) client 
B) client number 
C) client name 
D) client street address A

Question 4

The first step in REA is evaluating the attributes.

Accepted Answer

A) True 
 B)False

Question 5

An entity in an accounting system can be classified as a resource, event or agent about which data are collected.

Accepted Answer

A) True 
 B)False

Question 6

The cardinality constraint:

Accepted Answer

A) specifies the degree of minimum participation of one entity in the relationship with the other entity. 
B) provides more information than the participation constraint. 
C) is the most common constraint specified in E-R diagrams. 
D) all of the above. 
A) specifies the degree of minimum participation of one entity in the relationship with the other entity. 
B) provides more information than the participation constraint. 
C) is the most common constraint specified in E-R diagrams. 
D) all of the above.

Question 7

In an REA diagram, the rectangle is used to represent the composite attribute.

Accepted Answer

A) True 
 B)False

Question 8

Relationships map and define the way in which data can be extracted from a database.

Accepted Answer

A) True 
 B)False

Question 9

The _________________________ is specified to uniquely identity each tuple in the relation.

Accepted Answer

The answer of The _________________________ is specified to uniquely identity...

Question 10

Legacy systems do not usually have which of the following characteristics?

Accepted Answer

A) developed on previous hardware (and/or software) platforms 
B) are easily adaptable to enterprise systems 
C) have been used by an organization for a long period of time 
D) all of the above are typical characteristics of legacy systems 
A) developed on previous hardware (and/or software) platforms 
B) are easily adaptable to enterprise systems 
C) have been used by an organization for a long period of time 
D) all of the above are typical characteristics of legacy systems

Question 11

Which of the following SQL statements would extract the employee number and date for every instance that an employee worked more than 8 hours any particular day?

Accepted Answer

A) SELECT Employee_No, Date FROM BILLING_HOURS
WHERE Hours>8 
B) QUERY Employee_No, Date FROM BILLING_HOURS
WHERE Hours>8 
C) SELECT Employee_No, Date WHERE Hours>8 
D) QUERY BILLING_HOURS SELECT Employee_No, Date
WHERE Hours>8 
A) SELECT Employee_No, Date FROM BILLING_HOURS
WHERE Hours>8 
B) QUERY Employee_No, Date FROM BILLING_HOURS
WHERE Hours>8 
C) SELECT Employee_No, Date WHERE Hours>8 
D) QUERY BILLING_HOURS SELECT Employee_No, Date
WHERE Hours>8

Question 12

A set of data that describes a single instance of the entity represented by a relation is known as a(n) ____________________.

Accepted Answer

The answer of A set of data that describes a...

Question 13

The ____________________ command is used to add new tuples to a relation.

Accepted Answer

The answer of The ____________________ command is used to add...

Question 14

Which of the following is not a relationship type?

Accepted Answer

A) one-to-many 
B) one-to-one 
C) one-to-few 
D) many-to-many 
A) one-to-many 
B) one-to-one 
C) one-to-few 
D) many-to-many

Question 15

A recursive relationship is created when there is an employee being supervised, and another employee is the supervisor.

Accepted Answer

A) True 
 B)False

Question 16

The notation 1,N is used to specify the relationship type of _________________________.

Accepted Answer

The answer of The notation 1,N is used to specify...

Question 17

Which of the following relational commands would a manager use to combine the data from two related relations into a third relation?

Accepted Answer

A) select 
B) project 
C) join 
D) display 
A) select 
B) project 
C) join 
D) display

Question 18

A(n) ____ of an entity is on specific thing of the type defined by the entity.

Accepted Answer

A) agent 
B) composite attribute 
C) attribute 
D) instance 
A) agent 
B) composite attribute 
C) attribute 
D) instance

Question 19

REA stands for resources, entities and agents

Accepted Answer

A) True 
 B)False

Question 20

Which is not an SQL command in which data can be changed in the database?

Accepted Answer

A) INSERT 
B) DELETE 
C) UPDATE 
D) CREATE 
A) INSERT 
B) DELETE 
C) UPDATE 
D) CREATE

Enterprise systems are integrated software packages designed to provide complete integration of:

The relationship that relates to the specification of how many occurrences of an entity can participate in the given relationship with any one occurrence of the other entity in the relationship is referred to as ______________________________.

Which of the following is the entity or agent?

The first step in REA is evaluating the attributes.

An entity in an accounting system can be classified as a resource, event or agent about which data are collected.

The cardinality constraint:

In an REA diagram, the rectangle is used to represent the composite attribute.

Relationships map and define the way in which data can be extracted from a database.

The _________________________ is specified to uniquely identity each tuple in the relation.

Legacy systems do not usually have which of the following characteristics?

Which of the following SQL statements would extract the employee number and date for every instance that an employee worked more than 8 hours any particular day?

A set of data that describes a single instance of the entity represented by a relation is known as a(n) ____________________.

The ____________________ command is used to add new tuples to a relation.

Which of the following is not a relationship type?

A recursive relationship is created when there is an employee being supervised, and another employee is the supervisor.

The notation 1,N is used to specify the relationship type of _________________________.

Which of the following relational commands would a manager use to combine the data from two related relations into a third relation?

A(n) ____ of an entity is on specific thing of the type defined by the entity.

REA stands for resources, entities and agents

Which is not an SQL command in which data can be changed in the database?

Introduction to Accounting Information Systems

Enterprise Systems

Electronic Business E-Business Systems

Documenting Information Systems

Database Management Systems

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 Receivable Cash Receipts Barcr Process

The Purchasing Process

Accounts Payablecash Disbursements Apcd Process

The Human Resources Process HR Management and Payroll Processes

Integrated Production Processes IPP

General Ledger and Business Reporting Glbr Process

Acquiring and Implementing Accounting Information Systems

Filters

Exam 6: Relational Databases and Sql

Enterprise systems are integrated software packages designed to provide complete integration of:

The relationship that relates to the specification of how many occurrences of an entity can participate in the given relationship with any one occurrence of the other entity in the relationship is referred to as ______________________________.

Which of the following is the entity or agent?

The first step in REA is evaluating the attributes.

An entity in an accounting system can be classified as a resource, event or agent about which data are collected.

The cardinality constraint:

In an REA diagram, the rectangle is used to represent the composite attribute.

Relationships map and define the way in which data can be extracted from a database.

The _________________________ is specified to uniquely identity each tuple in the relation.

Legacy systems do not usually have which of the following characteristics?

Which of the following SQL statements would extract the employee number and date for every instance that an employee worked more than 8 hours any particular day?

A set of data that describes a single instance of the entity represented by a relation is known as a(n) ____________________.

The ____________________ command is used to add new tuples to a relation.

Which of the following is not a relationship type?

A recursive relationship is created when there is an employee being supervised, and another employee is the supervisor.

The notation 1,N is used to specify the relationship type of _________________________.

Which of the following relational commands would a manager use to combine the data from two related relations into a third relation?

A(n) ____ of an entity is on specific thing of the type defined by the entity.

REA stands for resources, entities and agents

Which is not an SQL command in which data can be changed in the database?

Introduction to Accounting Information Systems

Enterprise Systems

Electronic Business E-Business Systems

Documenting Information Systems

Database Management Systems

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 Receivable Cash Receipts Barcr Process

The Purchasing Process

Accounts Payablecash Disbursements Apcd Process

The Human Resources Process HR Management and Payroll Processes

Integrated Production Processes IPP

General Ledger and Business Reporting Glbr Process

Acquiring and Implementing Accounting Information Systems

Filters