Question 1

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 2

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 aboveE) A) and B)
F) B) and D)

Question 3

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 modelE) A) and B)
F) A) and C)

Question 4

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 correctE) A) and D)
F) A) and B)

Question 5

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.E) All of the above
F) C) and D)

Question 6

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 equipmentE) None of the above
F) C) and D)

Question 7

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 ExecutionE) A) and B)
F) B) and C)

Question 8

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.E) C) and D)
F) B) and C)

Question 9

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 tablesE) A) and B)
F) None of the above

Question 10

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

Accepted Answer

Tables are used to store data.

Queries...

Question 11

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 12

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) "E) A) and B)
F) A) and C)

Question 13

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) E) A) and B)
F) A) and C)

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

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.E) C) and D)
F) A) and B)

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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.E) C) and D)
F) None of the above B

Question 18

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 19

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 20

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

Accepted Answer

A) True 
 B)False

Exam 4: Relational Databases and Enterprise Systems

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

Which of the following about SQL is incorrect?

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified
Tables are used to store data. Queries...
View Answer

Discuss the challenges of enterprise system implementation?

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified
B

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

Correct Answer
verified
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.

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'

Correct Answer
verified

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

Correct Answer
verified

Exam 4: Relational Databases and Enterprise Systems

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Which of the following about SQL is incorrect?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct Answerverified Tables are used to store data. Queries...View AnswerShow Answer

Discuss the challenges of enterprise system implementation?

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedB

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

Correct AnswerverifiedManagers (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.

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'

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Tables are used to store data. Queries...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
B

Correct Answer
verified
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.

Correct Answer
verified

Correct Answer
verified