Data Management Test Preparation
Course Introduction
Data Management is a foundational course that introduces students to the principles and practices involved in organizing, storing, retrieving, and securing data in various environments. The course explores data modeling, database design, and the use of database management systems (DBMS) to ensure data integrity, efficiency, and accessibility. Key topics include relational databases, Structured Query Language (SQL), normalization, data warehousing, and emerging trends such as NoSQL databases and big data technologies. Students will develop practical skills in handling data lifecycle processes and learn best practices for managing large-scale datasets in both academic and professional contexts.
Recommended Textbook
Database Systems Design Implementation and Management 13th Edition by Carlos Coronel
Available Study Resources on Quizplus
16 Chapters
1194 Verified Questions
1194 Flashcards
Source URL: https://quizplus.com/study-set/1337 Page 2
Chapter 1: Database Systems
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/26666
Sample Questions
Q1) A(n) _____ is a specific request issued to the DBMS for data manipulation. Answer: query
Q2) A(n) _____ is a collection of programs that manages the database structure and controls access to the data stored in the database. Answer: DBMS (database management system) database management system (DBMS) database management system DBMS
Q3) _____ are the result of formatting disorganized data in order to facilitate storage, use and generation of information.
A) Structured data
B) Raw data
C) Unstructured data
D) Obsolete data
Answer: A
Q4) _____ databases focus primarily on storing data used to generate information required to make tactical or strategic decisions.
Answer: Analytical
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/26667
Sample Questions
Q1) Database designers determine the data and information that yield the required understanding of the entire business.
A)True
B)False
Answer: False
Q2) The _____ model is the end users' view of the data environment.
Answer: external
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
Q4) A(n) _____ is a collection of similar objects with a shared structure and behavior.
Answer: class
Q5) The relational model's foundation is a mathematical concept known as a(n) _____.
Answer: relation
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/26668
Sample Questions
Q1) In a database context, a(n) _____ indicates the use of different names to describe the same attribute.
A) entity
B) duplicate
C) synonym
D) homonym
Answer: C
Q2) According to Codd's _____ rule of relational databases, if the system supports low-level access to the data, users must not be allowed to bypass the integrity rules of the database.
A) nonsubversion
B) information
C) guaranteed access
D) view updating
Answer: A
Q3) _____ is the real power behind the relational database, allowing the use of independent tables linked by common attributes.
Answer: JOIN
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/26669
Sample Questions
Q1) The Crow's Foot notation easily identifies multivalued attributes.
A)True
B)False
Q2) The entity relationship model (ERM) is dependent on the database type.
A)True
B)False
Q3) When indicating cardinality, the first value represents the _____ number of associated entities.
Q4) A(n) _____ process is based on repetition of processes and procedures.
Q5) The existence of a mandatory relationship indicates that the minimum cardinality is 0 or 1 for the mandatory entity.
A)True
B)False
Q6) The first step in building an entity-relationship diagram (ERD) is _____.
A) developing the initial ERD
B) creating a detailed narrative of the organization's description of operation
C) identifying the attributes and primary keys that adequately describe the entities
D) identifying the business rules based on the description of operations
Q7) A(n) _____ attribute need not be physically stored within the database.
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
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/26670
Sample Questions
Q1) An entity cluster is a "virtual" entity type used to represent multiple entities and relationships in the ERD.
A)True
B)False
Q2) At the implementation level, the supertype and its subtype(s) depicted in the specialization hierarchy maintain a 1:1 relationship.
A)True
B)False
Q3) 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
Q4) An entity supertype can have disjoint or overlapping entity subtypes.
A)True
B)False
Q5) In which two cases are composite primary keys particularly useful?
Q6) What do specialization hierarchies do?
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
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/26671
Sample Questions
Q1) Describe a dependency diagram and explain its purpose.
Q2) 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
Q3) An example of denormalization is using a _____ denormalized table to hold report data. This is required when creating a tabular report in which the columns represent data that are stored in the table as rows.
A) transitive
B) 3NF
C) component
D) temporary
Q4) Normalization works through a series of stages called normal forms.
A)True
B)False
Q5) Any attribute that is at least part of a key is known as a(n) _____.
Q6) _____ is a process to help reduce the likelihood of data anomalies.
To view all questions and flashcards with answers, click on the resource link above. Page 8
Chapter 7: Introduction to Structured Query Language Sql
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/26672
Sample Questions
Q1) An alias cannot be used when a table is required to be joined to itself in a recursive query.
A)True
B)False
Q2) In Oracle, the _____ function converts a date to a character string.
A) CONVERT()
B) TO_DATE
C) TO_CHAR()
D) TO_STRING()
Q3) The basic SQL vocabulary has fewer than _____words.
Q4) In SQL, all _____ expressions evaluate to true or false.
Q5) Comparison operators cannot be used to place restrictions on character-based attributes.
A)True
B)False
Q6) ANSI-standard SQL allows the use of special operators in conjunction with the WHERE clause.
A)True
B)False
Q7) Explain the SQL function categories.
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
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/26673
Sample Questions
Q1) Summarize the hierarchy of steps involved in creating and running an executable program with embedded SQL statements.
Q2) The _____ constraint is used to validate data when an attribute value is entered.
A) UNIQUE
B) CASCADE
C) CHECK
D) SET NULL
Q3) To remedy the lack of procedural functionality in SQL, and to provide some standardization within the many vendor offerings, the SQL-99 standard defined the use of persistent stored modules.
A)True
B)False
Q4) A(n) _____ is a logical group of database objects, such as tables and indexes, that are related to each other.
Q5) An explicit cursor must return two or more rows.
A)True
B)False
Q6) How are triggers critical to proper database operation and management?
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
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/26674
Sample Questions
Q1) Systems analysis establishes the need for an information system and its extent.
A)True
B)False
Q2) In DBLC, the phase after the database initial study is _____.
A) operation
B) database design
C) database initial study
D) implementation and loading
Q3) A system is always at some stage of SDLC because every request for structural changes requires retracing the steps of the Systems Development Life Cycle (SDLC).
A)True
B)False
Q4) The logical systems design is created during the _____ phase of the Systems Development Life Cycle (SDLC).
A) planning
B) analysis
C) implementation
D) maintenance
Q5) The first step in _____ is to discover the data element characteristics.
To view all questions and flashcards with answers, click on the resource link above. Page 11
Chapter 10: Transaction Management and Concurrency Control
Available Study Resources on Quizplus for this Chatper
74 Verified Questions
74 Flashcards
Source URL: https://quizplus.com/quiz/26675
Sample
Questions
Q1) In a heavily used database management system (DBMS), the prevention and detection of _____ constitutes an important DBMS function.
Q2) _____ requires that all operations of a transaction be completed.
A) Specificity
B) Atomicity
C) Durability
D) Time stamping
Q3) Uniqueness ensures that no equal time stamp values can exist, and _____ ensures that time stamp values always increase.
Q4) A single-user database system automatically ensures_____ of the database, because only one transaction is executed at a time.
A) serializability and durability
B) atomicity and isolation
C) serializability and isolation
D) atomicity and serializability
Q5) The _____ protocol ensures that transaction logs are always written before any database data is actually updated.
Page 12
Q6) As a rule, a(n) _____ must unlock the object after its termination.
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
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/26676
Sample Questions
Q1) On the client side, the objective is to generate an SQL query that returns a correct answer in the least amount of time, using a minimum amount of resources at the server end. The activities required to achieve this goal are commonly referred to as _____ tuning.
A) client SQL
B) database SQL
C) SQL performance
D) DBMS performance
Q2) During the ____ phase, the DBMS retrieves the data and sends the result set back to the client.
A) parse
B) execute
C) fetch
D) process
Q3) A conditional expression is normally expressed within the _____ or HAVING clauses of a SQL statement.
Q4) A(n) _____ request is a low-level read or write data access operation to or from computer devices.
Q6) DBMS query processing has _____ phases. Page 13
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 14
Chapter 12: Distributed Database Management Systems
Available Study Resources on Quizplus for this Chatper
74 Verified Questions
74 Flashcards
Source URL: https://quizplus.com/quiz/26677
Sample Questions
Q1) Theweb is the repository for distributed data.
A)True
B)False
Q2) The objective of _____ optimization is to minimize the total cost associated with the execution of a request.
A) data
B) remote
C) transaction
D) query
Q3) A disadvantage of a distributed database management system (DDBMS) is:
A) slower data access.
B) site additions affects other operations.
C) processor dependence.
D) lack of standards.
Q4) A distributed database is composed of several parts known as database _____.
A) sections
B) fragments
C) partitions
D) parts
Q5) Describe performance transparency and heterogeneity transparency.
Page 15
To view all questions and flashcards with answers, click on the resource link above.
Chapter 13: Business Intelligence and Data Warehouses
Available Study Resources on Quizplus for this Chatper
74 Verified Questions
74 Flashcards
Source URL: https://quizplus.com/quiz/26678
Sample Questions
Q1) In multidimensional terms, the ability to focus on slices of the cube to perform a more detailed analysis is known as _____.
Q2) A data store is used by data analysts to create queries that access the database.
A)True
B)False
Q3) ______ is a method or process of government.
Q4) Normalizing fact tables improves data access performance and saves data storage space.
A)True
B)False
Q5) The _____ hierarchy providesa top-down data organization that is used for two main purposes: aggregation and drill-down/roll-up data analysis.
Q6) In business intelligence framework, data are captured from a production system and placed in _____ on a near real-time basis.
A) decision support system
B) portal
C) data warehouse
D) dashboard
To view all questions and flashcards with answers, click on the resource link above. Page 16
Chapter 14: Big Data and Nosql
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/26679
Sample Questions
Q1) A block report is used to let the name node know that the data mode is still available. A)True
B)False
Q2) Mostorganizations that use Hadoop also use a set of other related products that interact and complement each other to produce an entire ______ of applications and tools.
Q3) The analysis of data to produce actionable results is feedback loop processing. A)True
B)False
Q4) The interactive, declarative query language in Neo4j is called ______.
Q5) Discuss NewSQL and what it attempts to do.
Q6) _____ are like attributes; they are the data that we need to store about the node.
Q7) In many ways, the issues associated with volume and velocity are the same. A)True B)False
Q8) ______ isthe coexistence of a variety of data storage and data management technologies within an organization's infrastructure.
Page 17
Q9) What is NoSQL and what are the major NoSQL approaches (categories)?
To view all questions and flashcards with answers, click on the resource link above.
Chapter 15: Database Connectivity and Web Technologies
Available Study Resources on Quizplus for this Chatper
73 Verified Questions
73 Flashcards
Source URL: https://quizplus.com/quiz/26680
Sample Questions
Q1) A plug-in is an external application that is automatically invoked by a web browser when needed.
A)True
B)False
Q2) APIs are faster than _____ scripts because the code resides in memory and there is no need to run an external program for each request.
Q3) The _____ is the most specialized object in the ADO.NET framework.
A) Command
B) DataReader
C) DataAdapter
D) DataSet
Q4) Based on Microsoft's Component Object Model (COM), _____ is database middleware that adds object-oriented functionality for access to relational and nonrelational data.
A) MS-DB
B) OLE-DB
C) COM-DB
D) ODBC
Q5) What are the main types of objects in the OLE-DB model? Explain.
Q6) What is JavaScript? How is JavaScript code activated?
Page 18
To view all questions and flashcards with answers, click on the resource link above.
Chapter 16: Database Administration and Security
Available Study Resources on Quizplus for this Chatper
74 Verified Questions
74 Flashcards
Source URL: https://quizplus.com/quiz/26681
Sample Questions
Q1) _____ CASE tools provide support for the planning, analysis, and design phases.
A) Front-end
B) Back-end
C) Vertical
D) Horizontal
Q2) 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
Q3) A security vulnerability is a collection of standards and policies created to guarantee the security of a system and ensure auditing and compliance.
A)True
B)False
Q4) A(n) _____ is a logical storage area in Oracle.
A) audit log
B) datafile
C) schema
D) tablespace
To view all questions and flashcards with answers, click on the resource link above. Page 19