Questão 1
Questão
What is the difference between data and information?
Responda
-
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
Questão 2
Questão
Select the characteristics of information
Responda
-
Timely
-
Relevant
-
Understandable
-
Complete
-
Reliable
-
Material
-
Verifiable
-
Honest
-
Accessible
Questão 3
Questão
The Production Cycle consists of getting labor and giving materials
Questão 4
Questão
What is the Business Cycle: Getting materials and giving cash
Responda
-
Expenditure
-
Revenue
-
Production
-
Financing
Questão 5
Questão
What does an AIS fulfill?
Responda
-
Collection of Data
-
Turning data into information
-
Providing adequate controls
-
Making decisions based off of decisions
-
Improving efficiency
Questão 6
Questão
An AIS adds value by improving the quality and efficiency of decision making, as well as reduce cost, share knowledge and improve internal controls
Questão 7
Questão
Which of the following is NOT an example of a Primary Activity of an AIS in a value chain?
Responda
-
Inbound logistics
-
Marketing and Sales
-
Operations
-
Purchasing
Questão 8
Questão
Which of the following is NOT an example of a support activity for an AIS in a value chain?
Responda
-
Firm infrastructure
-
Human Resources
-
Technology
-
Purchasing
-
Service
Questão 9
Questão
Primary activities of an AIS in a value chain provides [blank_start]direct[blank_end] value to the customer
Questão 10
Questão
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
Responda
-
capture
-
accurate
-
company policies
Questão 11
Questão
Which of the following is an example of a turnaround document?
Responda
-
Balance Sheet
-
Utility Bill
-
W4 Form
-
Sales Order
Questão 12
Questão
A code where two or more subgroups of digits are used to code the item is considered a ___ Code
Responda
-
Block
-
Sequence
-
Group
-
Mnemonic
Questão 13
Questão
What are the general rules for the characteristics of code?
Questão 14
Questão
What is not a characteristic of a general ledger?
Responda
-
summary level information
-
asset and liabilities shown
-
used for financial statements
-
contains control accounts
Questão 15
Questão
The sum of subsidiary account balances should be ____ to the balance in the control account
Responda
-
Equal
-
Greater than
-
Less than
Questão 16
Questão
General Journals are used to record what types of transactions?
Responda
-
non routine transactions
-
loan payments
-
adjusting entries
-
closing entries
-
cash receipts
-
credit sales
Questão 17
Questão
[blank_start]Specialized[blank_end] journals record repetitive transactions
Questão 18
Questão
Which of the following journals are not an example of a speciality journal?
Responda
-
Cash receipts
-
Cash disembursements
-
Credit Sales
-
Closing entries
Questão 19
Questão
Why is a master file similar to a ledger in a manual AIS?
Questão 20
Questão
What makes a transaction file unique?
Questão 21
Questão
Which of the following is NOT part of CRUD database processing?
Questão 22
Questão
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.
Questão 23
Questão
What is the difference between online batch processing and online real time processing?
Responda
-
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
Questão 24
Questão
Which of the following is NOT an advantage of an ERP?
Questão 25
Questão
What is the biggest disadvantage of an ERP?
Questão 26
Questão
Why were databases created?
Responda
-
Duplicated information in many master files
-
data inconsistencies
-
data integration was difficult
-
organization-wide view of data was hard to acheive
Questão 27
Questão
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
Questão 28
Questão
Who would NOT typically look at a database at its logical view?
Questão 29
Questão
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.
Questão 30
Questão
Which of the following is NOT a characteristic of DDL? (Data Definition Language)
Responda
-
Builds the data dictionary
-
Creates the Database
-
describes the logical view
-
changes the content in the database
-
specifies recor or field security constraints
Questão 31
Questão
A [blank_start]primary[blank_end] key is the attribute or combination of attributes that uniquely define a specific row in a table
Questão 32
Questão
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?
Questão 33
Questão
Being unable to add a record to the database is considered what kind of anomoly?
Questão 34
Questão
A [blank_start]foreign[blank_end] key links the tables in a database together.
Questão 35
Questão
Which of the following is NOT a rule for relational databases?
Responda
-
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
Questão 36
Questão
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
Responda
-
1 entity
-
a specific instance
Questão 37
Questão
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