Practice Exam
docx
keyboard_arrow_up
School
Oxnard College *
*We aren’t endorsed by this school
Course
2301
Subject
Information Systems
Date
Apr 3, 2024
Type
docx
Pages
4
Uploaded by shayjaberi
Practice Exam:
Note:
This practice exam has been created to simulate a 30-minute exam.
It will consist of 10 multiple choice questions and 2 essay questions.
While the exam is designed to familiarize you with the type of questions that may show up on the exam, it may or may not represent the “difficulty” level of the exam, as this depends on your familiarity with the subject.
Doing well on the practice exam does not guarantee similar performance on the final exam.
Not all topics are covered on the practice exam. Note that everything covered in class from Weeks 1 through 5 is fair game on the exam.
MCQs: Please select the right answer:
1.
I in SIPOC stands for:
a.
Institute
b.
Interval
c.
Input
d.
Indoor
2.
If a software is industry specific, it is likely to be a ------ software?
a.
Vertical
b.
Local
c.
Extra-organizational
d.
Enterprise
3.
____ represent each category of data contained in a record.
a.
Column
b.
Row
c.
Table
d.
None of these
4.
According to the Wired article you read for the Amazon article in class, which of the following isn't a major revenue source for Amazon?
a.
Finance
b.
Retail
c.
Healthcare
d.
Hardware
5.
According to the value discipline framework, your company may have one of ____ primary value disciplines.
a.
1
b.
2
c.
3
d.
4
6.
Middleware is a useful system software. Its role can be summarized through the acronym:
a.
LET
b.
LTE
c.
ELT
d.
ETL
7.
ERPs stand for:
a.
Enterprise Reserve Provider
b.
Enterprise Resource Planning
c.
Enterprise Revenue Provider
d.
Enterprise Reserve Planning
8.
Older information systems that are incompatible with other systems, technologies, and ways of conducting business are called:
a.
Primitive Systems
b.
Legacy Systems
c.
Ancient Systems
d.
Antique Systems
9.
Which of the following terms never appear in the Knowledge Hierarchy pyramid?
a.
Data
b.
Information
c.
Innovation
d.
Wisdom
10. Which of the following is an operating system?
a.
Linux
b.
USB 3.0
c.
Java
d.
iPhone
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Essay type questions:
1.
Please see the data table below:
Tablename: RestaurantOrders
OrderID
NumberItems
TotalAmount
Server
Payment
1
4
15
Tom
CreditCard
2
5
20
Bob
Cash
3
6
21
Tom
CreditCard
4
3
20
Tom
Cash
5
4
18
Bob
CreditCard
6
5
25
Jill
CreditCard
7
1
10
Jill
CreditCard
Please write the SQL code that helps answer the following questions:
I.
List all columns for orders served by Tom and paid via CreditCard.
II.
Find the maximum TotalAmount processed via CreditCard.
III.
List all columns where NumberItems is greater than 3, sorted in descending order.
IV.
Find the average NumberItems serviced by Tom which were paid via CreditCard.
2.
Answer the following questions briefly:
I.
What is TCO? Name four IT software considerations for TCO?
II.
Briefly describe the 5 V’s of Big data.