Data Modeling Test Preparation
Course Introduction
Data Modeling is a foundational course that introduces students to the concepts, techniques, and tools used to design and structure data for information systems. The course covers the development and application of conceptual, logical, and physical data models, emphasizing best practices for representing data relationships, constraints, and semantics. Students will learn to use Entity-Relationship (ER) diagrams and other modeling notations, understand normalization processes, and translate real-world requirements into robust database designs that support efficient data storage, integrity, and retrieval. By the end of the course, students will be equipped with the practical skills needed to model complex data systems 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) Historically, a manual file system was composed of a system of file folders and filing cabinets.
A)True
B)False
Answer: True
Q2) What are the advantages of having the DBMS between the end user's applications and the database?
Answer: Having a DBMS between the end user's applications and the database offers some important advantages. First, the DBMS enables the data in the database to be shared among multiple applications or users. Second, the DBMS integrates the many different users' views of the data into a single all-encompassing data repository.
Q3) ___________________________________ is a special language used to represent and manipulate data elements in a textual format.
Answer: XML (Extensible Markup Language)
Extensible Markup Language (XML)
Extensible Markup Language
XML
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) The conceptual design step that determines end-user views, outputs, and transaction-processing requirements is ____.
A) data analysis and requirements
B) entity relationship modeling and normalization
C) data model verification
D) distributed database design
Answer: A
Q2) The database contents may be loaded interactively or in ____________________ mode.
Answer: batch
Q3) To analyze the company situation, the database designer must discover what the company's operational components are, how they function, and how they interact.
A)True
B)False
Answer: True
Q4) The first step in ____________________ design is to discover the data element characteristics.
Answer: conceptual
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) A verb associating two nouns in a business rule translates to a(n) ____ in the data model.
A) entity
B) attribute
C) relationship
D) constraint
Answer: C
Q2) ___________________________________ is a language based on OO concepts that describes a set of diagrams and symbols used to graphically model a system.
Answer: UML (Unified Modeling Language)
Unified Modeling Language (UML)
Unified Modeling Language
UML
Q3) The hierarchical data model was developed in the ____.
A) 1960s
B) 1970s
C) 1980s
D) 1990s
Answer: A
To view all questions and flashcards with answers, click on the resource link above. Page 5
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) Depending on the sophistication of the application development software, nulls can create problems when functions such as COUNT, AVERAGE, and SUM are used.
A)True
B)False
Q2) Only a single attribute, not multiple attributes, can define functional dependence.
A)True
B)False
Q3) ____________________ is the real power behind the relational database, allowing the use of independent tables linked by common attributes.
Q4) ____ combines all rows from two tables, excluding duplicate rows.
A) INTERSECT
B) UNION
C) DIFFERENCE
D) SELECT
Q5) Tables within a database share common attributes that enable the tables to be linked together.
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) In a 1:M relationship, you must always create the table for the ____________________ side first.
Q2) A(n) ____________________, also known as a nested query or an inner query, is a query that is embedded (or nested) inside another query.
Q3) Most SQL implementations yield case-insensitive searches.
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) Entity integrity is enforced automatically when the primary key is specified in the CREATE TABLE command sequence.
A)True
B)False
Q6) Rows can be grouped into smaller collections quickly and easily using the SQL ____________________ clause.
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 most useful feature of PL/SQL blocks is that they let you create code that can be named, stored, and executed by the DBMS.
A)True
B)False
Q2) An explicit cursor must return two or more rows.
A)True
B)False
Q3) Procedural code is executed on the database client machine.
A)True
B)False
Q4) The statement SELECT * FROM T1, T2 produces a(n) ____ join.
A) cross
B) natural
C) equi-
D) full
Q5) The ____________________ statement in SQL combines rows from two queries and returns only the rows that appear in the first set but not in the second.
Q6) The IN subquery uses a(n) ____________________ operator.
Q7) Describe the characteristics of an Oracle sequence.
Page 8
To view all questions and flashcards with answers, click on the resource link above.
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) The ER model refers to a specific table row as an entity instance.
A)True
B)False
Q2) A(n) ____ entity is composed of the primary keys of each of the entities to be connected.
A) associative
B) recursive
C) unary
D) binary
Q3) A ____ attribute can be further subdivided to yield additional attributes.
A) composite
B) simple
C) single-valued
D) multivalued
Q4) Identifying the attributes of the entities helps you better understand the ____________________ among entities.
Q5) Derived attributes are stored in a special database table.
A)True
B)False
9
Q6) The ERM forms the basis of a(n) ___________________________________.
To view all questions and flashcards with answers, click on the resource link above.
Page 10
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) One important inheritance characteristic is that all entity subtypes inherit their ____ key attribute from their supertype.
A) primary
B) natural
C) foreign
D) surrogate
Q2) The ____________________ is the result of adding more semantic constructs to the original entity relationship (ER) model.
Q3) Overlapping subtypes are subtypes that contain a unique subset of the supertype entity set.
A)True
B)False
Q4) The most common design trap is known as a(n) ____________________.
Q5) If you use a surrogate key, you must ensure that the candidate key of the entity in question performs properly through the use of the "____________________" and "not null" constraints.
Q6) Composite keys are useful as identifiers of weak entities, where the weak entity has a strong ____________________ relationship with the parent entity.
To view all questions and flashcards with answers, click on the resource link above. Page 11
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) Unnormalized database tables often lead to various data redundancy disasters in production databases.
A)True
B)False
Q2) To generate a surrogate key, Microsoft Access uses a(n) ____ data type.
A) surrogate
B) sequence
C) AutoNumber
D) identity
Q3) A good relational DBMS excels at managing denormalized relations.
A)True
B)False
Q4) A table is in BCNF if every determinant in the table is a candidate key.
A)True
B)False
Q5) The price paid for increased performance through denormalization is a larger amount of ____________________.
Q6) Atomic attributes are attributes that can be further subdivided.
A)True
B)False
Page 12
To view all questions and flashcards with answers, click on the resource link above.
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 __________________________________________________ scenario is typical of most mainframe and midrange server computer DBMSs.
Q2) The DO-UNDO-REDO protocol defines three types of operations. What are they?
Q3) ____ is the delay imposed by the amount of time required for a data packet to make a round trip from point A to point B.
A) Data distribution
B) Replica transparency
C) Network latency
D) Network partitioning
Q4) The ____ processor is the software component residing on each computer that stores and retrieves data located at the site.
A) transaction
B) network
C) data
D) management
Q5) In a DDBMS, ____________________ control is used to manage simultaneous data access and ensure data consistency across database fragments.
Q6) A user-friendly ____________________ is one advantage of a DDBMS.
To view all questions and flashcards with answers, click on the resource link above. Page 13
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) A Web browser's function is to display a page on the client computer. The browser, through its use of HTML, does not have computational abilities beyond formatting output text and accepting form field inputs.
A)True
B)False
Q2) Which of the following is a client-side extension?
A) ActiveX
B) ODBC
C) SQL*Net
D) TCP/IP
Q3) Whether you purchase online or by standing in line, the system-level transaction details are essentially the same and they require the same basic database structures and relationships.
A)True
B)False
Q4) A(n) ____________________ is a unique name by which the data source will be known to ODBC, and therefore, to applications.
Q5) XML tags must be well formed; that is, each opening tag has a corresponding ____________________ tag.
To view all questions and flashcards with answers, click on the resource link above. Page 14
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) User-access management is a subset of ____.
A) password protection
B) authorization management
C) data integrity
D) managerial control
Q2) A(n) ____ data dictionary is not updated automatically and usually requires a batch process to be run.
A) active
B) passive
C) static
D) dynamic
Q3) An organization is subject to a(n) _________________________ cycle; that is, the data user applies intelligence to data to produce information that is the basis of knowledge used in decision making by the user.
Q4) The DBA or security officer must secure an insurance policy to provide financial protection in the event of a database failure.
A)True
B)False
Q5) The most common backup medium has traditionally been
Page 15
To view all questions and flashcards with answers, click on the resource link above.
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) If T1 has not unlocked data item Y, T2 cannot begin; if T2 has not unlocked data item X, T1 cannot continue. Consequently, T1 and T2 each wait for the other to unlock the required data item. Such a deadlock is also known as a(n) ____________________.
Q2) The ANSI has defined standards that govern SQL database transactions. Transaction support is provided by two SQL statements: ____ and ROLLBACK.
A) RETRIEVE
B) ASSIGN
C) UPDATE
D) COMMIT
Q3) Incomplete or improper transactions can have a devastating effect on database integrity.
A)True
B)False
Q4) What are the three basic techniques to control deadlocks?
Q5) The objective of ____________________ control is to ensure the serializability of transactions in a multiuser database environment.
Q6) How does a shared/exclusive lock schema increase the lock manager's overhead?
Q7) Explain the transaction log. What is its function?
Page 16
To view all questions and flashcards with answers, click on the resource link above.
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 SQL cache stores the end-user written SQL.
A)True
B)False
Q2) A(n) ____________________ request is a low-level (read or write) data access operation to/from computer devices.
Q3) On the server side, the DBMS environment must be properly configured to respond to clients requests in the fastest way possible, while making optimum use of existing resources. The activities required to achieve that goal are commonly referred to as ____ tuning.
A) client and server
B) database
C) SQL performance
D) DBMS performance
Q4) The purpose of an I/O operation is to move data to and from different computer components or devices.
A)True
B)False
Q5) ____________________ are ordered sets of values that are crucial in speeding up data access.
To view all questions and flashcards with answers, click on the resource link above. Page 17
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) In a typical star schema, each dimension record is related to thousands of ____ records.
A) attribute
B) fact
C) key
D) star
Q2) ____________________ online analytical processing provides OLAP functionality by using relational databases and familiar relational query tools to store and analyze multidimensional data.
Q3) Data warehouse data are organized and summarized by table, such as CUSTOMER and ADDRESS.
A)True
B)False
Q4) What is one of the main characteristics of OLAP systems?
A) They use single-dimensional data analysis techniques.
B) They provide complex command-line end-user interfaces.
C) They provide minimal database support.
D) They support client/server architecture.
Q5) A(n) ____________________ uses special proprietary techniques to store data in matrix-like n-dimensional arrays.
18
To view all questions and flashcards with answers, click on the resource link above.