Database Systems Concepts
Exam Practice Tests
Course Introduction
This course provides a comprehensive introduction to the fundamental concepts of database systems, emphasizing both the theoretical principles and practical applications. Students will explore data models, particularly the relational model, and learn about relational algebra, SQL, and query processing. Key topics include database design, normalization, indexing, transactions, concurrency control, and recovery mechanisms. The course also covers the architecture of database management systems (DBMS), database security, and emerging trends in database technologies, preparing students to design, implement, and manage robust database solutions in real-world scenarios.
Recommended Textbook
Database Processing 12th Edition by
David M. Kroenke
Available Study Resources on Quizplus
24 Chapters
1854 Verified Questions
1854 Flashcards
Source URL: https://quizplus.com/study-set/1823 Page 2
Chapter 1: Introduction
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/36220
Sample Questions
Q1) The NoSQL movement should really be called a NoRelational movement.
A)True
B)False Answer: True
Q2) The relational model was first proposed in 1970 by E.F.Codd at IBM.
A)True
B)False Answer: True
Q3) Applications are computer programs used directly by users.
A)True
B)False Answer: True
Q4) Microsoft Access includes:
A)a DBMS.
B)an application generator.
C)a Web server.
D)A and B
E)A,B and C Answer: D
To view all questions and flashcards with answers, click on the resource link above. Page 3
Chapter 2: Introduction to Structured Query Language SQL
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/36222
Sample Questions
Q1) In an SQL query,which SQL keyword is used with built-in functions to group together rows that have the same value in a specified column?
A)GROUP BY
B)ORDER BY
C)SELECT
D)SORT BY
E)DISTINCT SET
Answer: A
Q2) The rows of the result table can be sorted by the values in one or more columns.
A)True
B)False
Answer: True
Q3) While many subqueries can be alternatively written as joins,correlated subqueries do work that cannot be duplicated as a join.
A)True
B)False
Answer: True
To view all questions and flashcards with answers, click on the resource link above. Page 4
Chapter 3: The Relational Model and Normalization
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/36224
Sample Questions
Q1) If by knowing the value of A we can find the value of B,then we would say that B is functionally dependent on A.
A)True
B)False
Answer: True
Q2) A combination of one or more columns used to identify particular rows in a relation is a ________.
A)record
B)field
C)key
D)tuple
E)dependency
Answer: C
Q3) A relation is also known as a(n)________.
A)table
B)tuple
C)relationship
D)attribute
E)field
Answer: A
To view all questions and flashcards with answers, click on the resource link above. Page 5
Chapter 4: Database Design Using Normalization
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/36226
Sample Questions
Q1) Reviewing the work done on a table that was created using existing data from multiple sources,you are likely to find that a column named Remarks has been included,and is populated with inconsistent and verbose verbal data.This is an example of ________.
A)the multivalued,multicolumn problem
B)the inconsistent values problem
C)the missing values problem
D)the general-purpose remarks column problem
E)None of the above is correct.
Q2) Relations in BCNF have no modification anomalies in regard to functional dependencies.
A)True
B)False
Q3) The problem of misspelled data entries is really the same as ________.
A)the multivalue,multicolumn problem
B)the inconsistent values problem
C)the missing values problem
D)the general-purpose remarks column problem
E)None of the above is correct.
Q4) What are inconsistent values,and why are they a problem?
Page 6
To view all questions and flashcards with answers, click on the resource link above.
Chapter 5: Data Modeling With the Entity-Relationship
Model
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/36228
Sample Questions
Q1) You are given an E-R diagram with two entities,ORDER and CUSTOMER,as shown above,and are asked to draw the relationship between them.If a given customer can place only one order and a given order can be placed by at most one customer,which of the following should be indicated in the relationship symbol between the two entities?
A)0:1
B)1:1
C)1:N
D)N:1
E)N:M
Q2) A relationship's maximum cardinality indicates the maximum number of entities that can participate in the relationship.
A)True
B)False
Q3) In E-R modeling,an attribute describes the characteristics of an entity.
A)True
B)False
Q4) In a 1:N relationship,the term parent refers to the N side of the relationship.
A)True
B)False
7
To view all questions and flashcards with answers, click on the resource link above.
Chapter 6: Transforming Data Models Into Database Designs
Available Study Resources on Quizplus for this Chatper
103 Verified Questions
103 Flashcards
Source URL: https://quizplus.com/quiz/36230
Sample Questions
Q1) Association tables sometimes connect more than two entities.
A)True
B)False
Q2) An intersection table can have additional attributes besides the keys of its parent tables.
A)True
B)False
Q3) Like all ID-dependent relationships,the parents of an association table are required. A)True
B)False
Q4) To represent a 1:N relationship in a relational database design,an intersection table is created.
A)True
B)False
Q5) To represent an IS-A relationship in a relational database design,the IS-A relationship must be converted into a HAS-A relationship.
A)True
B)False
Page 8
To view all questions and flashcards with answers, click on the resource link above.
Chapter 7: SQL for Database Construction and Application Processing
Available Study Resources on Quizplus for this Chatper
105 Verified Questions
105 Flashcards
Source URL: https://quizplus.com/quiz/36232
Sample Questions
Q1) Joins that show only matching rows from the joined tables in their results are called inner joins.
A)True
B)False
Q2) Which of the following is not an ANSI SQL trigger?
A)BEFORE UPDATE
B)INSTEAD OF UPDATE
C)BEFORE INSERT
D)INSTEAD OF CONSTRAINT
E)AFTER DELETE
Q3) To set a column value to an initial value that is selected according to some business logic,you would use:
A)the SQL DEFAULT constraint with the CREATE TABLE command.
B)an SQL view.
C)embedded SQL.
D)an SQL trigger.
E)an SQL stored procedure.
Q4) What is embedded SQL,and what considerations are necessary when using it in an application?
9
Q5) Discuss what is meant by a data type of "Numeric (10,3)."
To view all questions and flashcards with answers, click on the resource link above.
Chapter 8: Database Redesign
Available Study Resources on Quizplus for this Chatper
101 Verified Questions
101 Flashcards
Source URL: https://quizplus.com/quiz/36234
Sample Questions
Q1) In the database redesign process,two SQL tools are useful for testing whether or not certain conditions or assumptions are valid: uncorrelated subqueries and EXISTS/NOT EXISTS.
A)True
B)False
Q2) Although correlated subqueries are useful in database redesign,they cannot be used to verify functional dependencies.
A)True
B)False
Q3) Even if an organization has a very large database,it will be possible to make a complete backup copy of the operational database prior to making structure changes.
A)True
B)False
Q4) What is reverse engineering and how well does it work?
Q5) What is a correlated subquery?
Q6) A correlated subquery,looks very different from a noncorrelated subquery.
A)True
B)False
Q7) Discuss the role of backup and test databases in database redesign.
Page 10
To view all questions and flashcards with answers, click on the resource link above.
Chapter 9: Managing Multiuser Databases
Available Study Resources on Quizplus for this Chatper
102 Verified Questions
102 Flashcards
Source URL: https://quizplus.com/quiz/36236
Sample Questions
Q1) Two-phased locking is a scheme for achieving serializability of transactions.
A)True
B)False
Q2) Transaction level consistency means that all rows impacted by any actions in a transaction are protected from change during the entire transaction.
A)True
B)False
Q3) With optimistic locking,the assumption is made that no conflict will occur.
A)True
B)False
Q4) Reprocessing is normally the most convenient method for recovery after a system failure.
A)True
B)False
Q5) Explain the purpose of transaction logs and checkpoints.
Q6) In regard to database security,neither the DBMS nor the database applications can enforce processing responsibilities.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 11
Chapter 10: Managing Databases With SQL Server 2008 R2
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/36237
Sample Questions
Q1) The language available in SQL Server that adds programming constructs to the SQL language is known as ________.
A)PL/SQL
B)SQLP
C)C++
D)INTERACT-SQL
E)TRANSACT-SQL
Q2) Database views can only be created in SQL Server through the use of SQL commands.
A)True
B)False
Q3) Which of the following are ways of processing an SQL Server database?
A)From an application written in a programming language such as C# or Visual Basic
B)From text files processed by the SQL Server Query Analyzer
C)From invoked SQL Server stored procedures
D)From invoked SQL Server triggers
E)All of the above.
Q4) Explain the SQL Server IDENTITY constraint.
Q5) Explain SQL Server indexes.
To view all questions and flashcards with answers, click on the resource link above. Page 12
Chapter 11: Managing Databases With Oracle Database 11g
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/36238
Sample Questions
Q1) Oracle Database uses the SQL ALTER TABLE command to change the structure of a table.
A)True B)False
Q2) With Oracle Database,you can change the default transaction isolation for all transactions in a session by using the SET TRANSACTION ISOLATION LEVEL statement.
A)True B)False
Q3) The PL/SQL keyword DECLARE is used to begin the basic PL/SQL block structure.
A)True B)False
Q4) What is the Database Configuration Assistant (DBCA)?
Q5) Which of the following Oracle Database PL/SQL statements is used to create a block of code that repeats while some condition is true?
A)FOR
B)WHILE
C)LOOP
D)A and B
E)A,B and C
To view all questions and flashcards with answers, click on the resource link above. Page 13
Chapter 12: Managing Databases With MySQL 55
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/36239
Sample Questions
Q1) The MySQL statement to delete a stored procedure already in the database is:
A)CREATE PROCEDURE.
B)ALTER PROCEDURE.
C)DROP PROCEDURE.
D)CLOSE PROCEDURE.
E)None of the above.
Q2) MySQL uses the MySQL CALL statement to run a stored procedure.
A)True
B)False
Q3) Explain the MySQL control-of-flow statements.
Q4) SQL query results are displayed:
A)in a tabbed Resultset window.
B)in a tabbed Results window.
C)in a tabbed Document window.
D)in a tabbed Messages window.
E)in a tabbed results window named the same as the window with the SQL code.
Q5) For use with this book,it is recommend that MySQL be configured as a developer machine.
A)True
B)False
14
To view all questions and flashcards with answers, click on the resource link above.
Chapter 13: The Web Server Environment
Available Study Resources on Quizplus for this Chatper
110 Verified Questions
110 Flashcards
Source URL: https://quizplus.com/quiz/36240
Sample Questions
Q1) A(n)________ is a Java program that is interpreted and executed by a bytecode interpreter on the Web server.
A)applet
B)Java virtual machine
C)servlet
D)HTTP
E)JDBC translator
Q2) ODBC works with table-like data sources such as relational databases and spreadsheets.
A)True
B)False
Q3) What are the different types of conformance levels within the ODBC standard,and why do they exist?
Q4) Which of the following is a type of OLE DB data provider?
A)relational data provider
B)method provider
C)sequential data provider
D)tabular data provider
E)implementation provider
Q5) Explain the process by which JSP pages are compiled.
Page 15
To view all questions and flashcards with answers, click on the resource link above.
Chapter 14: Database Processing With XML
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/36241
Sample Questions
Q1) Setting the minimum cardinality to 0 is similar to using a NULL constraint in SQL.
A)True
B)False
Q2) Oracle requires the use of Java for generating XML documents from database data.
A)True
B)False
Q3) What is XQuery?
Q4) XSLT processors are context oriented;that is,each statement is evaluated within the context of the match that has already been made.
A)True
B)False
Q5) Which of the following is true about XML?
A)It is a subset of SGML.
B)Additional standards and capabilities have been added to XML processing.
C)It is a hybrid of document processing and database processing.
D)A and B
E)A,B and C
Q6) What are flat and structured XML Schemas?
Q7) How can XML be used with a DBMS?
To view all questions and flashcards with answers, click on the resource link above. Page 16
Chapter 15: Database Processing for Business Intelligence Systems
Available Study Resources on Quizplus for this Chatper
101 Verified Questions
101 Flashcards
Source URL: https://quizplus.com/quiz/36242
Sample Questions
Q1) Report delivery is more important for data mining than it is for reporting systems.
A)True
B)False
Q2) In supervised data mining,statistical techniques are used to estimate the parameters of the model.
A)True
B)False
Q3) Refer to the table above.What is the confidence of Drug B being purchased given that Drug A has been purchased?
A).200
B).250
C).333
D).400
E).500
Q4) Reports that rely on the most current data when they are prepared are called dynamic reports.
A)True
B)False
Q5) What is a slowly changing dimension?
To view all questions and flashcards with answers, click on the resource link above. Page 17
Chapter 16: Microsoft Access 2010
Available Study Resources on Quizplus for this Chatper
48 Verified Questions
48 Flashcards
Source URL: https://quizplus.com/quiz/36219
Sample Questions
Q1) Microsoft Access is considered a "personal database" product.What is a personal database?
Q2) Microsoft Access SQL commands are run within the SQL View of a Query window.
A)True
B)False
Q3) In Microsoft Access,tables are added to a Query window by:
A)selecting the tables from the Use Table dialog box.
B)selecting the tables from the Show Table dialog box.
C)selecting the tables from the Tables section of the Navigation Pane.
D)selecting the tables from the Queries section of the Navigation Pane.
E)selecting the tables from the Relationships window.
Q4) Microsoft Access is a personal database system,and a personal database system is characterized by:
A)the DBMS removing the metadata from the database.
B)the DBMS product taking the role of the DBMS and the database application generator.
C)the database being stored inside the DBMS.
D)the DBMS product being limited to a maximum of ten tables in any given database.
E)the DBMS not supporting indexes.
To view all questions and flashcards with answers, click on the resource link above.
Page 18
Chapter 17: Getting Started With Systems Analysis and Design
Available Study Resources on Quizplus for this Chatper
35 Verified Questions
35 Flashcards
Source URL: https://quizplus.com/quiz/36221
Sample Questions
Q1) Which of the following is not included in Michael Porter's list of primary or operational activities?
A)Procurement
B)Inbound logistics
C)Manufacturing operations
D)Outbound logistics
E)All of above are considered primary or operational activities.
Q2) The classic systems analysis methodology is called the:
A)Systems Development Life Cycle (SDLC).
B)Analysis Development Life Cycle (ADLC).
C)Component Development Life Cycle (CDLC).
D)Information Development Life Cycle (IDLC).
E)None of the above is correct.
Q3) Information systems must be both developed and used to help businesses reach their goals and objectives.
A)True
B)False
Q4) What are the five steps or stages of the systems development life cycle (SDLC)?
To view all questions and flashcards with answers, click on the resource link above. Page 19
Q5) What activities take place during the component design step of the systems development life cycle (SDLC)?
Chapter 18: E-R Diagrams and the Idef1x Standard
Available Study Resources on Quizplus for this Chatper
35 Verified Questions
35 Flashcards
Source URL: https://quizplus.com/quiz/36223
Sample Questions
Q1) What line symbols are used in IDEF1X diagrams to represent relationships?
Q2) In IDEF1X,extended E-R model 1:N relationships are called:
A)nonidentifying connection relationships.
B)identifying connection relationships.
C)nonspecific relationships.
D)category clusters.
E)There is no equivalent IDEF1X term.
Q3) What is IDEF1X?
Q4) The IDEF1X excludes the concept of domains found in the extended E-R model. A)True
B)False
Q5) Extended E-R model 1:1 relationships are called nonidentifying connection relationships in IDEF1X.
A)True
B)False
Q6) What symbols are used in IDEF1X diagrams to represent cardinalities?
Q7) IDEF1X categories are put into a clutter.
A)True
B)False
Q8) What are IDEF1X domains?
To view all questions and flashcards with answers, click on the resource link above. Page 20
Chapter 19: E-R Diagrams and the UML Standard
Available Study Resources on Quizplus for this Chatper
36 Verified Questions
36 Flashcards
Source URL: https://quizplus.com/quiz/36225
Sample Questions
Q1) Which of the following is true about UML?
A)UML is a methodology for developing OOP systems.
B)UML is a set of tools to support the development of OOP systems.
C)UML is primarily focused on database development.
D)A and B
E)A,B and C
Q2) In UML notation,the relationship line in a relationship between two strong entities is labeled as:
A)<persistent>.
B)<identifying>.
C)<nonidentifying>.
D)<protected>.
E)There is no label used.
Q3) In UML,an attribute that is accessible only by methods of its entity class or of its subclasses is said to be ________.
A)private
B)exclusive
C)protected
D)public
E)persistent
To view all questions and flashcards with answers, click on the resource link above. Page 21
Chapter 20: Getting Started With MySQL Workbench Data
Modeling Tools
Available Study Resources on Quizplus for this Chatper
37 Verified Questions
37 Flashcards
Source URL: https://quizplus.com/quiz/36227
Sample Questions
Q1) Table column data is edited in the MySQL Table Editor.
A)True
B)False
Q2) To create a new MySQL Workbench EER model,you can use the File | New Model command.
A)True
B)False
Q3) In the MySQL Table Editor,the abbreviation for AUTO_INCREMENT is:
A)PK.
B)NN.
C)UQ.
D)BIN.
E)AI.
Q4) The MySQL Workbench EER models are data models. A)True
B)False
Q5) The MySQL Installer for Windows can be used to install the MySQL Workbench. A)True B)False
Q6) Describe how to add a table object to a MySQL Workbench database design. Page 22
To view all questions and flashcards with answers, click on the resource link above.
Page 23
Chapter 21: Getting Started With Microsoft Visio 2010
Available Study Resources on Quizplus for this Chatper
36 Verified Questions
36 Flashcards
Source URL: https://quizplus.com/quiz/36229
Sample Questions
Q1) In Microsoft Visio 2010,both data models and database designs are created using:
A)the Database Model Diagram template.
B)the UML Model Diagram template.
C)the Enterprise Application template.
D)the Data Flow Model template.
E)the Wireframe Diagram template.
Q2) In Microsoft Visio 2010,both data models and database designs are created using the Database Model Diagram template.
A)True
B)False
Q3) In Microsoft Visio 2010,how do we create database designs?
Q4) In Microsoft Visio 2010,describe the possible cardinality settings for a Relationship object that can be set in the Database Properties for a relationship in a database design,and how these settings correspond to the IE Crow's Foot symbols shown in Figure 4-8?
Q5) In Microsoft Visio 2010,the Entity Relationship (US units)stencil objects include a Recursive Relationship object.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 24
Chapter 22: the Semantic Object Model
Available Study Resources on Quizplus for this Chatper
35 Verified Questions
35 Flashcards
Source URL: https://quizplus.com/quiz/36231
Sample Questions
Q1) Group attributes are composites of other attributes.
A)True
B)False
Q2) Semantic objects represent distinct identities.
A)True
B)False
Q3) Describe the two ways that semantic object views can be used.
Q4) A group identifier:
A)has more than one attribute.
B)identifies a group of instances.
C)identifies a group of attributes in an object.
D)is the identifier for a group of semantic objects.
E)links two objects.
Q5) Subtype objects can be:
A)inclusive subtypes.
B)exclusive subtypes.
C)nested subtypes.
D)Either B or C.
E)Either A,B or C.
Q6) Explain the differences between the E-R model and the semantic object model.
To view all questions and flashcards with answers, click on the resource link above. Page 25
Chapter 23: Data Structures for Database Processing
Available Study Resources on Quizplus for this Chatper
35 Verified Questions
35 Flashcards
Source URL: https://quizplus.com/quiz/36233
Sample Questions
Q1) A two-way linked list has links in both directions.
A)True
B)False
Q2) What is a linked list?
Q3) To represent a tree structure using indexes,store each 1:N relationship as an index.
A)True
B)False
Q4) A complex network is a collection of records and the 1:N relationships between them.
A)True
B)False
Q5) What is a set?
Q6) What are tress,simple networks and complex networks?
Q7) In a linked list,the sequence field holds the address of the next record in the logical sequence.
A)True
B)False
Q8) How does a DBMS store data on its direct access files?
Q9) What is a B-tree?
To view all questions and flashcards with answers, click on the resource link above. Page 26
Chapter 24: Getting Started With Web Servers php and the
Available Study Resources on Quizplus for this Chatper
35 Verified Questions
35 Flashcards
Source URL: https://quizplus.com/quiz/36235
Sample Questions
Q1) For a Web server running the Windows operating system,the most commonly used Web server is:
A)the IIS Web server.
B)the Apache Web server.
C)the Tomcat Web server.
D)the ASP.NET Web server.
E)the JSP Web server.
Q2) The Java JRE is installed directly form the Java download page at:
A)www.java.com.
B)www.jre.com.
C)www.jdk.com.
D)www.sun.com.
E)www.oracle.com.
Q3) For a workstation running the Windows operating system,a commonly used Web browser is Microsoft Internet Explorer.
A)True
B)False
Q4) What is the Microsoft Web Platform Installer,and what are the advantages and disadvantages of using it to install PHP?
Page 27
To view all questions and flashcards with answers, click on the resource link above.