Information Systems
Mock Exam
Course Introduction
Information Systems is a multidisciplinary course that explores how technology, people, and organizations interact to collect, process, store, and share information. Students learn about the fundamental concepts of information systems, including hardware, software, networks, data management, and cybersecurity. The course examines how information systems support decision-making, streamline business processes, and provide competitive advantages in a rapidly evolving digital landscape. Through theoretical models and practical case studies, students gain insight into system development, the strategic role of IT in organizations, and current trends such as cloud computing, big data, and artificial intelligence.
Recommended Textbook
Database Systems Design Implementation and Management 11th Edition by Carlos Coronel
Available Study Resources on Quizplus
15 Chapters
1318 Verified Questions
1318 Flashcards
Source URL: https://quizplus.com/study-set/1460 Page 2
Chapter 1: Database Systems
Available Study Resources on Quizplus for this Chatper
76 Verified Questions
76 Flashcards
Source URL: https://quizplus.com/quiz/29009
Sample Questions
Q1) To reveal meaning, information requires .
Answer: context
Q2) What are some reasons for studying file systems?
Answer: A brief explanation of the evolution of file system data processing can be helpful in understanding the data access limitations that databases attempt to overcome. Understanding these limitations is relevant to database designers and developers because database technologies do not make these problems magically disappear-database technologies simply make it easier to create solutions that avoid these problems.
Creating database designs that avoid the pitfalls of earlier systems requires that the designer understand these problems and how to avoid them; otherwise, the database technologies are no better (and are potentially even worse!) than the technologies and techniques they have replaced.
Q3) A desktop database is a database.
A) single-user
B) multiuser
C) workgroup
D) distributed
Answer: A
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/29016
Sample Questions
Q1) are important because they help to ensure data integrity.
A) Attributes
B) Entities
C) Relationships
D) Constraints
Answer: D
Q2) In object-oriented terms, a(n) defines an object's behavior.
Answer: method
Q3) The data model is said to be a semantic data model.
A) relational
B) network
C) object-oriented
D) entity relationship
Answer: C
Q4) In , a three-pronged symbol represents the "many" side of the relationship.
Answer: Crow's Foot notation
Q5) The term is used to refer to the task of creating a conceptual data model that could be implemented in any DBMS.
Answer: logical design
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/29017
Sample Questions
Q1) Only a single attribute, not multiple attributes, can define functional dependence. A)True
B)False
Answer: False
Q2) If one department chair-a professor-can chair only one department, and one department can have only one department chair. The entities PROFESSOR and DEPARTMENT exhibit a(n) relationship.
Answer: 1:1
Q3) The one-to-many (1:M) relationship is easily implemented in the relational model by putting the foreign key of the "1" side in the table of the "many" side as a primary key.
A)True
B)False
Answer: False
Q4) The proper use of keys is crucial to controlling data redundancy.
Answer: foreign
Q5) A(n) index is an index in which the index key can have only one pointer value (row) associated with it.
Answer: unique
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/29018
Sample Questions
Q1) are characteristics of entities.
Q2) Knowing the minimum and maximum number of occurrences is very helpful at the application software level.
A) object
B) attribute
C) data
D) entity
Q3) The Crow's Foot notation depicts the strong relationship with a(n) line between the entities.
Q4) What is a weak relationship? Provide an example.
Q5) A(n) attribute is an attribute that must have a value.
Q6) The Crow's foot symbol with two vertical parallel lines indicates cardinality.
A) (0,N)
B) (1,N)
C) (1,1)
D) (0,1)
Q7) Composite attributes make it easier to facilitate detailed queries.
A)True
B)False
Q8) A person's Social Security number would be an example of a(n) attribute.
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
85 Verified Questions
85 Flashcards
Source URL: https://quizplus.com/quiz/29019
Sample Questions
Q1) A is a primary key created by a database designer to simplify the identification of entity instances.
A) composite key
B) compound key
C) natural key
D) surrogate key
Q2) Explain the "no change over time" characteristic of a primary key.
Q3) Explain the two criteria that help a designer in determining when to use subtypes and supertypes.
Q4) An entity cluster is a "virtual" entity type used to represent multiple entities and relationships in the ERD.
A)True
B)False
Q5) Specialization is based on grouping characteristics and relationships of the subtypes.
Q6) At the implementation level, the supertype and its subtype(s) depicted in the specialization hierarchy maintain a 1:1 relationship.
A)True
B)False
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
110 Verified Questions
110 Flashcards
Source URL: https://quizplus.com/quiz/29020
Sample Questions
Q1) Unnormalized tables yield no simple strategies for creating virtual tables known as .
Q2) Dependencies can be identified with the help of a dependency .
Q3) Atomic attributes are attributes that can be further subdivided.
A)True
B)False
Q4) In the context of partial dependencies, data redundancies occur because every row entry requires duplication of data.
A)True
B)False
Q5) For most business transactional databases, we should normalize relations into .
A) 1NF
B) 2NF
C) 3NF
D) 6NF
Q6) Explain the Boyce-Codd normal form (BCNF). How is it related to other normal forms?
Q7) Normalization is a process that is used for changing attributes to entities.
A)True
B)False
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
111 Verified Questions
111 Flashcards
Source URL: https://quizplus.com/quiz/29021
Sample Questions
Q1) The query used to list the P_CODE, P_DESCRIPT, P_INDATE, and P_PRICE fields from the PRODUCT table in ascending order by P_PRICE is .
A) SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE FROM PRODUCT SEQUENCE BY P_PRICE;
B) SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE FROM PRODUCT LIST BY P_PRICE;
C) SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE FROM PRODUCT ORDER BY P_PRICE;
D) SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE FROM PRODUCT ASCENDING BY P_PRICE;
Q2) A(n) is performed when data are retrieved from more than one table at a time.
Q3) A(n) is an alternate name given to a column or table in any SQL statement. A) alias B) data type
C) stored function D) trigger
Q4) The special operator used to check whether a subquery returns any rows is . A) BETWEEN B) EXISTS
C) LIKE D) IN
Q5) The SQL data type DATE stores date in the date format.
To view all questions and flashcards with answers, click on the resource link above. Page 9
Chapter 8: Advanced Sql
Available Study Resources on Quizplus for this Chatper
109 Verified Questions
109 Flashcards
Source URL: https://quizplus.com/quiz/29022
Sample Questions
Q1) Explain the different basic types of join operations. What are they and how do they work?
Q2) A persistent stored module is stored and executed on the database client machine.
A)True
B)False
Q3) The syntax of the DECODE function starts with .
Q4) "Linked SQL" is a term used to refer to SQL statements that are contained within an application programming language such as COBOL, C++, ASP, Java, or ColdFusion.
A)True
B)False
Q5) 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
Q6) The statement can be used to combine rows from two queries, returning only the rows that appear in both sets.
Q7) A(n) subquery is a subquery that executes once for each row in the outer query.
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
103 Verified Questions
103 Flashcards
Source URL: https://quizplus.com/quiz/29023
Sample Questions
Q1) is the first stage in the database design process.
Q2) What are the factors affecting the purchasing decision for DBMS software?
Q3) The goal is to design an enterprise-wide database based on a specific data model but independent of physical-level details.
Q4) After the initial declarations in Database Life Cycle (DBLC), the database designer must carefully probe in order to generate additional information that will help define the problem within the larger framework of company operations.
A)True
B)False
Q5) The database contents are loaded during the phase of the Systems Development Life Cycle (SDLC).
A) analysis
B) detailed systems design
C) implementation
D) maintenance
Q6) The Systems Development Life Cycle (SDLC) is a sequential process rather than an iterative process.
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
85 Verified Questions
85 Flashcards
Source URL: https://quizplus.com/quiz/29010
Sample Questions
Q1) In the optimistic approach, during the phase, changes are permanently applied to the database.
A) read
B) validation
C) write
D) shared
Q2) A lock locks the entire table preventing access to any row by a transaction while another transaction is using the table.
A) database-level
B) table-level
C) page-level
D) row-level
Q3) What are database checkpoints?
Q4) Explain the transaction log. What is its function?
Q5) A field-level lock allows concurrent transactions to access the same row, as long as they require the use of different fields within that row.
A)True
B)False
Q6) What are the three basic techniques to control deadlocks?
To view all questions and flashcards with answers, click on the resource link above. Page 12
Chapter 11: Database Performance Tuning and Query Optimization
Available Study Resources on Quizplus for this Chatper
85 Verified Questions
85 Flashcards
Source URL: https://quizplus.com/quiz/29011
Sample Questions
Q1) is the central activity during the parsing phase in query processing.
A) Clustering
B) Partitioning
C) Query validation
D) Query optimization
Q2) To generate database object statistics manually, following syntax should be used in Oracle: .
A) ANALYZE <TABLE/INDEX> object_name;
B) CREATE <TABLE/INDEX> object_name;
C) ANALYZE <TABLE/INDEX> object_name COMPUTE STATISTICS;
D) CREATE <TABLE/INDEX> object_name COMPUTE STATISTICS;
Q3) The table space is used for transaction-recovery purposes.
A) system
B) user data
C) temporary
D) rollback segment
Q4) Good database performance is easy to evaluate.
A)True
B)False
Q5) helps provide a balance between performance and fault tolerance.
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
83 Verified Questions
83 Flashcards
Source URL: https://quizplus.com/quiz/29012
Sample Questions
Q1) Distributed processing does not require:
A) database processing functions to be distributed to all data storage sites.
B) an existing distributed database.
C) a network of interconnected components.
D) multiple sites to share processing chores.
Q2) Rapid ad hoc data became unnecessary in the quick-response decision-making environment.
A)True
B)False
Q3) The database description, known as the distributed schema, is the common database schema used by local transaction processors (TPs) to translate user requests into subqueries that will be processed by different data processors (DPs).
Q4) In order to manage distributed data, copies or parts of the database processing functions must be distributed to all data storage sites.
A)True
B)False
Q5) Distribution transparency is supported by a distributed data dictionary.
A)True
B)False
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
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/29013
Sample Questions
Q1) A data store is used by data analysts to create queries that access the database.
A)True
B)False
Q2) The schema must support complex (non-normalized) data representations.
A) snowflake
B) online analytical processing
C) decision support database
D) multidimensional database
Q3) The data warehouse development life cycle differs from classical systems development.
A)True
B)False
Q4) can serve as a test vehicle for companies exploring the potential benefits of data warehouses.
A) Data networks
B) Data marts
C) Data cubes
D) OLAPs
Q5) is a read-only database optimized for data analysis and query processing.
To view all questions and flashcards with answers, click on the resource link above. Page 15
Chapter 14: Database Connectivity and Web Technologies
Available Study Resources on Quizplus for this Chatper
85 Verified Questions
85 Flashcards
Source URL: https://quizplus.com/quiz/29014
Sample Questions
Q1) The is the most specialized object in the ADO.NET framework.
A) Command
B) DataReader
C) DataAdapter
D) DataSet
Q2) A document type definition (DTD) can be referenced by many Extensible Markup Language (XML) documents of the same type.
A)True
B)False
Q3) One of the advantages of over other middleware is that it requires no configuration on the client side.
A) ODBC
B) JDBC
C) OLE-DB
D) ADO.NET
Q4) ODBC works on the operating system.
A) Kronos
B) UNIX
C) Windows
D) Mac
To view all questions and flashcards with answers, click on the resource link above. Page 16
Chapter 15: Database Administration and Security
Available Study Resources on Quizplus for this Chatper
86 Verified Questions
86 Flashcards
Source URL: https://quizplus.com/quiz/29015
Sample Questions
Q1) Coordinating, monitoring, and allocating database administration resources is included in a DBA's role.
A) operative
B) arbitration
C) technical
D) managerial
Q2) In the context of the Oracle Enterprise Manager, a(n) is a named collection of database access privileges that authorize a user to connect to the database and use the database system resources.
A) license
B) role
C) profile
D) quota
Q3) The DBA is responsible for ensuring that the data are distributed to the right persons, at the right time, and in the right format.
A)True
B)False
Q4) Explain conflict and problem resolution as part of the DBA's end-user support services.
To view all questions and flashcards with answers, click on the resource link above. Page 17