Question 1

Access offers modules,which are defined by users to automate processes like opening a specific form.

Accepted Answer

A) True 
 B)False

Question 2

In a hierarchical data model,data elements are related in many-to-many relationships.

Accepted Answer

A) True 
 B)False

Question 3

In Microsoft Access,we use "Tables" for:

Accepted Answer

A)  Data entry 
B)  Data storage 
C)  Date retrieve 
D)  Two of the above 
A)  Data entry 
B)  Data storage 
C)  Date retrieve 
D)  Two of the above

Question 4

The SQL command "Group by" can be used to order an amount in a descending order.

Accepted Answer

A) True 
 B)False

Question 5

A company would like to implement a management information system that integrates all functional areas within an organization to allow information exchange and collaboration among all parties involved in business operations.Which of the following systems is most effective for this application?

Accepted Answer

A)  A decision support system. 
B)  An executive support system. 
C)  An office automation system. 
D)  An enterprise resource planning system. 
A)  A decision support system. 
B)  An executive support system. 
C)  An office automation system. 
D)  An enterprise resource planning system.

Question 6

Which of the following correctly describes the Referential Integrity Rule?

Accepted Answer

A)  The primary key of a table must have data values (cannot be null) 
B)  Each attribute in a table must have a unique name 
C)  The data value for a foreign key could be null 
D)  Values of a specific attribute must be of the same type 
A)  The primary key of a table must have data values (cannot be null) 
B)  Each attribute in a table must have a unique name 
C)  The data value for a foreign key could be null 
D)  Values of a specific attribute must be of the same type

Question 7

SQL is based on relational algebra and allows a user to query and update the database.

Accepted Answer

A) True 
 B)False

Question 8

What kind data model is most commonly used as a basis for today's enterprise systems?

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

Access offers modules,which are defined by users to automate processes like opening a specific form.

In a hierarchical data model,data elements are related in many-to-many relationships.

In Microsoft Access,we use "Tables" for:

The SQL command "Group by" can be used to order an amount in a descending order.

A company would like to implement a management information system that integrates all functional areas within an organization to allow information exchange and collaboration among all parties involved in business operations.Which of the following systems is most effective for this application?

Which of the following correctly describes the Referential Integrity Rule?

SQL is based on relational algebra and allows a user to query and update the database.

What kind data model is most commonly used as a basis for today's enterprise systems?

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

Access offers modules,which are defined by users to automate processes like opening a specific form.

In a hierarchical data model,data elements are related in many-to-many relationships.

In Microsoft Access,we use "Tables" for:

The SQL command "Group by" can be used to order an amount in a descending order.

A company would like to implement a management information system that integrates all functional areas within an organization to allow information exchange and collaboration among all parties involved in business operations.Which of the following systems is most effective for this application?

Which of the following correctly describes the Referential Integrity Rule?

SQL is based on relational algebra and allows a user to query and update the database.

What kind data model is most commonly used as a basis for today's enterprise systems?

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