Business Information Systems
Practice Exam
Course Introduction
Business Information Systems explores the role of information technology in managing and organizing business operations. The course examines how systems such as databases, enterprise applications, and communication networks support decision-making, improve efficiency, and drive strategic advantage in organizations. Students learn about system development, data management, and the integration of technology with business processes, while analyzing case studies that illustrate how information systems transform business practices. Topics also cover information security, ethical considerations, and trends such as cloud computing, e-commerce, and big data analytics.
Recommended Textbook
Database Concepts 7th Edition by David M. Kroenke
Available Study Resources on Quizplus
18 Chapters
1205 Verified Questions
1205 Flashcards
Source URL: https://quizplus.com/study-set/1260
Page 2
Chapter 1: Getting Started
Available Study Resources on Quizplus for this Chatper
76 Verified Questions
76 Flashcards
Source URL: https://quizplus.com/quiz/24869
Sample Questions
Q1) The Microsoft Access application generator is not responsible for:
A) creating forms.
B) creating reports.
C) creating queries.
D) creating tables.
E) storing queries.
Answer: D
Q2) Which of the following is not a function of the database application in a database system?
A) Execute application logic
B) Control concurrency
C) Create and process forms
D) Create and transmit queries
E) Create and process reports
Answer: B
Q3) Metadata is the user data stored in the database.
A)True
B)False
Answer: False
To view all questions and flashcards with answers, click on the resource link above.
Page 3
Chapter 2: The Relational Model
Available Study Resources on Quizplus for this Chatper
87 Verified Questions
87 Flashcards
Source URL: https://quizplus.com/quiz/24871
Sample Questions
Q1) While the relational model for databases appears to hold much promise,few commercial databases have implemented it.
A)True
B)False
Answer: False
Q2) In practice,why would tables that have duplicate rows be allowed?
Answer: It is not uncommon for a table that is returned as the result of a data manipulation operation,such as a query,to contain duplicate rows.This is often tolerated because of the processing time necessary for the DBMS to search the table to find and eliminate duplicate rows.This is especially true if the table is very large.In these cases,it is often acceptable to allow the duplicate rows to exist.
Q3) In Microsoft Access,the relationship between two tables is not actually created until:
A) the OK button in the Create Relationships dialog box is clicked.
B) the Create button in the Create Relationships dialog box is clicked.
C) the OK button in the Edit Relationships dialog box is clicked.
D) the Create button in the Edit Relationships dialog box is clicked.
E) the Join button in the Edit Relationships dialog box is clicked.
Answer: D
To view all questions and flashcards with answers, click on the resource link above. Page 4
Chapter 3: Structured Query Language
Available Study Resources on Quizplus for this Chatper
96 Verified Questions
96 Flashcards
Source URL: https://quizplus.com/quiz/24873
Sample Questions
Q1) Microsoft Access SQL commands are run in the ________ of a Query window. Answer: SQL View
Q2) For a column to be defined as the primary key using table constraints,the column must have been given the property NULL.
A)True
B)False
Answer: False
Q3) To open a new Microsoft Access Query window:
A) click the New button on the Home command tab.
B) click the New Query button on the Home command tab.
C) click the Create Query button on the Create command tab.
D) click the New Query in Design view button on the Create command tab.
E) click the Query Design button on the Command tab.
Answer: E
Q4) In SQL,the IS NULL keyword can be used to select on records containing NULL values in a particular column.
A)True
B)False
Answer: True
To view all questions and flashcards with answers, click on the resource link above. Page 5
Chapter 4: Data Modeling and the Entity-Relationship
Model
Available Study Resources on Quizplus for this Chatper
76 Verified Questions
76 Flashcards
Source URL: https://quizplus.com/quiz/24875
Sample Questions
Q1) Which of the following is true about identifiers of entities?
A) Identifiers must be unique.
B) Identifiers are not normally used in a naming role.
C) The value of an identifier may identify a set of entity instances.
D) Identifiers may not be more than two attributes.
E) An identifier in the E-R model is equivalent to a key in the relational model.
Q2) Microsoft Access 2013 uses banded form and report editors.
A)True
B)False
Q3) An entity class is described by the structure of the entities in that class.
A)True
B)False
Q4) An ID-dependent entity is:
A) a special type of weak entity.
B) an entity in which the identifier of the entity includes the identifier of another entity.
C) a strong entity.
D) an entity with a maximum cardinality of one.
E) Both A and B
To view all questions and flashcards with answers, click on the resource link above. Page 6
Chapter 5: Database Design
Available Study Resources on Quizplus for this Chatper
81 Verified Questions
81 Flashcards
Source URL: https://quizplus.com/quiz/24877
Sample Questions
Q1) To normalize a relation,the determinant of every functional dependency should be a(n)________.
Q2) A(n)________ is a relationship among entities of the same class.
Q3) To represent a M:N relationship in the relational model,an intersection relation is created to represent the relationship itself.
A)True
B)False
Q4) The identifier of the entity becomes the ________ of the corresponding table.
A) primary key
B) foreign key
C) supertype
D) subtype
E) either A or B
Q5) One of the important properties of an attribute is whether or not it is required. A)True
B)False
Q6) Relationships that are 1:1 do not require referential integrity constraints.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 7
Chapter 6: Database Administration
Available Study Resources on Quizplus for this Chatper
76 Verified Questions
76 Flashcards
Source URL: https://quizplus.com/quiz/24879
Sample Questions
Q1) When Microsoft Access 2013 uses user-level security with an Access 2003 database file,it stores the database in a(n)________ file.
Q2) Microsoft Access 2013 databases can be secured using trusted locations for database storage.
A)True
B)False
Q3) A point of synchronization between the database and the transaction log is called a(n):
A) before-image.
B) after-image.
C) recovery.
D) checkpoint.
E) None of the above
Q4) Which of the following is not a means of processing databases?
A) Internet applications using ASP
B) Internet applications using JSP
C) Applications invoking stored procedures
D) Programs coded in C#
E) All of the above are means of processing a database.
Q5) Explain the concept of an "atomic transaction."
To view all questions and flashcards with answers, click on the resource link above. Page 8
Chapter 7: Database Processing Applications
Available Study Resources on Quizplus for this Chatper
82 Verified Questions
82 Flashcards
Source URL: https://quizplus.com/quiz/24881
Sample Questions
Q1) A common default Web page name recognized by most Web servers is FirstPage.html.
A)True
B)False
Q2) What is XML,and why is it useful?
Q3) A BEFORE trigger is called by the DBMS before reading data.
A)True
B)False
Q4) XML Web Services is a means for protecting and hiding elements of program functionality that otherwise would be available for misuse over the Web.
A)True
B)False
Q5) XML provides a standardized,non-customizable way to describe the content of a document.
A)True
B)False
Q6) ODBC stands for ________.
Q7) Every DBMS product has an application programming interface (API).
A)True
B)False
Q8) How can XML be used with a DBMS? Page 9
To view all questions and flashcards with answers, click on the resource link above.
Page 10
Chapter 8: Big Data, data Warehouses, and Business Intelligence Systems
Available Study Resources on Quizplus for this Chatper
99 Verified Questions
99 Flashcards
Source URL: https://quizplus.com/quiz/24883
Sample Questions
Q1) Operational databases store historical data.
A)True
B)False
Q2) Business Intelligence (BI)reporting systems can analyze data using standard SQL.
A)True
B)False
Q3) Why is operational data sometimes unusable for Business Intelligence use?
Q4) When creating an OLAP report based on Access 2013 data,it is often a good idea to create a view equivalent query to organize the data needed for the OLAP report.
A)True
B)False
Q5) To arrange the PivotTable columns and rows in Excel 2013,we use the:
A) PivotTable Control.
B) PivotTable dialog box.
C) PivotTable Field List.
D) PivotTable Wizard.
E) PivotTable command tab.
Q6) Business Intelligence (BI)systems obtain data in ________ different ways.
Q7) What is a star schema?
11
To view all questions and flashcards with answers, click on the resource link above.
Chapter 9: Getting Started With Microsoft Sql Server 2012
Available Study Resources on Quizplus for this Chatper
40 Verified Questions
40 Flashcards
Source URL: https://quizplus.com/quiz/24868
Sample Questions
Q1) Describe how to create and run an SQL query in SQL Server 2014 Express.
Q2) An important reason for using SQL Server 2014 Express is that it has ________.
Q3) Database objects are displayed in the Object Explorer window in the SQL Server Management Studio.
A)True
B)False
Q4) What is an SQL script,and why are SQL scripts useful?
Q5) To run an SQL script,click the ________ button on the Query Toolbar.
Q6) SQL query results are displayed in a tabbed Resultset window.
A)True
B)False
Q7) Describe why SQL Server 2014 is sensitive to certain words being used in SQL commands or scripts,and what to do about it.
Q8) The ODBC Driver 11 for SQL Server is installed ________ when SQL Server 2014 is installed.
Q9) Users can click the ________ button to enable or disable the SQL editor windows set of outlining and auto-completion features.
Page 12
Q10) The name of the Microsoft SQL Server 2014 ODBC Client as it appears the ODBC Data Source Administrator is ________.
To view all questions and flashcards with answers, click on the resource link above.
Chapter 10: Getting Started With Oracle Database 11g
Release 2
Available Study Resources on Quizplus for this Chatper
43 Verified Questions
43 Flashcards
Source URL: https://quizplus.com/quiz/24870
Sample Questions
Q1) SQL query results are displayed:
A) in a tabbed Resultset window.
B) in a tabbed Query Result window.
C) in a tabbed Document window.
D) in a tabbed Messages window.
E) in a tabbed Finished window.
Q2) When using Oracle Database,a sequence is an object that generates a sequential series of unique numbers.
A)True
B)False
Q3) Explain sequences and their relationship to surrogate keys.
Q4) The Oracle Database FORMAT_DATE function can be used to make sure that Oracle Database interprets date data correctly.
A)True
B)False
Q5) What is an SQL script,and why are SQL scripts useful?
Q6) The Oracle Database ODBC Client is installed ________ when Oracle Database 11g Release 2 is installed.
13
Q7) SQL query results are displayed in a tabbed ________ window.
To view all questions and flashcards with answers, click on the resource link above.
Chapter 11: Getting Started With Mysql 56 Community Server
Available Study Resources on Quizplus for this Chatper
71 Verified Questions
71 Flashcards
Source URL: https://quizplus.com/quiz/24872
Sample Questions
Q1) To create a new MySQL Workbench EER model,you can use the New Model link on the Home page.
A)True
B)False
Q2) A new MySQL database is created using:
A) the new_database dialog box.
B) the Create Database command.
C) the new_schema dialog box.
D) the Create Schema command.
E) the New Object dialog box.
Q3) Users should create a Data Models folder to hold EER models created with the MySQL Workbench.
A)True
B)False
Q4) MySQL Community Server 5.6 requires that the .NET Framework version 4.5.1 be installed.
A)True
B)False
Page 14
Q5) Database objects are displayed in the ________ window in the MySQL Workbench.
Q6) Describe the MySQL Connector/ODBC and how to install it.
To view all questions and flashcards with answers, click on the resource link above.
Page 15
Chapter 12: James River Jewelry Project Questions
Available Study Resources on Quizplus for this Chatper
70 Verified Questions
70 Flashcards
Source URL: https://quizplus.com/quiz/24874
Sample Questions
Q1) SQL views are used:
A) to hide columns or rows.
B) to display the results of computations.
C) to hide complicated SQL syntax.
D) to layer built-in functions.
E) All of the above
Q2) SQL views can be used to hide table ________.
Q3) The SQL statement ________ is used to modify a view.
Q4) The SQL statement DROP VIEW ViewName is used to delete a view from a database.
A)True
B)False
Q5) An SQL virtual table is called a(n)________.
Q6) SQL views can be used to hide columns.
A)True
B)False
Q7) The SQL keyword ORDER BY can be used with SELECT statements that are retrieving data from view instances to sort the results of the SELECT.
A)True
B)False
Q8) What are SQL triggers and how are they used?
To view all questions and flashcards with answers, click on the resource link above. Page 16
Chapter 13: Sql Views
Available Study Resources on Quizplus for this Chatper
47 Verified Questions
47 Flashcards
Source URL: https://quizplus.com/quiz/24876
Sample Questions
Q1) Information systems are used to support business processes.
A)True
B)False
Q2) What activities take place during the component design step of the systems development life cycle (SDLC)?
Q3) Databases are created in a DBMS during the ________ step of the SDLC.
A) system definition
B) requirements analysis
C) component design
D) implementation
E) systems maintenance
Q4) Information systems are used to support ________.
Q5) Database designs are created during the ________ step.
Q6) A business process is a set of activities that transforms materials into products.
A)True
B)False
Q7) A business process is a set of activities that transforms ________ into ________.
Q8) Data models are created during the ________ step.
Page 17
To view all questions and flashcards with answers, click on the resource link above.
Chapter 14: Getting Started in Systems Analysis and Design
Available Study Resources on Quizplus for this Chatper
34 Verified Questions
34 Flashcards
Source URL: https://quizplus.com/quiz/24878
Sample Questions
Q1) In Microsoft Visio 2013,how do we create database designs?
Q2) In Microsoft Visio 2013,for a Relationship object relationship that is one-mandatory on the child side of the relationship,the correct setting in the Symbol menu is:
A) 1 and only 1.
B) 1 or more.
C) Zero or 1.
D) Zero or more.
E) Range [At least][At most].
Q3) Microsoft Visio 2013 can be used to create data models,but not database designs.
A)True
B)False
Q4) In Microsoft Visio 2013,we can create database designs using Entity and Dynamic connector objects.
A)True
B)False
Q5) In Microsoft Visio 2013,we can create data models using Entity and Relationship objects.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 18
Chapter 15: Getting Started With Microsoft Visio 2010
Available Study Resources on Quizplus for this Chatper
17 Verified Questions
17 Flashcards
Source URL: https://quizplus.com/quiz/24880
Sample Questions
Q1) A Microsoft Access 2013 switchboard provides application menuing capabilities in Microsoft Access 2013.
A)True
B)False
Q2) Microsoft Access 2013 switchboards are built in a report window in Microsoft Access 2013.
A)True
B)False
Q3) Microsoft Access 2013 switchboards use ________ as part of the switchboard.
A) text buttons
B) report windows
C) Wizard buttons
D) command buttons
E) All of the above
Q4) Microsoft Access 2013 switchboard command buttons are built using:
A) the Text Label Wizard.
B) the Command Button Wizard.
C) the All Button Wizard.
D) the Form Wizard.
E) All of the above
To view all questions and flashcards with answers, click on the resource link above. Page 19
Chapter 16: The Access Workbench-section Microsoft
Access
Available Study Resources on Quizplus for this Chatper
35 Verified Questions
35 Flashcards
Source URL: https://quizplus.com/quiz/24882
Sample Questions
Q1) When running the NetBeans IDE for the first time,use a default file workspace named:
A) NetBeans Workspace.
B) NetBeansProjects.
C) Documents.
D) My Documents.
E) My Workspace.
Q2) Below installing the NetBeans IDE,we have to install ________.
A) the Java JRE
B) the Java SDK
C) the Java JDK
D) the Java SRE
E) Any of the above will work.
Q3) For a Web server running the Linux operating system,the most commonly used Web server is:
A) the IIS Web server.
B) the Apache Web server.
C) the Tomcat Web server.
D) the ASP.NET Web server.
E) the JSP Web server.
To view all questions and flashcards with answers, click on the resource link above. Page 20
Chapter 17: Getting Started With Web Servers, php, and the
Netbeans IDE
Available Study Resources on Quizplus for this Chatper
98 Verified Questions
98 Flashcards
Source URL: https://quizplus.com/quiz/24884
Sample Questions
Q1) Report authoring includes responsibility for delivery of the report. A)True
B)False
Q2) In market basket analysis,lift is confidence divided by support.
A)True
B)False
Q3) What is a data warehouse?
Q4) The "R" in RFM analysis stands for:
A) rank.
B) recent.
C) relationship.
D) readiness.
E) random.
Q5) Data warehouses are populated with data prepared by ________ programs.
Q6) The metadata maintained by a reporting system database describes: A) reports.
B) users.
C) groups. D) roles.
E) All of the above Page 21
To view all questions and flashcards with answers, click on the resource link above.
Page 22
Chapter 18: Business Intelligence Systems
Available Study Resources on Quizplus for this Chatper
77 Verified Questions
77 Flashcards
Source URL: https://quizplus.com/quiz/24885
Sample Questions
Q1) The CAP Theorem defines three properties of distributed database systems,which are:
A) consistency, always-on, properties.
B) competency, always-on, properties.
C) consistency, availability, partition tolerance.
D) competency, availability, partition tolerance.
E) consistency, availability, properties.
Q2) The key-value database uses columns.
A)True
B)False
Q3) An example of a graph database is ________.
A) Dynamo
B) Couchbase Server
C) Bigtable
D) Neo4j
E) MySQL
Q4) DTD stands for Document Type Declaration.
A)True
B)False
Q5) Graph databases are composed of ________.
Page 23
To view all questions and flashcards with answers, click on the resource link above.