Question 1

Database ________ are used to search the database and retrieve specific data from one or more database tables.

Accepted Answer

The answer of Database ________ are used to search the...

Question 2

Database ________ store pieces of information about people, events, and objects.

Accepted Answer

The answer of Database ________ store pieces of information about...

Question 3

Match the database table to the appropriate transaction cycle.
-Time Worked

Accepted Answer

A) Banking Cycle 
B) Sales Cycle 
C) Purchasing Cycle 
D) Financial Cycle 
E) Payroll Cycle 
A) Banking Cycle 
B) Sales Cycle 
C) Purchasing Cycle 
D) Financial Cycle 
E) Payroll Cycle

Question 4

An intersection table's primary key is a(n)________.

Accepted Answer

The answer of An intersection table's primary key is a(n)________....

Question 5

Match the database table to the appropriate transaction cycle.
-Account Transactions

Accepted Answer

A) Banking Cycle 
B) Sales Cycle 
C) Purchasing Cycle 
D) Financial Cycle 
E) Payroll Cycle 
A) Banking Cycle 
B) Sales Cycle 
C) Purchasing Cycle 
D) Financial Cycle 
E) Payroll Cycle

Question 6

In the Database Builder Realm database programmers work with the database users to identify user requirements.

Accepted Answer

A) True 
 B)False

Question 7

Database forms are

Accepted Answer

A) A way to input data into the database 
B) Tools for searching and extracting data from a database 
C) Output of database queries 
D) None of the above 
A) A way to input data into the database 
B) Tools for searching and extracting data from a database 
C) Output of database queries 
D) None of the above

Question 8

To create a relational database based on the purchasing cycle, which types of data should be recorded in the database?

Accepted Answer

A) Customers, purchase orders, invoices 
B) Vendors, inventory items, invoices 
C) Inventory items, purchase orders, invoices 
D) Vendors, inventory items, purchase orders 
A) Customers, purchase orders, invoices 
B) Vendors, inventory items, invoices 
C) Inventory items, purchase orders, invoices 
D) Vendors, inventory items, purchase orders

Question 9

Match the database table to the appropriate transaction cycle.
-Customer

Accepted Answer

A) Banking Cycle 
B) Sales Cycle 
C) Purchasing Cycle 
D) Financial Cycle 
E) Payroll Cycle 
A) Banking Cycle 
B) Sales Cycle 
C) Purchasing Cycle 
D) Financial Cycle 
E) Payroll Cycle

Question 10

Match the database table to the appropriate transaction cycle.
-Employee

Accepted Answer

A) Banking Cycle 
B) Sales Cycle 
C) Purchasing Cycle 
D) Financial Cycle 
E) Payroll Cycle 
A) Banking Cycle 
B) Sales Cycle 
C) Purchasing Cycle 
D) Financial Cycle 
E) Payroll Cycle

Question 11

Database fields are

Accepted Answer

A) A collection of related tables 
B) A collection of related records 
C) Pieces of information about people, events, and objects 
D) A way to input data into a database 
A) A collection of related tables 
B) A collection of related records 
C) Pieces of information about people, events, and objects 
D) A way to input data into a database

Question 12

To create a relational database based on the payroll cycle, which types of data should be recorded in the database?

Accepted Answer

A) Number of hours worked and inventory information 
B) Number of hours worked and purchase orders 
C) Employee information and number of hours worked 
D) Employee information and sales invoices 
A) Number of hours worked and inventory information 
B) Number of hours worked and purchase orders 
C) Employee information and number of hours worked 
D) Employee information and sales invoices

Question 13

Generally, the relationship between a table that stores customer data and table that stores sales order data is ________.

Accepted Answer

The answer of Generally, the relationship between a table that...

Question 14

In the design phase of SDLC, the design for a new accounting database model is created that satisfies user requirements.

Accepted Answer

A) True 
 B)False

Question 15

________ tables are placed between two tables with many-to-many relationship to create two one-to-many relationships.

Accepted Answer

The answer of ________ tables are placed between two tables...

Question 16

Match the database table to the appropriate transaction cycle.
-Purchase Order

Accepted Answer

A) Banking Cycle 
B) Sales Cycle 
C) Purchasing Cycle 
D) Financial Cycle 
E) Payroll Cycle 
A) Banking Cycle 
B) Sales Cycle 
C) Purchasing Cycle 
D) Financial Cycle 
E) Payroll Cycle

Question 17

Which statement is true regarding a one-to-many relationship?

Accepted Answer

A) One-to-many relationships are the most common type of relationships in a relational database. 
B) Many records in one table relate to many records in a related table. 
C) This type of relationship is problematic when building a database and must be eliminated using an intersection table. 
D) For each record type in one database table there one record in the related table. 
A) One-to-many relationships are the most common type of relationships in a relational database. 
B) Many records in one table relate to many records in a related table. 
C) This type of relationship is problematic when building a database and must be eliminated using an intersection table. 
D) For each record type in one database table there one record in the related table.

Question 18

Generally, the relationship between a table that stores sales order data and a table that stores inventory data is ________.

Accepted Answer

The answer of Generally, the relationship between a table that...

Question 19

Match the database table to the appropriate transaction cycle.
-Cash Receipts

Accepted Answer

A) Banking Cycle 
B) Sales Cycle 
C) Purchasing Cycle 
D) Financial Cycle 
E) Payroll Cycle 
A) Banking Cycle 
B) Sales Cycle 
C) Purchasing Cycle 
D) Financial Cycle 
E) Payroll Cycle

Question 20

Match the database table to the appropriate transaction cycle.
-General Ledger

Accepted Answer

A) Banking Cycle 
B) Sales Cycle 
C) Purchasing Cycle 
D) Financial Cycle 
E) Payroll Cycle 
A) Banking Cycle 
B) Sales Cycle 
C) Purchasing Cycle 
D) Financial Cycle 
E) Payroll Cycle

Database ________ are used to search the database and retrieve specific data from one or more database tables.

Database ________ store pieces of information about people, events, and objects.

Match the database table to the appropriate transaction cycle. -Time Worked

An intersection table's primary key is a(n)________.

Match the database table to the appropriate transaction cycle. -Account Transactions

In the Database Builder Realm database programmers work with the database users to identify user requirements.

Database forms are

To create a relational database based on the purchasing cycle, which types of data should be recorded in the database?

Match the database table to the appropriate transaction cycle. -Customer

Match the database table to the appropriate transaction cycle. -Employee

Database fields are

To create a relational database based on the payroll cycle, which types of data should be recorded in the database?

Generally, the relationship between a table that stores customer data and table that stores sales order data is ________.

In the design phase of SDLC, the design for a new accounting database model is created that satisfies user requirements.

________ tables are placed between two tables with many-to-many relationship to create two one-to-many relationships.

Match the database table to the appropriate transaction cycle. -Purchase Order

Which statement is true regarding a one-to-many relationship?

Generally, the relationship between a table that stores sales order data and a table that stores inventory data is ________.

Match the database table to the appropriate transaction cycle. -Cash Receipts

Match the database table to the appropriate transaction cycle. -General Ledger

Accounting Systems Insights

Accounting Interface: Database Forms, Queries, and Reports

Accounting Systems and Business Processes

Business Processes: Purchasing, Sales, and Payroll Cycles

Integrated Enterprise Systems and Cloud Computing

Accounting and Business Intelligence

Accounting and Sustainability Intelligence

XBRL: Intelligent Business Reporting

Fraud and Internal Control

Cybersecurity

The Risk Intelligent Enterprise: Enterprise Risk Management

Accounting System Development

Database Design: ERD, REA, and SQL

Filters

Exam 2: Accounting Databases

Database ________ are used to search the database and retrieve specific data from one or more database tables.

Database ________ store pieces of information about people, events, and objects.

Match the database table to the appropriate transaction cycle. -Time Worked

An intersection table's primary key is a(n)________.

Match the database table to the appropriate transaction cycle. -Account Transactions

In the Database Builder Realm database programmers work with the database users to identify user requirements.

Database forms are

To create a relational database based on the purchasing cycle, which types of data should be recorded in the database?

Match the database table to the appropriate transaction cycle. -Customer

Match the database table to the appropriate transaction cycle. -Employee

Database fields are

To create a relational database based on the payroll cycle, which types of data should be recorded in the database?

Generally, the relationship between a table that stores customer data and table that stores sales order data is ________.

In the design phase of SDLC, the design for a new accounting database model is created that satisfies user requirements.

________ tables are placed between two tables with many-to-many relationship to create two one-to-many relationships.

Match the database table to the appropriate transaction cycle. -Purchase Order

Which statement is true regarding a one-to-many relationship?

Generally, the relationship between a table that stores sales order data and a table that stores inventory data is ________.

Match the database table to the appropriate transaction cycle. -Cash Receipts

Match the database table to the appropriate transaction cycle. -General Ledger

Accounting Systems Insights

Accounting Interface: Database Forms, Queries, and Reports

Accounting Systems and Business Processes

Business Processes: Purchasing, Sales, and Payroll Cycles

Integrated Enterprise Systems and Cloud Computing

Accounting and Business Intelligence

Accounting and Sustainability Intelligence

XBRL: Intelligent Business Reporting

Fraud and Internal Control

Cybersecurity

The Risk Intelligent Enterprise: Enterprise Risk Management

Accounting System Development

Database Design: ERD, REA, and SQL

Filters