Information Systems
Exam Solutions
Course Introduction
Information Systems is an interdisciplinary course that explores the development, management, and utilization of information technology to support organizational operations, decision-making, and competitive advantage. Students will learn about core concepts such as systems analysis and design, database management, networking, and cybersecurity, alongside the strategic roles information systems play in various industries. The course emphasizes both the technical and managerial aspects of information systems, equipping students with practical skills to analyze business requirements, implement technological solutions, and understand the ethical and societal impacts of digital transformation in modern organizations.
Recommended Textbook
Database Design Application Development and Administration 3rd Edition by Michael Mannino
Available Study Resources on Quizplus
17 Chapters
1294 Verified Questions
1294 Flashcards
Source URL: https://quizplus.com/study-set/3249
Page 2
Chapter 1: Introduction to Database Management
Available Study Resources on Quizplus for this Chatper
76 Verified Questions
76 Flashcards
Source URL: https://quizplus.com/quiz/64545
Sample Questions
Q1) Which of the following assertions is not true about DBMS market domination?
A) Oracle dominates the Unix environment
B) DB2 dominates the IBM mainframe environment
C) Open source DBMS products have begun to challenge the commercial DBMS products at the high end of the enterprise DBMS market.
D) Microsoft Access dominates the desktop environment
Answer: C
Q2) The goal of information resource management is to use information technology as a tool for processing,distributing,and integrating information for isolated functions within an organization.
A)True
B)False
Answer: False
Q3) Which database user is the most capable to make an unplanned use of a database?
A) Indirect user
B) Parametric user
C) Power user
D) Either an indirect user or a parametric user
Answer: C
To view all questions and flashcards with answers, click on the resource link above. Page 3
Chapter 2: Introduction to Database Development
Available Study Resources on Quizplus for this Chatper
76 Verified Questions
76 Flashcards
Source URL: https://quizplus.com/quiz/64544
Sample Questions
Q1) Which of the following is independent of the choice of a DBMS?
A) Entity Relationship Diagrams
B) Distribution Schema
C) Internal Schema
D) Index files
Answer: A
Q2) The __________________ strategy,which breaks a large problem into many smaller problems,is one way to manage complexity in database design.
Answer: divide-and-conquer
Q3) Entity Relationship Diagrams are input to the following phase of Database Development:
A) Physical Database Design
B) Conceptual Data Modeling
C) Logical Database Design
D) Distributed Database Design
Answer: C
Q4) In the traditional systems development life cycle,the __________________________ phase produces a problem statement and a feasibility study.
Answer: preliminary investigation
Page 4
To view all questions and flashcards with answers, click on the resource link above.
Chapter 3: The Relational Data Model
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/64543
Sample Questions
Q1) The relationship connecting Employee to Department and expressing that an employee belongs to a department (foreign key Empdeptno)is:
A) 1-M from Employee to Department
B) 1-M from Department to Employee
C) M-N
D) Self-referencing
Answer: B
Q2) The _______ part of a table consists of the table name and the column names.The ______ body shows the rows of the table.
A) Body, heading
B) Heading, body
C) Heading, context store
D) Hyper data, body
Answer: B
Q3) The referential integrity rule prohibits foreign keys to have null values.
A)True
B)False
Answer: False
To view all questions and flashcards with answers, click on the resource link above. Page 5
Chapter 4: Query Formulation With SQL
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/64542
Sample Questions
Q1) One way to formulate joins is the ________________________,which lists tables in the FROM clause and join conditions in the WHERE clause.
Q2) The execution of the ORACLE SQL command SELECT * FROM RENTALS
WHERE Date_Out BETWEEN '01-AUG-1994' AND '31-DEC-1994'
Will produce the following number of rows:
A) 1
B) 2
C) 3
D) 4
Q3) You cannot use an expression in the list of columns of a SELECT statement. A)True
B)False
Q4) In SELECT statements,the _______________ keyword is used to specify conditions to be matched for inclusion in the result table.
Q5) In the _______________ usage context of SQL,an executing program submits SQL statements and the DBMS sends the results of the statements back to the program.
Q6) SQL is an acronym for ___________________________.
To view all questions and flashcards with answers, click on the resource link above. Page 6
Chapter 5: Understanding Entity Relations
Available Study Resources on Quizplus for this Chatper
76 Verified Questions
76 Flashcards
Source URL: https://quizplus.com/quiz/64541
Sample Questions
Q1) A relationship that involves more than two entity types is called a(n)__________________ relationship.
Q2) If we want to indicate that the authors of a book have conceived it when visiting another author in some country,the usual symbol used in the Chen ERD notation would be:
A) A relationship connecting Book, Country, and Author
B) An associative entity type connecting to Book and Country
C) Three binary relationships connecting pairwise Book, Country, and Author
D) Two binary relationships connecting Book and Country, and Book and Author
Q3) In Crow's Foot notation,the Crow's Foot (two angled lines and one straight line)means a cardinality of ______________.
Q4) If we want to add the relationship "Published-in" between Book and Country,it would be:
A) M-N
B) 1-1
C) 1-M
D) M-way
Q5) A 1-M relationship cannot have any attributes.
A)True
B)False
Page 7
To view all questions and flashcards with answers, click on the resource link above.
Chapter 6: Developing Data Models for Business Databases
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/64540
Sample Questions
Q1) Assuming that we use the rule(s)that avoid null values in tables,the table AUTHOR obtained in converting the ERD diagram to a relational database will have the following number of attributes:
A) 2
B) 3
C) 4
D) 5
Q2) To avoid null values in foreign keys,an optional 1-M relationship can be converted to a separate table.
A)True
B)False
Q3) Assuming that we do not use the rule(s)that avoid null values in tables in converting the ERD diagram to a relational database,Deptno appears as a foreign key the following number of times:
A) 3
B) 4
C) 5
D) 6
To view all questions and flashcards with answers, click on the resource link above.
8
Chapter 7: Normalization of Relational Tables
Available Study Resources on Quizplus for this Chatper
76 Verified Questions
76 Flashcards
Source URL: https://quizplus.com/quiz/64539
Sample Questions
Q1) Which of the following is not one of the modification anomalies discussed in the text:
A) an update anomaly
B) a write anomaly
C) a deletion anomaly
D) an insertion anomaly
Q2) When you can conclude that object A is related to object C because A is related to object B and B is related to C,this is an example of a(n)____________________.
Q3) Like 4NF,5NF also applies to M-way relationships.
A)True
B)False
Q4) The following is a transitive functional dependency in the table STUDENTC:
A) Name -> Minor
B) Name -> Major
C) Major -> Minor
D) All of the above
Q5) When deletion of one row in a table inadvertently causes other data to be deleted,this would be called a(n)____________________.
Q6) A table is said to be in ___________ if every determinant is a candidate key.
To view all questions and flashcards with answers, click on the resource link above. Page 9
Chapter 8: Physical Database Design
Available Study Resources on Quizplus for this Chatper
76 Verified Questions
76 Flashcards
Source URL: https://quizplus.com/quiz/64538
Sample Questions
Q1) In hash files,if a collision occurs because two keys hash to the same physical address,one method for locating a physical record with free space is a linear probe.
A)True
B)False
Q2) Query binding:
A) Saves the access plan selected for a query
B) Reduces optimization time
C) May be changed if table profiles change
D) All of the above
Q3) Each node of the B-tree can contain at most 4 keys.After inserting into the B-tree a record with key = 62 and a record with key = 85,the B-tree will have the following number of nodes (including the root):
A) 3
B) 4
C) 5
D) 6
Q4) One of the inputs to the physical database design is the _________________,which are statistics for each table such as the number of rows and unique column values.
To view all questions and flashcards with answers, click on the resource link above. Page 10
Chapter 9: Advanced Query Formulation With SQL
Available Study Resources on Quizplus for this Chatper
74 Verified Questions
74 Flashcards
Source URL: https://quizplus.com/quiz/64537
Sample Questions
Q1) When performing a grouping operation,the SQL standard specifies that all rows with null values are grouped together. A)True B)False
Q2) A nested query in which the inner query does not reference any tables in the outer query is a(n)__________________.
Q3) SELECT DISTINCT CNAME,AGE FROM CUSTOMER WHERE CID NOT IN (SELECT CID FROM RENTALS)
This query is NOT equivalent (order ignored)to the following query:
A) SELECT DISTINCT CNAME, AGE FROM CUSTOMER, RENTALS WHERE CUSTOMER.CID <> RENTALS.CID
B) SELECT DISTINCT CNAME, AGE FROM CUSTOMER WHERE 0 IN (SELECT COUNT(*) FROM RENTALS
C) SELECT DISTINCT CNAME, AGE FROM CUSTOMER WHERE 0 = (SELECT COUNT(*) FROM RENTALS WHERE CUSTOMER.CID = RENTALS.CID)
D) SELECT DISTINCT CNAME, AGE FROM CUSTOMER WHERE NOT EXISTS (SELECT CID FROM RENTALS
To view all questions and flashcards with answers, click on the resource link above.
11
Chapter 10: Application Development With Views
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/64536
Sample Questions
Q1) (Access)Which of the following statements is true?
A) Data in RENTALS may be updated, using an UPDATE command on View3
B) Data in CUSTOMER may be updated, using an UPDATE command on View3
C) Data in RENTCOST may be updated, using an UPDATE command on View3
D) All of the above
Q2) Typically in a hierarchical form,data in the main form may be non-updatable.
A)True
B)False
Q3) In a 1-M updatable query,you cannot insert a row into the parent table without also inserting a corresponding row into the child table.
A)True
B)False
Q4) A view that can be used only in SELECT statements is a(n)______________________.
Q5) Typically in a hierarchical form,the data from the two 1-M tables shown on the main form and the subform would be the result of executing a join query on the two tables for a specific value of the foreign key.
A)True
B)False
Q6) The fixed part of a hierarchical form is known as the __________________.
Page 12
To view all questions and flashcards with answers, click on the resource link above.
Chapter 11: Stored Procedures and Triggers
Available Study Resources on Quizplus for this Chatper
76 Verified Questions
76 Flashcards
Source URL: https://quizplus.com/quiz/64535
Sample Questions
Q1) Because the SQL:1999 trigger specification was defined in response to vendor implementation,most trigger implementations adhere to the SQL:1999 specification.
A)True
B)False
Q2) A trigger execution procedure can be affected by which of the following?
A) The DBMS the triggers are executed on.
B) The type of data manipulation statements specified in a trigger.
C) Foreign key constraints on referenced rows.
D) All of the above.
Q3) Like procedures,triggers can be tested directly by executing them in SQL*Plus.
A)True
B)False
Q4) In a stored procedure,a(n)_____________ parameter should have a value provided outside the procedure but it can be changed inside the procedure.
Q5) A _____________________ is a procedural language with an interface to one or more DBMSs.
Q6) An event-condition-action rule managed by a DBMS is another name for a
Q7) A ______________ can be implicit or explicit.
Page 13
To view all questions and flashcards with answers, click on the resource link above.
Chapter 12: View Design and Integration
Available Study Resources on Quizplus for this Chatper
76 Verified Questions
76 Flashcards
Source URL: https://quizplus.com/quiz/64534
Sample Questions
Q1) When adding relationships in the fourth step of form analysis,after you identify the form entity type,you should add 1-M relationships with the other entity types derived from fields in the main form.
A)True
B)False
Q2) In view design,an ERD representing a form is the output of the __________________ process.
Q3) In a typical integration strategy,parallel integration is applied to the ERDs that have resulted from integrating view subsets,in order to produce a final,integrated ERD for the database.
A)True
B)False
Q4) Conflicts arising from different uses of fields and timing differences are resolved sooner in the _____________ approach to view integration.
Q5) In a large database development effort,the process of constructing an ERD for each group of users is called ____________________.
Q6) The complexity of an individual database can be measured by the size of its
To view all questions and flashcards with answers, click on the resource link above. Page 14
Chapter 14: Data and Database Administration
Available Study Resources on Quizplus for this Chatper
76 Verified Questions
76 Flashcards
Source URL: https://quizplus.com/quiz/64533
Sample Questions
Q1) Two forms of authorization controls are _________ and ____________?
A) Discretionary Access Control / Mandatory Access Control
B) Public key / Private key
C) Primary key / Foreign key
D) Internal Access Control / External Access Control
Q2) Often the level of data quality that is sufficient for business operations meets or exceeds the level necessary for upper management decision making.
A)True
B)False
Q3) A(n)___________________ database directly supports the major,daily functions of an organization.
Q4) Inconsistency of customer names across operational databases typically would negatively affect the decision making of:
A) Strategic management
B) Tactical management
C) Operational management
D) Low level management
Q5) Data that describes the source,use,value,and meaning of other data is known as ______________.
To view all questions and flashcards with answers, click on the resource link above. Page 15
Chapter 15: Transaction Management
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/64532
Sample Questions
Q1) A(n)______________________ is a collection of operations that must be processed reliably as a single unit of work.
Q2) In designing a hierarchical form,the best choice for the transaction boundary would be to treat the main form as one transaction and each subform line as separate transactions.
A)True
B)False
Q3) Name three types of inconsistent retrievals:
Q4) Which one of the following isolation levels does not prevent the scholar's lost update problem?
A) Read committed
B) Read uncommitted
C) Repeatable read
D) Serializable
Q5) The decision made by a transaction designer as to how a collection of SQL statements is divided into one or more transactions is known as the _______________________.
Q6) A type of lock usually used on a large database item,such as a table,to alleviate blocking when locking coarse items is called a(n)_________________.
Page 16
To view all questions and flashcards with answers, click on the resource link above.
Chapter 16: Data Warehouse Technology and Management
Available Study Resources on Quizplus for this Chatper
78 Verified Questions
78 Flashcards
Source URL: https://quizplus.com/quiz/64531
Sample Questions
Q1) ______________ is the process of discovering implicit data patterns in the data of a data warehouse,and using those patterns for business advantage.
Q2) The ATTRIBUTE clause:
A) Defines a functional dependency between a dimension level and a non-source column
B) Specifies a constraint of the dimension
C) Both of the above
D) None of the above
Q3) One of the decision support operations that can be performed on a data cube is the _______________ operation,which rearranges the dimensions in a data cube so that the data can be presented in a more visually appealing order.
Q4) We want to have the data for the past five years in Table1.This would require:
A) Adding one column
B) Adding one column and 3 rows
C) Adding one column and 15 rows
D) Adding one column and more than 15 rows
Q5) In refreshing a data warehouse,________________ change data involves files that record changes or other user activity.
Page 17
To view all questions and flashcards with answers, click on the resource link above.
Chapter 17: Client-Server Processing and Distributed Databases
Available Study Resources on Quizplus for this Chatper
76 Verified Questions
76 Flashcards
Source URL: https://quizplus.com/quiz/64530
Sample Questions
Q1) Which of the following is one of the types of client server architectures discussed?
A) two-tier architecture
B) three-tier architecture
C) web services architecture
D) hyper object broker architecture
Q2) In distributed transaction processing,transactions do not necessarily have to conform to all of the ACID properties that non-distributed transactions do.
A)True
B)False
Q3) Some of the disadvantages of distributed data are increased data duplication,a higher complexity of database design,and a higher complexity of providing security for data distributed among multiple sites.
A)True
B)False
Q4) In a distributed DBMS environment,the ______________________ optimizes query execution across sites,coordinates concurrency control and recovery across sites,and controls access to remote data.
To view all questions and flashcards with answers, click on the resource link above. Page 18
Chapter 18: Object Database Management Systems
Available Study Resources on Quizplus for this Chatper
83 Verified Questions
83 Flashcards
Source URL: https://quizplus.com/quiz/64529
Sample Questions
Q1) A new kind of DBMS in which both the data model and the kernel have been changed to accommodate objects is a(n)_________________________.
Q2) A(n)______________ definition is a collection of variables and methods.
Q3) Oracle 9i follows the SQL:1999 standard in supporting row types,subtables and typed tables.
A)True
B)False
Q4) There is a request to delete the only row with value bp = 50 from table Tb.Which of the following statements is true?
A) This row is deleted from table Tb and no rows are deleted from the other tables
B) This row is deleted from table Tb and one row is deleted from table Ta and no rows may be deleted from table Tc
C) This row is deleted from table Tb and one row is deleted from table Ta and one row may be deleted from table Tc
D) This request may not be satisfied
Q5) An architecture that uses a dedicated server to manage complex data outside of a database is called ______________________________.
To view all questions and flashcards with answers, click on the resource link above.
Page 19