Business Information Systems
Test Bank
Course Introduction
Business Information Systems is a foundational course that explores how organizations utilize information technologies to enhance business operations, support decision-making, and achieve strategic goals. The course covers core concepts such as data management, system development, enterprise resource planning, and e-commerce, while highlighting the integration of information systems into various business processes. Students gain insight into both the technical and organizational aspects of information systems, examining real-world applications, ethical considerations, and emerging trends that are shaping the future of business in a digital landscape.
Recommended Textbook
Concepts of Database Management 9th Edition by
Available Study Resources on Quizplus
9 Chapters
525 Verified Questions
525 Flashcards
Source URL: https://quizplus.com/study-set/1925
Page 2
Joy L. Starks
Chapter 1: Introduction to Database Management
Available Study Resources on Quizplus for this Chatper
50 Verified Questions
50 Flashcards
Source URL: https://quizplus.com/quiz/38335
Sample Questions
Q1) List the disadvantages of database processing.
Answer: Larger file size
Increased complexity
Greater impact of failure
More difficult recovery
Q2) A database file requires a large amount of disk space and internal ____________________.
Answer: memory
Q3) An entity is a person, place, object, event, or idea for which you want to store and process data.
A)True
B)False
Answer: True
Q4) Which of the following is called a field or column in many database systems?
A) attribute
B) entity
C) data file
D) relationship
Answer: A
To view all questions and flashcards with answers, click on the resource link above. Page 3
Chapter 2: The Relational Model 1: Introduction, QBE, and Relational Algebra
Available Study Resources on Quizplus for this Chatper
50 Verified Questions
50 Flashcards
Source URL: https://quizplus.com/quiz/38336
Sample Questions
Q1) Which term is another word for a row in a table?
A) tuple
B) field
C) group
D) relation
Answer: A
Q2) List the six properties that define a relation in a two-dimensional table.
Answer: A relation is a two-dimensional table in which:
1. The entries in the table are single-valued; that is, each location in the table contains a single entry.
2. Each column has a distinct name
3. All values in a column are values of the same attributes
4. The order of columns is immaterial
5. Each row is distinct
6. The order of rows is immaterial
Q3) A(n) ____________________ database is a collection of tables.
Answer: relational
Q4) When both criteria must be true for the compound criterion to be true, the _______________ operator is being used.
Answer: AND
To view all questions and flashcards with answers, click on the resource link above. Page 4
Chapter 3: The Relational Model 2: SQL
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/38337
Sample Questions
Q1) Use the ____________________ data type for fields that contain letters and other special characters, and for fields that contain numbers that will not be used for arithmetic.
Answer: CHAR
Q2) Based on the code shown, which query lists the descriptions of all items that are not in Storehouse 3???Item (ItemNum, Description, OnHand, Category, Storehouse, Price )
A) SELECT Description FROM Customer WHERE NOT Storehouse='3' ;
B) SELECT Description FROM Item WHERE Storehouse='4' ;
C) SELECT Description FROM Item WHERE Storehouse>'3' ;
D) SELECT Description FROM Item WHERE NOT Storehouse='3' ; Answer: D
Q3) Which function calculates the number of entries in a table?
A) COUNT
B) SUM
C) MAX
D) MIN
Answer: A
Q4) The ____________ clause is to groups as the WHERE clause is to rows. Answer: HAVING
To view all questions and flashcards with answers, click on the resource link above. Page 5
Chapter 4: The Relational Model 3: Advanced Topics
Available Study Resources on Quizplus for this Chatper
50 Verified Questions
50 Flashcards
Source URL: https://quizplus.com/quiz/38338
Sample Questions
Q1) The type of field for which you should never allow nulls is the
Q2) The following command will enable Jones to retrieve data from the Customer table, but not to take any other action: GRANT SELECT ON Customer To Jones ;
A)True
B)False
Q3) A trigger is stored and compiled on the client computer.
A)True
B)False
Q4) You use the __________ statement to give users privileges to the database.
Q5) Stored procedures do not accept parameters, and must be queried in a manner similar to tables.
A)True
B)False
Q6) One disadvantage of using views is that they are data dependent so that if the database structure changes in any way, the view can no longer be used.
A)True
B)False
Q7) Describe a client/server system and how it applies to stored procedures.
To view all questions and flashcards with answers, click on the resource link above. Page 6
Chapter 5: Database Design 1: Normalization
Available Study Resources on Quizplus for this Chatper
50 Verified Questions
50 Flashcards
Source URL: https://quizplus.com/quiz/38339
Sample Questions
Q1) What is each key that meets the criteria for a primary key called?
A) alternate key
B) candidate key
C) functional key
D) normal key
Q2) If B is functionally dependent on A, what can you also say?
A) A functionally determines B
B) A functionally determines another attribute in the table
C) B functionally determines A
D) B does not determine any other attribute
Q3) A column is a nonkey column when it is part of the primary key.
A)True
B)False
Q4) When the ____________________ of a table is a single column, the table is automatically in second normal form.
Q5) Any column or collection of columns that determines another column is called a(n)
Q6) Discuss what normal forms are and list the most common normal forms.
Q7) What is the difference between a table in first normal form and one in second normal form?
To view all questions and flashcards with answers, click on the resource link above. Page 7
Chapter 6: Database Design 2: Design Method
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/38340
Sample Questions
Q1) The first substep in representing the user view as a collection of tables is to determine entities and create a table for each.
A)True
B)False
Q2) You create a many-to-many relationship by creating a new table whose primary key is the combination of the primary keys of the original tables.
A)True
B)False
Q3) Which of the following is used to improve performance in frequently used columns by maintaining a sort order but does not enforce constraints?
A) surrogate key
B) unique index
C) artificial key
D) nonunique index
Q4) If you find that more than one table in your cumulative design has the same primary key, you should combine the tables to form a new table.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 8
Chapter 7: Dbms Functions
Available Study Resources on Quizplus for this Chatper
50 Verified Questions
50 Flashcards
Source URL: https://quizplus.com/quiz/38341
Sample Questions
Q1) The DBMS must successfully complete all transaction steps or none at all for the database to remain in a correct state.
A)True
B)False
Q2) What type of rules specify which users have what type of access to which data in the database?
A) encryption
B) authentication
C) authorization
D) privacy
Q3) Which authentication method identifies users by physical characteristics such as fingerprints, voiceprints, handwritten signatures, and facial characteristics?
A) smart cards
B) data dictionaries
C) authorization
D) biometrics
Q4) Explain how a database is updated using batch processing.
Q5) ____________________ involves maintaining a log of all updates in the database.
Q6) A backward recovery is also called a(n) ____________________.
To view all questions and flashcards with answers, click on the resource link above. Page 9
Chapter 8: Database Administration
Available Study Resources on Quizplus for this Chatper
50 Verified Questions
50 Flashcards
Source URL: https://quizplus.com/quiz/38342
Sample Questions
Q1) The DBA determines the access privileges for all users and enters the appropriate authorization rules in the DBMS catalog.
A)True
B)False
Q2) With just two exceptions, the DBA grants access and update privileges to the production system only to authorized users. What are the exceptions?
Q3) What is it called when a database is divided into segments and the segments are stored on different computers?
A) converged database
B) centralized database
C) distributed database
D) virtual database
Q4) After the database designers complete the information-level design, what design level does the DBA do next?
A) physical
B) information
C) logical
D) graphical
To view all questions and flashcards with answers, click on the resource link above.
Page 10
Chapter 9: Database Management Approaches
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/38343
Sample Questions
Q1) With respect to the definition of data warehouse, which of the following means that the data is read-only?
A) time-variant
B) integrated
C) nonvolatile
D) subject-oriented
Q2) The relationship between a superclass and a subclass is called a ____________________.
Q3) Transmission Control Protocol/____________________ Protocol is the standard protocol for all communication on the Internet.
Q4) Describe a client-side and a server-side technique used by organizations to remember key data supplied by a web client.
Q5) A(n) ____________________ DDBMS is a database that has the same local DBMS at each site.
Q6) To execute the steps in a(n) ____________________, the user sends a message to the object.
Q7) The term domain refers to the general structure of an object.
A)True
B)False
11
To view all questions and flashcards with answers, click on the resource link above.