Exam 4: Relational Databases and Enterprise System

Explore all topics

Which of the following correctly describes the Referential Integrity Rule? 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

(Short Answer)

4.7/5

(34)

Question 41

Which of the following Microsoft Access objects is used to integrate data from one or more queries and/or tables in order to present information useful to decision makers? A. Tables B. Reports C. Forms D. Macros

(Short Answer)

4.8/5

(37)

Question 42

An enterprise resource planning system has which of the following advantages over multiple independent functional systems? 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.

(Short Answer)

5.0/5

(39)

Question 43

In Access, users can edit database information in reports.

(True/False)

4.9/5

(37)

Question 44

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

(True/False)

5.0/5

(34)

Question 45

Which of the following is not one of the objects used in Microsoft Access? A. Tables B. Sites C. Forms D. Macros

(Short Answer)

4.9/5

(37)

Question 46

Queries in Access are utilized by users to enter data into tables and view existing records.

(True/False)

4.7/5

(41)

Question 47

Which of the following is not a type of data model? A. Hierarchical data model B. Network data model C. Normalization data model D. Relational data model

(Short Answer)

4.9/5

(41)

Question 48

Which type of data models allows each record to have multiple parent and child records? A. The hierarchical mode B. The network model C. The relational model D. None of the above

(Short Answer)

4.8/5

(33)

Question 49

Classes in a relational database model for AISs are typically grouped into all of the following categories except: A. Events B. Agents C. Resources D. Activities

(Short Answer)

4.7/5

(39)

Question 50

Showing 41 - 50 of 50

Which of the following Microsoft Access objects is used to integrate data from one or more queries and/or tables in order to present information useful to decision makers? A. Tables B. Reports C. Forms D. Macros

In Access, users can edit database information in reports.

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

Which of the following is not one of the objects used in Microsoft Access? A. Tables B. Sites C. Forms D. Macros

Queries in Access are utilized by users to enter data into tables and view existing records.

Which of the following is not a type of data model? A. Hierarchical data model B. Network data model C. Normalization data model D. Relational data model

Which type of data models allows each record to have multiple parent and child records? A. The hierarchical mode B. The network model C. The relational model D. None of the above

Classes in a relational database model for AISs are typically grouped into all of the following categories except: A. Events B. Agents C. Resources D. Activities

Accountants As Business Analysts

Data Modeling

Sales and Collections Business Process

Purchases and Payments Business Process

Conversion Processes

Data Analytics in Accounting

Reporting Processes and Extensible Business Reporting Language XBRL

Ais 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