Information Systems
Final Exam Questions
Course Introduction
Information Systems is an interdisciplinary course that explores the development, management, and utilization of technological solutions to support organizational needs and decision-making processes. Students learn about the role of information systems in business environments, principles of database management, systems analysis and design, enterprise architectures, security, and emerging trends in IT. The course emphasizes real-world application through case studies, project management, and the ethical and strategic challenges faced by organizations when leveraging technology for improved efficiency and competitiveness.
Recommended Textbook
Database Processing Fundamentals Design and Implementation 13th Edition by
Available Study Resources on Quizplus
24 Chapters
1921 Verified Questions
1921 Flashcards
Source URL: https://quizplus.com/study-set/1804
Page 2
David M. Kroenke
Chapter 1: Introduction
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/35866
Sample Questions
Q1) Modern microcomputer personal DBMS products ________.
A)are supplied by several well-established manufacturers
B)were essentially made obsolete by Microsoft Access
C)have poor response time
D)are not true DBMS products
E)are really just programming languages with generalized file-processing capabilities
Answer: B
Q2) The DBMS ranked as having the "least power and features" in the text is Microsoft Access.
A)True
B)False
Answer: True
Q3) In an Enterprise-class database system,a database application accesses the database data.
A)True
B)False
Answer: False
To view all questions and flashcards with answers, click on the resource link above.
Page 3
Chapter 2: Introduction to Structured Query Language SQL
Available Study Resources on Quizplus for this Chatper
105 Verified Questions
105 Flashcards
Source URL: https://quizplus.com/quiz/35868
Sample Questions
Q1) The SQL built-in function ADDUP totals values in numeric columns.
A)True
B)False
Answer: False
Q2) The rows of the result table can be sorted by the values in one or more columns.
A)True
B)False
Answer: True
Q3) In an SQL query,which SQL keyword is used to sort the result table by the values in one or more columns?
A)GROUP BY
B)ORDER BY
C)SELECT
D)SORT BY
E)WHERE Answer: B
Q4) SQL can only query a single table.
A)True
B)False
Answer: False
To view all questions and flashcards with answers, click on the resource link above. Page 4
Chapter 3: The Relational Model and Normalization
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/35870
Sample Questions
Q1) If a relation is in BCNF,and each multivalued dependency has been moved to a relation of its own,then the first relation is in ________.
A)First Normal Form
B)Second Normal Form
C)Third Normal Form
D)Boyce-Codd Normal Form
E)Fourth Normal Form
Answer: E
Q2) Explain the relationships among primary keys and functional dependencies.
Answer: Relations store instances of functional dependencies in their rows.All primary keys represent a functional dependency,since each primary key functionally determines the entire row.Since the primary key determines the entire row,if a primary key were duplicated in a relation,then the entire row would have to be duplicated.Since a relation can contain no duplicate rows,the primary key must be unique.
Q3) Given the functional dependency (A,B) C,then it is true that A C and B C.
A)True
B)False
Answer: False
To view all questions and flashcards with answers, click on the resource link above. Page 5
Chapter 4: Database Design Using Normalization
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/35872
Sample Questions
Q1) When examining data values as a part of assessing table structure,you should try to determine the table's primary key.
A)True
B)False
Q2) Multivalued dependencies show up under a different name as the multivalued,multicolumn problem.
A)True
B)False
Q3) You are creating a BOAT table using existing data from multiple sources,and you find that you have "power boat blue","boat,power,blue" and "blue power boat" as data values for the same column.This is an example of the inconsistent values problem.
A)True
B)False
Q4) To count the number of rows in a table,use the SQL construct COUNT(ROWS).
A)True B)False
Q5) Relations are sometimes left unnormalized to improve performance. A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 6
Chapter 5: Data Modeling With the Entity-Relationship
Model
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/35874
Sample Questions
Q1) Relationships are classified by their cardinality.
A)True
B)False
Q2) Relationships between supertypes and subtypes are called IS-A relationships.
A)True
B)False
Q3) An ID-dependent entity is an entity whose identifier includes the identifier of another entity.
A)True
B)False
Q4) An identifier of an entity instance must consist of one and only one attribute.
A)True
B)False
Q5) An exclusive subtype pattern has one supertype entity that relates to one or more subtype entities.
A)True
B)False
Q6) How is minimum cardinality expressed in IE Crow's Foot E-R diagrams?
Page 7
Q7) How is maximum cardinality expressed in IE Crow's Foot E-R diagrams?
Q8) What is meant by the cardinality of a relationship?
To view all questions and flashcards with answers, click on the resource link above.
Page 8
Chapter 6: Transforming Data Models Into Database Designs
Available Study Resources on Quizplus for this Chatper
103 Verified Questions
103 Flashcards
Source URL: https://quizplus.com/quiz/35876
Sample Questions
Q1) When representing a 1:1 relationship in a relational database design,________. A)the key of each table must be placed as foreign keys into the other B)the key of either table may be placed as a foreign key into the other C)the key of both tables must be the same D)the intersection table gets the key from both relations E)B and C
Q2) To represent a 1:N relationship in a relational database design,an intersection table is created.
A)True
B)False
Q3) In many-to-many relationships in a relational database design,the primary keys of both tables are joined into a composite primary key in the intersection table.
A)True
B)False
Q4) To represent an M:N relationship in a relational database design,an intersection table is created.
A)True
B)False
Q5) What are MUST NOT and MUST COVER constraints?
To view all questions and flashcards with answers, click on the resource link above. Page 9
Chapter 7: Sql for Database Construction and Application
Processing
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/35878
Sample Questions
Q1) To set a column value to an initial value that is selected according to some business logic,you would use:
A)the SQL DEFAULT constraint with the CREATE TABLE command.
B)an SQL view.
C)embedded SQL.
D)an SQL trigger.
E)an SQL stored procedure.
Q2) One advantage of using the CONSTRAINT command to define a primary key is that the database designer controls the name of the constraint.
A)True
B)False
Q3) Distinguish between Char and VarChar data types.
Q4) Unless it is being used to copy data from one table to another,the SQL INSERT statement can be used to insert only a single row into a table.
A)True
B)False
Q5) An SQL virtual table is called a view.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 10
Chapter 8: Database Redesign
Available Study Resources on Quizplus for this Chatper
101 Verified Questions
101 Flashcards
Source URL: https://quizplus.com/quiz/35880
Sample Questions
Q1) When decreasing cardinalities,there will always be ________.
A)relationship loss
B)foreign key loss
C)data loss
D)A and B
E)A,B,and C
Q2) To add a NULL column to a table,we ________.
A)use the REVISE TABLE command
B)use the ALTER TABLE command
C)use the MODIFY TABLE command
D)create a new table with the NULL column,move the other data,and drop the old table
E)None of the above is the correct way to add a NULL column.
Q3) When making any change to the database structure,we may need to check for effects of the change on ________.
A)data
B)foreign keys
C)constraints
D)triggers
E)All of the above may need to be checked.
To view all questions and flashcards with answers, click on the resource link above.
Page 11
Chapter 9: Managing Multiuser Databases
Available Study Resources on Quizplus for this Chatper
102 Verified Questions
102 Flashcards
Source URL: https://quizplus.com/quiz/35882
Sample Questions
Q1) In two-phase locking,all locks are obtained during the growing phase.
A)True
B)False
Q2) The DBA has to find a balance between the conflicting goals of maximizing availability of the database to users and protecting the database.
A)True
B)False
Q3) Briefly define the four isolation levels and the problems they prevent.
Q4) A transaction is sometimes called atomic because it is performed as a unit.
A)True
B)False
Q5) An active data repository is one in which the metadata is automatically created as the system components are created.
A)True
B)False
Q6) A "database save" is used to mark the end of a transaction.
A)True
B)False
Q7) Which are more commonly used: implicit or explicit locks? Why?
Page 12
To view all questions and flashcards with answers, click on the resource link above.
Chapter 10: A: Managing Databases With SQL Server 20012
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/35865
Sample Questions
Q1) SQL Server supports three types of indexes: clustered,unclustered,and random.
A)True
B)False
Q2) In the Microsoft SQL Server Management Studio,the amount to add to the surrogate key value when adding a new row is specified by the increment property.
A)True
B)False
Q3) Explain how to work around the SQL Server IDENTITY constraint when non-sequential data must be entered.
Q4) When creating a T-SQL statement,you should:
A)predefine it graphically in Enterprise Manager.
B)limit it to one table.
C)limit it to two tables.
D)end it with the semicolon normally used to terminate SQL statements.
E)include the word "View" in the view name.
Q5) Discuss the Microsoft PowerShell utility.
Q6) The SQL Server GUI program is the Enterprise Manager.
A)True
B)False
Page 13
To view all questions and flashcards with answers, click on the resource link above.
Chapter 10: B: Managing Databases With Oracle Database
11g Release 2
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/35864
Sample Questions
Q1) Which of the following is not a transaction isolation level supported by Oracle Database?
A)Read Committed
B)Serializable
C)Repeatable Read
D)Read Only
E)All of the above are supported.
Q2) The PL/SQL keywords FOR,WHILE,and LOOP are used to create blocks of code that repeat until an ending condition is reached.
A)True
B)False
Q3) In Oracle Database,triggers that are fired once for each row that is changed in a table are called row triggers.
A)True
B)False
Q4) Explain the Oracle Database PL/SQL control-of-flow statements.
Q5) Explain the Oracle Database PL/SQL Block Structure.
Q6) What is SQL Developer?
Q7) What is SQL*Plus?
14
To view all questions and flashcards with answers, click on the resource link above.
Chapter 10: C: Managing Databases With MySQL
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/35863
Sample Questions
Q1) The MySQL transaction isolation level can be manually set using a MySQL SET {SCOPE} TRANSACTION ISOLATION LEVEL {LEVEL OPTION} command.
A)True
B)False
Q2) To insert non-sequential data into a MySQL table that uses AUTO_INCREMENT:
A)Disable AUTO_INCREMENT.
B)Temporarily remove AUTO_INCREMENT.
C)Use the AUTO_INCREMENT_INSERT command.
D)A or C
E)B or C
Q3) The MySQL command line utility is:
A)MySQL*Plus.
B)the MySQL Command-Line Client.
C)MySQL-Shell.
D)MySQL-CMD.
E)None of the above is correct.
Q4) The MySQL Workbench is the main utility used to implement MySQL security.
A)True
B)False
Q5) Describe how to create and run an SQL query in MySQL Server Community Edition.
Page 15
To view all questions and flashcards with answers, click on the resource link above.
Chapter 11: The Web Server Environment
Available Study Resources on Quizplus for this Chatper
198 Verified Questions
198 Flashcards
Source URL: https://quizplus.com/quiz/35884
Sample Questions
Q1) A set of objects and the properties and methods that they expose are known as a(n)________.
A)provider
B)data consumer
C)implementation
D)instantiation
E)interface
Q2) An XML Schema where all the elements occur at the same level is called a structured schema.
A)True
B)False
Q3) XML documents that conform to their DTD are said to be type-valid XML documents.
A)True
B)False
Q4) What are flat and structured XML Schemas?
Q5) ODBC acts as a wrapper for OLE DB. A)True B)False
Q6) Compare and contrast servlets and applets.
Q7) What is XSLT?
To view all questions and flashcards with answers, click on the resource link above. Page 16
Chapter 12: Big Data datawarehouse and Business Intelligence Systems
Available Study Resources on Quizplus for this Chatper
102 Verified Questions
102 Flashcards
Source URL: https://quizplus.com/quiz/35885
Sample Questions
Q1) In OLAP,the data item of interest is called a ________.
A)level
B)dimension
C)measure
D)member
E)slice
Q2) Data warehouses use a(n)________.
A)operational database
B)dimensional database
C)structured storage
D)A or B
E)All of the above
Q3) Business Intelligence (BI)reporting systems are used to filter data,sort data,group data and make simple calculations based on the data.
A)True
B)False
Q4) In RFM analysis,F stands for "how frequently."
A)True
B)False
Q5) What is a slowly changing dimension?
To view all questions and flashcards with answers, click on the resource link above. Page 17
Chapter 13: Microsoft Access 2013
Available Study Resources on Quizplus for this Chatper
48 Verified Questions
48 Flashcards
Source URL: https://quizplus.com/quiz/35862
Sample Questions
Q1) What Microsoft Access file format is used by default in Microsoft Access 2013?
Q2) Microsoft Access databases are stored using the file extension .accdb.
A)True
B)False
Q3) Microsoft Access is a personal database that combines a DBMS with an application generator.
A)True
B)False
Q4) Microsoft uses the term object as a general name for various parts of a Microsoft Access 2013 database.
A)True
B)False
Q5) 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.
Q6) Microsoft Access is considered a "personal database" product.What is a personal database?
To view all questions and flashcards with answers, click on the resource link above. Page 18
Chapter 14: Getting Started With Systems Analysis and Design
Available Study Resources on Quizplus for this Chatper
35 Verified Questions
35 Flashcards
Source URL: https://quizplus.com/quiz/35867
Sample Questions
Q1) What activities take place during the component design step of the systems development life cycle (SDLC)?
Q2) Database designs are created during the ________ step of the SDLC.
A)system definition
B)requirements analysis
C)component design
D)implementation
E)systems maintenance
Q3) Which of the following is a component of a computer-based information system?
A)Hardware
B)Software
C)Data
D)Procedures
E)All of the above
Q4) Databases are created in a DBMS during the implementation step.
A)True
B)False
Q5) A computer-based information system has four components.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 19
Chapter 15: E-R Diagrams and the Idef1x Standard
Available Study Resources on Quizplus for this Chatper
35 Verified Questions
35 Flashcards
Source URL: https://quizplus.com/quiz/35869
Sample Questions
Q1) In IDEF1X,extended E-R model supertype entities are called:
A)generic entities.
B)category entities.
C)nonspecific entities.
D)category clusters.
E)There is no equivalent IDEF1X term.
Q2) IDEF1X categories are put into a cluster.
A)True
B)False
Q3) In IDEF1X,extended E-R model subtype entities are grouped into:
A)generic entities.
B)category entities.
C)nonspecific entities.
D)category clusters.
E)There is no equivalent IDEF1X term.
Q4) The IDEF1X default cardinality of a nonidentifying connection relationship is indicated by a dashed line with a filled-in circle by the child and no other notation.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 20
Chapter 16: E-R Diagrams and the UML Standard
Available Study Resources on Quizplus for this Chatper
36 Verified Questions
36 Flashcards
Source URL: https://quizplus.com/quiz/35871
Sample Questions
Q1) Attributes preceded by a + are public.
A)True
B)False
Q2) In UML-style E-R diagrams,a weak entity is shown by placing a filled-in diamond on the parent of the weak entity.
A)True
B)False
Q3) Which of the following is a true statement about the current version of UML?
A)UML places a filled-in diamond on the parent of a weak entity.
B)UML does not provide a means to document exclusivity among subtypes.
C)UML uses the label <identifying> to document an ID-dependent relationship.
D)UML shows the cardinality on the parent entity of a weak entity as simply "1."
E)All of the above.
Q4) What new contributions to data modeling do UML-style E-R diagrams introduce?
Q5) UML is intended for modeling and designing object-oriented programs and applications.
A)True
B)False
Q6) How are entity classes drawn in UML-style E-R diagrams?
Page 21
To view all questions and flashcards with answers, click on the resource link above.
Chapter 17: Getting Started With MySQL Workbench Data
Modeling Tools
Available Study Resources on Quizplus for this Chatper
37 Verified Questions
37 Flashcards
Source URL: https://quizplus.com/quiz/35873
Sample Questions
Q1) In the MySQL Workbench,a 1:N non-identifying relationship between two tables that already contain the needed primary and foreign keys is created using:
A)the 1:N Identifying Relationship button.
B)the 1:N Non-identifying Relationship button.
C)the N:M Identifying Relationship button.
D)the Place a Relationship Using Existing Columns button.
E)None of the above is correct.
Q2) In the MySQL Table Editor,the abbreviation AI stands for AUTO_INCREMENT.
A)True
B)False
Q3) In the MySQL Workbench,a 1:N identifying relationship between two tables that already contain the needed primary and foreign keys is created using:
A)the 1:N Identifying Relationship button.
B)the 1:N Non-identifying Relationship button.
C)the N:M Identifying Relationship button.
D)the Place a Relationship Using Existing Columns button.
E)None of the above is correct.
Q4) Describe how to create a new database design in the MySQL Workbench.
To view all questions and flashcards with answers, click on the resource link above. Page 22
Q5) Describe how to create relationships in a MySQL Workbench database design.
Chapter 18: Getting Started With Microsoft Visio 2013
Available Study Resources on Quizplus for this Chatper
34 Verified Questions
34 Flashcards
Source URL: https://quizplus.com/quiz/35875
Sample Questions
Q1) In Microsoft Visio 2013,we can create data models using:
A)Entity and Dynamic connector objects.
B)Entity and Relationship connector objects.
C)Category and Dynamic connector objects.
D)Category and Relationship connector objects.
E)We cannot create data models in Microsoft Visio 2013.
Q2) In Microsoft Visio 2013,Dynamic connector objects can be formatted with the line end symbols needed to create IE Crow's Foot notation.
A)True
B)False
Q3) In Microsoft Visio 2013,both data models and database designs are created using the Database Model Diagram template.
A)True
B)False
Q4) In Microsoft Visio 2013,the cardinalities of the relationship are set using the Set Begin Symbol and Set End Symbol commands.
A)True
B)False
Q5) In Microsoft Visio 2013,how do we create data models?
To view all questions and flashcards with answers, click on the resource link above. Page 23
Chapter 19: Data Structures for Database Processing
Available Study Resources on Quizplus for this Chatper
35 Verified Questions
35 Flashcards
Source URL: https://quizplus.com/quiz/35877
Sample Questions
Q1) Complex networks can be represented by reducing them to simple networks,which requires the introduction of a(n):
A)association record.
B)link record.
C)intersection record.
D)sequential record.
E)index record.
Q2) Keys may include:
A)primary keys.
B)unique secondary keys.
C)nonunique secondary keys.
D)B and C
E)A,B,and C
Q3) An intersection record is a record that is created when a complex network is decomposed into a simple network.
A)True
B)False
Q4) How does a DBMS store data on its direct access files?
Q5) What are tress,simple networks and complex networks?
Q6) What is a set?
To view all questions and flashcards with answers, click on the resource link above. Page 24
Chapter 20: the Semantic Object Model
Available Study Resources on Quizplus for this Chatper
35 Verified Questions
35 Flashcards
Source URL: https://quizplus.com/quiz/35879
Sample Questions
Q1) A version object:
A)may be a composite object.
B)typically contains the archetype object in its identifier.
C)typically is a simple object.
D)produces archetype objects.
E)All of the above.
Q2) The relationship between a parent object and its associated subtype objects is a(n):
A)HAS-A relationship.
B)WANTS-A relationship.
C)NEEDS-A relationship.
D)IS-A relationship.
E)None of the above.
Q3) Explain the differences between the E-R model and the semantic object model.
Q4) A "composite object" cannot contain more than one multivalued attribute.
A)True
B)False
Q5) A "simple object" can contain only simple attributes. A)True B)False
To view all questions and flashcards with answers, click on the resource link above. Page 25
Chapter 21: Getting Started With Web Servers php and the Eclipse PDT
Available Study Resources on Quizplus for this Chatper
35 Verified Questions
35 Flashcards
Source URL: https://quizplus.com/quiz/35881
Sample Questions
Q1) The IIS Web server is automatically installed when the Windows operating system is installed,and no additional steps are necessary to either install or activate it.
A)True
B)False
Q2) For a workstation running the Windows operating system,the additional user file system permissions ________ must be granted to the Users group at the wwwroot folder.
A)Read and Write
B)Modify and Read
C)Modify and Write
D)Read and Execute
E)None of the above is correct.
Q3) When running the Eclipse PDT for the first time,set up a default file workspace named:
A)Eclipse Workspace.
B)EclipsePDT Workspace.
C)Documents.
D)My Documents.
E)My Workspace.
To view all questions and flashcards with answers, click on the resource link above.
Chapter 22: Business Intelligence Systems
Available Study Resources on Quizplus for this Chatper
80 Verified Questions
80 Flashcards
Source URL: https://quizplus.com/quiz/35883
Sample Questions
Q1) What are Business Intelligence (BI)systems?
Q2) A data mart is a collection of data that addresses a particular component of functional area of a business.
A)True
B)False
Q3) In a common form of RFM analysis,a score of 1 is "high" or "good" while a score of 5 is "low" of "bad".
A)True
B)False
Q4) Market basket analysis as described in the text uses the technique of conditional probabilities.
A)True
B)False
Q5) A report that is sent to users on a predetermined schedule is called a push report.
A)True
B)False
Q6) In unsupervised data mining,explanations are created after patterns are found.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 27