Question 1
Question
What is the difference between data and information?
Answer
-
Data is facts whereas information is facts within a context
-
Information is only facts
-
decisions are made based off of information
-
decisions are made based off of data and information
Question 2
Question
Select the characteristics of information
Answer
-
Timely
-
Relevant
-
Understandable
-
Complete
-
Reliable
-
Material
-
Verifiable
-
Honest
-
Accessible
Question 3
Question
The Production Cycle consists of getting labor and giving materials
Question 4
Question
What is the Business Cycle: Getting materials and giving cash
Answer
-
Expenditure
-
Revenue
-
Production
-
Financing
Question 5
Question
What does an AIS fulfill?
Answer
-
Collection of Data
-
Turning data into information
-
Providing adequate controls
-
Making decisions based off of decisions
-
Improving efficiency
Question 6
Question
An AIS adds value by improving the quality and efficiency of decision making, as well as reduce cost, share knowledge and improve internal controls
Question 7
Question
Which of the following is NOT an example of a Primary Activity of an AIS in a value chain?
Answer
-
Inbound logistics
-
Marketing and Sales
-
Operations
-
Purchasing
Question 8
Question
Which of the following is NOT an example of a support activity for an AIS in a value chain?
Answer
-
Firm infrastructure
-
Human Resources
-
Technology
-
Purchasing
-
Service
Question 9
Question
Primary activities of an AIS in a value chain provides [blank_start]direct[blank_end] value to the customer
Question 10
Question
The steps in processing data input are:
1. [blank_start]capture[blank_end] transaction data
2. make sure captured data is [blank_start]accurate[blank_end]
3. ensure [blank_start]company policies[blank_end] are followed
Answer
-
capture
-
accurate
-
company policies
Question 11
Question
Which of the following is an example of a turnaround document?
Answer
-
Balance Sheet
-
Utility Bill
-
W4 Form
-
Sales Order
Question 12
Question
A code where two or more subgroups of digits are used to code the item is considered a ___ Code
Answer
-
Block
-
Sequence
-
Group
-
Mnemonic
Question 13
Question
What are the general rules for the characteristics of code?
Question 14
Question
What is not a characteristic of a general ledger?
Answer
-
summary level information
-
asset and liabilities shown
-
used for financial statements
-
contains control accounts
Question 15
Question
The sum of subsidiary account balances should be ____ to the balance in the control account
Answer
-
Equal
-
Greater than
-
Less than
Question 16
Question
General Journals are used to record what types of transactions?
Answer
-
non routine transactions
-
loan payments
-
adjusting entries
-
closing entries
-
cash receipts
-
credit sales
Question 17
Question
[blank_start]Specialized[blank_end] journals record repetitive transactions
Question 18
Question
Which of the following journals are not an example of a speciality journal?
Answer
-
Cash receipts
-
Cash disembursements
-
Credit Sales
-
Closing entries
Question 19
Question
Why is a master file similar to a ledger in a manual AIS?
Question 20
Question
What makes a transaction file unique?
Question 21
Question
Which of the following is NOT part of CRUD database processing?
Question 22
Question
Batch processing: documents are stored in batches and periodically entered into the computer system. The temporary file is then run agains the master file to update the master and the output is printed along with error reports.
Question 23
Question
What is the difference between online batch processing and online real time processing?
Answer
-
Master file is immediately updated in the batch processing
-
Master file is immediately updated in transaction processing
-
Output is printed in transaction but not in batch
-
Transactions are entered as they occur for real time processing
Question 24
Question
Which of the following is NOT an advantage of an ERP?
Question 25
Question
What is the biggest disadvantage of an ERP?
Question 26
Question
Why were databases created?
Answer
-
Duplicated information in many master files
-
data inconsistencies
-
data integration was difficult
-
organization-wide view of data was hard to acheive
Question 27
Question
The physical view of teh database is at the [blank_start]internal[blank_end] level, this is how the data is stored in the system
Question 28
Question
Who would NOT typically look at a database at its logical view?
Question 29
Question
The ER diagram is typically used at the [blank_start]conceptual[blank_end] level because it shows the schema of the database with the entities connected by a diamond.
Question 30
Question
Which of the following is NOT a characteristic of DDL? (Data Definition Language)
Answer
-
Builds the data dictionary
-
Creates the Database
-
describes the logical view
-
changes the content in the database
-
specifies recor or field security constraints
Question 31
Question
A [blank_start]primary[blank_end] key is the attribute or combination of attributes that uniquely define a specific row in a table
Question 32
Question
Say student A is shown in the database 3 times. You need to change their phone number, you only do it on the first row. In doing so, you forget to change the other 2 rows with the old phone number. What kind of anomoly is this?
Question 33
Question
Being unable to add a record to the database is considered what kind of anomoly?
Question 34
Question
A [blank_start]foreign[blank_end] key links the tables in a database together.
Question 35
Question
Which of the following is NOT a rule for relational databases?
Answer
-
Every column in a row must have a single value
-
Primary keys can be empty
-
Foreign keys can be empty, BUT if not empty the value must correspond to a primary key in another table
-
all attributes must describe characteristics of the object identified by the primary key
Question 36
Question
Cardinality is the max number of instances of [blank_start]1 entity[blank_end] that may be related to [blank_start]a specific instance[blank_end] of another entity
Answer
-
1 entity
-
a specific instance
Question 37
Question
Modality is the [blank_start]minimum[blank_end] number of instance of one entity that can be related to a specific instance of another entity