Business Information Systems
Exam Practice Tests
Course Introduction
Business Information Systems explores the integration of information technology and business processes to enhance organizational performance and decision-making. The course covers fundamental concepts such as data management, system development life cycles, and enterprise resource planning, while examining how information systems support strategic objectives and daily operations. Students will analyze real-world case studies to understand how businesses utilize technology for competitive advantage, address security and ethical issues, and adapt to rapidly changing digital environments. Through hands-on assignments, learners will gain practical skills in evaluating, selecting, and implementing information systems solutions in various business contexts.
Recommended Textbook
Database Systems Design Implementation and Management 11th Edition by Carlos Coronel
Available Study Resources on Quizplus
15 Chapters
1318 Verified Questions
1318 Flashcards
Source URL: https://quizplus.com/study-set/1460 Page 2
Chapter 1: Database Systems
Available Study Resources on Quizplus for this Chatper
76 Verified Questions
76 Flashcards
Source URL: https://quizplus.com/quiz/29009
Sample Questions
Q1) refer to a type of database that stores most of its data in RAM rather than in hard disks.
A) Integrated databases
B) Cloud databases
C) Desktop databases
D) In-memory databases
Answer: D
Q2) is defined as the condition in which all of the data in the database are consistent with the real-world events and conditions.
A) Data integrity
B) Data anomaly
C) Data ubiquity
D) Data quality
Answer: A
Q3) Database programming languages receive all application requests and translate them into the complex operations required to fulfill those requests.
A)True
B)False
Answer: False
To view all questions and flashcards with answers, click on the resource link above.
Page 3
Chapter 2: Data Models
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/29016
Sample Questions
Q1) In Chen notation, entities and relationships have to be oriented horizontally; not vertically.
A)True
B)False
Answer: False
Q2) Today, most relational database products can be classified as object/relational.
A)True
B)False
Answer: True
Q3) M:N relationships are not appropriate in a relational model.
A)True
B)False
Answer: True
Q4) A(n) enables a database administrator to describe schema components.
A) extensible markup language (XML)
B) data definition language (DDL)
C) unified modeling language (UML)
D) query language
Answer: B
To view all questions and flashcards with answers, click on the resource link above. Page 4
Chapter 3: The Relational Database Model
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/29017
Sample Questions
Q1) The one-to-many (1:M) relationship is easily implemented in the relational model by putting the foreign key of the "1" side in the table of the "many" side as a primary key.
A)True
B)False
Answer: False
Q2) A data dictionary is sometimes described as "the database designer's database" because it records the design decisions about tables and their structures.
A)True
B)False Answer: True
Q3) Each table in a relational database must have a primary key.
A)True
B)False Answer: True
Q4) The order of the rows and columns is important to the DBMS.
A)True
B)False Answer: False
To view all questions and flashcards with answers, click on the resource link above. Page 5
Chapter 4: Entity Relationship Er Modeling
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/29018
Sample Questions
Q1) The process of database design is a sequential process.
A)True
B)False
Q2) In implementation terms, an entity is existence-dependent if it has a mandatory primary key.
A)True
B)False
Q3) To implement a small database, a database designer must know the "1" and the "M" sides of each relationship and whether the relationships are mandatory or optional.
A)True
B)False
Q4) The Chen notation identifies a weak entity by using a double-walled entity .
Q5) What is a weak relationship? Provide an example.
Q6) A weak entity must be -dependent.
Q7) In the Chen and Crow's Foot notations, an entity is represented with a rectangle containing the entity's name.
A)True
B)False
Q8) A(n) attribute is an attribute that must have a value.
To view all questions and flashcards with answers, click on the resource link above. Page 6
Chapter 5: Advanced Data Modeling
Available Study Resources on Quizplus for this Chatper
85 Verified Questions
85 Flashcards
Source URL: https://quizplus.com/quiz/29019
Sample Questions
Q1) The default comparison condition for the subtype discriminator attribute is the comparison.
A) nonequality
B) less than
C) greater than
D) equality
Q2) The extended entity relationship model (EERM) is sometimes referred to as the .
A) enclosed entity relationship model
B) enhanced entity relationship model
C) entity clustering relationship model
D) extended entity relationship diagram
Q3) Specialization is the top-down process of identifying lower-level, more specific entity subtypes from a higher-level entity supertype.
A)True
B)False
Q4) The property of a subtype discriminator enables an entity supertype to inherit the attributes and relationships of the subtype.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 7
Chapter 6: Normalization of Database Tables
Available Study Resources on Quizplus for this Chatper
110 Verified Questions
110 Flashcards
Source URL: https://quizplus.com/quiz/29020
Sample Questions
Q1) BCNF can be violated only if the table contains more than one key.
A) primary
B) candidate
C) foreign
D) secondary
Q2) An attribute that cannot be further subdivided is said to display .
Q3) In the context of partial dependencies, data redundancies occur because every row entry requires duplication of data.
A)True
B)False
Q4) It becomes difficult to create a suitable key when the related table uses a composite primary key.
Q5) A derives its name from the fact that a collection of multiple entries of the same type can exist for any single key attribute occurrence.
A) partial dependency
B) transitive dependency
C) repeating group
D) primary key
Q6) refers to the level of detail represented by the values stored in a table's row.
Page 8
To view all questions and flashcards with answers, click on the resource link above.
Chapter 7: Introduction to Structured Query Language Sql
Available Study Resources on Quizplus for this Chatper
111 Verified Questions
111 Flashcards
Source URL: https://quizplus.com/quiz/29021
Sample Questions
Q1) The query used to list the P_CODE, P_DESCRIPT, P_INDATE, and P_PRICE fields from the PRODUCT table in ascending order by P_PRICE is .
A) SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE FROM PRODUCT SEQUENCE BY P_PRICE;
B) SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE FROM PRODUCT LIST BY P_PRICE;
C) SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE FROM PRODUCT ORDER BY P_PRICE;
D) SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE FROM PRODUCT ASCENDING BY P_PRICE;
Q2) The special operator is used to check whether an attribute value is null.
A) BETWEEN
B) IS NULL C) LIKE
D) NOT NULL
Q3) The SQL command that allows a user to permanently save data changes is . A) INSERT B) SELECT C) COMMIT D) UPDATE
Q4) The specification is used to avoid having duplicated values in a column.
Q5) In the SQL environment, the word covers both questions and actions.
To view all questions and flashcards with answers, click on the resource link above. Page 9
Chapter 8: Advanced Sql
Available Study Resources on Quizplus for this Chatper
109 Verified Questions
109 Flashcards
Source URL: https://quizplus.com/quiz/29022
Sample Questions
Q1) How are triggers critical to proper database operation and management?
Q2) Describe the characteristics of an Oracle sequence.
Q3) The function returns the current system date in MS Access.
A) TO_DATE()
B) SYSDATE()
C) DATE()
D) TODAY()
Q4) is the term used to describe an environment in which the SQL statement is not known in advance and is generated at run time.
Q5) is a cursor attribute that returns True if the last FETCH returned a row, and FALSE if not.
A) %ROWCOUNT
B) %NOTFOUND
C) %FOUND
D) %ISOPEN
Q6) UNION, INTERSECT, and MINUS work properly only if relations are intersect-compatible, which means that the names of the relation attributes and their data types must be different.
A)True
B)False
Page 10
To view all questions and flashcards with answers, click on the resource link above.
Chapter 9: Database Design
Available Study Resources on Quizplus for this Chatper
103 Verified Questions
103 Flashcards
Source URL: https://quizplus.com/quiz/29023
Sample Questions
Q1) Systems analysis establishes the need for an information system and its extent.
A)True
B)False
Q2) Discovery of user requirements, existing system evaluation, and logical system design are part of the phase of the Systems Development Life Cycle (SDLC).
A) planning
B) analysis
C) detailed systems design
D) implementation
Q3) The implementation of applications tends to prolong the operational life of systems by making them easier to update and maintain.
A) database-produced
B) network-produced
C) CASE-produced
D) design-produced
Q4) are usually provided by the database management system (DBMS) to check for access violations.
Q5) Explain the concept of logical design and list the steps involved.
Q6) allows the assignment of access rights to specific authorized users.
Page 11
To view all questions and flashcards with answers, click on the resource link above.
Chapter 10: Transaction Management and Concurrency
Control
Available Study Resources on Quizplus for this Chatper
85 Verified Questions
85 Flashcards
Source URL: https://quizplus.com/quiz/29010
Sample Questions
Q1) Atomicity indicates the permanence of the database's consistent state.
A)True
B)False
Q2) A lock locks the entire table preventing access to any row by a transaction while another transaction is using the table.
A) database-level
B) table-level
C) page-level
D) row-level
Q3) A field-level lock allows concurrent transactions to access the same row, as long as they require the use of different fields within that row.
A)True
B)False
Q4) The last step in the write-through technique recovery procedure is to identify the last checkpoint in the transaction log.
A)True
B)False
Q5) Explain the transaction log. What is its function?
Q6) What are the three basic techniques to control deadlocks?
To view all questions and flashcards with answers, click on the resource link above. Page 12
Chapter 11: Database Performance Tuning and Query
Optimization
Available Study Resources on Quizplus for this Chatper
85 Verified Questions
85 Flashcards
Source URL: https://quizplus.com/quiz/29011
Sample Questions
Q1) A(n) is a logical grouping of several data files that store data with similar characteristics.
A) procedure cache
B) table space
C) data cache
D) listener
Q2) Knowing the sparsity of a column helps you decide whether the use of is appropriate.
A) query processing
B) query optimization
C) an index
D) a full table scan
Q3) refers to the number of different values a column could possibly have.
A) Database statistics
B) Data sparsity
C) A bitmap index
D) Clustering
Q4) RAID systems use a single disk to create storage volumes.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 13
Chapter 12: Distributed Database Management Systems
Available Study Resources on Quizplus for this Chatper
83 Verified Questions
83 Flashcards
Source URL: https://quizplus.com/quiz/29012
Sample Questions
Q1) A distributed can reference several different local or remote data processing sites.
A) request
B) site
C) data location
D) transaction
Q2) A distributed database management system (DDBMS) must be communications-media-dependent.
A)True
B)False
Q3) In a basic distributed processing environment, the distributed processing system shares the database chores among three sites connected through a .
Q4) fragmentation refers to the division of a relation into subsets of tuples.
A) Vertical
B) Horizontal
C) Data
D) Mixed
Q5) The distributed database system must be of the computer hardware system.
Q6) A transaction processor is also known as the processor.
Q7) Explain the three types of operations defined by the DO-UNDO-REDO protocol.
Page 14
To view all questions and flashcards with answers, click on the resource link above.
Chapter 13: Business Intelligence and Data Warehouses
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/29013
Sample Questions
Q1) In the prognosis phase, the data-mining findings are used to predict future behavior and forecast business outcomes.
A)True
B)False
Q2) Business intelligence tools use the data warehouse data as the raw materials for data analytics to generate business knowledge.
A)True
B)False
Q3) Data _____ tools are tools that provide advanced statistical analysis to uncover problems and opportunities hidden within business data.
Q4) _____ are quantifiable measurements (numeric or scale based) that assess a company's effectiveness or success in reaching its strategic and operational goals.
Q5) In a typical star schema, each dimension record is related to thousands of records.
A) attribute
B) fact
C) key
D) primary
To view all questions and flashcards with answers, click on the resource link above. Page 15
Chapter 14: Database Connectivity and Web Technologies
Available Study Resources on Quizplus for this Chatper
85 Verified Questions
85 Flashcards
Source URL: https://quizplus.com/quiz/29014
Sample Questions
Q1) The ODBC API standard defines three levels of compliance: , Level-1, and Level-2, which provide increasing levels of functionality.
A) Elementary
B) Basic
C) Core
D) Level-0
Q2) A(n) _____ is a program written in a programming language that is not compiled, but is interpreted and executed at run time.
Q3) The benefits of the web as a data access platform arise from its cross-platform functionality and the simplicity of its interface.
A)True
B)False
Q4) A good API makes it easy to develop a program by providing all of the building blocks.
A)True
B)False
Q5) To prevent the server from performing all data validation, data input validation is one of the most basic requirements for web applications.
To view all questions and flashcards with answers, click on the resource link above. Page 16
Chapter 15: Database Administration and Security
Available Study Resources on Quizplus for this Chatper
86 Verified Questions
86 Flashcards
Source URL: https://quizplus.com/quiz/29015
Sample Questions
Q1) In the context of an organization's managerial structure, decisions are short term and affect only daily operations; for example, deciding to change the price of a product to clear it from inventory.
Q2) Incremental backups produce a backup of all data.
A)True
B)False
Q3) Having a computerized DBMS guarantees that the data will be properly used to provide the best solutions required by managers.
A)True
B)False
Q4) security breaches include database access by computer viruses and by hackers whose actions are designed to destroy or alter data.
A) Debilitative
B) Preserving
C) Corrupting
D) Destructive
Q5) Explain conflict and problem resolution as part of the DBA's end-user support services.
Q6) Describe the DBA's managerial role.
Page 17
To view all questions and flashcards with answers, click on the resource link above.