Database Systems
Test Bank
Course Introduction
Database Systems explores the fundamental concepts, design, implementation, and management of database technologies. The course covers data modeling, relational database theory, Structured Query Language (SQL), and normalization, alongside concepts such as transactions, concurrency control, and database security. Students gain practical experience in designing databases, querying and manipulating data, and understanding the principles behind modern database management systems, preparing them to solve real-world data storage and retrieval challenges 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) A data warehouse can store data derived from many sources.
A)True
B)False Answer: True
Q2) XML data is ____.
A) structured
B) multistructured
C) unstructured
D) semistructured
Answer: D
Q3) 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
Q4) Data and information are essentially the same thing.
A)True
B)False Answer: False
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) In most modern relational DBMSs, a new database implementation requires the creation of special storage-related constructs to house the end-user tables.
A)True
B)False
Answer: True
Q2) Database designs that fail to recognize that the database is part of a larger information system are not likely to be successful.
A)True
B)False
Answer: True
Q3) Database performance is one of the least important factors in all database implementations.
A)True
B)False
Answer: False
Q4) A(n) ____________________ is a carefully designed and constructed repository of facts that is a part of a larger whole known as an information system.
Answer: database
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(n) ____'s main function is to help you understand the complexities of the real-world environment.
A) constraint
B) entity
C) model
D) database
Answer: C
Q2) 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
Q3) ____ are important because they help to ensure data integrity.
A) Attributes
B) Entities
C) Relationships
D) Constraints
Answer: D
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) A ____ contains at least all of the attribute names and characteristics for each table in the system.
A) data dictionary
B) relational schema
C) logical schema
D) join
Q2) Controlled ____ makes a relational database work.
A) relations
B) logic
C) chaos
D) redundancy
Q3) The relational database model enables you to view data ____ rather than ____.
A) relationally, hierarchically
B) hierarchically, relationally
C) physically, logically
D) logically, physically
Q4) The relational operators have the property of ____________________; that is, the use of relational algebra operators on existing relations (tables) produces new relations.
Q5) The ____________________ relationship is the relational database norm.
Page 6
To view all questions and flashcards with answers, click on the resource link above.
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) Which query will use the given columns and column aliases from the PRODUCT table to determine the total value of inventory held on hand and display the results in a column labeled TOTVALUE?
A) SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH*P_PRICE AS TOTVALUE FROM PRODUCT;
B) SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH=P_PRICE AS TOTVALUE FROM PRODUCT;
C) SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH/P_PRICE AS TOTVALUE FROM PRODUCT;
D) SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH-P_PRICE AS TOTVALUE FROM PRODUCT;
Q2) A(n) ____ is a query that is embedded (or nested) inside another query.
A) alias
B) operator
C) subquery
D) view
Q3) The CHECK constraint is used to define a condition for the values that the attribute domain cannot have.
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) A ____ join returns rows with matching values and includes all rows from both tables (T1 and T2) with unmatched values.
A) natural
B) cross
C) full outer
D) left outer
Q2) How many rows would be returned from a cross join of tables A and B, if A contains 8 rows and B contains 18?
A) 8
B) 18
C) 26
D) 144
Q3) ____________________ functions allow you to take a value of a given data type and convert it to the equivalent value in another data type.
Q4) Triggers can only be used to update table values.
A)True
B)False
Q5) The IN subquery uses a(n) ____________________ operator.
Q6) 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 Crow's Foot notation depicts the strong relationship with a(n) ____________________ line between the entities.
Q2) Participation is ____________________ if one entity occurrence does not require a corresponding entity occurrence in a particular relationship.
Q3) A recursive relationship is one in which a relationship can exist between occurrences of the same entity set
A)True
B)False
Q4) The word "entity" in the ER model corresponds to a table.
A)True
B)False
Q5) A(n) ____________________ process is based on repetition of processes and procedures.
Q6) Some ____ database modeling concepts can be expressed only using the Chen notation.
A) developmental
B) conceptual
C) actual
D) specific
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) One important inheritance characteristic is that all entity subtypes inherit their primary key attribute from their supertype.
A)True
B)False
Q2) The "____" characteristic of a primary key states the following: The PK should not have embedded semantic meaning. An attribute with embedded semantic meaning is probably better used as a descriptive characteristic of the entity rather than as an identifier.
A) unique values
B) nonintelligent
C) preferably single-attribute
D) security compliant
Q3) What is an entity cluster?
Q4) The ____________________ is the result of adding more semantic constructs to the original entity relationship (ER) model.
Q5) At the implementation level, the supertype and its subtype(s) depicted in the specialization hierarchy maintain a 1:1 relationship.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 10
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) The conflicts between design efficiency, information requirements, and processing speed are often resolved through ____.
A) conversion from 1NF to 2NF
B) conversion from 2NF to 3NF
C) compromises that include denormalization
D) conversion from 3NF to 4NF
Q3) ____________________ is a process to help reduce the likelihood of data anomalies.
Q4) In a real-world environment, we must strike a balance between design integrity and ____.
A) robustness
B) flexibility
C) uniqueness
D) ease of use
Q5) The price paid for increased performance through denormalization is a larger amount of ____________________.
Q6) Data redundancies occur from ____________________ of data on every row entry.
Page 11
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) ____ fragmentation refers to the division of a relation into subsets of tuples.
A) Vertical
B) Horizontal
C) Data
D) Mixed
Q2) A fully distributed DBMS must perform all the functions of a centralized DBMS, and it must handle all necessary functions imposed by the distribution of data and processing.
A)True
B)False
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) ____________________ management ensures that data move from one consistent state to another, including synchronization of local and remote transactions.
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) Of the following, what is one of the benefits of hardware and software independence of Internet technologies?
A) Global access
B) Reduced costs of maintaining private networks
C) Savings in equipment and software acquisition
D) Multiple platform development
Q2) Microsoft's alternative to Java is ____.
A) Active X
B) JavaScript
C) VBScript
D) Visual C++
Q3) In the ODBC architecture, a(n) ____ is in charge of managing all database connections.
A) API
B) data source name
C) ODBC driver
D) driver manager
Q4) ColdFusion is a Web application server.
A)True
B)False
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 testing and evaluation of a database application cover all aspects of the system-from the simple collection and creation of data to its use and retirement. What is covered by the evaluation process?
Q2) By default, Oracle automatically creates ____________________ and SYS user IDs that have administrative privileges with every new database you create.
Q3) Disaster management includes all the end-user activities designed to secure data availability following a physical disaster or a database integrity failure.
A)True
B)False
Q4) The most common backup medium has traditionally been ____________________.
Q5) The general coordinator of all DBAs is sometimes known as the ____________________ administrator.
Q6) It is common practice to define the DBA function by dividing the DBA operations according to the ____ phases.
A) SLA
B) DBLC
C) SDLC
D) MRA
Page 14
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) Although the DBMS is designed to recover a database to a previous consistent state (when an interruption prevents the completion of a required set of transactions), the transactions themselves are defined by the end user or programmer and must be ____________________ correct.
Q2) Serializability means that data used during the execution of a transaction cannot be used by a second transaction until the first one is completed.
A)True
B)False
Q3) What are the three basic techniques to control deadlocks?
Q4) A(n) ____ specifically reserves access to the transaction that locked the object.
A) shared lock
B) exclusive lock
C) binary lock
D) deadlock
Q5) If a(n) ____________________ is issued before the termination of a transaction, the DBMS will restore the database only for that particular transaction, rather than for all transactions, in order to maintain the durability of the previous transactions.
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 ____ cache stores the most recently executed SQL statements.
A) data
B) SQL
C) sort
D) optimizer
Q2) DBMS implementations are typically similar in complexity to two-tier client/server configurations.
A)True
B)False
Q3) Indexes do not facilitate join operations.
A)True
B)False
Q4) The ____ must be set large enough to permit as many data requests to be serviced from cache as possible.
A) data cache
B) SQL cache
C) sort cache
D) optimizer mode
Q5) Why do we need to optimize a DBMS with SQL performance tuning, even though they automatically optimize SQL queries?
To view all questions and flashcards with answers, click on the resource link above. Page 16
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) Analyzing decision support data to generate information is part of ____.
A) data warehousing
B) very large database systems
C) business intelligence
D) distributed processing
Q2) ______________________________ is a collection of concepts, techniques, and processes for the proper identification, definition, and management of data elements within an organization.
Q3) A characteristic of decision support data is ____.
A) high query activity
B) high update volumes
C) highly normalized
D) low aggregation level
Q4) ___________________________________ are quantifiable measurements (numeric or scale based) that assess the company's effectiveness or success in reaching its strategic and operational goals.
Q5) Decision support data are a snapshot of the operational data at a given point in time.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 17