Information Management Test Preparation
Course Introduction
Information Management explores the principles, practices, and technologies involved in the effective collection, organization, storage, retrieval, and use of information within organizations. The course covers key topics such as data governance, information systems, database management, information security, and the role of information in decision-making. Students will examine methods for ensuring data quality, privacy, and compliance with legal and ethical standards, as well as the challenges presented by big data and digital transformation. Emphasis is placed on the strategic value of information assets and the skills needed to manage information resources effectively in a rapidly evolving technological landscape.
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 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) If an M:N relationship is mandatory on both sides,and if both relations resulting from the entities involved in the relationship each have 3 records,then the resulting bridge relation cannot have less than ________ records.
A)0
B)1
C)3
D)9
Answer: C
Q2) 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.
Q3) Autonumber data type option:
A)Automatically converts the existing data type into a number type
B)Assigns a number to each of the used data types
C)Enables automatic generation of consecutive numeric data values in a column
D)Enables automatic counting of columns in a table
Answer: C
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) What type of functional dependency exists in the table DOCTOR?
A)Trivial
B)Partial
C)Transitive
D)All of the above
Q2) If A,B,C,and D are columns of the table whose composite primary key is A,B while C and D are nonkey columns then B --> C is a partial functional dependency.
A)True
B)False
Q3) Which of the following (regarding the relation ENROLLMENT)represents the insertion anomaly?
A)Inability to insert a student without adding a class
B)Inability to insert a class without adding a student
C)Inability to insert a class name without a class ID
D)Inability to insert a student name without a student ID
Q4) List the types of update anomalies?
Q5) Trivial functional dependency exists in the table VEHICLE.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 6
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) Which of the following statements would be used to drop a column from the table?
A)CREATE TABLE
B)ALTER TABLE
C)DROP TABLE
D)UPDATE
Q2) What is a nested query?
Q3) 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
Q4) When is the IS NULL comparison used?
Q5) The following query on table VEHICLE will return 4 values:
SELECT type FROM vehicle;
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 7
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) 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
Q2) What is the purpose of an index?
Q3) What is a trigger?
Q4) Using an input mask such as DD/MM/YYYY for entry of a date value is an example of a corrective data quality action.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 8
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) Data warehouse front-end applications are often referred to as business intelligence (BI)applications.
A)True
B)False
Q2) What is an independent data mart?
Q3) A data mart is a data store based on the same principles as a data warehouse but with a wider scope.
A)True
B)False
Q4) What is a dependent data mart?
Q5) The operational data sources include the data warehouses and data marts. A)True
B)False
Q6) In contrast to a narrow constituency of operational data,analytical data is used by a widespread set of users.
A)True
B)False
Q7) Describe the data redundancy difference between operational and analytical database systems.
To view all questions and flashcards with answers, click on the resource link above. Page 9
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) The CUSTOM SPA star schema contains the dimension PROCEDURE.
A)True
B)False
Q2) What are conformed dimensions?
Q3) What is represented by each row in a transaction-level detailed fact table?
Q4) The ER modeling and dimensional modeling methods cannot be combined and used within the same data warehousing project.
A)True
B)False
Q5) The detailed fact table in the STATEWIDE HEALTH star schema has ________ records.
A)0
B)5
C)9
D)82
Q6) The detailed fact table in the CUSTOM SPA star schema has ________ records.
A)0
B)5
C)8
D)50
To view all questions and flashcards with answers, click on the resource link above. Page 10
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) Data cleansing is a part of:
A)OLAP
B)Extraction
C)Transformation
D)Load
Q2) What is an executive dashboard?
Q3) What is the multidimensional database model?
Q4) The purpose of the drill down operation is to make the granularity of the data in the query result finer.
A)True
B)False
Q5) OLAP tools are:
A)Write-only tools
B)Read-only tools
C)Read and write tools
D)Read,write,and delete tools
Q6) The process of transformation cannot involve standardizing different versions of the same data present in different data sources.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 11
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) The application development component provides functionalities to the developers of:
A)Database models
B)Security and backup procedures
C)Data dictionaries
D)Front-end applications
Q2) If,during the use of the database system,it becomes apparent that a new relation needs to be added to the database,the decision to add the new relation to the database will rest with the:
A)Database developer
B)DBA
C)End user
D)DBMS software developer
Q3) What is the difference between accidental misuse and malicious data updates?
Q4) What is update failure?
Q5) What is the purpose of the data administration component of a DBMS?
Q6) What is a checkpoint?
A)True Page 12
Q7) The data definition DBMS component uses the SQL commands from the DDL category.
To view all questions and flashcards with answers, click on the resource link above.
Page 13