Data Modeling Test Preparation
Course Introduction
Data Modeling is a foundational course that explores the principles, techniques, and applications involved in structuring data for effective storage, retrieval, and analysis. The course covers conceptual, logical, and physical data models, with an emphasis on entity-relationship (ER) diagrams, normalization, and relational database design. Students will learn how to translate real-world scenarios into data models that reflect business requirements, enforce data integrity, and support efficient queries. Through hands-on assignments and practical case studies, the course prepares students to create robust database systems and understand the impact of data modeling choices in various organizational contexts.
Recommended Textbook
Database Principles Fundamentals of Design Implementation and Management international 10th
Available Study Resources on Quizplus
15 Chapters
1320 Verified Questions
1320 Flashcards
Source URL: https://quizplus.com/study-set/1336 Page 2
Chapter 1: The Database Approach
Available Study Resources on Quizplus for this Chatper
70 Verified Questions
70 Flashcards
Source URL: https://quizplus.com/quiz/26651
Sample Questions
Q1) Database programming languages receive all application requests and translate them into the complex operations required to fulfill those requests.
A)True
B)False
Answer: False
Q2) One disadvantage of the DBMS is that it increases the risk of data security breaches.
A)True
B)False
Answer: False
Q3) In early computer file systems, a(n) ___________________________________ was hired to create a computer-based system that would track data and produce required reports.
Answer: data processing (DP) specialist
data processing specialist
DP specialist
Q4) ____________________ 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: Database Development Process
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/26652
Sample Questions
Q1) Database performance is one of the least important factors in all database implementations.
A)True
B)False
Answer: False
Q2) The company ____________________ describes the general conditions in which a company operates, its organizational structure, and its mission.
Answer: situation
Q3) Once the data has been loaded into the database, the ____ tests and fine-tunes the database for performance, integrity, concurrent access, and security constraints.
A) programmer
B) manager
C) database administrator
D) systems administrator
Answer: C
Q4) In order to develop an accurate data ____________________, the designer must have a thorough understanding of the company's data types, extent, and uses.
Answer: model
To view all questions and flashcards with answers, click on the resource link above.
Page 4
Chapter 3: Data Models
Available Study Resources on Quizplus for this Chatper
70 Verified Questions
70 Flashcards
Source URL: https://quizplus.com/quiz/26653
Sample Questions
Q1) M:N relationships are not appropriate in a relational model.
A)True
B)False
Answer: True
Q2) Oracle 11g is an example of a(n) ____.
A) hierarchical model
B) file system data model
C) relational data model
D) XML/Hybrid data model
Answer: D
Q3) A(n) ____ is bidirectional.
A) attribute
B) entity
C) relationship
D) constraint
Answer: C
Q4) In an SQL-based relational database, each table is dependent on another.
A)True
B)False
Answer: False
Page 5
To view all questions and flashcards with answers, click on the resource link above.
Chapter 4: Relational Model Characteristics
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/26654
Sample Questions
Q1) The following example exhibits ____________________ integrity: The CUSTOMER table's primary key is CUS_CODE. The CUSTOMER primary key column has no null entries, and all entries are unique. Similarly, the AGENT table's primary key is AGENT_CODE, and this primary key column also is free of null entries.
Q2) The index key can have multiple attributes, this is called a(n) ____________________ index.
Q3) In the context of a database table, the statement "A ____ B" indicates that if you know the value of attribute A, you can look up the value of attribute B. A) contains B) is related to C) owns D) determines
Q4) Describe the use of the UNION operator.
Q5) Fortunately, the problems inherent in the ____________________ relationship can easily be avoided by creating a composite entity.
Q6) You can think of a table as a persistent representation of a logical relation. A)True B)False
To view all questions and flashcards with answers, click on the resource link above. Page 6
Chapter 5: Beginning Structured Query Language Sql
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/26655
Sample Questions
Q1) What command is used to save changes to the database? What is the syntax for this command?
Q2) A(n) ____________________ order sequence is a multilevel ordered sequence that can be created easily by listing several attributes, separated by commas, after the ORDER BY clause.
Q3) A database language enables the user to create database and table structures to perform basic data management chores.
A)True
B)False
Q4) Although SQL commands can be grouped together on a single line, complex command sequences are best shown on separate lines, with space between the SQL command and the command's components.
A)True
B)False
Q5) If you have not yet used the COMMIT command to store the changes permanently in the database, you can restore the database to its previous condition with the ROLLBACK command.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 7
Chapter 6: Procedural Language Sql and Advanced Sql
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/26656
Sample Questions
Q1) The syntax for a left outer join is ____.
A) SELECT column-list FROM table1 OUTER JOIN table2 LEFT WHERE join-condition
B) SELECT column-list FROM table1 LEFT [OUTER] JOIN table2 ON join-condition
C) SELECT column-list WHERE LEFT table1 = table 2
D) SELECT column-list FROM table1 LEFT table2 [JOIN] WHERE join-condition
Q2) An alternate syntax for a join is SELECT column-list FROM table1 JOIN table2 ____________________ (common-column).
Q3) Cursor-style processing involves retrieving data from the cursor, one row at a time. A)True B)False
Q4) Oracle uses the ____________________ function to extract the various parts of a date.
To view all questions and flashcards with answers, click on the resource link above. Page 8
Chapter 7: Data Modeling With Entity Relationship
Diagrams
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/26657
Sample Questions
Q1) A ____ should be a derived attribute.
A) person's name
B) person's age
C) person's social security number
D) person's phone number
Q2) The Crow's foot symbol with two parallel lines indicates ____ cardinality.
A) (0,N)
B) (1,N)
C) (1,1)
D) (0,1)
Q3) In the Chen model, a multivalued attribute is connected to the owning entity with a double line.
A)True
B)False
Q4) The word "entity" in the ER model corresponds to a table.
A)True
B)False
Q5) ____________________ not only helps you stay on track during the design process, it also enables you and your coworkers to pick up the design thread when the time comes to modify the design.
To view all questions and flashcards with answers, click on the resource link above. Page 9
Chapter 8: Data Modeling Advanced Concepts
Available Study Resources on Quizplus for this Chatper
70 Verified Questions
70 Flashcards
Source URL: https://quizplus.com/quiz/26658
Sample Questions
Q1) To model time-variant data, you must create a new entity in a M:N relationship with the original entity.
A)True
B)False
Q2) A ____ key is a real-world, generally accepted identifier used to uniquely identify real-world objects.
A) primary
B) natural
C) foreign
D) surrogate
Q3) Surrogate primary keys are especially helpful when there is no ____ key.
A) primary
B) natural
C) foreign
D) composite
Q4) The ____________________ constraint specifies whether each entity supertype occurrence must also be a member of at least one subtype.
Q5) The most common design trap is known as a(n) ____________________.
Q6) Disjoint subtypes are also known as ____________________ subtypes.
Page 10
To view all questions and flashcards with answers, click on the resource link above.
Chapter 9: Normalizing Database Designs
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/26659
Sample Questions
Q1) A(n) ____________________ derives its name from the fact that a group of multiple entries of the same type can exist for any single key attribute occurrence.
Q2) A table where every determinant is a candidate key is said to be in ____.
A) BCNF
B) 2NF
C) 3NF
D) 4NF
Q3) Normalization purity is easy to sustain in the modern database environment.
A)True
B)False
Q4) A table that has all key attributes defined, has no repeating groups, and all its attributes are dependent on the primary key, is said to be in ____.
A) 1NF
B) 2NF
C) 3NF
D) 4NF
Q5) All relational tables satisfy the 1NF requirements. A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 11
Chapter 10: Distributed Databases
Available Study Resources on Quizplus for this Chatper
70 Verified Questions
70 Flashcards
Source URL: https://quizplus.com/quiz/26660
Sample Questions
Q1) The DO-UNDO-REDO protocol defines three types of operations. What are they?
Q2) Describe performance transparency and heterogeneity transparency.
Q3) The ability to execute a ____ request provides fully distributed database processing because you can partition a database table into several fragments.
A) distributed
B) transaction
C) fragmented
D) transparent
Q4) One of the advantages of a DDBMS is growth facilitation.
A)True
B)False
Q5) A fully distributed database management system must perform all of the functions of a centralized DBMS. What are these functions?
Q6) One of the advantages of a DDBMS is that the data is located near the site with the least demand.
A)True
B)False
Q7) One of the advantages of a DDBMS is less danger of a single-____________________ failure.
To view all questions and flashcards with answers, click on the resource link above. Page 12
Chapter 11: Interacting With Databases Through the Web
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/26661
Sample Questions
Q1) ____ is a Web application server that provides the ability to connect Web servers to multiple data sources.
A) Access
B) ColdFusion/JRun
C) FoxPro
D) dBase
Q2) ____________________ transactions-the sale of products or services-can take place between businesses or between a business and a consumer.
Q3) ______________________________ provides a unified interface to access data from any programming language that uses the underlying OLE-DB objects.
Q4) ____________________ are objects that manage the connection with a data source and provide data to the consumers.
Q5) The ____ is the most specialized object in the ADO.NET framework.
A) Command
B) DataReader
C) DataAdapter
D) DataSet
Q6) What is a server-side extension?
To view all questions and flashcards with answers, click on the resource link above. Page 13
Chapter 12: Database Administration and Security
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/26662
Sample Questions
Q1) The advent of the DBMS and its shared view of data produced a new level of data management sophistication and led the DP department to evolve into a(n) _________________________ department.
Q2) As a manager, the DBA must concentrate on the ____ dimensions of the database administration function.
A) control and planning
B) conflict and problem-resolution
C) policies and standards
D) security and privacy
Q3) A ____ is a named collection of database access privileges that authorize a user to connect to the database and use the database system resources.
A) user
B) role
C) profile
D) manager
Q4) Placing the DBA function in a(n) ____________________ position often creates a consulting environment in which the DBA is able to devise the data administration strategy but does not have the authority to enforce it or to resolve possible conflicts.
To view all questions and flashcards with answers, click on the resource link above. Page 14
Chapter 13: Managing Transactions and Concurrency
Available Study Resources on Quizplus for this Chatper
70 Verified Questions
70 Flashcards
Source URL: https://quizplus.com/quiz/26663
Sample Questions
Q1) As long as two transactions, T1 and T2, access ____ data, there is no conflict, and the order of execution is irrelevant to the final outcome.
A) shared
B) common
C) unrelated
D) locked
Q2) What is transaction isolation and why it is important?
Q3) The phenomenon of uncommitted data occurs when two transactions are executed concurrently and the first transaction is rolled back after the second transaction has already accessed the uncommitted data-thus violating the isolation property of transactions.
A)True
B)False
Q4) What are the three basic techniques to control deadlocks?
Q5) When using an optimistic approach, during the write phase, the transaction is validated to ensure that the changes made will not affect the integrity and consistency of the database.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 15
Chapter 14: Managing Database and Sql Performance
Available Study Resources on Quizplus for this Chatper
70 Verified Questions
70 Flashcards
Source URL: https://quizplus.com/quiz/26664
Sample Questions
Q1) The ____ table space is used to store the data dictionary tables.
A) system
B) user data
C) temporary
D) rollback segment
Q2) The data cache or ____ is a shared, reserved memory area that stores the most recently accessed data blocks in RAM.
A) buffer cache
B) procedure cache
C) SQL cache
D) permanent storage
Q3) Database ____________________ activities can be divided into those taking place either on the client side or on the server side.
Q4) Use __________________________________________________ to provide balance between performance and fault tolerance.
Q5) A conditional expression is normally expressed within the ____________________ or HAVING clauses of a SQL statement.
Q6) How should storage volumes be allocated for indexes, system, and high-usage tables?
Page 16
To view all questions and flashcards with answers, click on the resource link above.
Chapter 15: Databases for Decision Support
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/26665
Sample Questions
Q1) The basic star schema has four components: facts, ____, attributes, and attribute hierarchies.
A) keys
B) relationships
C) cubes
D) dimensions
Q2) The ____________________ hierarchy provides the capability to perform drill-down and roll-up searches in a data warehouse.
Q3) To provide better performance, some OLAP systems merge the data warehouse and data mart approaches by storing small extracts of the data warehouse at end-user workstations.
A)True
B)False
Q4) To tie a KPI to the strategic master plan of an organization, a KPI will be compared to a desired goal within a specific time frame.
A)True
B)False
Q5) In a typical ____________________ schema, each dimension record is related to thousands of fact records.
To view all questions and flashcards with answers, click on the resource link above. Page 17