Management Information Systems
Final Exam Questions
Course Introduction
Management Information Systems (MIS) explores the strategic role of information technology in business organizations, focusing on the design, implementation, and management of systems that support operational, tactical, and strategic decision-making. The course covers the fundamentals of information systems, database management, enterprise resource planning, e-commerce, and cybersecurity, emphasizing how technology can be leveraged to improve efficiency, enhance communication, and drive innovation. Students will analyze real-world case studies, examine ethical and social issues related to information management, and develop skills to effectively integrate technological solutions with business processes.
Recommended Textbook
Database Systems Design Implementation and Management 13th Edition by Carlos Coronel
Available Study Resources on Quizplus
16 Chapters
1194 Verified Questions
1194 Flashcards
Source URL: https://quizplus.com/study-set/1337 Page 2
Chapter 1: Database Systems
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/26666
Sample Questions
Q1) Which of the following is true of spreadsheet applications?
A) They provide enhanced security and robust data sharing features.
B) They do not allow manipulation of data once entered.
C) They are a better alternative to databases.
D) They enhance the user's ability to understand the data.
Answer: D
Q2) Data anomaly is defined as the condition in which all of the data in the database are consistent with the real-world events and conditions.
A)True
B)False
Answer: False
Q3) _____ is a special language used to represent and manipulate data elements in a textual format.
Answer: XML (Extensible Markup Language)
Extensible Markup Language (XML)
Extensible Markup Language
XML
Q4) _____ is the result of processing raw data to reveal its meaning.
Answer: Information
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/26667
Sample Questions
Q1) The _____ data model is said to be a semantic data model.
A) relational
B) network
C) object-oriented
D) entity relationship
Answer: C
Q2) From a database point of view, the collection of data becomes meaningful only when it reflects properly defined _____.
Answer: business rules
Q3) _____ are important because they help to ensure data integrity.
A) Attributes
B) Entities
C) Relationships
D) Constraints
Answer: D
Q4) In _____, a three-pronged symbol represents the "many" side of the relationship.
Answer: Crow's Foot notation
Q5) In object-oriented terms, a(n) _____ defines an object's behavior.
Answer: method
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/26668
Sample Questions
Q1) An index key can have multiple _____ (a composite index). Answer: attributes
Q2) As rare as 1:1 relationships should be, certain conditions absolutely require their use.
A)True
B)False
Answer: True
Q3) The order of the rows and columns is important to the DBMS.
A)True
B)False
Answer: False
Q4) The row's range of permissible values is known as its domain.
A)True
B)False
Answer: False
Q5) RDBMSs enforce integrity rules automatically.
A)True
B)False Answer: True
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/26669
Sample Questions
Q1) Connectivities and cardinalities are established by concise statements known as business rules.
A)True
B)False
Q2) A(n) _____ is the set of possible values for a given attribute.
A) domain
B) range
C) identifier
D) key
Q3) Explain multivalued attributes with the help of examples. How are multivalued attributes indicated in the Chen Entity Relationship model?
Q4) The Crow's Foot notation depicts the strong relationship with a(n) _____ line between the entities.
Q5) A weak relationship exists if the primary key of the related entity contains at least one primary key component of the parent entity.
A)True
B)False
Q6) _____ are underlined in an ER diagram.
Q7) A(n) _____ relationship is also known as an identifying relationship.
Page 6
To view all questions and flashcards with answers, click on the resource link above.
Chapter 5: Advanced Data Modeling
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/26670
Sample Questions
Q1) Composite keys are useful as identifiers of weak entities, where the weak entity has a strong _____ relationship with the parent entity.
Q2) The _____ depicts the arrangement of higher-level entity supertypes (parent entities) and lower-level entity subtypes (child entities).
A) subtype discriminator
B) inheritance
C) specialization hierarchy
D) entity supertype
Q3) Within a specialization hierarchy, every subtype can have _____ supertype(s) to which it is directly related.
A) zero
B) only one
C) one or many
D) many
Q4) Explain the two criteria that help a designer in determining when to use subtypes and supertypes.
Q5) Specialization is based on grouping _____ characteristics and relationships of the subtypes.
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
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/26671
Sample Questions
Q1) In the context of partial dependencies, data redundancies occur because every row entry requires duplication of data.
A)True
B)False
Q2) What characteristics do tables that conform to the concept of well-informed relations have?
Q3) Normalization works through a series of stages called normal forms. For most purposes in business database design, _____ stages are as high as you need to go in the normalization process.
A) two
B) three
C) four
D) five
Q4) Data warehouse routinely uses _____ structures in its complex, multilevel, multisource data environment.
A) 1NF
B) 2NF
C) 3NF
D) 4NF
To view all questions and flashcards with answers, click on the resource link above. Page 8
Chapter 7: Introduction to Structured Query Language Sql
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/26672
Sample Questions
Q1) A(n) _____ join will select only the rows with matching values in the common attribute(s).
A) natural
B) outer
C) full
D) cross
Q2) A(n) _____ character is a symbol that can be used as a general substitute for other characters or commands.
Q3) Which is a feature of a correlated subquery?
A) The inner subquery executes first.
B) The outer subquery initiates the process of execution in a subquery.
C) The inner subquery initiates the process of execution in a subquery.
D) The outer subquery executes independent of the inner subquery.
Q4) Which comparison operator indicates a value isnot equal?
A) <
B) <=
C) >=
D) <>
Q5) A specialty field in mathematics, known as _____ algebra, is dedicated to the use of logical operators.
9
To view all questions and flashcards with answers, click on the resource link above.
Chapter 8: Advanced Sql
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/26673
Sample Questions
Q1) Just like database triggers, stored procedures are stored in the database.
A)True
B)False
Q2) To remedy the lack of procedural functionality in SQL, and to provide some standardization within the many vendor offerings, the SQL-99 standard defined the use of persistent stored modules.
A)True
B)False
Q3) How are triggers critical to proper database operation and management?
Q4) A(n) _____ is a logical group of database objects, such as tables and indexes, that are related to each other.
Q5) MySQL allows multiple triggering conditions per trigger.
A)True
B)False
Q6) A table can be deleted from the database by using the _____ TABLE command.
A) DROP
B) DELETE
C) MODIFY
D) ERASE
Q7) How can a table be deleted from the database? Provide an example.
To view all questions and flashcards with answers, click on the resource link above. Page 10
Chapter 9: Database Design
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/26674
Sample Questions
Q1) _____ is the process that establishes the need for, and the extent of, an information system.
Q2) During the _____ phase of the Systems Development Life Cycle (SDLC), the hardware, database management system (DBMS) software, and application programs are installed, and the database design is implemented.
A) detailed systems design
B) analysis
C) maintenance
D) implementation
Q3) Because real-world database design is generally done by teams, the database design is probably divided into major components known as _____.
Q4) The advent of very sophisticated application generators and _____ has substantially decreased coding and testing time.
Q5) The first step in _____ is to discover the data element characteristics.
Q6) The primary objective in database design is to create complete, normalized, nonredundant, and fully integrated conceptual, logical, and physical database models.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 11
Chapter 10: Transaction Management and Concurrency Control
Available Study Resources on Quizplus for this Chatper
74 Verified Questions
74 Flashcards
Source URL: https://quizplus.com/quiz/26675
Sample Questions
Q1) The scheduler establishes the order in which the operations within concurrent transactions are executed.
A)True
B)False
Q2) Most multiuser _____ automatically initiate and enforce locking procedures, where all locking information is managed by the lock manager.
Q3) A(n) ______ occurs when a transaction executes a query at time T1, and it runs the same query at same time T2, yielding additional rows that satisfy the query.
Q4) The DBMS uses the information stored in the _____log for a recovery requirement triggered by a ROLLBACK statement, a program's abnormal termination, or a system failure such as a network discrepancy or a disk crash.
Q5) _____ requires that all operations of a transaction be completed.
A) Specificity
B) Atomicity
C) Durability
D) Time stamping
Q6) The _____ interleaves the execution of database operations to ensure serializability.
Page 12
To view all questions and flashcards with answers, click on the resource link above.
Chapter 11: Database Performance Tuning and Query
Optimization
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/26676
Sample Questions
Q1) The _____ segment table space is used for transaction-recovery purposes.
Q2) In alevel _____ RAID, the data and the parity data is striped across separate drives.
Q3) When setting optimizer hints, _____ instructs the optimizer to minimize the overall execution time, that is, to minimize the time it takes to return the total number of rows in the query result set. This hint is generally used for batch mode processes.
A) ALL_ROWS
B) FIRST_ROWS
C) INDEX(P_QOH_NDX)
D) OPTIMIZATION_ROWS
Q4) All transaction management commands are processed during the parsing and execution phases of query processing.
A)True
B)False
Q5) The _____ table space is the most frequently accessed table space and should be stored in its own volume.
Q6) ______ helps provide a balance between performance and fault tolerance.
Q7) A system will perform best when its hardware and software resources are _____.
Q8) List and describe some typical DBMS processes.
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
74 Verified Questions
74 Flashcards
Source URL: https://quizplus.com/quiz/26677
Sample Questions
Q1) Rapid ad hoc data became unnecessary in the quick-response decision-making environment.
A)True
B)False
Q2) A(n) _____ database stores each database fragment at a single site.
A) partially replicated
B) unreplicated
C) fully replicated
D) partitioned
Q3) _____ transparency exists when the end user or programmer must specify the database fragment names but does not need to specify where these fragments are located.
A) Transaction
B) Location
C) Local mapping
D) Fragmentation
Q4) In a distributed database management system (DDBMS), _____ control is used to manage simultaneous data access and ensure data consistency across database fragments.
Q5) Explain the three types of operations defined by the DO-UNDO-REDO protocol.
To view all questions and flashcards with answers, click on the resource link above. Page 14
Chapter 13: Business Intelligence and Data Warehouses
Available Study Resources on Quizplus for this Chatper
74 Verified Questions
74 Flashcards
Source URL: https://quizplus.com/quiz/26678
Sample Questions
Q1) ROLAP and MOLAP vendors are working toward the integration of their respective solutions within a unified decision support framework.
A)True
B)False
Q2) Normalizing fact tables improves data access performance and saves data storage space.
A)True
B)False
Q3) _____ is a measurement of the density of the data held in the data cube and is computed by dividing the total number of actual values in the cube by the total number of cells in the cube.
Q4) _____ are qualifying characteristics that provide additional perspectives to a given fact.
Q5) _____ makes a copy of a table and places it in a different location to improve access time.
Q6) A data warehouse designer must define common business dimensions that will be used by a data analyst to expand a search.
A)True
B)False
Page 15
To view all questions and flashcards with answers, click on the resource link above.
Chapter 14: Big Data and Nosql
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/26679
Sample Questions
Q1) Discuss the need for a Hadoop ecosystem and identify the key components.
Q2) Graph theory is a mathematical and computer science field that models relationships, or edges, between objects called ______.
A) maps
B) scales
C) buckets
D) nodes
Q3) The analysis of data to produce actionable results is feedback loop processing.
A)True
B)False
Q4) A(n) ______ is a process or set of operations in a calculation.
A) algorithm
B) feedback loop
C) stream
D) structure
Q5) A block report is used to let the name node know that the data mode is still available.
A)True
B)False
Q6) WithinHadoop, can transfer data in both directions - into and out of HDFS.
Page 16
To view all questions and flashcards with answers, click on the resource link above.
Chapter 15: Database Connectivity and Web Technologies
Available Study Resources on Quizplus for this Chatper
73 Verified Questions
73 Flashcards
Source URL: https://quizplus.com/quiz/26680
Sample Questions
Q1) Among client-side extensions, _____ is a Microsoft specification for writing programs that run inside the Internet Explorer browser.
A) COBOL
B) ActiveX
C) JavaScript
D) Visor.Net
Q2) What is a server-side extension? Explain.
Q3) Extending the web server functionality implies that the web server and the web-to-database middleware will properly communicate with each other.
A)True
B)False
Q4) ODBC, OLE-DB, and ADO.NET form the backbone of the _____ architecture.
Q5) The effects of bad database design, implementation, and management are magnified in an environment in which the number of transactions is less than one hundred.
A)True
B)False
Q6) XML is used to create _____, or vocabularies for entire industries.
Q7) _____ webpages are at the heart of current generation websites.
Page 17
To view all questions and flashcards with answers, click on the resource link above.
Chapter 16: Database Administration and Security
Available Study Resources on Quizplus for this Chatper
74 Verified Questions
74 Flashcards
Source URL: https://quizplus.com/quiz/26681
Sample Questions
Q1) Within the data security framework, _____ is concerned with keeping data consistent and free of errors or anomalies.
Q2) Testing procedures and standards must already be in place before any application program can be approved for use in the company.
A)True
B)False
Q3) Backups must be clearly identified through detailed descriptions and date information, assuring that the correct backup is used to recover the database.
A)True
B)False
Q4) In the context of Oracle Enterprise Manager, a(n) _____ is a named collection of database access privileges that authorize a user to connect to the database and use its system resources.
Q5) The storage locations for multiple backups must include sites inside and outside the organization.
A)True
B)False
Q6) A(n) _____ physically stores the database's data.
To view all questions and flashcards with answers, click on the resource link above. Page 18