Information Systems
Test Questions
Course Introduction
Information Systems explores the design, implementation, management, and impact of systems that manage and process information within organizations. The course examines the ways in which hardware, software, data, people, and processes interact to improve organizational effectiveness and decision-making. Students will learn about key concepts such as databases, networks, enterprise systems, and cybersecurity, alongside the ethical, social, and strategic considerations of information systems in contemporary businesses. The course also covers trends in digital transformation and the integration of information systems to drive innovation and competitive advantage.
Recommended Textbook
Database Systems Introduction to Databases and Data Warehouses 1st Edition by Nenad Jukic
Available Study Resources on Quizplus
10 Chapters
752 Verified Questions
752 Flashcards
Source URL: https://quizplus.com/study-set/3126
Page 2
Chapter 1: Introduction
Available Study Resources on Quizplus for this Chatper
57 Verified Questions
57 Flashcards
Source URL: https://quizplus.com/quiz/61941
Sample Questions
Q1) Analytical databases collect and present operational information in support of daily operational procedures and processes.
A)True
B)False
Answer: False
Q2) Which of the following is a format in which data can appear?
A)Text
B)Numbers
C)Image
D)All of the above
Answer: D
Q3) Front-end applications are created in order to provide a mechanism for easy interaction between the database and the DBMS.
A)True
B)False
Answer: False
To view all questions and flashcards with answers, click on the resource link above.
Page 3
Chapter 2: Database Requirements and ER Modeling
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/61942
Sample Questions
Q1) A relationship attribute of a M:N relationship cannot be assigned to either of the entities involved in that relationship.
A)True
B)False
Answer: True
Q2) In the ER Diagram for the SUNSHINE AIRLINE COMPANY,which word should replace BBB?
A)AirplaneTypeID
B)AIRPLANETYPE
C)AirportID
D)AIRPORT
Answer: D
Q3) An M:N relationship that can have multiple occurrences between the same instances of involved entities can be depicted as a:
A)Weak entity with one owner
B)Multivalued composite attribute
C)Unary M:N relationship
D)Weak entity with two owners
Answer: D
To view all questions and flashcards with answers, click on the resource link above.
Page 4
Chapter 3: Relational Database Modeling
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/61943
Sample Questions
Q1) What is a business rule?
Answer: A business rule is a user-defined constraint that specifies restrictions on resulting databases that are not a part of the standard notation for creating ER diagrams.
Q2) The relation resulting from mapping a weak entity (with a 1:M identifying relationship)has a composite primary key that is composed of the partial identifier and a foreign key corresponding to the primary key of the owner entity.
A)True
B)False
Answer: True
Q3) What is a primary key?
Answer: Primary key is a column (or a set of columns)whose value is unique for each row.Primary keys cannot have null values.If there are multiple columns (or sets of columns)that have unique values in each row,one of them is designated as a primary key.Each relation must have a primary key.
Q4) What is a relational database a collection of?
Answer: A relational database is a collection of related relations within which each relation has a unique name.
To view all questions and flashcards with answers, click on the resource link above.
Page 5
Chapter 4: Update Operations, update Anomalies, and Normalization
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/61944
Sample Questions
Q1) Table STUDENT is in 2NF.
A)True
B)False
Q2) Functional dependency Make --> Type exists in the table VEHICLE.
A)True
B)False
Q3) Attempting to insert a new vehicle 666,Car,Ford in the table VEHICLE will cause an occurrence of an insertion anomaly.
A)True
B)False
Q4) If A --> B is an existing functional dependency,which of the following is an augmented functional dependency?
A)A,B --> C
B)A,C --> B
C)A --> C
D)B --> A
Q5) Give a definition of 1NF.
Q6) When does a partial functional dependency occur?
Q7) Which three operations are collectively referred to as update operations?
Q8) When does a full key functional dependency occur? Page 6
To view all questions and flashcards with answers, click on the resource link above.
Page 7
Chapter 5: SQL
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/61945
Sample Questions
Q1) What is the result of the following SQL query?
SELECT ename,esalary * 1.1 FROM employee;
A)For each employee,the query will display the name,the salary,and all other columns from the table employee
B)For each employee,the query will display the name,the salary,all other columns from the table employee,and the number 1.1
C)For each employee,the query will display the name and the salary increased by 10%
D)For each employee,the query will display the name and 10% of the salary
Q2) Show the INSERT INTO statements for the table VEHICLE.
Q3) The following query on table VEHICLE will return 2 values:
SELECT DISTINCT ownerid,ownername FROM vehicle;
A)True
B)False
Q4) What will be retrieved by the following query on the table CLIENT?
SELECT DISTINCT clientname FROM client WHERE clientspousename = 'Amy';
A)Name Amy twice
B)Name Amy
C)Name Cole
D)Names Andy and Cole
To view all questions and flashcards with answers, click on the resource link above. Page 8
Chapter 6: Database Implementation and Use
Available Study Resources on Quizplus for this Chatper
55 Verified Questions
55 Flashcards
Source URL: https://quizplus.com/quiz/61946
Sample Questions
Q1) Show the SQL statement that will for HAPPY INSURANCE database create and index on the ClientName column of the table CLIENT.
Q2) If the office worker inserts the record below into the table CURRENTLY ENROLLED STUDENTS,which problem will occur? (Assume that all the dates in the record below are correct. )
\(\begin{array}{|l|l|c|c|l|l|c|c|ll| }
\hline200705& \text {MeCormick } & \text { Chris}& \text {Chcoormickc@arcedu}&11.10 .1992 &1.1.2010.&1.1.2014.& \text {Chicago}& \text {USA} \\ \hline
\end{array}\)
A)Accuracy
B)Uniqueness
C)Conformity
D)No data quality problem with this record
Q3) What are corrective data quality actions?
Q4) Describe the delete restrict option (for implementing a referential integrity constraint).
Q5) What are preventive data quality actions?
To view all questions and flashcards with answers, click on the resource link above. Page 9
Chapter 7: Data Warehousing Concepts
Available Study Resources on Quizplus for this Chatper
48 Verified Questions
48 Flashcards
Source URL: https://quizplus.com/quiz/61947
Sample Questions
Q1) Show a diagram that illustrates the principal activities in the process of the development of the data warehouse.
Q2) Implicit changes of data warehouse requirements are permitted during:
A)Data warehouse use
B)Data warehouse deployment
C)Creating ETL infrastructure
D)Implicit changes of requirements are not permitted
Q3) What is the difference between a typical (regular)data warehouse and an active data warehouse?
Q4) A data warehouse is created within an organization as a separate data store whose primary purpose is data analysis.
A)True
B)False
Q5) Explain the term integrated in the following data warehouse definition: The data warehouse is a structured repository of integrated,subject-oriented,enterprise-wide,historical,and time-variant data.The purpose of the data warehouse is the retrieval of analytical information.A data warehouse can store detailed and/or summarized data.
Q6) Describe the data warehouse deployment step.
To view all questions and flashcards with answers, click on the resource link above. Page 10
Chapter 8: Data Warehouse and Data Mart Modeling
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/61948
Sample Questions
Q1) Independent data marts approach can be used for designing an enterprise-wide analytical data warehouse.
A)True
B)False
Q2) The CUSTOM SPA DAILY VISITS DATABASE column AmountCharged provides the data for a dimension in the STATEWIDE HEALTH star schema.
A)True
B)False
Q3) Based on the data shown in the STATEWIDE HEALTH PRESCRIPTIONS DATABASE,the dimension MEDICATION in the STATEWIDE HEALTH star schema has ________ records.
A)0 (the dimension MEDICATION does not exist)
B)2
C)3
D)5
Q4) Normalized data warehouse approach results in multiple unrelated ETL infrastructures.
A)True
B)False
Q5) What do timestamps indicate in slowly changing dimensions?
To view all questions and flashcards with answers, click on the resource link above. Page 11
Chapter 9: Data Warehouse Implementation and Use
Available Study Resources on Quizplus for this Chatper
50 Verified Questions
50 Flashcards
Source URL: https://quizplus.com/quiz/61949
Sample Questions
Q1) Updating,querying,and presenting data from databases for operational purposes is known as:
A)ETL
B)OLAP
C)OLTP
D)Micro batches
Q2) Illustrate a typical ROLAP architecture.
Q3) A user using an OLAP query (based on the dimensionally modeled data set that contains the Generic Retailer dimension PRODUCT)can drill down from ProductBrandID to ProductID.
A)True
B)False
Q4) In the case of so-called active data warehouses,the loads occur in ________ that happen continuously,ensuring that the data in the data warehouse is updated close to real time (enabling analysis of the latest data).
A)Dimensional modeling actions
B)OLAP actions
C)OLTP actions
D)Micro batches
Q5) What is a refresh load?
12
To view all questions and flashcards with answers, click on the resource link above.
Chapter 10: Overview of Dbms Functionalities and Database
Administration
Available Study Resources on Quizplus for this Chatper
42 Verified Questions
42 Flashcards
Source URL: https://quizplus.com/quiz/61950
Sample Questions
Q1) Regular monitoring helps the DBA recognize instances when maintenance activities are needed.
A)True
B)False
Q2) The data dictionary created by the ________ is often referred to as the catalog.
A)TCL
B)DML
C)DCL
D)DBMS
Q3) What number will the following query in the HAPPY INSURANCE database return?
SELECT count (DISTINCT column_name)
FROM user_tab_columns;
A)2
B)3
C)10
D)13
Q4) The data manipulation DBMS component uses the SQL commands from the DCL category.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 13