Information Systems
Exam Materials
Course Introduction
Information Systems is a foundational course that explores how organizations use technology to collect, process, store, and distribute information to support decision-making and business operations. The course covers key topics such as the components of information systems, the role of information technology in business strategy, system development life cycles, enterprise applications, data management, cybersecurity, and ethical considerations in the digital age. Through real-world case studies and practical applications, students gain an understanding of how information systems contribute to organizational efficiency, innovation, and competitive advantage.
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) Data constitute the building blocks of information.
A)True
B)False
Answer: True
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) _____ relates to the activities that make the database execute transactions more efficiently in terms of storage and access speed.
A) Performance tuning
B) Database design
C) Query access
D) Database management
Answer: A
Q4) _____ relates to activities that make a database operate more efficiently in terms of storage and access speed.
Answer: Performance tuning
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 uses the concept of inheritance.
A) relational
B) network
C) object-oriented
D) entity relationship
Answer: C
Q2) The relational model is hardware-dependent and software-independent.
A)True
B)False
Answer: False
Q3) A(n) _____ is a collection of similar objects with a shared structure and behavior. Answer: class
Q4) Which of the following types of HDFS nodes stores all the metadata about a file system?
A) Data node
B) Client node
C) Name node
D) Map node
Answer: C
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) Referential _____ dictates that the foreign key must contain values that match the primary key in the related table, or must contain null.
A) integrity
B) uniqueness
C) model
D) attribute
Answer: A
Q2) Date attributes contain calendar dates stored in a special format known as the _____ date format.
A) Epoch
B) calendar
C) Julian
D) logical
Answer: C
Q3) You can think of a table as a persistent representation of a logical relation.
A)True
B)False
Answer: True
Q4) An index key can have multiple _____ (a composite index).
Answer: attributes
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) Participation is _____ if one entity occurrence does not require a corresponding entity occurrence in a particular relationship.
Q2) Ideally, an entity identifier is composed of _____ attribute(s).
A) one
B) two
C) three
D) six
Q3) The decision to store _____ attributes in database tables depends on the processing requirements and the constraints placed on a particular application.
A) multivalued
B) derived
C) single-valued
D) composite
Q4) A weak entity must be _____-dependent.
Q5) Explain multivalued attributes with the help of examples. How are multivalued attributes indicated in the Chen Entity Relationship model?
Q6) In Crow's Foot notation, an optional relationship between entities is shown by drawing a(n) _____ on the side of the optional entity.
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
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/26670
Sample Questions
Q1) Unique values can be better managed when they are _____, because the database can use internal routines to implement a counter-style attribute that automatically increments values with the addition of each new row.
Q2) The property of _____ enables an entity subtype to inherit the attributes and relationships of the supertype.
A) subtype discriminator
B) inheritance
C) specialization hierarchy
D) entity supertype
Q3) A partial completeness constraint is represented by _____.
A) a dotted line
B) two dashed lines
C) a single horizontal line under a circle
D) a double horizontal line over a circle
Q4) Explain the "no change over time" characteristic of a primary key.
Q5) A weak entity in a strong identifying relationship with a parent entity is normally used to represent a(n) _____ that is represented in the data model as two separate entities.
Q6) Differentiate between specialization and generalization.
Page 7
To view all questions and flashcards with answers, click on the resource link above.
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) Of the following normal forms, _____ is mostly of theoretical interest.
A) 1NF
B) 3NF
C) BCNF
D) DKNF
Q2) The price paid for increased performance through denormalization is a larger amount of _____.
Q3) When a table contains only one candidate key, _____ are considered to be equivalent.
A) the 1NF and the 2NF
B) the 3NF and the BCNF
C) the 4NF and the 3NF
D) the BCNF and the DKNF
Q4) A relational table must not contain a(n) _____.
A) entity
B) attribute
C) relationship
D) repeating group
Q5) In the _____, no row may contain two or more multivalued facts about an entity.
Page 8
Q6) Explain normalization and its different forms.
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
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/26672
Sample Questions
Q1) An alias cannot be used when a table is required to be joined to itself in a recursive query.
A)True
B)False
Q2) Most SQL implementations yield case-insensitive searches.
A)True
B)False
Q3) Oracle users can use the Access QBE (query by example) query generator.
A)True
B)False
Q4) SQL is considered difficult to learn; its command set has a vocabulary of more than 300 words.
A)True
B)False
Q5) What is a subquery? What is always executed first?
Q6) Which comparison operator indicates a value isnot equal?
A) <
B) <=
C) >= D) <>
Page 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) The _____ constraint is used to validate data when an attribute value is entered.
A) UNIQUE
B) CASCADE
C) CHECK
D) SET NULL
Q2) The CREATE TABLE command lets you define constraints when you use the CONSTRAINT keyword, known as a(n) _____ constraint.
A) column
B) table
C) index
D) cell
Q3) The most useful feature of PL/SQL blocks is that they let a designer create code that can be named, stored, and executed by the DBMS.
A)True
B)False
Q4) MySQL allows multiple triggering conditions per trigger.
A)True
B)False
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) 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
Q2) When selecting DBMS _____, items to consider include processors, RAM, and disk space.
Q3) _____ is a technique that creates logical representations of computing resources that are independent of the underlying physical computing resources.
A) Normalization
B) Virtualization
C) Specialization
D) Generalization
Q4) _____ allow end users to access the database without being able to download the information from their workstations.
Q5) What are the factors affecting the purchasing decision for DBMS software?
Q6) Explain the concept of logical design and list the steps involved.
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 _____ rule states that only one transaction at a time can own an exclusive lock on the same object.
Q2) A scheduler facilitates data isolation to ensure that two transactions do not update the same data element at the same time.
A)True
B)False
Q3) The _____ isolation level ensures that queries return consistent results.
A) read uncommitted
B) read committed
C) serializable
D) repeatable read
Q4) In the optimistic approach, during the_____ phase, a transaction scans the database, executes the needed computations, and makes the updates to a private copy of the database values.
A) read
B) validation
C) write
D) shared
Page 12
Q5) How does a shared/exclusive lock schema increase the lock manager's overhead?
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) A(n) _____ tablestores the end-user data and the index data in consecutive locations on permanent storage.
Q2) A(n) _____ is good for simple and fast lookup operations based on equality conditions.
Q3) Most current-generation relational DBMSs perform automatic query optimization at the client end.
A)True
B)False
Q4) The _____ analyzes the SQL query and finds the most efficient way to access the data.
Q5) The _____ segment table space is used for transaction-recovery purposes.
Q6) From the performance point of view, _____ databases eliminate disk access bottlenecks.
A) RAID
B) distributed
C) index-organized
D) in-memory
Q8) DBMS query processing has _____ phases. Page 13
Q7) _____ is a measure of the likelihood that an index will be used in query processing.
To view all questions and flashcards with answers, click on the resource link above.
Page 14
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) After an update, the originating DP node sends the changes to the replica nodes to ensure that data is immediately updated, during _____replication.
Q2) Distributed data access was needed to support geographically dispersed business units.
A)True
B)False
Q3) One of the advantages of a distributed database management system (DDBMS) is less danger of a single-_____ failure.
Q4) Performance transparency ensures that the system finds the most cost-effective path to access remote data.
A)True
B)False
Q5) Which propertyof the CAP theorem assumes that all transaction operations take place at the same time in all nodes, as if they were executing in a single-node database?
A) Consistency
B) Partition tolerance
C) Availability
D) Performance transparency
To view all questions and flashcards with answers, click on the resource link above. Page 15
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) Bill Inmon and Chuck Kelley created a set of 12 rules to define a(n) _____.
A) data warehouse
B) multidimensional cube
C) OLAP tool
D) star schema
Q2) _____ is a term used to describe a comprehensive, cohesive, and integrated set of tools and processes used to capture, collect, integrate, store, and analyze data with the purpose of generating and presenting information used to support business decision making.
Q3) _____ are numeric measurements (values) that represent a specific business aspect or activity.
Q4) _____ makes a copy of a table and places it in a different location to improve access time.
Q5) Operational data and decision support data serve the same purpose.
A)True
B)False
Q6) What is data visualization? Name different techniques of data visualization.
Q7) _____ are quantifiable measurements (numeric or scale based) that assess a company's effectiveness or success in reaching its strategic and operational goals.
Page 16
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) For a data set to be considered Big Data, it must display only one of the 3Vs (volume, velocity and variety).
A)True
B)False
Q2) What is NoSQL and what are the major NoSQL approaches (categories)?
Q3) Which of the following is NOT one of the standard NoSQL categories?
A) Document databases
B) Column-oriented databases
C) Graph databases
D) Chart databases
Q4) In agraph database, the representation of a relationship between nodes is called a(n) ______.
Q5) In acolumn family database, a column that is composed of a group of other related columns is called a(n) ______.
Q6) ______databases simply store data with no attempt to understand the contents of the value component or its meaning.
Q7) Discuss NewSQL and what it attempts to do.
Q8) Adatabase model that attempts to provide ACID-compliant transactions across a highly distributed infrastructure is ______.
To view all questions and flashcards with answers, click on the resource link above. Page 17
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) In the ADO.NET framework, the _____ object contains the actual SQL code or a stored procedure call to be run by the database.
A) Command
B) DataReader
C) DataAdapter
D) DataSet
Q2) Which of the following is a characteristic of the XML metalanguage?
A) It is concerned with the way data are displayed.
B) It allows the definition of new tags.
C) You can use the // symbol for entering a comment in the XML document.
D) It can be used as a replacement of HTML.
Q3) ODBC, OLE-DB, and ADO.NET form the backbone of the _____ architecture.
Q4) Database connectivity software is also known as database middleware because it interfaces between the application program and the database.
A)True
B)False
Q5) XML is used to create _____, or vocabularies for entire industries.
Q6) XML tags must be well formed, that is, each opening tag must have a corresponding _____ tag.
Page 18
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) _____ 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
Q2) An enterprise database can be defined as the company's data representation that provides support for all present and expected future operations.
A)True
B)False
Q3) Database administration operations are commonly defined and divided according to the phases of the _____.
A) SLA
B) DBLC
C) SDLC
D) MRA
Q4) The DBA must review the database application design to ensure that transactions are _____, meaning that they mirror real-world events.
To view all questions and flashcards with answers, click on the resource link above.
Page 19