Information Systems
Solved Exam Questions
Course Introduction
Information Systems is a course that explores the fundamental concepts, technologies, and organizational impact of information systems in todays digital era. Students will learn how information systems support business operations, decision-making, and strategic advantage by integrating hardware, software, data management, networking, and human resources. The course examines different types of information systems, such as transaction processing systems, management information systems, and enterprise resource planning, emphasizing their roles in facilitating communication, efficiency, and innovation within organizations. Real-world case studies and practical applications are used to illustrate how information systems drive business success and adapt to changing technological landscapes.
Recommended Textbook
Database Systems Design Implementation and Management 10th Edition by Carlos Coronel
Available Study Resources on Quizplus 15 Chapters
1320 Verified Questions
1320 Flashcards
Source URL: https://quizplus.com/study-set/556
Page 2
Chapter 1: Database Systems
Available Study Resources on Quizplus for this Chatper
70 Verified Questions
70 Flashcards
Source URL: https://quizplus.com/quiz/10359
Sample Questions
Q1) Most decision-support data are based on historical data obtained from ____.
A) operational databases
B) data warehouses
C) enterprise databases
D) workgroup databases
Answer: A
Q2) Corporations use only structured data.
A)True
B)False
Answer: False
Q3) Data and information are essentially the same thing.
A)True
B)False
Answer: False
Q4) A ____ database supports data distributed across several different sites.
A) single-user
B) multiuser
C) centralized
D) distributed
Answer: D
Page 3
To view all questions and flashcards with answers, click on the resource link above.
Chapter 2: Data Models
Available Study Resources on Quizplus for this Chatper
70 Verified Questions
70 Flashcards
Source URL: https://quizplus.com/quiz/10360
Sample Questions
Q1) Data modeling starts with a very complex representation,and as knowledge of the problem is gained,the model is simplified.
A)True
B)False
Answer: False
Q2) In object-oriented terms,a(n)____________________ defines an object's behavior.
Answer: method
Q3) The hierarchical data model was developed in the ____.
A) 1960s
B) 1970s
C) 1980s
D) 1990s
Answer: A
Q4) The ____ data model is said to be a semantic data model.
A) relational
B) network
C) object-oriented
D) entity relationship
Answer: C
Page 4
To view all questions and flashcards with answers, click on the resource link above.
Chapter 3: The Relational Database Model
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/10361
Sample Questions
Q1) Tables must have the same attribute characteristics (the columns and domains must be compatible)to be used in a UNION.
A)True
B)False
Answer: True
Q2) A ____ key is defined as a key that is used strictly for data retrieval purposes.
A) lookup
B) foreign
C) candidate
D) secondary
Answer: D
Q3) In a relational table,each column has a specific range of values known as the ____________________ domain.
Answer: attribute
Q4) The index key can have multiple attributes,this is called a(n)____________________ index.
Answer: composite
Q5) The ____________________ relationship is the relational database norm. Answer: 1:M
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
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/10362
Sample Questions
Q1) The Chen notation identifies the weak entity by using a double-walled entity
Q2) 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
Q3) The DBMS can easily handle multivalued attributes. A)True B)False
Q4) A person's social security number would be an example of a(n)____________________ attribute.
Q5) The relationship ____________________ is difficult to establish if you know only one side of the relationship.
Q6) Storing ____________________ attributes requires constant maintenance.
Q7) A(n)____________________ attribute need not be physically stored within the database.
Q8) You should always load data from the 1 side of a 1:M relationship. A)True B)False
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
70 Verified Questions
70 Flashcards
Source URL: https://quizplus.com/quiz/10363
Sample Questions
Q1) ____ is the bottom-up process of identifying a higher-level,more generic entity supertype from lower-level entity subtypes.
A) Specialization
B) Generalization
C) Partial completeness
D) Total completeness
Q2) When selecting a foreign key placement for a 1:1 relationship,place the PK of the entity on the mandatory side in the entity on the optional side as a FK,and make the FK mandatory when ____.
A) one side is mandatory and the other side is optional
B) one side participates in another relationship
C) both sides are optional
D) both sides are mandatory
Q3) Surrogate primary keys are especially helpful when there is no ____ key.
A) primary
B) natural
C) foreign
D) composite
Q4) In what two cases are composite primary keys particularly useful?
Q5) Describe specialization and generalization.
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
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/10364
Sample Questions
Q1) Normalization represents a micro view of the entities within the ERD.
A)True
B)False
Q2) Atomic attributes are attributes that can be further divided. A)True
B)False
Q3) Converting a database format from 1NF to 2NF is a complex process.
A)True
B)False
Q4) In _________________________,no row may contain two or more multivalued facts about an entity.
Q5) ____ yields better performance.
A) Denormalization
B) Normalization
C) Atomization
D) Compression
Q6) Any attribute whose value determines other values within a row is called a(n)____________________.
Q7) What steps are involved in the conversion to third normal form?
Q8) Describe a dependency diagram and explain its purpose.
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
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/10365
Sample Questions
Q1) Using the ____________________ command,SQL indexes can be created on the basis of any selected attribute.
Q2) An example of a command you would use when making changes to a PRODUCT table is ____.
A) CHANGE PRODUCT
SET P_INDATE = '18-JAN-2004' WHERE P_CODE = '13-Q2/P2';
B) ROLLBACK PRODUCT
SET P_INDATE = '18-JAN-2004' WHERE P_CODE = '13-Q2/P2';
C) EDIT PRODUCT
SET P_INDATE = '18-JAN-2004' WHERE P_CODE = '13-Q2/P2';
D) UPDATE PRODUCT
SET P_INDATE = '18-JAN-2004' WHERE P_CODE = '13-Q2/P2';
Q3) SQL allows the use of logical restrictions on its inquiries such as OR,AND,and NOT. A)True B)False
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
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/10366
Sample Questions
Q1) A(n)____________________ join returns not only the matching rows but also the rows with unmatched attribute values for one or both tables to be joined.
Q2) The ____________________ outer join returns not only the rows matching the join condition (that is,rows with matching values in the common column),but also the rows in the left-side table with unmatched values in the right-side table.
Q3) The ____________________ join is the traditional join in which only rows that meet a given criteria are selected.
Q4) Stored procedures help reduce code duplication by means of code isolation and code sharing.
A)True
B)False
Q5) A(n)____________________ view is a view that can be used to update attributes in the base table(s)that are used in the view.
Q6) The most useful feature of PL/SQL blocks is that they let you create code that can be named,stored,and executed by the DBMS.
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
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/10367
Sample Questions
Q1) The primary objective in database design is to create complete,denormalized,redundant,and fully integrated conceptual,logical,and physical database models.
A)True
B)False
Q2) Installing the DBMS,creating the database,and loading or converting the data are part of the ____ phase of the DBLC.
A) database initial study
B) database design
C) implementation and loading
D) testing and evaluation
Q3) The first step in developing the conceptual model using ER diagrams is to ____.
A) normalize the entities
B) complete the initial ER diagram
C) identify, analyze, and refine the business rules
D) define the attributes, primary keys, and foreign keys for each of the entities
Q4) Making sure that the final product meets user and system requirements is the most critical ____________________ phase.
Q5) What are the classical approaches to database design?
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
70 Verified Questions
70 Flashcards
Source URL: https://quizplus.com/quiz/10368
Sample Questions
Q1) Explain the transaction log.What is its function?
Q2) Durability requires that all portions of the transaction must be treated as a single,logical unit of work in which all operations are applied and completed to produce a consistent database.
A)True
B)False
Q3) ____________________ can take place at any of the following levels: database,table,page,row,or field.
Q4) ____ means that data used during the execution of a transaction cannot be used by a second transaction until the first one is completed.
A) Serializability
B) Atomicity
C) Isolation
D) Time stamping
Q5) The multiuser DBMS must implement controls to ensure serializability and isolation of transactions,in addition to atomicity and durability,in order to guard the database's consistency and integrity.
A)True
B)False
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
70 Verified Questions
70 Flashcards
Source URL: https://quizplus.com/quiz/10369
Sample Questions
Q1) A cost-based optimizer uses a set of preset rules and points to determine the best approach to execute a query.
A)True
B)False
Q2) Good database performance starts with good database design.
A)True
B)False
Q3) ____ is/are the central activity during the parsing phase in query processing.
A) Database statistics
B) Data sparsity
C) SQL query
D) Query optimization
Q4) A DBA determines the initial size of the data files that make up the database;however,as required,the data files can automatically expand in predefined increments known as ____.
A) procedure cache
B) file group
C) data files
D) extends
Page 13
Q5) List and describe some typical DBMS processes.
To view all questions and flashcards with answers, click on the resource link above.
Chapter 12: Distributed Database Management Systems
Available Study Resources on Quizplus for this Chatper
70 Verified Questions
70 Flashcards
Source URL: https://quizplus.com/quiz/10370
Sample Questions
Q1) Both distributed processing and distributed databases require a network to connect all components.
A)True
B)False
Q2) ____ transparency allows a distributed database to be treated as a single logical database.
A) Distribution
B) Transaction
C) Failure
D) Performance
Q3) Distributed database systems do not require complex mechanisms to manage transactions and ensure the database's consistency and integrity.
A)True
B)False
Q4) A remote transaction,composed of several requests,may access data at multiple sites.
A)True
B)False
Q5) A transaction processor is also known as the ____________________ processor.
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
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/10371
Sample Questions
Q1) MDM's main goal is to provide a partial and segmented definition of all data within an organization.
A)True
B)False
Q2) Normalizing fact tables improves data access performance and saves data storage space.
A)True
B)False
Q3) ____________________ use Web-based technologies to present key business performance indicators or information in a single integrated view,generally using graphics in a clear,concise,and easy to understand manner.
Q4) Describe the use of SQL in relation to ROLAP.
Q5) It is a relatively easy task to provide a precise list of characteristics of data-mining tools.
A)True B)False
Q6) Data ____________________ tools are tools that provide advanced statistical analysis to uncover problems and opportunities hidden within business data.
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
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/10372
Sample Questions
Q1) Client-side extensions are available in various forms,such as ____.
A) COBOL
B) Java and JavaScript
C) Visual Basic .NET
D) Visor.Net
Q2) DBMS vendors can publish ____ to facilitate data exchanges and the creation of data views from multiple applications for multiple industries.
A) metadictionaries
B) database support
C) Web pages
D) XML databases
Q3) Which of the following is a client-side extension?
A) ActiveX
B) ODBC
C) SQL*Net
D) TCP/IP
Q4) A(n)____________________ is a unique name by which the data source will be known to ODBC,and therefore,to applications.
Q5) What is JavaScript?
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
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/10373
Sample Questions
Q1) The DBA works with managers to ensure the quality and integrity of database design and transactions.
A)True
B)False
Q2) ____ management is designed to limit access to the database.
A) Authorization
B) User access
C) View
D) DBMS utility
Q3) The DBA's function includes educating the ____________________ in the services provided and how those services enhance data stewardship and data security.
Q4) At the level of middle management,the database must be able to ____.
A) represent and support the company operations as closely as possible
B) deliver the data necessary for tactical decisions and planning
C) produce query results within specified performance levels
D) provide access to external and internal data to identify growth opportunities and to chart the direction of such growth
Q5) A(n)____________________ physically stores the database's data.
Q6) An access ____________________ describes the type of authorized access.
17
To view all questions and flashcards with answers, click on the resource link above.