Business Information Systems
Practice Questions
Course Introduction
Business Information Systems explores the essential role of information technology in the modern business environment, examining how organizations leverage IT to optimize operations, streamline decision-making, and gain competitive advantage. This course covers fundamental concepts such as systems analysis and design, data management, enterprise resource planning, and e-commerce applications. Students will learn about the integration of business processes with digital systems, the ethical and security issues facing professionals in the field, and how emerging technologies are shaping the future of business. Practical case studies and real-world applications are emphasized to demonstrate the strategic value and challenges of implementing information systems in various business contexts.
Recommended Textbook
Modern Database Management 10th Edition by
Jeffrey A. Hoffer
Available Study Resources on Quizplus 14 Chapters
1571 Verified Questions
1571 Flashcards
Source URL: https://quizplus.com/study-set/528
Page 2
Chapter 1: The Database Environment and Development Process
Available Study Resources on Quizplus for this Chatper
173 Verified Questions
173 Flashcards
Source URL: https://quizplus.com/quiz/9865
Sample Questions
Q1) A graphical system that is used to capture the nature and relationships among data is called a ________.
Answer: data model
Q2) One disadvantage of file processing systems is:
A) reduced data duplication.
B) program-data independence.
C) limited data sharing.
D) enforcement of integrity constraints.
Answer: C
Q3) Which of the following is NOT a cost and/or risk of the database approach?
A) Specialized personnel
B) Cost of conversion
C) Improved responsiveness
D) Organizational conflict
Answer: C
Q4) File processing systems have been replaced by database systems in most critical business applications today.
A)True
B)False
Answer: True
To view all questions and flashcards with answers, click on the resource link above. Page 3
Chapter 2: Modeling Data in the Organization
Available Study Resources on Quizplus for this Chatper
121 Verified Questions
121 Flashcards
Source URL: https://quizplus.com/quiz/9866
Sample Questions
Q1) A fact is an association between two or more:
A) words.
B) terms.
C) facts.
D) nuggets.
Answer: B
Q2) One reason to use an associative entity is if the associative entity has one or more attributes in addition to the identifier.
A)True
B)False
Answer: True
Q3) A(n)________ entity type exists independently of other entity types.
Answer: strong
Q4) An attribute that can be calculated from related attribute values is called a(n)________ attribute.
A) simple
B) composite
C) multivalued
D) derived
Answer: D
Page 4
To view all questions and flashcards with answers, click on the resource link above.
Chapter 3: The Enhanced E-R Model and Business Rules
Available Study Resources on Quizplus for this Chatper
74 Verified Questions
74 Flashcards
Source URL: https://quizplus.com/quiz/9867
Sample Questions
Q1) How is the data modeling process different when starting with a purchased solution?
Answer: A packaged data model is quite extensive,so you would begin with the part of the data model which you will use for your situation.You would start first with entities,then attributes and then relationships.The next step is to rename the data elements to terms that are meaningful to your organization.Since the packaged data model may be used to replace an existing system,the next step is to map the packaged model to the current database.This mapping will be used later for data migration.Perhaps the most challenging step is to determine the business rules for the new system.
Q2) The subtype discriminator is a composite attribute when there is a(n):
A) overlap rule.
B) disjoint rule.
C) partial specialization.
D) full specialization.
Answer: A
Q3) Data models of an existing database are harder for data modelers to read.
A)True
B)False
Answer: False
To view all questions and flashcards with answers, click on the resource link above. Page 5
Chapter 4: Logical Database Design and the Relational Model
Available Study Resources on Quizplus for this Chatper
120 Verified Questions
120 Flashcards
Source URL: https://quizplus.com/quiz/9868
Sample Questions
Q1) An alternative name for an attribute is called a(n):
A) synonym.
B) alias.
C) alternate attribute.
D) related characteristic.
Q2) A nonkey attribute is also called a(n): A) column.
B) unimportant datum.
C) descriptor.
D) address.
Q3) A composite key consists of only one attribute.
A)True
B)False
Q4) A(n)________ is an attribute that uniquely identifies each row in a relation.
Q5) The relational data model consists of which components?
A) Data structure
B) Data manipulation
C) Data integrity
D) All of the above
Q6) The ________ states that no primary key attribute can be null. Page 6
To view all questions and flashcards with answers, click on the resource link above.
Page 7
Chapter 5: Physical Database Design and Performance
Available Study Resources on Quizplus for this Chatper
105 Verified Questions
105 Flashcards
Source URL: https://quizplus.com/quiz/9869
Sample Questions
Q1) A table or other data structure used to determine the location of rows in a file that satisfy some condition is called a(n)________.
Q2) A ________ is a named set of disk storage elements in which physical files for database tables may be stored.
Q3) One objective of selecting a data type is to minimize storage space.
A)True
B)False
Q4) The storage format for each attribute from the logical data model is chosen to maximize ________ and minimize storage space.
A) query design
B) programmer productivity
C) data integrity
D) data integration
Q5) In most cases the goal of ________ dominates the design process.
A) efficient data processing
B) security
C) quick pointer updates
D) shorter design times
Q6) Explain the differences between sequential and indexed file organizations.
Page 8
To view all questions and flashcards with answers, click on the resource link above.
Chapter 6: Introduction to SQL
Available Study Resources on Quizplus for this Chatper
119 Verified Questions
119 Flashcards
Source URL: https://quizplus.com/quiz/9870
Sample Questions
Q1) When the select clause in the create view statement contains the keyword DISTINCT,the view can be used to update data.
A)True
B)False
Q2) The ALTER TABLE command is used to change a table definition.
A)True
B)False
Q3) ________ is a constraint that specifies that the value of an attribute in one relation depends upon the value of a primary key in the same or other relation.
Q4) What results will be produced by the following SQL query?
Select sum(standard_price)as total_price
From product_v
Where product_type = 'WOOD';
A) The total price of all products that are of type wood
B) The total price of all products
C) The standard_price of the first wood product in the table
D) The standard_price of any wood product in the table
Q5) What is a materialized view and when would it be used?
Q6) What three clauses are contained in most SQL retrieval statements?
Page 9
To view all questions and flashcards with answers, click on the resource link above.
Chapter 7: Advanced SQL
Available Study Resources on Quizplus for this Chatper
111 Verified Questions
111 Flashcards
Source URL: https://quizplus.com/quiz/9871
Sample Questions
Q1) DBA_USERS contains comments on all tables in an Oracle database.
A)True
B)False
Q2) User-defined transactions can improve system performance because:
A) transactions are processed as sets, reducing system overhead.
B) transactions are mapped to SQL statements.
C) speed is improved due to query optimization.
D) all of the above.
Q3) A new set of analytical functions added in SQL:200n are referred to as:
A) OLAF Functions.
B) MOLAP Functions.
C) Average Functions.
D) OLAP Functions.
Q4) The natural join is very rarely used.
A)True
B)False
Q5) When a subquery is used in the FROM clause,it is called a(n)________.
Q6) A join in which the joining condition is based on equality between values in the common column is called a(n)________.
Q7) What strategies can be used to write queries that run more efficiently?
To view all questions and flashcards with answers, click on the resource link above. Page 10
Chapter 8: Database Application Development
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/9872
Sample Questions
Q1) A(n)________ is a language used for defining XML databases.
Q2) Which of the following is a component of processing logic?
A) Input
B) Output
C) Retrieval
D) Business rules
Q3) A computer that provides database storage and access in a client/server environment is called a ________.
Q4) Discuss some of the key benefits of three-tier applications.
Q5) SOAP is an insignificant Web standard.
A)True
B)False
Q6) Web services allow for communication between programs over the Internet.
A)True
B)False
Q7) ________ are a set of emerging standards that define protocols for automatic communication between software programs over the Web.
Q8) UDDI stands for Underwritten Data Dictionary Inquiry.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 11
Chapter 9: Data Warehousing
Available Study Resources on Quizplus for this Chatper
117 Verified Questions
117 Flashcards
Source URL: https://quizplus.com/quiz/9873
Sample Questions
Q1) Organizations adopt data mart architectures because it is easier to have separate,small data warehouses than to get all organizational parties to agree to one view of the organization in a central data warehouse.
A)True
B)False
Q2) A system that is used to run a business in real time,based on current data is called a(n)________ system.
Q3) ________ is/are a new technology which trade(s)off storage space savings for computing time.
A) Dimensional modeling
B) Column databases
C) Fact tables
D) Snowflake schemas
Q4) The star schema is a simple database design in which ________ data are separated from ________ data.
Q5) Discuss some of the characteristics of derived data.
Q6) Discuss the three-layer data architecture.
Q7) Why are data mining applications growing rapidly?
Q8) A ________ data mart is created by a relation view of a data warehouse.
To view all questions and flashcards with answers, click on the resource link above. Page 12
Chapter 10: Data Quality and Integration
Available Study Resources on Quizplus for this Chatper
102 Verified Questions
102 Flashcards
Source URL: https://quizplus.com/quiz/9874
Sample Questions
Q1) Discuss data governance and what needs to be included in a data governance program.
Q2) Retention refers to the amount of data that is not purged periodically from tables.
A)True
B)False
Q3) An approach to filling a data warehouse that employs bulk rewriting of the target data periodically is called:
A) dump mode.
B) overwrite mode.
C) refresh mode.
D) update mode.
Q4) All of the following are tasks of data cleansing EXCEPT:
A) decoding data to make them understandable for data warehousing applications.
B) adding time stamps to distinguish values for the same attribute over time.
C) generating primary keys for each row of a table.
D) creating foreign keys.
Q5) There are six major steps to ETL. A)True B)False
To view all questions and flashcards with answers, click on the resource link above. Page 13
Chapter 11: Data and Database Administration
Available Study Resources on Quizplus for this Chatper
116 Verified Questions
116 Flashcards
Source URL: https://quizplus.com/quiz/9875
Sample Questions
Q1) Forward recovery is faster than restore/rerun because:
A) transactions do not have to be repeated.
B) security can be avoided.
C) images are mirrored.
D) systems are more complete.
Q2) What are some of the core roles of the traditional data administrator?
Q3) The process of managing simultaneous operations against a database so that data integrity is maintained is called ________.
Q4) ________ makes it easier to integrate a new software tool into a development process.
Q5) Loss of data integrity does not impact the quality of data in a database.
A)True
B)False
Q6) An open-source DBMS is:
A) a free source-code RBMS that provides the functionality of an SQL-compliant DBMS.
B) a beta release of a commercial RDBMS.
C) an object-oriented database management system.
D) source code for a commercial RDBMS.
Q7) A ________ measures or detects personal characteristics such as fingerprints.
Page 14
To view all questions and flashcards with answers, click on the resource link above.
Chapter 12: Distributed Databases
Available Study Resources on Quizplus for this Chatper
109 Verified Questions
109 Flashcards
Source URL: https://quizplus.com/quiz/9876
Sample Questions
Q1) In a homogeneous environment,the same DBMS is used at each location.
A)True
B)False
Q2) Local autonomy means that data are not accessible from remote sites.
A)True
B)False
Q3) Distributed databases make data sharing more difficult because of the data communication problems.
A)True
B)False
Q4) A design goal for distributed databases that states that although a distributed database runs many transactions,it appears that a given transaction is the only one in the system is called:
A) linear run.
B) concurrency transparency.
C) transaction CPU transparency.
D) location transparency.
Q5) What are the functions of a distributed DBMS?
Q6) Discuss the different types of data replication.
To view all questions and flashcards with answers, click on the resource link above. Page 15
Q7) What are some of the advantages and disadvantages of a distributed database?
Chapter 13: Object-Oriented Data Modeling
Available Study Resources on Quizplus for this Chatper
91 Verified Questions
91 Flashcards
Source URL: https://quizplus.com/quiz/9877
Sample Questions
Q1) ________ encompasses an object's properties and the values of those properties.
Q2) Which of the following operations does not alter the state of an object?
A) Update
B) Query
C) Constructor
D) None of the above
Q3) An aggregation expresses a part-of relationship between a component object and an aggregate object.
A)True
B)False
Q4) A diagram that shows the static structure of an object-oriented model is called a(n):
A) structure diagram.
B) class diagram.
C) entity diagram.
D) none of the above.
Q5) An association class is similar to an associative entity in the E-R model.
A)True
B)False
Q6) What is an association and an association role?
Page 16
To view all questions and flashcards with answers, click on the resource link above.
Chapter 14: Using Relational Databases to Provide Object
Persistence
Available Study Resources on Quizplus for this Chatper
113 Verified Questions
113 Flashcards
Source URL: https://quizplus.com/quiz/9878
Sample Questions
Q1) Object-relational mapping frameworks require less overhead than call-level APIs and query mapping frameworks.
A)True
B)False
Q2) The identity of the ________ is dealt with differently in the object-oriented and relational worlds.
A) attributes
B) entities
C) objects
D) core Elements
Q3) SQL query mapping frameworks reduce significantly the amount of code required to manage ________.
Q4) In the relational world,each object has its own identity based upon its existence.
A)True
B)False
Q5) ________ refers to the process of writing an object into a storage medium or communication channel as a data stream.
Q6) ________ enables Java programs to access SQL databases.
To view all questions and flashcards with answers, click on the resource link above. Page 17