Data Warehousing Review Questions
Course Introduction
Data Warehousing is a course designed to introduce students to the fundamental concepts, architectures, and implementation strategies of data warehouses. The course emphasizes the process of designing, building, and managing large-scale repositories that aggregate data from multiple sources for efficient analytical querying and reporting. Students will explore data modeling techniques such as star and snowflake schemas, ETL (Extract, Transform, Load) processes, and OLAP (Online Analytical Processing) operations. Through practical exercises and case studies, learners gain hands-on experience with data warehousing tools and platforms, understanding how data warehouses support business intelligence, data mining, and decision-making in organizational settings.
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) One disadvantage of the DBMS is that it increases the risk of data security breaches.
A)True
B)False
Answer: False
Q3) Data and information are essentially the same thing.
A)True
B)False
Answer: False
Q4) The organization of data within folders in a manual file system is determined by .
A) its date of creation
B) its expected use
C) the title of the documents in the folder
D) the data processing specialist
Answer: B
Q5) is data about data through which the end-user data are integrated and managed. Answer: Metadata
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) In the model, the basic logical structure is represented as an upside-down tree.
A) hierarchical
B) network
C) relational
D) entity relationship
Answer: A
Q2) A(n) is a restriction placed on the data.
A) attribute
B) entity
C) relationship
D) constraint
Answer: D
Q3) The model was developed to allow designers to use a graphical tool to examine structures rather than describing them with text.
A) hierarchical
B) network
C) object-oriented
D) entity relationship
Answer: D
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) Date attributes contain calendar dates stored in a special format known as the date format.
A) Epoch
B) calendar
C) Julian
D) logical
Answer: C
Q2) RDBMSs enforce integrity rules automatically.
A)True
B)False
Answer: True
Q3) When two or more tables share the same number of columns, and when their corresponding columns share the same or compatible domains, they are said to be .
A) intersect-compatible
B) union-compatible
C) difference-compatible
D) select-compatible
Answer: B
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) A entity has a primary key that is partially or totally derived from the parent entity in the relationship.
A) strong
B) weak
C) business
D) child
Q2) In Crow's Foot notation, an optional relationship between entities is shown by drawing a(n) on the side of the optional entity.
Q3) A attribute can be further subdivided to yield additional attributes.
A) composite
B) simple
C) single-valued
D) multivalued
Q4) A(n) attribute is an attribute that must have a value.
Q5) Explain multivalued attributes with the help of examples. How are multivalued attributes indicated in the Chen Entity Relationship model?
Q6) The concept of relationship strength is based on how the of a related entity is defined.
Q7) The Chen notation identifies a weak entity by using a double-walled entity .
Page 6
To view all questions and flashcards with answers, click on the resource link above.
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(n) is the attribute in the supertype entity that determines to which entity subtype each supertype occurrence is related.
A) subtype discriminator
B) inheritance discriminator
C) specialization hierarchy
D) entity supertype
Q2) Usually, a data modeler uses a natural identifier as the of the entity being modeled, assuming that the entity has a natural identifier.
Q3) The relationships depicted within the specialization hierarchy are sometimes described in terms of "is-a" relationships.
A)True
B)False
Q4) In the context of total completeness, in a(n) , every supertype occurrence is a member of at least one subtype.
A) unique constraint
B) disjoint constraint
C) overlapping constraint
D) foreign key constraint
To view all questions and flashcards with answers, click on the resource link above. Page 7
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) A table is in BCNF if every determinant in the table is a foreign key.
A)True
B)False
Q2) What characteristics do tables that conform to the concept of well-informed relations have?
Q3) A dependency based on only a part of a composite primary key is known as a partial dependency.
A)True
B)False
Q4) For most business transactional databases, we should normalize relations into .
A) 1NF
B) 2NF
C) 3NF
D) 6NF
Q5) BCNF can be violated only if the table contains more than one key.
A) primary
B) candidate
C) foreign
D) secondary
Q6) is a process to help reduce the likelihood of data anomalies.
Page 8
To view all questions and flashcards with answers, click on the resource link above.
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) Which of the following queries will output the table contents when the value of V_CODE is not equal to 21344?
A) SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE <> 21344;
B) SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE <= 21344;
C) SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE = 21344;
D) SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE => 21344;
Q2) Only numeric data types can be added and subtracted in SQL.
A)True
B)False
Q3) In SQL, all expressions evaluate to True or false.
Q4) The COMMIT command does not permanently save all changes. In order to do that, you must use SAVE.
A)True
B)False
Q5) DATE() and SYSDATE are special functions that return today's date in MS Access and , respectively.
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) Variables can be declared inside a stored procedure.
A)True
B)False
Q2) Summarize the hierarchy of steps involved in creating and running an executable program with embedded SQL statements.
Q3) In Oracle, make(s) it possible to merge SQL and traditional programming constructs, such as variables, conditional processing (IF-THEN-ELSE), basic loops (FOR and WHILE loops,) and error trapping.
A) cursor-style processing
B) stored procedures
C) embedded SQL
D) Procedural Language SQL
Q4) A persistent stored module is stored and executed on the database client machine.
A)True
B)False
Q5) A(n) subquery is a subquery that executes once for each row in the outer query.
Q6) A(n) view is a view that can be used to update attributes in the base table(s) that are used in the view.
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) List and describe the different levels at which database backups can be performed.
Q2) The Systems Development Life Cycle (SDLC) provides the big picture within which the database design and application development can be mapped out and evaluated.
A)True
B)False
Q3) The main purpose of a backup is to guarantee database restoration following a hardware or software failure.
A)True
B)False
Q4) Coding, testing, and debugging are part of the phase of the Systems Development Life Cycle (SDLC).
A) planning
B) analysis
C) detailed systems design
D) implementation
Q5) What are the factors affecting the purchasing decision for DBMS software?
Q6) allows the assignment of access rights to specific authorized users.
Q7) The term describes the extent to which modules are independent of one another.
Page 11
To view all questions and flashcards with answers, click on the resource link above.
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) The objective of control is to ensure the serializability of transactions in a multiuser database environment.
Q2) In the wait/die scheme,:
A) the older transaction rolls back the younger transaction and reschedules it.
B) the younger, preempted transaction is rescheduled using the same time stamp. C) the older transaction waits for the younger one to complete and release its locks.
D) both the younger and older transactions wait indefinitely to be released.
Q3) A shared lock produces no conflict as long as all the concurrent transactions are read-write only.
A)True
B)False
Q4) The scheduler's main job is to create a(n) of a transaction's operation, in which the interleaved executions of transactions yield the same results as if the transactions were executed in serial order.
Q5) The serializable isolation level is the least restrictive level defined by the ANSI SQL standard.
A)True
B)False
Page 12
To view all questions and flashcards with answers, click on the resource link above.
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) The is a shared, reserved memory area that stores the most recently executed SQL statements or PL/SQL procedures, including triggers and functions.
A) buffer cache
B) procedure cache
C) data cache
D) permanent storage
Q2) All transaction management commands are processed during the parsing and execution phases of query processing.
A)True
B)False
Q3) In RAID level 5,:
A) the data and the parity data are striped across separate drives.
B) the data blocks are spread over separate drives and are duplicated.
C) the array requires a minimum of two drives and is known as a striped array.
D) the array requires a minimum of five drives and is known as duplexing.
Q4) Indexes do not facilitate join operations.
A)True
B)False
Page 13
Q5) is a measure of the likelihood that an index will be used in query processing.
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
83 Verified Questions
83 Flashcards
Source URL: https://quizplus.com/quiz/29012
Sample Questions
Q1) distributed database systems integrate different types of centralized database management systems (DBMS) over a network.
A) Homogeneous
B) Heterogeneous
C) Fully homogeneous
D) Combination
Q2) In a basic distributed processing environment, the distributed processing system shares the database chores among three sites connected through a .
Q3) A DDBMS is subject to which of the following restrictions?
A) Multiple instances of the same database should be integrated over a network.
B) All database processing must be done at a single site.
C) Rapid ad hoc data access is not possible.
D) Remote data access is provided on a read-only basis.
Q4) Distributed database systems do not require complex mechanisms to manage transactions and ensure the database's consistency and integrity.
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
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/29013
Sample Questions
Q1) What is the difference between decision support data and operational data from the point of view of data analyst?
Q2) Data warehouse data are organized and summarized by table, such as CUSTOMER and ADDRESS.
A)True
B)False
Q3) Data _____ tools are tools that provide advanced statistical analysis to uncover problems and opportunities hidden within business data.
Q4) What is the ROLLUP extension to the GROUP BY clause? Provide the syntax for this extension.
Q5) A schema is a type of star schema in which dimension tables can have their own dimension tables.
A) snowflake
B) starflake
C) dimension
D) matrix
Q6) A data _____ is a small, single-subject data warehouse subset that provides decision support to a small group of people.
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) Cloud services allow any organization to quickly and economically add information technology services to its IT portfolio.
A)True
B)False
Q2) What is JavaScript? How does it work?
Q3) The initial costs of using cloud services tend to be significantly higher than building on-premise IT infrastructures.
A)True
B)False
Q4) The only time the client and server computers communicate is when the client requests a page and the server sends the requested page to the client.
A)True
B)False
Q5) A(n) provides limited additional semantic value to XML, such as data type support or data validation rules.
Q6) A web server is a middleware application that expands the functionality of web servers by linking them to a wide range of services.
Q7) What are the main types of objects in the OLE-DB model? Explain.
Page 16
To view all questions and flashcards with answers, click on the resource link above.
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) One of the important functions provided by the database is to reserve the resources that must be used by the database at run time.
A) security component
B) authorization manager
C) initialization parameters
D) administrator
Q2) Having a computerized DBMS guarantees that the data will be properly used to provide the best solutions required by managers.
A)True
B)False
Q3) The DBA function provides data modeling and design services to the end-user community, often through coordination with an application development group within the data-processing department.
A)True
B)False
Q4) In the context of the advancements in DBMS technology, the use of data services can free the DBA from many lower-level technology-oriented tasks.
Q5) A(n) _____ physically stores the database's data.
To view all questions and flashcards with answers, click on the resource link above. Page 17