ACTG 313 CERTIFICATION EXAM Q&A 2026
STUDY GUIDE WITH VERIFIED SOLUTIONS
● Why were databases developed? Answer: To address the proliferation
of redundant data in the files of systems using the file approach
● What is the goal of databases? Answer: Create an organization-wide
database that stores all of the data needed to operate the business while
linking data across various functions and eliminating redundancy
● Record Answer: a collection of related data elements
Rows in excell
● Fields Answer: columns in the table; each field describes a
characteristic of the record
● File Answer: collection of related records
● Database management system Answer: the program that manages and
controls the data and the interfaces between the data and the application
programs that use the data stored in the database
,● database system Answer: the database, the DBMS, and the application
programs that access the database through the DBMS
● Database Administrator (DBA) Answer: the person responsible for
coordinating, controlling, and managing the database
● Online transaction processing database (OTPD) Answer: database
containing detailed current transaction data, usually in third normal
form. Focuses on throughput, speed, availability, concurrency, and
recoverability.
● Data warehousr Answer: very large databases containing detailed and
summarized data for a number of years used for analysis rather than
transaction processing
● Data analytics Answer: analyzing large amounts of data for strategic
decision making
● Business Intelligence Answer: analyzing large amounts of data for
strategic decision making
● Two main business intelligence techiniques: Answer: 1. Online
analytical processing (OLAP)
2. Data mining
, ● Online Analytical processing (OLAP) Answer: using queries to
investigate hypothesized relationships among data
● Data mining Answer: the use of a variety of statistical analysis tools
to uncover previously unknown patterns in the data stored in databases
or relationships among variables
● Advantages of Database systems Answer: 1. Data integration
2. Data sharing
3. Minimal data redundancy and data inconsistencies
4. Data independence
5. Cross-functional analysis
● The logical view of a database: Answer: presents data as they would
be perceived by end users.
● Physical view Answer: the way data are physically arranged and
stored in the computer system
● Schemas Answer: a description of the data elements in a database, the
relationship between among them, and the logical model used to
organize and describe the data
STUDY GUIDE WITH VERIFIED SOLUTIONS
● Why were databases developed? Answer: To address the proliferation
of redundant data in the files of systems using the file approach
● What is the goal of databases? Answer: Create an organization-wide
database that stores all of the data needed to operate the business while
linking data across various functions and eliminating redundancy
● Record Answer: a collection of related data elements
Rows in excell
● Fields Answer: columns in the table; each field describes a
characteristic of the record
● File Answer: collection of related records
● Database management system Answer: the program that manages and
controls the data and the interfaces between the data and the application
programs that use the data stored in the database
,● database system Answer: the database, the DBMS, and the application
programs that access the database through the DBMS
● Database Administrator (DBA) Answer: the person responsible for
coordinating, controlling, and managing the database
● Online transaction processing database (OTPD) Answer: database
containing detailed current transaction data, usually in third normal
form. Focuses on throughput, speed, availability, concurrency, and
recoverability.
● Data warehousr Answer: very large databases containing detailed and
summarized data for a number of years used for analysis rather than
transaction processing
● Data analytics Answer: analyzing large amounts of data for strategic
decision making
● Business Intelligence Answer: analyzing large amounts of data for
strategic decision making
● Two main business intelligence techiniques: Answer: 1. Online
analytical processing (OLAP)
2. Data mining
, ● Online Analytical processing (OLAP) Answer: using queries to
investigate hypothesized relationships among data
● Data mining Answer: the use of a variety of statistical analysis tools
to uncover previously unknown patterns in the data stored in databases
or relationships among variables
● Advantages of Database systems Answer: 1. Data integration
2. Data sharing
3. Minimal data redundancy and data inconsistencies
4. Data independence
5. Cross-functional analysis
● The logical view of a database: Answer: presents data as they would
be perceived by end users.
● Physical view Answer: the way data are physically arranged and
stored in the computer system
● Schemas Answer: a description of the data elements in a database, the
relationship between among them, and the logical model used to
organize and describe the data
