Question 1

In Microsoft Access,we use tables in a database for:

Accepted Answer

A)  Data entry 
B)  Data storage 
C)  Data retrieval 
D)  Two of the above are correct. 
A)  Data entry 
B)  Data storage 
C)  Data retrieval 
D)  Two of the above are correct. B

Question 2

Discuss the challenges of enterprise system implementation?

Accepted Answer

Integrating various modules within the enterprise system,   Integrating with external systems such as the information system of a supplier and/or customer,   Integrating with the firm's own existing legacy systems,   Converting data from existing legacy systems to the enterprise system,and   Getting any big project implemented at a firm.

Question 3

What are the benefits of implementing the enterprise systems in companies?

Accepted Answer

Managers (and auditors)can trace the creation of information throughout business processes,and also identify the participants in each process.Therefore,ES has a higher level of internal transparency compared to the typically isolated legacy systems.

Question 4

The asterisk (*)following the SELECT SQL statement is a wild card indicating all columns should be selected.

Accepted Answer

A) True 
 B)False

Question 5

Which SAP modules would a manufacturing company use to create a delivery order for a sales transaction?

Accepted Answer

A)  Materials Management 
B)  Sales and Distribution 
C)  Production Planning and Control 
D)  Logistics Execution 
A)  Materials Management 
B)  Sales and Distribution 
C)  Production Planning and Control 
D)  Logistics Execution

Question 6

An enterprise resource planning system has which of the following advantages over multiple independent functional systems?

Accepted Answer

A)  Modifications can be made to each module without affecting other modules. 
B)  Increased responsiveness and flexibility while aiding in the decision-making process. 
C)  Increased amount of data redundancy since more than one module contains the same information. 
D)  Reduction in costs for implementation and training. 
A)  Modifications can be made to each module without affecting other modules. 
B)  Increased responsiveness and flexibility while aiding in the decision-making process. 
C)  Increased amount of data redundancy since more than one module contains the same information. 
D)  Reduction in costs for implementation and training.

Question 7

Which of the following resources is usually not modeled as an entity (table)in an REA data model?

Accepted Answer

A)  Cash 
B)  Inventory 
C)  Accounts receivable 
D)  Property, plant and equipment 
A)  Cash 
B)  Inventory 
C)  Accounts receivable 
D)  Property, plant and equipment

Question 8

Which set of multiplicities correctly shows the relationship between the Cash Collection table and the Sales table in modeling cash sales?

Accepted Answer

A)  Cash Collection (1..1) - Sale (1..N) 
B)  Cash Collection (1..N) - Sale (1..1) 
C)  Cash Collection (1..N) - Sale (1..1). 
D)  Cash Collection (1..1) - Sale (1..1) 
A)  Cash Collection (1..1) - Sale (1..N) 
B)  Cash Collection (1..N) - Sale (1..1) 
C)  Cash Collection (1..N) - Sale (1..1). 
D)  Cash Collection (1..1) - Sale (1..1)

Question 9

Using the Cash Receipt Table below,show the output if the following SQL command is given:
Cash Receipt:
   SELECT SUM (Amount)
FROM [cash receipt]
Where [Customer Number] ='C-2'

Accepted Answer

The answer of Using the Cash Receipt Table below,show the...

Question 10

The "Where" SQL clause can be used to link two tables.

Accepted Answer

A) True 
 B)False

Question 11

Which of the following is not a type of data model?

Accepted Answer

A)  Hierarchical data model 
B)  Network data model 
C)  Normalization data model 
D)  Relational data model 
A)  Hierarchical data model 
B)  Network data model 
C)  Normalization data model 
D)  Relational data model

Question 12

Which type of data models allows each record to have multiple parent and child records?

Accepted Answer

A)  The hierarchical mode 
B)  The network model 
C)  The relational model 
D)  None of the above 
A)  The hierarchical mode 
B)  The network model 
C)  The relational model 
D)  None of the above

Question 13

What is the main purpose of using foreign keys in a relational database design?

Accepted Answer

A)  It provides useful financial data value in the table. 
B)  It is required in all tables. 
C)  It is used to link tables. 
D)  None of the above is correct. 
A)  It provides useful financial data value in the table. 
B)  It is required in all tables. 
C)  It is used to link tables. 
D)  None of the above is correct.

Question 14

Classes could be grouped into Resources (R),Entity (E),and Assets (A)in data modeling.

Accepted Answer

A) True 
 B)False

Question 15

List the seven objects and their functions that are used to implement relational databases using Microsoft Access.

Accepted Answer

@#IMG-DLM& Tables are used to store data. @#IMG-DLM& Queries

Question 16

Which of the following about SQL is incorrect?

Accepted Answer

A)  SQL is a language designed to query data in a relational database. 
B)  SQL is based on relational algebra and allows a user to query and update the database. 
C)  SQL is very user-friendly. 
D)  SQL uses SELECT statement to tell the query which columns (or attributes) of a table should be included in the query. 
A)  SQL is a language designed to query data in a relational database. 
B)  SQL is based on relational algebra and allows a user to query and update the database. 
C)  SQL is very user-friendly. 
D)  SQL uses SELECT statement to tell the query which columns (or attributes) of a table should be included in the query.

Question 17

Three types of data models used today are: the hierarchical model,the network model and the relational model.

Accepted Answer

A) True 
 B)False

Question 18

Which of the following tasks cannot be performed through queries in access?

Accepted Answer

A)  Retrieve and display data 
B)  Calculations of data 
C)  Data sorting 
D)  Enter data into tables 
A)  Retrieve and display data 
B)  Calculations of data 
C)  Data sorting 
D)  Enter data into tables

Question 19

Which of the following is considered as class in the relational database model?

Accepted Answer

A)  Customer 
B)  Sale 
C)  Cash 
D)  All of the above are correct 
A)  Customer 
B)  Sale 
C)  Cash 
D)  All of the above are correct

Question 20

The property of the primary key in a table in Microsoft Access should be set to:

Accepted Answer

A)  The required field = "Yes", the Indexed field = "Yes (No Duplicates)" 
B)  The Required field = "NO" and the Indexed field = "Yes (No Duplicates)" 
C)  The Required field = "Yes" and the Indexed field = "Yes (Duplicated)" 
D)  The Required field = "NO" and the Indexed field = "No (Duplicates)" 
A)  The required field = "Yes", the Indexed field = "Yes (No Duplicates)" 
B)  The Required field = "NO" and the Indexed field = "Yes (No Duplicates)" 
C)  The Required field = "Yes" and the Indexed field = "Yes (Duplicated)" 
D)  The Required field = "NO" and the Indexed field = "No (Duplicates)"

In Microsoft Access,we use tables in a database for:

Discuss the challenges of enterprise system implementation?

What are the benefits of implementing the enterprise systems in companies?

The asterisk (*)following the SELECT SQL statement is a wild card indicating all columns should be selected.

Which SAP modules would a manufacturing company use to create a delivery order for a sales transaction?

An enterprise resource planning system has which of the following advantages over multiple independent functional systems?

Which of the following resources is usually not modeled as an entity (table)in an REA data model?

Which set of multiplicities correctly shows the relationship between the Cash Collection table and the Sales table in modeling cash sales?

Using the Cash Receipt Table below,show the output if the following SQL command is given: Cash Receipt: SELECT SUM (Amount) FROM [cash receipt] Where [Customer Number] ='C-2'

The "Where" SQL clause can be used to link two tables.

Which of the following is not a type of data model?

Which type of data models allows each record to have multiple parent and child records?

What is the main purpose of using foreign keys in a relational database design?

Classes could be grouped into Resources (R),Entity (E),and Assets (A)in data modeling.

List the seven objects and their functions that are used to implement relational databases using Microsoft Access.

Which of the following about SQL is incorrect?

Three types of data models used today are: the hierarchical model,the network model and the relational model.

Which of the following tasks cannot be performed through queries in access?

Which of the following is considered as class in the relational database model?

The property of the primary key in a table in Microsoft Access should be set to:

Accounting Information Systems and Firm Value

Accountants As Business Analysts

Data Modeling

Sales and Collections Business Process

Purchases and Payments Business Process

Conversion Business Process

Reporting Processes and Extensible Business Reporting Language XBRL

Accounting Information Systems and Internal Controls

Information Security and Computer Fraud

Monitoring and Auditing AIS

The Balanced Scorecard and Business Value of Information Technology

Evaluating AIS Investments

The Systems Development Life Cycle and Project Management: Addressing the Challenges of Building Ais Systems

Filters

Exam 4: Relational Databases and Enterprise Systems

In Microsoft Access,we use tables in a database for:

Discuss the challenges of enterprise system implementation?

What are the benefits of implementing the enterprise systems in companies?

The asterisk (*)following the SELECT SQL statement is a wild card indicating all columns should be selected.

Which SAP modules would a manufacturing company use to create a delivery order for a sales transaction?

An enterprise resource planning system has which of the following advantages over multiple independent functional systems?

Which of the following resources is usually not modeled as an entity (table)in an REA data model?

Which set of multiplicities correctly shows the relationship between the Cash Collection table and the Sales table in modeling cash sales?

Using the Cash Receipt Table below,show the output if the following SQL command is given: Cash Receipt: SELECT SUM (Amount) FROM [cash receipt] Where [Customer Number] ='C-2'

The "Where" SQL clause can be used to link two tables.

Which of the following is not a type of data model?

Which type of data models allows each record to have multiple parent and child records?

What is the main purpose of using foreign keys in a relational database design?

Classes could be grouped into Resources (R),Entity (E),and Assets (A)in data modeling.

List the seven objects and their functions that are used to implement relational databases using Microsoft Access.

Which of the following about SQL is incorrect?

Three types of data models used today are: the hierarchical model,the network model and the relational model.

Which of the following tasks cannot be performed through queries in access?

Which of the following is considered as class in the relational database model?

The property of the primary key in a table in Microsoft Access should be set to:

Accounting Information Systems and Firm Value

Accountants As Business Analysts

Data Modeling

Sales and Collections Business Process

Purchases and Payments Business Process

Conversion Business Process

Reporting Processes and Extensible Business Reporting Language XBRL

Accounting Information Systems and Internal Controls

Information Security and Computer Fraud

Monitoring and Auditing AIS

The Balanced Scorecard and Business Value of Information Technology

Evaluating AIS Investments

The Systems Development Life Cycle and Project Management: Addressing the Challenges of Building Ais Systems

Filters