Free Printable COMPAI Midterm Exam

1.

Input controls ensure that only valid data is entered into a system.

a)

TRUE

b)

FALSE

2.

Processing controls determine how data is transformed and manipulated within a system.

a)

TRUE

b)

FALSE

3.

Output controls are used to ensure that data is displayed or produced in the correct format.

a)

TRUE

b)

FALSE

4.

Input controls can prevent errors and improve data quality by enforcing data validation rules.

a)

TRUE

b)

FALSE

5.

Processing controls can help detect and prevent unauthorized access to sensitive data.

a)

TRUE

b)

FALSE

6.

Output controls are not important because users can always reformat or adjust the output as needed.

a)

TRUE

b)

FALSE

7.

Input controls are used to verify that the data entered into a system is complete and accurate.

a)

TRUE

b)

FALSE

8.

Processing controls can include checks for duplicates, inconsistencies, and errors in data.

a)

TRUE

b)

FALSE

9.

Output controls are not necessary when data is only being used internally within a system.

a)

TRUE

b)

FALSE

10.

Input, processing, and output controls are all essential for maintaining the integrity and security of data within a system.

a)

TRUE

b)

FALSE

11.

Which of the following is a key feature of a Data Flow Diagram (DFD)?

a)

It displays the flow of data through a system

b)

It shows the physical layout of a system

c)

It describes the detailed logic of a system

d)

It displays the flow of control through a system

12.

Which of the following is NOT a standard symbol used in a DFD?

a)

Process

b)

Flow

c)

Entity

d)

Decision

13.

In a DFD, what does a rectangle represent?

a)

An entity or external agent that produces or consumes data

b)

A data store where data is temporarily held

c)

A process that transforms data

d)

A flow that moves data from one component to another

14.

What is the purpose of creating a context-level DFD?

a)

To show the overall scope and boundaries of the system

b)

To show the detailed logic of the system

c)

To show the interactions between different entities and processes

d)

To show the flow of data within the system

15.

Which of the following is true about a DFD?

a)

It shows only the physical components of a system

b)

It shows only the logical components of a system

c)

It shows both the physical and logical components of a system

d)

It shows neither the physical nor logical components of a system

16.

Which of the following is true about a Level-0 DFD?

a)

It shows the overall system in more detail than the context-level DFD

b)

It shows the overall system at a higher level of abstraction than the context-level DFD

c)

It is the same as the context-level DFD

d)

It is not commonly used in DFD modeling

17.

What does a double-headed arrow in a DFD represent?

a)

Data flow

b)

Process

c)

Data store

d)

Entity

18.

Which of the following is true about a Level-1 DFD?

a)

It shows the overall system in less detail than the context-level DFD

b)

It shows a more detailed view of a specific process or subsystem

c)

It is the same as the context-level DFD

d)

It is not commonly used in DFD modeling

19.

What does a circle in a DFD represent?

a)

An entity or external agent that produces or consumes data

b)

A data store where data is temporarily held

c)

A process that transforms data

d)

A flow that moves data from one component to another

20.

What is the purpose of balancing a DFD?

a)

To ensure that the data flows into and out of each process are consistent

b)

To ensure that the diagram is aesthetically pleasing

c)

To ensure that the system is secure

d)

To ensure that the data store is functioning properly

21.

Normalization is the process of organizing data into tables to reduce data redundancy and dependency.

a)

TRUE

b)

FALSE

22.

Normalization always results in a higher level of data redundancy.

a)

TRUE

b)

FALSE

23.

Normalization is a one-time process and does not need to be revisited.

a)

TRUE

b)

FALSE

24.

Denormalization is the process of breaking tables down into smaller pieces.

a)

TRUE

b)

FALSE

25.

A database can be over-normalized, resulting in poor performance.

a)

TRUE

b)

FALSE

26.

A well-designed database should have no redundant data.

a)

TRUE

b)

FALSE

27.

Third normal form (3NF) is always better than second normal form (2NF).

a)

TRUE

b)

FALSE

28.

Normalization always improves data integrity.

a)

TRUE

b)

FALSE

29.

The process of normalization is purely technical and does not require any understanding of the business requirements.

a)

TRUE

b)

FALSE

30.

Data modeling is the process of creating a physical representation of a database.

a)

TRUE

b)

FALSE

31.

Which of the following is a primary function of a database management system (DBMS) in accounting information systems?

a)

Generating financial reports

b)

Conducting financial analysis

c)

Ensuring data security and privacy

d)

Managing financial transactions

32.

Which of the following is a technique used to improve query performance in a database management system for accounting information systems?

a)

Normalization

b)

Referential integrity

c)

Indexing

d)

Sharding

33.

Which of the following is a type of database structure commonly used in accounting information systems?

a)

Object-oriented database

b)

Relational database

c)

Hierarchical database

d)

Network database

34.

Which of the following is a technique used to prevent the insertion of invalid data into a database?

a)

Referential integrity

b)

Normalization

c)

Data validation

d)

Indexing

35.

Which of the following is a benefit of using a cloud-based database management system for accounting information systems?

a)

Reduced risk of hardware failure

b)

Enhanced query performance

c)

Improved scalability and flexibility

d)

Increased data security and privacy

36.

Which of the following is a technique used to ensure data consistency by organizing data into tables that are free from data redundancy and dependency?

a)

Normalization

b)

Referential integrity

c)

Indexing

d)

Data validation

37.

What is the primary advantage of using a DBMS in an accounting information system?

a)

Improved data security and privacy

b)

Simplified financial transactions

c)

Reduced need for financial analysis

d)

Increased efficiency of financial reporting

38.

Which of the following is NOT a common DBMS in an accounting information system?

a)

Oracle Database

b)

Microsoft SQL Server

c)

Microsoft Excel

d)

MySQL

39.

What is the purpose of data normalization in a DBMS for an accounting information system?

a)

To reduce data redundancy and improve data integrity

b)

To increase the size of the database

c)

To improve data privacy and security

d)

To reduce the number of tables in the database

40.

Which of the following is NOT a benefit of using a DBMS for an accounting information system?

a)

Improved data accuracy

b)

Enhanced data privacy

c)

Reduced hardware costs

d)

Increased data availability

41.

Scenario: The online store sells various products such as electronics, clothing, and accessories. The store has customers who can create accounts, add items to their shopping carts, and place orders. The database will have tables for customers, products, orders, and order items.

Question: There will be an entity for Customers in the ERD.

a)

TRUE

b)

FALSE

42.

Scenario: The online store sells various products such as electronics, clothing, and accessories. The store has customers who can create accounts, add items to their shopping carts, and place orders. The database will have tables for customers, products, orders, and order items.

Question: There will be an entity for Products in the ERD.

a)

TRUE

b)

FALSE

43.

Scenario: The online store sells various products such as electronics, clothing, and accessories. The store has customers who can create accounts, add items to their shopping carts, and place orders. The database will have tables for customers, products, orders, and order items.

Question: There will be an entity for Orders in the ERD.

a)

TRUE

b)

FALSE

44.

Scenario: The online store sells various products such as electronics, clothing, and accessories. The store has customers who can create accounts, add items to their shopping carts, and place orders. The database will have tables for customers, products, orders, and order items.

Question: There will be an entity for Shopping Carts in the ERD.

a)

TRUE

b)

FALSE

45.

Scenario: The online store sells various products such as electronics, clothing, and accessories. The store has customers who can create accounts, add items to their shopping carts, and place orders. The database will have tables for customers, products, orders, and order items.

Question: There will be a one-to-many relationship between Customers and Orders.

a)

TRUE

b)

FALSE

46.

Scenario: The online store sells various products such as electronics, clothing, and accessories. The store has customers who can create accounts, add items to their shopping carts, and place orders. The database will have tables for customers, products, orders, and order items.

Question: There will be a many-to-many relationship between Products and Orders.

a)

TRUE

b)

FALSE

47.

Scenario: The online store sells various products such as electronics, clothing, and accessories. The store has customers who can create accounts, add items to their shopping carts, and place orders. The database will have tables for customers, products, orders, and order items.

Question: There will be an attribute in the Orders entity to represent the order date.

a)

TRUE

b)

FALSE

48.

Scenario: The online store sells various products such as electronics, clothing, and accessories. The store has customers who can create accounts, add items to their shopping carts, and place orders. The database will have tables for customers, products, orders, and order items.

Question: There will be a many-to-many relationship between Customers and Products to represent products in their shopping cart.

a)

TRUE

b)

FALSE

49.

Scenario: The online store sells various products such as electronics, clothing, and accessories. The store has customers who can create accounts, add items to their shopping carts, and place orders. The database will have tables for customers, products, orders, and order items.

Question: There will be an attribute in the Products entity to represent the product price.

a)

TRUE

b)

FALSE

50.

Scenario: The online store sells various products such as electronics, clothing, and accessories. The store has customers who can create accounts, add items to their shopping carts, and place orders. The database will have tables for customers, products, orders, and order items.

Question: There will be an entity for Order Items in the ERD to represent the products in each order.

a)

TRUE

b)

FALSE

51.

What is the main purpose of the online store's database?

a)

To manage employee accounts

b)

To store customer information and order data

c)

To track inventory levels

d)

To create marketing campaigns

52.

Scenario: The online store sells various products such as electronics, clothing, and accessories. The store has customers who can create accounts, add items to their shopping carts, and place orders. The database will have tables for customers, products, orders, and order items. Which of the following entities will not be included in the ERD for the online store's database?

a)

Customers

b)

Products

c)

Orders

d)

Shopping Carts

53.

Scenario: The online store sells various products such as electronics, clothing, and accessories. The store has customers who can create accounts, add items to their shopping carts, and place orders. The database will have tables for customers, products, orders, and order items. What kind of relationship exists between the Customers and Orders entities?

a)

One-to-one

b)

One-to-many

c)

Many-to-one

d)

Many-to-many

54.

Scenario: The online store sells various products such as electronics, clothing, and accessories. The store has customers who can create accounts, add items to their shopping carts, and place orders. The database will have tables for customers, products, orders, and order items. What kind of relationship exists between the Products and Orders entities?

a)

One-to-one

b)

One-to-many

c)

Many-to-one

d)

Many-to-many

55.

Scenario: The online store sells various products such as electronics, clothing, and accessories. The store has customers who can create accounts, add items to their shopping carts, and place orders. The database will have tables for customers, products, orders, and order items. Which of the following is an example of an attribute that would be included in the Orders entity?

a)

Product ID

b)

Customer Name

c)

Order Date

d)

Order Total

56.

Scenario: The online store sells various products such as electronics, clothing, and accessories. The store has customers who can create accounts, add items to their shopping carts, and place orders. The database will have tables for customers, products, orders, and order items. Which of the following is an example of an attribute that would be included in the Products entity?

a)

Order ID

b)

Product Price

c)

Customer ID

d)

Order Quantity

57.

Scenario: The online store sells various products such as electronics, clothing, and accessories. The store has customers who can create accounts, add items to their shopping carts, and place orders. The database will have tables for customers, products, orders, and order items. Which of the following is an example of an attribute that would be included in the Customers entity?

a)

Product Name

b)

Customer Address

c)

Order Quantity

d)

Order Total

58.

Scenario: The online store sells various products such as electronics, clothing, and accessories. The store has customers who can create accounts, add items to their shopping carts, and place orders. The database will have tables for customers, products, orders, and order items. Which of the following represents the correct cardinality for the relationship between Customers and Orders?

a)

One-to-one

b)

One-to-many

c)

Many-to-one

d)

Many-to-many

59.

Scenario: The online store sells various products such as electronics, clothing, and accessories. The store has customers who can create accounts, add items to their shopping carts, and place orders. The database will have tables for customers, products, orders, and order items. Which of the following represents the correct cardinality for the relationship between Products and Orders?

a)

One-to-one

b)

One-to-many

c)

Many-to-one

d)

Many-to-many

60.

Scenario: The online store sells various products such as electronics, clothing, and accessories. The store has customers who can create accounts, add items to their shopping carts, and place orders. The database will have tables for customers, products, orders, and order items. Which of the following entities would be used to represent the products in each order?

a)

Customers

b)

Products

c)

Orders

d)

Order Items

COMPAI Midterm Exam

Total questions: 60

Worksheet time: 3600secs

Similar Resources on Wayground