Database Design Exam Practice Tests
Course Introduction
Database Design is a foundational course that explores the principles and practices involved in creating efficient, reliable, and scalable databases. Students learn to analyze user requirements, model data using entity-relationship diagrams, and implement relational databases using normalization techniques. The course covers topics such as data integrity, indexing, transaction management, and security, while introducing Structured Query Language (SQL) for data manipulation and retrieval. Through hands-on projects and case studies, learners develop the skills necessary to design databases that meet the needs of modern applications and organizations.
Recommended Textbook
Database Processing Fundamentals Design and Implementation 13th Edition by David
Available Study Resources on Quizplus
24 Chapters
1921 Verified Questions
1921 Flashcards
Source URL: https://quizplus.com/study-set/1804
Page 2
M. Kroenke
Chapter 1: Introduction
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/35866
Sample Questions
Q1) A database records:
A)facts.
B)figures.
C)information.
D)A and B
E)A,B,and C
Answer: D
Q2) Referential integrity constraints are rules about what data values are allowed in certain columns.
A)True
B)False
Answer: True
Q3) In database systems,indexes are held by the database.
A)True
B)False
Answer: True
Q4) Twitter and Facebook use NoSQL databases.
A)True
B)False
Answer: True
Page 3
To view all questions and flashcards with answers, click on the resource link above.
Chapter 2: Introduction to Structured Query Language SQL
Available Study Resources on Quizplus for this Chatper
105 Verified Questions
105 Flashcards
Source URL: https://quizplus.com/quiz/35868
Sample Questions
Q1) Columns can be sorted in descending sequence by using the SQL DESC keyword.
A)True
B)False
Answer: True
Q2) The clause SELECT COUNT (*)results in a table with a single row and a single column.
A)True
B)False Answer: True
Q3) The condition in WHERE clauses can refer to a set of values by using the IN operator.
A)True
B)False
Answer: True
Q4) The SQL keyword GROUP BY instructs the DBMS to group together those rows that have the same value in a column.
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/35870
Sample Questions
Q1) Given the functional dependency (A,B) C,the attributes (A,B)are referred to as a composite determinant.
A)True
B)False
Answer: True
Q2) Saying that two entities are functionally dependent means that ________.
A)the entities are always connected by a mathematical equation
B)for one of the entities,if we are given the value of that entity,we can determine the value of one other entity
C)for both of the entities,if we are given the value of one entity,we can determine the value of the other entity
D)the functional dependency will have to be removed through normalization
E)All of the above.
Answer: B
Q3) The multivalued dependency noted as A B,means that the value of A determines a set of values of B.
A)True
B)False
Answer: True
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/35872
Sample Questions
Q1) A null value in a column may indicate that there is an appropriate value for that attribute,and although the value is known no one has entered the value into the database.
A)True
B)False
Q2) Denormalization reduces the complexity of the SQL statements needed in an application to read required data.
A)True
B)False
Q3) When a table is created using existing data from multiple sources,you are likely to find that the different sources code data in slightly different ways.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.
Q4) Read-only databases are often updated.
A)True
B)False
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/35874
Sample Questions
Q1) An entity instance is the occurrence of a particular entity.
A)True
B)False
Q2) A hash mark across the relationship line near an entity indicates ________.
A)a maximum cardinality of "zero"
B)a maximum cardinality of "one"
C)a minimum cardinality of "optional"
D)a minimum cardinality of "required"
E)None of the above.
Q3) Relationships among instances of a single entity class are called redundant relationships.
A)True
B)False
Q4) You are given an E-R diagram with two entities,ORDER and CUSTOMER,as shown above.What does the symbol next to the CUSTOMER entity indicate?
A)A maximum cardinality of "zero"
B)A maximum cardinality of "one"
C)A minimum cardinality of "optional"
D)A minimum cardinality of "required"
E)None of the above.
To view all questions and flashcards with answers, click on the resource link above. Page 7
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/35876
Sample Questions
Q1) Which of the following is not true of recursive relationships?
A)When the recursive relationship is M:N,an intersection table is created.
B)The rows of a single table can play two different roles.
C)The techniques for representing the tables are the same as for non-recursive relationships except the rows are in the same table.
D)Recursive relationships can be 1:1,1:N,or M:N relationships.
E)Even when the relationship is 1:N,a new table must be defined to represent the relationship.
Q2) A referential integrity constraint policy that guarantees that a row in a parent table always has a required entry in a child table ________.
A)is known as a minimum cardinality enforcement action
B)needs to be documented by the database development team
C)is enforced in most DBMS products
D)A and B
E)A,B,and C
Q3) One of the important properties of an attribute is whether or not it is required.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 8
Chapter 7: Sql for Database Construction and Application
Processing
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/35878
Sample Questions
Q1) The SQL CREATE TABLE statement is used to name a new table and describe the table's columns.
A)True
B)False
Q2) Because SQL statements are table-oriented,whereas programs are variable-oriented,the results of SQL statements used in programs are treated as pseudofiles.
A)True
B)False
Q3) Which SQL keyword is used to delete a table's structure?
A)DELETE
B)DROP
C)DISPOSE
D)ALTER
E)MODIFY
Q4) SQL triggers can be used when the DBMS receives an INSERT request.
A)True
B)False
Q5) Discuss SQL data types.
Q6) What are SQL triggers and how are they used? Page 9
To view all questions and flashcards with answers, click on the resource link above.
Page 10
Chapter 8: Database Redesign
Available Study Resources on Quizplus for this Chatper
101 Verified Questions
101 Flashcards
Source URL: https://quizplus.com/quiz/35880
Sample Questions
Q1) When dropping a primary key column from a table,which of the following steps is (are)included in the process? (The order of the steps listed below is not relevant,only the steps themselves. )
A)Drop the primary key constraint from the table
B)Drop the primary key column from the table
C)Drop the foreign keys in other tables based on the primary key column
D)A and B
E)A,B,and C
Q2) In the SQL statements SELECT C1.CustName,C1.SalesRepNo
FROM CUSTOMER C1; The "C1" is called a(n)________.
A)term
B)alias
C)convention
D)phrase
E)label
Q3) The design produced by reverse engineering may be described as a table-relationship diagram.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 11
Chapter 9: Managing Multiuser Databases
Available Study Resources on Quizplus for this Chatper
102 Verified Questions
102 Flashcards
Source URL: https://quizplus.com/quiz/35882
Sample Questions
Q1) A transaction is sometimes called atomic because it is performed as a unit.
A)True
B)False
Q2) In two-phase locking,all locks are obtained during the growing phase.
A)True
B)False
Q3) The DBA is responsible for managing changes to the database structure,but is rarely involved in the original design of the structure.
A)True
B)False
Q4) Which of the following would a DBA do in managing the DBMS?
A)Analyze system performance statistics
B)Investigate user complaints
C)Evaluate new DBMS product features
D)Tune DBMS product options to accommodate other software in use
E)All of the above
Q5) A checkpoint is a point of synchronization between the database and the transaction log.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 12
Chapter 10: A: Managing Databases With SQL Server 20012
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/35865
Sample Questions
Q1) Explain SQL Server indexes.
Q2) The default transaction isolation level for SQL Server is Read Committed. A)True
B)False
Q3) With SQL Server,a nonclustered index does not contain data but has pointers to the data.
A)True
B)False
Q4) The default cursor concurrency for a dynamic cursor in SQL Server is optimistic. A)True
B)False
Q5) In addition to the standard SQL Server 2012 tools,SQL statements such as CREATE TABLE can now also be executed by using Microsoft's PowerShell.
A)True B)False
Q6) The SQL Server default when creating a new database is to create two data files and one log file for each database. A)True
B)False
Page 13
To view all questions and flashcards with answers, click on the resource link above.
Chapter 10: B: Managing Databases With Oracle Database
11g Release 2
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/35864
Sample Questions
Q1) The PL/SQL keyword ISTHERE is used to test for the existence of a condition.
A)True
B)False
Q2) Instead of creating a new database instance in Oracle Database,it is preferable to create a new tablespace.
A)True
B)False
Q3) The Oracle Database variant of SQL with additional procedural language components is ________.
A)T-SQL
B)PL/SQL
C)My/SQL
D)MS/SQL
E)SQL
Q4) An Oracle Database tablespace is a logical subdivision of an Oracle database instance that is used to group related table,view,and other similar objects.
A)True
B)False
Q5) What is SQL*Plus?
To view all questions and flashcards with answers, click on the resource link above. Page 14
Chapter 10: C: Managing Databases With MySQL
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/35863
Sample Questions
Q1) MySQL supports INSTEAD OF triggers.
A)True
B)False
Q2) The MySQL GUI tool(s)used for database administration and management is(are):
A)MySQL Workbench.
B)MySQL*Plus.
C)MySQL Command Shell.
D)A and B
E)A,B,and C
Q3) What is the MySQL Command-Line Client?
Q4) Explain the MySQL cursor statements.
Q5) Which trigger type(s)does MySQL support?
A)BEFORE
B)AFTER
C)INSTEAD OF
D)A and B
E)A,B,and C
Q6) What is the MySQL Table Editor?
Q7) Explain the MySQL control-of-flow statements.
Q8) What MySQL utility is used for DBMS administration?
To view all questions and flashcards with answers, click on the resource link above. Page 15
Chapter 11: The Web Server Environment
Available Study Resources on Quizplus for this Chatper
198 Verified Questions
198 Flashcards
Source URL: https://quizplus.com/quiz/35884
Sample Questions
Q1) In a three-tier or n-tier architecture,which type of JDBC driver can be used if the DBMS and the Web server are running on the same computer?
A)Type 1 driver
B)Type 2 driver
C)Type 3 driver
D)Type 4 driver
E)All of the above.
Q2) Explain the relationships among native DBMS libraries,ODBC,OLE DB,ADO,and ADO.NET and why each led to the development of the next.
Q3) The ODBC standard defines a means of doing which of the following?
A)Start transactions
B)Rollback transactions
C)Create a connection
D)Issue SQL commands
E)All of the above
Q4) OLE DB is an object-oriented interface.
A)True
B)False
Q5) What is an XML Schema?
To view all questions and flashcards with answers, click on the resource link above. Page 16
Chapter 12: Big Data datawarehouse and Business Intelligence Systems
Available Study Resources on Quizplus for this Chatper
102 Verified Questions
102 Flashcards
Source URL: https://quizplus.com/quiz/35885
Sample Questions
Q1) OLAP provides the ability to sum,count,average and perform other simple arithmetic operations on groups of data.
A)True
B)False
Q2) RFM analysis analyzes and ranks customers based on:
A)their purchasing patterns.
B)their income status.
C)their residential location.
D)A and B
E)A,B,and C
Q3) One Business Intelligence (BI)reporting system that uses extensions to SQL is: A)cluster analysis.
B)OLAP.
C)regression analysis.
D)RFM analysis.
E)A,B,and C
Q4) What is a reporting system?
Q5) In RFM analysis,R stands for "how recently." A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 17
Chapter 13: Microsoft Access 2013
Available Study Resources on Quizplus for this Chatper
48 Verified Questions
48 Flashcards
Source URL: https://quizplus.com/quiz/35862
Sample Questions
Q1) The default Microsoft Access 2013 command tabs are HOME,CREATE,INTERNAL DATA and DATABASE TOOLS.
A)True
B)False
Q2) The Microsoft Access data type of AutoNumber is used when there is a specific need for a:
A)foreign key.
B)primary key.
C)surrogate key.
D)spare key.
E)secondary key.
Q3) To start Microsoft Access 2013 in Windows 8,use the command:
A)Start | Microsoft Access 2013.
B)Start | Microsoft Office | Microsoft Access 2013.
C)Start | All Programs | Microsoft Access 2013.
D)Start | All Programs | Microsoft Office | Microsoft Access 20130.
E)No command-use the Microsoft Access 2013 app tile.
Q4) What is a surrogate key and how does Microsoft Access 2013 create surrogate keys?
Q5) What Microsoft Access file format is used by default in Microsoft Access 2013?
To view all questions and flashcards with answers, click on the resource link above. Page 18
Chapter 14: 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/35867
Sample Questions
Q1) Hardware is installed and tested during the ________ step of the SDLC.
A)system definition
B)requirements analysis
C)component design
D)implementation
E)systems maintenance
Q2) How does Michael Porter define primary or operational business activities?
Q3) Information systems are used to support business processes.
A)True
B)False
Q4) Hardware specifications are determined during the ________ step of the SDLC.
A)system definition
B)requirements analysis
C)component design
D)implementation
E)systems maintenance
Q5) Databases are created in a DBMS during the implementation step.
A)True
B)False
Q6) What are the five step or stages of the systems development life cycle (SDLC)? Page 19
To view all questions and flashcards with answers, click on the resource link above.
Page 20
Chapter 15: 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/35869
Sample Questions
Q1) Extended E-R model 1:1 relationships are called nonidentifying connection relationships in IDEF1X.
A)True
B)False
Q2) The IDEF1X default cardinality of a nonidentifying connection relationship is one-to-one,with a mandatory parent and an optional child.
A)True B)False
Q3) A categorization relationship is an IS-A relationship.
A)True
B)False
Q4) IDEF1X category clusters are mutually exclusive.
A)True B)False
Q5) In IDEF1X,extended E-R model weak,but non-ID-dependent relationships are called:
A)nonidentifying connection relationships.
B)identifying connection relationships.
C)nonspecific relationships.
D)category clusters.
E)There is no equivalent IDEF1X term.
21
To view all questions and flashcards with answers, click on the resource link above.
Chapter 16: 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/35871
Sample Questions
Q1) What new contributions to data modeling do UML-style E-R diagrams introduce?
Q2) Which of the following is not a characteristic that was introduced to E-R diagramming by UML?
A)class attributes
B)relationship attributes
C)visibility of attributes
D)methods
E)constraints
Q3) What cardinality format is used in UML-style E-R diagrams?
Q4) 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
Q5) UML is intended for modeling and designing object-oriented programs and applications.
A)True
B)False
22
To view all questions and flashcards with answers, click on the resource link above.
Chapter 17: 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/35873
Sample Questions
Q1) Users should create a MySQL Workspace folder to hold documents created with the MySQL Workbench.
A)True
B)False
Q2) Describe how to create a new database design in the MySQL Workbench.
Q3) Table names are edited in the MySQL EER Component Editor.
A)True
B)False
Q4) In the MySQL Workbench,a 1:N identifying relationship between two tables that already contain the needed primary and foreign keys is created using:
A)the 1:N Identifying Relationship button.
B)the 1:N Non-identifying Relationship button.
C)the N:M Identifying Relationship button.
D)the Place a Relationship Using Existing Columns button.
E)None of the above is correct.
Q5) Users should create a Data Models folder to hold EER models created with the MySQL Workbench.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 23
Chapter 18: Getting Started With Microsoft Visio 2013
Available Study Resources on Quizplus for this Chatper
34 Verified Questions
34 Flashcards
Source URL: https://quizplus.com/quiz/35875
Sample Questions
Q1) In Microsoft Visio 2013,the Crow's Foot Database Notation stencil objects include:
A)an Entity object.
B)a Relationship object.
C)a Dynamic connector object.
D)A and B
E)A,B,and C
Q2) In Microsoft Visio 2013,we can create database designs using Entity and Dynamic connector objects.
A)True
B)False
Q3) In Microsoft Visio 2013,the arrow end of the Dynamic connector object points to the table containing the primary key.
A)True
B)False
Q4) In Microsoft Visio 2013,how do we create database designs?
Q5) In Microsoft Visio 2013,how do we create data models?
Q6) When using Microsoft Visio 2013,how do we create a blank diagram for use with a data model?
To view all questions and flashcards with answers, click on the resource link above. Page 24
Chapter 19: Data Structures for Database Processing
Available Study Resources on Quizplus for this Chatper
35 Verified Questions
35 Flashcards
Source URL: https://quizplus.com/quiz/35877
Sample Questions
Q1) Each physical record is addressed by its sequential record number (SRN).
A)True
B)False
Q2) A simple network is a collection of records and the 1:N relationships between them.
A)True
B)False
Q3) A complex network is a collection of records and the 1:N relationships between them.
A)True
B)False
Q4) Each physical record is addressed by its:
A)relative record number (RRN).
B)sequential record number (SRN).
C)transaction record number (TRN).
D)ultimate record number (URN).
E)unknown record number (XRN).
Q5) A two-way linked list has links in both directions.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 25
Chapter 20: the Semantic Object Model
Available Study Resources on Quizplus for this Chatper
35 Verified Questions
35 Flashcards
Source URL: https://quizplus.com/quiz/35879
Sample Questions
Q1) A subtype inherits all the attributes of its parent.
A)True
B)False
Q2) Whether a developer uses an E-R model or a semantic object model,the eventual database design that is created should be exactly the same.
A)True
B)False
Q3) Semantic objects are said to be:
A)Semantically self-contained.
B)Semantically complete.
C)Semantically inclusive.
D)Either A or B.
E)None of the above.
Q4) A "simple object" can contain only simple attributes.
A)True
B)False
Q5) A semantic object must represent something with a physical existence.
A)True
B)False
Q6) Describe the two ways that semantic object views can be used.
Page 26
To view all questions and flashcards with answers, click on the resource link above.
Chapter 21: Getting Started With Web Servers php and the Eclipse PDT
Available Study Resources on Quizplus for this Chatper
35 Verified Questions
35 Flashcards
Source URL: https://quizplus.com/quiz/35881
Sample Questions
Q1) The version of the Eclipse IDE that works with PHP is the Eclipse PDT.
A)True
B)False
Q2) For a workstation running the Windows operating system,a commonly used file system utility is Microsoft Internet Explorer.
A)True
B)False
Q3) Before installing the Eclipse PDT,we have to install ________ .
A)the Java JRE
B)the Java SDK
C)the Java JDK
D)the Jave SRE
E)Any of the above will work.
Q4) The Java JRE is installed directly from the Java download page at www.java.com.
A)True
B)False
Q5) What program must be installed before the installation of the Eclipse PDT,and how do you obtain and install this product?
Q6) What is the Eclipse PDT?
To view all questions and flashcards with answers, click on the resource link above. Page 27
Chapter 22: Business Intelligence Systems
Available Study Resources on Quizplus for this Chatper
80 Verified Questions
80 Flashcards
Source URL: https://quizplus.com/quiz/35883
Sample Questions
Q1) Report authoring includes responsibility for delivery of the report.
A)True
B)False
Q2) A data warehouse is a database system that has data for,programs for and personnel specialized in BI processing.
A)True
B)False
Q3) One Business Intelligence (BI)reporting system that uses extensions to SQL is:
A)cluster analysis.
B)OLAP.
C)regression analysis.
D)RFM analysis.
E)All of the above
Q4) Report management systems include the ability to create associated user accounts and groups.
A)True
B)False
Q5) In unsupervised data mining,explanations are created after patterns are found. A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 28