ACTG 313 UPDATED CORE EXAM MANUAL QUESTIONS
AND SOLUTIONS GUARANTEE A+
✔✔Commands in DML - ✔✔INSERT
UPDATE
TRUNCATE
DROP
✔✔data query language (DQL) - ✔✔High-level, English-like, DBMS language that
contains powerful, easy-to-use commands that enable users to retrieve, sort, order, and
display data.
✔✔Report writer - ✔✔DBMS language that simplifies report creation
✔✔T or F: Most DBMS are relational databases - ✔✔TRUE
✔✔Relational Data Model - ✔✔A two-dimensional table representation of data; each
row represents a unique entity (record) and each column is a field where record
attributes are stored.
✔✔Tuple - ✔✔a row in a table that contains data about a specific item in a database
table
✔✔Primary Key - ✔✔A field (or group of fields) that uniquely identifies a given entity in a
table
✔✔Foreign key - ✔✔A primary key of one table that appears as an attribute in another
table and acts to provide a logical relationship between the two tables
✔✔update anomaly - ✔✔improper database organization where a non-primary key item
is stored multiple times; updating the item in one location and not the others causes
data inconsistencies
✔✔Insert anomaly - ✔✔improper database organization that results in the inability to
add records to a database
✔✔delete anomaly - ✔✔improper organization of a database that results in the loss of
all information about an entity when a row is deleted
✔✔Two approaches to database design - ✔✔1. normalization
2. semantic data modeling
✔✔Normalization - ✔✔The process of applying rules to a database design to ensure
that information is divided into the appropriate tables.
, ✔✔semantic data modeling - ✔✔using knowledge of business processes and
information needs to create a diagram that shows what to include in a fully normalized
database
✔✔Physical view - ✔✔using actual data
✔✔Logical view - ✔✔looking at the copy of the data
✔✔Who would have the CREATE function in customer master files? - ✔✔Sales person,
credit function, AR
✔✔Who would have the READ function in customer master files? - ✔✔management
and shipping
✔✔Who would have the UPDATE function in customer master files? - ✔✔accountant,
ERP, database administrator
✔✔Who would have the DELETE function in customer master files? - ✔✔Database
administrator
or nobody
✔✔Threats to AIS - ✔✔-natural and political disasters
-software errors and equipment malfunctions
-unintentional acts
-intentional acts
✔✔Fraud - ✔✔wrongful or criminal deception intended to result in financial or personal
gain
✔✔For an act to be fraudulent there must be - ✔✔1) A false statement, representation,
disclosure
2) A material fact (something that induces a person to act)
3) An intent to deceive
4) A justifiable reliance (person relies on the misrepresentation to take the action)
5) An injury or loss
✔✔white collar crime - ✔✔crime committed by people of high social position in the
course of their occupations
✔✔Corruption - ✔✔dishonest or fraudulent conduct by those in power, typically
involving bribery.
AND SOLUTIONS GUARANTEE A+
✔✔Commands in DML - ✔✔INSERT
UPDATE
TRUNCATE
DROP
✔✔data query language (DQL) - ✔✔High-level, English-like, DBMS language that
contains powerful, easy-to-use commands that enable users to retrieve, sort, order, and
display data.
✔✔Report writer - ✔✔DBMS language that simplifies report creation
✔✔T or F: Most DBMS are relational databases - ✔✔TRUE
✔✔Relational Data Model - ✔✔A two-dimensional table representation of data; each
row represents a unique entity (record) and each column is a field where record
attributes are stored.
✔✔Tuple - ✔✔a row in a table that contains data about a specific item in a database
table
✔✔Primary Key - ✔✔A field (or group of fields) that uniquely identifies a given entity in a
table
✔✔Foreign key - ✔✔A primary key of one table that appears as an attribute in another
table and acts to provide a logical relationship between the two tables
✔✔update anomaly - ✔✔improper database organization where a non-primary key item
is stored multiple times; updating the item in one location and not the others causes
data inconsistencies
✔✔Insert anomaly - ✔✔improper database organization that results in the inability to
add records to a database
✔✔delete anomaly - ✔✔improper organization of a database that results in the loss of
all information about an entity when a row is deleted
✔✔Two approaches to database design - ✔✔1. normalization
2. semantic data modeling
✔✔Normalization - ✔✔The process of applying rules to a database design to ensure
that information is divided into the appropriate tables.
, ✔✔semantic data modeling - ✔✔using knowledge of business processes and
information needs to create a diagram that shows what to include in a fully normalized
database
✔✔Physical view - ✔✔using actual data
✔✔Logical view - ✔✔looking at the copy of the data
✔✔Who would have the CREATE function in customer master files? - ✔✔Sales person,
credit function, AR
✔✔Who would have the READ function in customer master files? - ✔✔management
and shipping
✔✔Who would have the UPDATE function in customer master files? - ✔✔accountant,
ERP, database administrator
✔✔Who would have the DELETE function in customer master files? - ✔✔Database
administrator
or nobody
✔✔Threats to AIS - ✔✔-natural and political disasters
-software errors and equipment malfunctions
-unintentional acts
-intentional acts
✔✔Fraud - ✔✔wrongful or criminal deception intended to result in financial or personal
gain
✔✔For an act to be fraudulent there must be - ✔✔1) A false statement, representation,
disclosure
2) A material fact (something that induces a person to act)
3) An intent to deceive
4) A justifiable reliance (person relies on the misrepresentation to take the action)
5) An injury or loss
✔✔white collar crime - ✔✔crime committed by people of high social position in the
course of their occupations
✔✔Corruption - ✔✔dishonest or fraudulent conduct by those in power, typically
involving bribery.
