stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
Information Systems Practice Midterm Flashcards | StudBud
Explore
/
Information Systems Practice Midterm
Information Systems Practice Midterm
50 terms
·
StudBud Administration
·
189 plays
Lets see how much you can remember from chapters 5, 6, 7, 8, and 9. Good luck to all!
Flashcards
50 cards
F
Practice quiz
P
Host live
L
Questions
50
Answers
1
What is the first step when developing databases with REA? (7)
Identify relationships among entities
Identify entities
Identify business and economic events
Identify attributes of entities
2
What does the SOLID arrow symbol stand for in a document flowchart? (5)
document flow
manual operation
information flow
electronic data communication
3
A point scoring analysis: (6)
is a useful tool in feasibility analysis
is a tool used for managing IT projects
provides study team with an objective means of selecting AIS
helps the system study team decide whether to outsource
4
The feasibility evaluation: (6)
answer 1 and 3 are both true
includes economic, schedule, technical, + legal feasibility
none of these is correct
is completed prior to detailed systems design
5
In the REA model, which of these would not be classified as an event? (7)
Cash sale
Hiring a new chief executive
Date of the office picnic
Credit sale
6
A form control that does not change from record to record is probably: (9)
a bound control
an unbound control
a design time control
a mistake
7
What happens when you click the (>I) symbol in the form navigation bar? (9)
you will transition from run mode to design mode
you will transition from design mode to run mode
you will go to the first record in the table
you will go to the last record in the table
8
Which of the following lists the data hierarchy in the correct ascending order? (7)
data field, file, record, database
data field, record, file, database
record, file, data field, database
file, data field, database, record
9
Which would be most helpful to managers of a project where precedence is important? (6)
Outsourcing
a turnkey system
PERT
A granite chart
10
Which of these best identifies the underlying data source for an access report? (9)
only tables
only queries
tables, queries, and forms
both tables and quieries
11
to make a select query where satisfy two conditions simultaneously, you should: (8)
give up, this is not possible in access
use separate fields and separate criteria lines for both
specify both in the same field of the criteria line
specify both in separate fields of the criteria line
12
When data is in 2 NF, all of these are requirements except: (7)
All of these are requirements of 2 NF
It is in 1 NF
Does not contain transitive dependencies
All data items depend on a primary key
13
the diagram here is most likely a: (5)
Document Flowchart
Data Flow Diagram
System flowchart
Sales transaction
14
When converting to a new system, which conversion method is the most risky? (6)
modular conversion
direct conversion
turnkey conversion
parallel conversion
15
All of the following are examples of action queries except: (8)
delete query
update query
find missing data query
append query
16
All of the following are examples of DBMSs except: (8)
oracle
SQL
DB2
access
17
Which of the four stages in the development life cycle is likely to be the most costly? (6)
design
implementation, follow up, and maintenance
planning and investigation
analysis
18
What is the biggest difference between an economic event and a business event? (7)
One impacts the financial statements, the other does not
None of these is the biggest difference
One is a business process, the other is a sales process
One creates value for the organization, the other does not
19
Which of these is not an attribute of normalization? (7)
Avoids redundancy in data
All of the above are attributes of normalization
Ensures attributes are stored in the most appropriate tables
Promotes accuracy
20
What do these symbols stand for in a document flowchart? (5)
flow of goods
permanent file
on page connector
off page connector
21
The difference between a database management system and a database is: (8)
the first is program software, the second is data and files
Nothing - these terms are synonyms
the first is hardware, the second is software
the first - complete accounting system, the second a subset
22
What is the typical cardinality between a customer and a purchase event? (7)
none-to-one
many-to-many
one-to-many
one-to-one
23
to identify employees receiving paychecks but no matching record in the master file, you: (8)
use cross-tabs query
use an auditor
update query
find unmatched records query
24
What does this symbol stand for in DOCUMENT flowchart? (5)
manual operation
flow of goods
keying operation
journal or ledger
25
Which of the following statements is NOT true? (6)
more work in the planning phase, the less chance of failure
the prelim. investigation is done by the steering committee
the design team begins with outputs
implementation and follow up includes aqiuring resources
26
the difference between using an update query and updating a single record is: (8)
the first updates all selected records, the second, only one
none of these are correct
the first updates one+ table, the second only one record
nothing-both are the same
27
Which of the following is not a typical part of a printed report using Access? (9)
report footer
navigation bar
detail line
report header
28
What types of data can be stored in modern databases? (8)
text only
none of the above can be stored in databases
text, graphics, video and audio files, and programming code
text and graphics only
29
What relationship is represented by this cardinality? (7)
many-to-many
one-to-many
none of the above
one-to-one
30
The term control break most closely associates with which of the following terms in access? (9)
report header
groups of data
form control
bathroom break
31
Which of these does not characterize a typical database? (7)
Simple systems
Irreplaceable data
Large number of records
High need for accuracy
32
What does this symbol stand for in a document flowchart? (5)
multiple documents
manual operation
payroll master file
terminator
33
What does the NON-SOLID (middle) arrow stand for in a document flowchart? (5)
Information flow
electronic data communication
document flow
on page connector
34
SQL is an example of: (8)
a multimedia database
a tool to perform online analytical processing
a query language
a database management system
35
which of the following statements about reports is incorrect? (9)
They are strictly inputs, they do not allow outputs
All of these statements are correct
they provide custom information to database users
they can be simple or complex
36
In access, you can use a form to perform all the following tasks except: (9)
all of these are tasks that can be done with a form
create a new record in a specific table
change the information in an existing record of a table
view the info from many different records sequentially
37
In selecting a new AIS, the steering committee should consider: (6)
all expected costs and benefits of the new system
support that a vendor can provide
all of the above
compatibility of a new system with existing systems
38
What type of feasibility attempts to answer the question "what resources are required?" (6)
technical
legal
operational
schedule
39
Which of the following has the steps in the prototype phase in the correct order? (6)
develop prototype, test, approve, identify requirements
identify requirements, develop prototype, approve, test
develop prototype, identify requirements, test, approve
identify requirements, develop prototype, test, approve
40
An insert anomaly occurs when the database user cannot: (7)
Delete data
Add new data
Modify data
View data
41
To link the records in a many-to-many relationship within a relational database: (7)
You must create a new database
You must use foreign keys and a spreadsheet system
You must create an intermediate "relationships" table
You cannot link records together under these circumstances
42
What does this symbol represent? (5)
Document
Connector
Internal Entity
File
43
which of the following statements is incorrect concerning a subform? (9)
it displays data related to information in the main form
None of these statements are incorrect
it is a form within a form
it can only be created when using the form wizard
44
to adjust the minimum wage of employees to the current federal level, you should use a(n): (8)
update
find minimums query
tax expert
append query
45
An example of a validation rule is: (8)
an input value must also have a default value
an input value must be between 0 and 40
an input value must be an integer
you cannot delete parent records that have child records
46
Which of the following is NOT a step in the systems development life cycle? (6)
Planning and investigation
all are steps in the life cycle
Analysis and design
Implementation, follow up, and maintenance
47
What does this symbol represent? (5)
Document
External Entity
Master File
File
48
which of the following is not one of the three major sections of a form? (9)
detail section
navigation bar
heading section
footer section
49
Which of these would not be a good primary key for a file of employee records? (7)
All of these would make equally good primary keys
Last name
Company employee number
Social security number
50
What kind of chart from the book uses this symbol? (5)
document flowchart
system flowchart
sales chart
data flow diagram
