Database Systems
Study Guide Questions
Course Introduction
This course introduces the fundamental concepts of database systems, focusing on the design, implementation, and management of relational databases. Students will explore data models, database architecture, and the principles of database design including normalization and entity-relationship modeling. The course covers Structured Query Language (SQL) for defining, manipulating, and querying data, as well as transaction management, concurrency control, and recovery techniques. Additionally, the course examines emerging trends in database technologies such as NoSQL systems and distributed databases, providing students with both theoretical knowledge and practical skills through hands-on assignments and projects.
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
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) is data about data through which the end-user data are integrated and managed.
Answer: Metadata
Q2) 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
Q3) The database structure in a DBMS is stored as a .
A) single file
B) collection of files
C) set of key/value pairs
D) collection of queries
Answer: B
Q4) exists when it is possible to make changes in the data storage characteristics without affecting an application program's ability to access data.
Answer: Data independence
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 object-oriented terms, a(n) defines an object's behavior. Answer: method
Q2) A(n) is the equivalent of a field in a file system.
A) attribute
B) entity
C) relationship
D) constraint Answer: A
Q3) A(n) is a restriction placed on the data.
A) attribute
B) entity
C) relationship
D) constraint Answer: D
Q4) A(n) in a hierarchical model is the equivalent of a record in a file system. Answer: segment
Q5) Business rules must be rendered in writing.
A)True
B)False
Answer: True
Page 4
To view all questions and flashcards with answers, click on the resource link above.
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) If one department chair-a professor-can chair only one department, and one department can have only one department chair. The entities PROFESSOR and DEPARTMENT exhibit a(n) relationship.
Answer: 1:1
Q2) When you define a table's primary key, the DBMS automatically creates a(n) index on the primary key column(s) you declared.
A) key
B) composite
C) unique
D) primary
Answer: C
Q3) A table is also called a(n) because the relational model's creator, E. F. Codd, used the two terms as synonyms.
Answer: relation
Q4) PRODUCT yields all possible pairs of rows from two tables, also known as the product. Answer: Cartesian
Q5) The relationship is the relational database norm. Answer: 1:M
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 composite identifier is a primary key composed of more than one attribute.
A)True
B)False
Q2) What is a ternary relationship? Provide some business rules examples that specify the need for a ternary or higher- order relationship.
Q3) A relationship is an association between .
A) objects
B) entities
C) databases
D) fields
Q4) In Crow's Foot notation, an optional relationship between entities is shown by drawing a(n) on the side of the optional entity.
Q5) A relationship exists when an association is maintained within a single entity.
A) unary
B) ternary
C) strong
D) weak
Q6) Explain multivalued attributes with the help of examples. How are multivalued attributes indicated in the Chen Entity Relationship model?
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) The depicts the arrangement of higher-level entity supertypes (parent entities) and lower-level entity subtypes (child entities).
A) subtype discriminator
B) inheritance
C) specialization hierarchy
D) entity supertype
Q2) A design trap occurs when a relationship is improperly or incompletely identified and is therefore represented in a way that is not consistent with the real world.
A)True
B)False
Q3) Overlapping subtypes are subtypes that contain a unique subset of the supertype entity set.
A)True
B)False
Q4) Describe an entity cluster.
Q5) The completeness constraint can be partial or total.
A)True
B)False
Q6) completeness means that not every supertype occurrence is a member of a subtype.
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) Normalization works through a series of stages called normal forms. For most purposes in business database design, stages are as high as you need to go in the normalization process.
A) two
B) three C) four D) five
Q2) Describe a dependency diagram and explain its purpose.
Q3) Attribute A attribute B if all of the rows in the table that agree in value for attribute A also agree in value for attribute B. A) determines B) derives from C) controls D) owns
Q4) A table is in 2NF if it is in 1NF, and it includes no partial dependencies. A)True B)False
Q5) A good relational DBMS excels at managing denormalized relations. A)True B)False
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
111 Verified Questions
111 Flashcards
Source URL: https://quizplus.com/quiz/29021
Sample Questions
Q1) The query to join the P_DESCRIPT and P_PRICE fields from the PRODUCT table and the V_NAME, V_AREACODE, V_PHONE and V_CONTACT fields from the VENDOR table, where the values of V_CODE match and the output is ordered by the price is .
A) SELECT PRODUCT.P_DESCRIPT, PRODUCT.P_PRICE, VENDOR.V_NAME, VENDOR.V_CONTACT, VENDOR.V_AREACODE, VENDOR.V_PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE <> VENDOR.V_CODE; ORDER BY PRODUCT.P_PRICE;
B) SELECT PRODUCT.P_DESCRIPT, PRODUCT.P_PRICE, VENDOR.V_NAME,
VENDOR.V_CONTACT, VENDOR.V_AREACODE, VENDOR.V_PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE => VENDOR.V_CODE; ORDER BY PRODUCT.P_PRICE;
C) SELECT PRODUCT.P_DESCRIPT, PRODUCT.P_PRICE, VENDOR.V_NAME,
VENDOR.V_CONTACT, VENDOR.V_AREACODE, VENDOR.V_PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE <= VENDOR.V_CODE; ORDER BY PRODUCT.P_PRICE;
D) SELECT PRODUCT.P_DESCRIPT, PRODUCT.P_PRICE, VENDOR.V_NAME, VENDOR.V_CONTACT, VENDOR.V_AREACODE, VENDOR.V_PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE = VENDOR.V_CODE; ORDER BY PRODUCT.P_PRICE;
Q2) A table can be deleted from the database by using the command.
Q3) In the SQL environment, the word covers both questions and actions.
Q4) words are words used by SQL to perform specific functions.
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) The ANSI standard defines type(s) of outer join(s)
A) one
B) two
C) three
D) four
Q2) To test a trigger, one should use the EXECUTE TRIGGER command.
A)True
B)False
Q3) An implicit cursor is automatically created in procedural SQL when the SQL statement returns only one value.
A)True
B)False
Q4) A(n) join returns not only the rows matching the join condition (that is, rows with matching values in the common columns) but also the rows with unmatched values.
A) outer
B) inner
C) equi-
D) cross
Q5) Describe the important features and applications of SQL functions
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) A rule is a brief and precise narrative of a policy, procedure, or principle within a specific organization's environment.
Q2) List and describe the different levels at which database backups can be performed.
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
Q4) The advent of very sophisticated application generators and has substantially decreased coding and testing time.
Q5) After the initial declarations in Database Life Cycle (DBLC), the database designer must carefully probe in order to generate additional information that will help define the problem within the larger framework of company operations.
A)True
B)False
Q6) The proposed system is subject to limits known as , which are external to the system.
Q7) When selecting DBMS , items to consider include processors, RAM, and disk space.
To view all questions and flashcards with answers, click on the resource link above.
11
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) A lock locks the entire table preventing access to any row by a transaction while another transaction is using the table.
A) database-level
B) table-level
C) page-level
D) row-level
Q2) can take place at any of the following levels: database, table, page, row, or field.
Q3) 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) _____.
Q4) The last step in the write-through technique recovery procedure is to identify the last checkpoint in the transaction log.
A)True
B)False
Q5) Database transaction restores a database from an inconsistent state to a previously consistent state.
Q6) What is transaction isolation and why it is important?
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) How can queries be written to perform the fastest when equality and inequality comparisons are needed?
Q2) Knowing the sparsity of a column helps you decide whether the use of is appropriate.
A) query processing
B) query optimization
C) an index
D) a full table scan
Q3) List and describe some typical DBMS processes.
Q4) One of the main functions of a database system is to provide timely answers to end users.
A)True
B)False
Q5) A DBA determines the initial size of the data files that make up the database; however, as required, the data files can automatically expand in predefined increments known as .
A) procedure cache
B) buffer cache
C) supplements
D) extends
To view all questions and flashcards with answers, click on the resource link above. Page 13
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) The scenario is typical of most mainframe and midrange UNIX/LINUX server database management systems (DBMS).
Q2) Distributed processing does not require:
A) database processing functions to be distributed to all data storage sites.
B) an existing distributed database.
C) a network of interconnected components.
D) multiple sites to share processing chores.
Q3) The guarantees that if a portion of a transaction operation cannot be committed, all changes made at the other sites participating in the transaction will be undone to maintain a consistent database state.
A) DO-UNDO-REDO protocol
B) two-phase commit protocol (2PC)
C) coordinator protocol
D) write-ahead protocol
Q4) Performance transparency ensures that the system finds the most cost-effective path to access remote data.
A)True
B)False
Q5) Describe performance transparency and heterogeneity transparency.
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) To support a(n) _____ adequately, the DBMS might be required to support advanced storage technologies, and even more importantly, to support multiple-processor technologies, such as a symmetric multiprocessor (SMP) or a massively parallel processor (MPP).
Q2) The schema must support complex (non-normalized) data representations. A) snowflake
B) online analytical processing
C) decision support database
D) multidimensional database
Q3) Explain the concept of data analytics. What are the various tools of data analytics?
Q4) Fact and dimension tables are related by keys.
A) shared
B) primary
C) foreign
D) linked
Q5) What is data visualization? Name different techniques of data visualization.
Q6) is a collection of concepts, techniques, and processes for the proper identification, definition, and management of data elements within an organization.
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) The initial costs of using cloud services tend to be significantly higher than building on-premise IT infrastructures.
A)True
B)False
Q2) Regardless of the type of web server interface used, a web-to-database program must be able to connect with a database.
Q3) A plug-in is an external application that is automatically invoked by a web browser when needed.
A)True
B)False
Q4) Open Database Connectivity (ODBC), a superset of the SQL Access Group Call Level Interface (CLI), is implemented by .
Q5) A(n) can use a shared connection to the database instead of creating a new one every time.
A) DLL
B) API
C) web browser
D) HTTP GET request
Q6) ODBC, OLE-DB, and ADO.NET form the backbone of the architecture.
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) The role of a DBA covers activities that involve evaluating, selecting, installing, and maintaining a DBMS and its related utilities and applications.
A) technical
B) administrative
C) managerial
D) interactive
Q2) In the context of the Oracle Enterprise Manager, a is a named collection of settings that control how much of the database resource a given user can use.
A) license
B) role
C) profile
D) constraint
Q3) Security breaches can yield a database whose integrity is either preserved or corrupted.
A)True
B)False
Q4) A security is a weakness in a system component that could be exploited to allow unauthorized access or cause service disruptions.
To view all questions and flashcards with answers, click on the resource link above.
Page 17