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