Question 1

All the following statements about intersection tables are true except?

Accepted Answer

A) Intersection tables remove many-to-many relationships. 
B) Only one field in an intersect table is needed to uniquely identify a record. 
C) An intersection table's primary key is a composite key. 
D) The primary key for the intersection table includes the foreign keys of the tables. 
A) Intersection tables remove many-to-many relationships. 
B) Only one field in an intersect table is needed to uniquely identify a record. 
C) An intersection table's primary key is a composite key. 
D) The primary key for the intersection table includes the foreign keys of the tables.

Question 2

Match the database type to the corresponding structure.
A)Multiple Tables
B)Multiple Parents and Multiple Children
C)One Parent and Multiple Children
-Relational Database

Accepted Answer

The answer of Match the database type to the corresponding...

Question 3

The ________ table is an intersection table.

Accepted Answer

A) VENDORS 
B) PURCHASE ORDERS 
C) ITEMS 
D) PO LINE 
A) VENDORS 
B) PURCHASE ORDERS 
C) ITEMS 
D) PO LINE

Question 4

Normalization is the process of increasing data redundancy in a relational database.

Accepted Answer

A) True 
 B)False

Question 5

Data stored in a data warehouse is used for routine business activities.

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A) Vendors, Inventory items, Invoices 
B) Inventory items, Purchase orders, Invoices 
C) Vendors, Inventory items, Purchase orders 
D) Customers, Purchase orders, Invoices 
A) Vendors, Inventory items, Invoices 
B) Inventory items, Purchase orders, Invoices 
C) Vendors, Inventory items, Purchase orders 
D) Customers, Purchase orders, Invoices

Question 7

When retrieving data from a network database, what do you need to know?

Accepted Answer

A) Record address 
B) Database table structure 
C) Table names 
D) Primary keys 
A) Record address 
B) Database table structure 
C) Table names 
D) Primary keys

Question 8

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

Accepted Answer

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

Question 9

Who are the people responsible for establishing policies for database security?

Accepted Answer

A) Database administrators and system users 
B) Internal auditors and security personnel 
C) Internal auditors and database administrators 
D) Database administrators and security personnel 
A) Database administrators and system users 
B) Internal auditors and security personnel 
C) Internal auditors and database administrators 
D) Database administrators and security personnel

Question 10

Which of the following tables is least likely to be used in the Payroll cycle?

Accepted Answer

A) Time Worked 
B) Cash Payment 
C) Cash Receipts 
D) Withholding 
A) Time Worked 
B) Cash Payment 
C) Cash Receipts 
D) Withholding

Question 11

Match the database table to the appropriate transaction cycle.
A)Banking Cycle
B)Payroll Cycle
C)Financial Cycle
D)Sales Cycle
E)Purchasing Cycle
-Time Worked

Accepted Answer

The answer of Match the database table to the appropriate...

Question 12

Entering data once eliminates the possibility of updating some, but not all of the other entries.

Accepted Answer

A) True 
 B)False

Question 13

In a one-to-one relationship, for each record in one database table there are many records in a related table.

Accepted Answer

A) True 
 B)False

Question 14

________ 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 15

What is the difference between a relational database and a network database?

Accepted Answer

A relational database stores data in mul

Question 16

In a database accounting system, the following is true except

Accepted Answer

A) Transactions are entered using onscreen database forms. 
B) Adjustments are made using an onscreen journal. 
C) Closing entries are made manually with debits and credits. 
D) Account information is stored in database tables. 
A) Transactions are entered using onscreen database forms. 
B) Adjustments are made using an onscreen journal. 
C) Closing entries are made manually with debits and credits. 
D) Account information is stored in database tables.

Question 17

Use the database table below to answer the following questions.  
-You are an accountant at a small company and you are reviewing the vendor database table. Identify the database anomalies shown and explain how they impact this database.

Accepted Answer

This database contains the deletion anom

Question 18

Database anomalies can be removed by the process of ________.

Accepted Answer

The answer of Database anomalies can be removed by the...

Question 19

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 20

Use the database tables below to answer the following questions.  
-Which table is an intersection table?

Accepted Answer

A) TimeSheets 
B) TS Line 
C) Employees 
D) Projects 
A) TimeSheets 
B) TS Line 
C) Employees 
D) Projects

All the following statements about intersection tables are true except?

Match the database type to the corresponding structure. A)Multiple Tables B)Multiple Parents and Multiple Children C)One Parent and Multiple Children -Relational Database

The ________ table is an intersection table.

Normalization is the process of increasing data redundancy in a relational database.

Data stored in a data warehouse is used for routine business activities.

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

When retrieving data from a network database, what do you need to know?

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

Who are the people responsible for establishing policies for database security?

Which of the following tables is least likely to be used in the Payroll cycle?

Match the database table to the appropriate transaction cycle. A)Banking Cycle B)Payroll Cycle C)Financial Cycle D)Sales Cycle E)Purchasing Cycle -Time Worked

Entering data once eliminates the possibility of updating some, but not all of the other entries.

In a one-to-one relationship, for each record in one database table there are many records in a related table.

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

What is the difference between a relational database and a network database?

In a database accounting system, the following is true except

Use the database table below to answer the following questions. -You are an accountant at a small company and you are reviewing the vendor database table. Identify the database anomalies shown and explain how they impact this database.

Database anomalies can be removed by the process of ________.

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

Use the database tables below to answer the following questions. -Which table is an intersection table?

Accounting Systems Insights

XBRL: Intelligent Business Reporting

Accounting and Sustainability Intelligence

Accounting and Business Intelligence

Integrated Enterprise Systems

Business Processes: Purchasing, Sales, and Payroll Cycles

Accounting Systems and Business Processes

Accounting Interface: Database Forms, Queries, and Reports

Database Design: ERD, REA, and SQL

Accounting System Development

The Risk Intelligent Enterprise: Enterprise Risk Management

Cybersecurity

Fraud and Internal Control

Filters

Exam 2: Accounting Databases

All the following statements about intersection tables are true except?

Match the database type to the corresponding structure. A)Multiple Tables B)Multiple Parents and Multiple Children C)One Parent and Multiple Children -Relational Database

The ________ table is an intersection table.

Normalization is the process of increasing data redundancy in a relational database.

Data stored in a data warehouse is used for routine business activities.

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

When retrieving data from a network database, what do you need to know?

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

Who are the people responsible for establishing policies for database security?

Which of the following tables is least likely to be used in the Payroll cycle?

Match the database table to the appropriate transaction cycle. A)Banking Cycle B)Payroll Cycle C)Financial Cycle D)Sales Cycle E)Purchasing Cycle -Time Worked

Entering data once eliminates the possibility of updating some, but not all of the other entries.

In a one-to-one relationship, for each record in one database table there are many records in a related table.

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

What is the difference between a relational database and a network database?

In a database accounting system, the following is true except

Use the database table below to answer the following questions. -You are an accountant at a small company and you are reviewing the vendor database table. Identify the database anomalies shown and explain how they impact this database.

Database anomalies can be removed by the process of ________.

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

Use the database tables below to answer the following questions. -Which table is an intersection table?

Accounting Systems Insights

XBRL: Intelligent Business Reporting

Accounting and Sustainability Intelligence

Accounting and Business Intelligence

Integrated Enterprise Systems

Business Processes: Purchasing, Sales, and Payroll Cycles

Accounting Systems and Business Processes

Accounting Interface: Database Forms, Queries, and Reports

Database Design: ERD, REA, and SQL

Accounting System Development

The Risk Intelligent Enterprise: Enterprise Risk Management

Cybersecurity

Fraud and Internal Control

Filters