Question 1

What are the structures of a relational database, hierarchical database, and a network database? How is data retrieved from each of these types of databases?

Accepted Answer

A relational database is structured as t

Question 2

In a ________ database structure, a parent record can have many child records and each child record can have only one parent record.

Accepted Answer

The answer of In a ________ database structure, a parent...

Question 3

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

Accepted Answer

A relational database stores data in mul

Question 4

Database fields are pieces of information about event, people, and objects.

Accepted Answer

A) True 
 B)False

Question 5

Match the database type to the corresponding structure.
-Network Database

Accepted Answer

A) Multiple Tables 
B) One Parent and Multiple Children 
C) Multiple Parents and Multiple Children 
A) Multiple Tables 
B) One Parent and Multiple Children 
C) Multiple Parents and Multiple Children

Question 6

An intersection table transforms a many-to-many relationship to two one-to-many relationships.

Accepted Answer

A) True 
 B)False

Question 7

Match the database type to the corresponding structure.
-Hierarchical Database

Accepted Answer

A) Multiple Tables 
B) One Parent and Multiple Children 
C) Multiple Parents and Multiple Children 
A) Multiple Tables 
B) One Parent and Multiple Children 
C) Multiple Parents and Multiple Children

Question 8

Which type of data is NOT stored in a data warehouse?

Accepted Answer

A) Historical data 
B) Current data 
C) Future estimates 
D) Data that is used for routine business activities 
A) Historical data 
B) Current data 
C) Future estimates 
D) Data that is used for routine business activities

Question 9

What IT professionals call people or things, accounting professionals call objects.

Accepted Answer

A) True 
 B)False

Question 10

In a ________ database structure, a parent record can have many child records and a child record can have many parent records.

Accepted Answer

The answer of In a ________ database structure, a parent...

Question 11

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

Accepted Answer

A relational database stores data in mul

Question 12

To retrieve data stored in a relational database, each record must have one or more unique identifier.

Accepted Answer

A) True 
 B)False

Question 13

Match the database type to the corresponding structure.
-Relational Database

Accepted Answer

A) Multiple Tables 
B) One Parent and Multiple Children 
C) Multiple Parents and Multiple Children 
A) Multiple Tables 
B) One Parent and Multiple Children 
C) Multiple Parents and Multiple Children

Question 14

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

Accepted Answer

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

Question 15

What is an operational database and a data warehouse? How are they different?

Accepted Answer

An operational database stores data rela

Question 16

When retrieving data from a relational database, which of the following is true?

Accepted Answer

A) You need to know the record address of the data. 
B) You need to understand the database structure. 
C) You need to know how the tables are related. 
D) You need to understand the parent/child record relationship. 
A) You need to know the record address of the data. 
B) You need to understand the database structure. 
C) You need to know how the tables are related. 
D) You need to understand the parent/child record relationship.

Question 17

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 18

A database table that stores data about items a business sells is used in the Sales cycle and the Purchasing cycle.

Accepted Answer

A) True 
 B)False

Question 19

The intersection table's primary key is a composite primary key.

Accepted Answer

A) True 
 B)False

Question 20

In a relational database, the database tables should not have any connections to other tables in the database.

Accepted Answer

A) True 
 B)False

What are the structures of a relational database, hierarchical database, and a network database? How is data retrieved from each of these types of databases?

In a ________ database structure, a parent record can have many child records and each child record can have only one parent record.

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

Database fields are pieces of information about event, people, and objects.

Match the database type to the corresponding structure. -Network Database

An intersection table transforms a many-to-many relationship to two one-to-many relationships.

Match the database type to the corresponding structure. -Hierarchical Database

Which type of data is NOT stored in a data warehouse?

What IT professionals call people or things, accounting professionals call objects.

In a ________ database structure, a parent record can have many child records and a child record can have many parent records.

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

To retrieve data stored in a relational database, each record must have one or more unique identifier.

Match the database type to the corresponding structure. -Relational Database

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

What is an operational database and a data warehouse? How are they different?

When retrieving data from a relational database, which of the following is true?

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

A database table that stores data about items a business sells is used in the Sales cycle and the Purchasing cycle.

The intersection table's primary key is a composite primary key.

In a relational database, the database tables should not have any connections to other tables in the database.

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

What are the structures of a relational database, hierarchical database, and a network database? How is data retrieved from each of these types of databases?

In a ________ database structure, a parent record can have many child records and each child record can have only one parent record.

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

Database fields are pieces of information about event, people, and objects.

Match the database type to the corresponding structure. -Network Database

An intersection table transforms a many-to-many relationship to two one-to-many relationships.

Match the database type to the corresponding structure. -Hierarchical Database

Which type of data is NOT stored in a data warehouse?

What IT professionals call people or things, accounting professionals call objects.

In a ________ database structure, a parent record can have many child records and a child record can have many parent records.

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

To retrieve data stored in a relational database, each record must have one or more unique identifier.

Match the database type to the corresponding structure. -Relational Database

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

What is an operational database and a data warehouse? How are they different?

When retrieving data from a relational database, which of the following is true?

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

A database table that stores data about items a business sells is used in the Sales cycle and the Purchasing cycle.

The intersection table's primary key is a composite primary key.

In a relational database, the database tables should not have any connections to other tables in the database.

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