IS 312 - Information Systems for Business Managers » Spring 2021 » Exam 1

Need help with your exam preparation?

Existing Quiz Clients Login here
Question #1
Place the following components of the data hierarchy in their correct order:
A.   Bit – byte – field – record – file – database
B.   Bit – field – byte – record – file – database
C.   Bit – byte – field – record – database – file
D.   Byte – bit – record – field – database
Question #2
Which of the following regarding SQL SELECT-statement is TRUE?
A.   ORDER BY-clause immediately follows WHERE-clause
B.   The SELECT-FROM-WHERE clauses are must-haves in the SELECT statement
C.   The FROM-clause is a must-have in the SELECT statement
D.   WHERE provides criteria to filter groups for display so it works with GROUP BY
Question #3
According to Professor Michael Porter’s five competitive forces model, which of the following is NOT a competitive force?
A.   bargaining power of customers
B.   bargaining power of governmental regulation bodies
C.   substitutes
D.   new entrants
Question #4
Which of the following is NOT true about business rules?
A.   each rule involves only two entities
B.   each rule uses nouns for relationship
C.   each relationship is described with two rules
D.   rules help to create accurate data model
Question #5
Which of the following is a correct statement to define a relationship (1:1, 1:M, or M:N): [This question tests the FUNDAMENTAL concepts of 1-1, 1-M, M-N]
A.   there are many students in a class and there is only one faculty in a class, so FAC and STUD is 1:M
B.   there are many students, and there are many faculty; so the STUD:FAC relationship is M:N
C.   each faculty advises many students, many students are advised by each faculty, so it’s 1:M
D.   each student can purchase a parking permit, each permit is assigned to only one student, so it’s 1:1
Question #6
Which of the following is NOT an example of business–IT alignment?
A.   The company views IT as a way to support the business but not as a way to create new revenue streams
B.   The company goals are clear to every IT and business employee.
C.   IT professionals rotate into business departments.
D.   The company ensures that IT employees understand how the company makes money.
Question #7
Which of the following is NOT one of the dimensions to measure data quality?
A.   maintainability
B.   accessibility
C.   relevance
D.   accuracy
Question #8
Which of the following is NOT a feature of management information systems (MIS):
A.   provide routine information
B.   provide standard reports
C.   focus on operational efficiency
D.   provide in-depth analysis of complex business issues
Question #9
At your university, students can take more than one class, and each class can have more than one student. This is an example of what kind of relationship?
A.   many-to-one
B.   many-to-many
C.   one-to-many
D.   one-to-one
Question #10
Which of the following regarding SQL SELECT-statement is NOT true?
A.   FROM-clause indicates the data source (tables)
B.   ORDER BY-clause, if present, is always the last clause
C.   You can only ORDER BY one field, since ordering by multiple fields doesn't make sense
D.   SELECT-clause indicates the fields to be displayed
Question #11
Which of the following is an example of functional area information systems (FAIS)?
A.   word processing software to help a secretary to create memos
B.   accounting/finance systems
C.   none of the others
D.   healthcare information systems
Question #12
Which of the following contains an optional relationship?
A.   Each TUTOR has at least one APPOINTMENT
B.   Each STUDENT is advised by one and only one FACULTY
C.   Each MATERIAL is used on many PRODUCT, or none
D.   Each PERMIT is assigned to one and only one STUDENT

Need help with your exam preparation?

Existing Quiz Clients Login here