Relational Database Management Exam Bank
Course Introduction
This course provides an in-depth introduction to relational database management systems (RDBMS), focusing on the principles, architecture, and applications of relational databases. Students will learn about data modeling using Entity-Relationship diagrams, relational algebra, normalization techniques, and Structured Query Language (SQL) for data definition, manipulation, and retrieval. The course also covers transaction management, database security, indexing strategies, and the design of efficient queries. Through hands-on projects and assignments, students will develop practical skills in designing, implementing, and managing relational databases to solve real-world problems.
Recommended Textbook
Database Concepts 7th Edition by David M. Kroenke
Available Study Resources on Quizplus
18 Chapters
1205 Verified Questions
1205 Flashcards
Source URL: https://quizplus.com/study-set/1260 Page 2
Chapter 1: Getting Started
Available Study Resources on Quizplus for this Chatper
76 Verified Questions
76 Flashcards
Source URL: https://quizplus.com/quiz/24869
Sample Questions
Q1) SQL stands for:
A) Standard Query Language.
B) Structural Question Language.
C) Structured Query Language.
D) Standard Question Language.
E) Structured Question Language.
Answer: C
Q2) The purpose of a database is to help people ________. Answer: keep track of things
Q3) Usually,a database table containing both rows and columns is designed to store data for exactly two themes.
A)True
B)False Answer: False
Q4) Microsoft Access 2013 uses the Access 2003 .mdb file format as the default file format for database files.
A)True
B)False Answer: False
To view all questions and flashcards with answers, click on the resource link above. Page 3
Chapter 2: The Relational Model
Available Study Resources on Quizplus for this Chatper
87 Verified Questions
87 Flashcards
Source URL: https://quizplus.com/quiz/24871
Sample Questions
Q1) In SQL Server,the starting value of a surrogate key is called the:
A) Identity.
B) Identity Increment.
C) Identity Start.
D) Identity Seed.
E) Identity Property.
Answer: D
Q2) What is normalization?
Answer: Normalization is a process whereby relations that are not well-formed are modified to become well-formed relations.A relation is considered to be well-formed if the data within it are not subject to unintended negative consequences when it is maintained.Although normalization recognizes several different normal forms,which are categories that the structure of a relation can be classified into based on the types of problems to which it is vulnerable,the basic premises of normalization are that (1)every determinant should be a candidate key,and (2)any relation that is not well formed should be broken into two or more relations that are well-formed.
Q3) In Microsoft Access,the Relationships window is accessed by using the ________ button on the Database tools command tab.
Answer: Relationship
To view all questions and flashcards with answers, click on the resource link above.
Page 4
Chapter 3: Structured Query Language
Available Study Resources on Quizplus for this Chatper
96 Verified Questions
96 Flashcards
Source URL: https://quizplus.com/quiz/24873
Sample Questions
Q1) If you need to create a primary key that is a composite key using SQL,the key may be defined when the table is created using the CREATE TABLE statement.
A)True
B)False
Answer: True
Q2) Conditions after the WHERE keyword require single quotes around the values for columns that have which data type?
A) Char
B) VarChar
C) Integer
D) Numeric
E) Both A and B
Answer: E
Q3) Built-in SQL functions cannot be applied to data combined using the GROUP BY keyword.
A)True
B)False
Answer: False
To view all questions and flashcards with answers, click on the resource link above. Page 5
Chapter 4: Data Modeling and the Entity-Relationship
Model
Available Study Resources on Quizplus for this Chatper
76 Verified Questions
76 Flashcards
Source URL: https://quizplus.com/quiz/24875
Sample Questions
Q1) Distinguish between entity identifiers and keys.
Q2) A use case can be used to perform which of the following tasks?
A) Transform the data model into the database design
B) Validate the data model
C) Fill the database with data
D) Implement business rules
E) Develop applications
Q3) Identifiers of an entity that are composed of two or more attributes are called ________ identifiers.
Q4) A dashed line between entities indicates:
A) a unique identifier.
B) a minimum cardinality of zero.
C) a minimum cardinality of one.
D) an identifying relationship.
E) a nonidentifying relationship.
Q5) A use case is a description of the way a user will employ the features and functions of the new system.
A)True
B)False
Q6) How is maximum cardinality expressed in crow's foot E-R diagrams? Page 6
To view all questions and flashcards with answers, click on the resource link above.
Page 7
Chapter 5: Database Design
Available Study Resources on Quizplus for this Chatper
81 Verified Questions
81 Flashcards
Source URL: https://quizplus.com/quiz/24877
Sample Questions
Q1) What relationship pattern is illustrated in the following schema? EMPLOYEE (EmployeeID,OfficePhone,Manager)
Manager in EMPLOYEE must exist in EmployeeID in EMPLOYEE
A) Association relationship
B) Intersection relationship
C) Recursive relationship
D) Strong entity relationship
E) Supertype/subtype relationship
Q2) As far as Microsoft Access is concerned,there are no N:M relationships.
A)True B)False
Q3) Explain the representation of ID-dependent weak entities using the relational model.
Q4) How are 1:1,1:N and N:M relationships handled in Microsoft Access?
Q5) Once a table has been defined,it should be examined according to ________ criteria.
Q6) Relations should always be normalized to the highest degree possible. A)True B)False
Q7) Explain the process of representing an entity using the relational model.
8
To view all questions and flashcards with answers, click on the resource link above.
Chapter 6: Database Administration
Available Study Resources on Quizplus for this Chatper
76 Verified Questions
76 Flashcards
Source URL: https://quizplus.com/quiz/24879
Sample Questions
Q1) Standard SQL defines four ________,which specify which of the concurrency control problems are allowed to occur.
Q2) Explain the process of using optimistic locking.
Q3) What is the least restrictive isolation level that will prevent nonrepeatable reads?
A) Read Committed
B) Serializable
C) Read Uncommitted
D) Atomic Read
E) Repeatable Read
Q4) The simplest and most feasible means of recovering a database is through reprocessing.
A)True
B)False
Q5) Breaking hardware,power outages,and human mistakes are all reasons that ________.
Q6) Microsoft Access 2013 uses a user-level security system.
A)True
B)False
Q7) Discuss Microsoft Access 2013 security administration.
To view all questions and flashcards with answers, click on the resource link above. Page 9
Chapter 7: Database Processing Applications
Available Study Resources on Quizplus for this Chatper
82 Verified Questions
82 Flashcards
Source URL: https://quizplus.com/quiz/24881
Sample Questions
Q1) A stored procedure is invoked automatically by the DBMS whenever certain events occur.
A)True
B)False
Q2) If the computer hosting the Web server is running a Windows operating system,the Web server is probably:
A) Apache.
B) Tomcat.
C) Internet Information Services (IIS).
D) Internet Interpreter Server (IIS).
E) Information Interpreter Server (IIS).
Q3) Before running Web pages in Internet Information Server (IIS)against a Microsoft Access database,we need to create a(n):
A) OBDC data source.
B) JBDC data source.
C) OLE DB data source.
D) LAMP data source.
E) WAMP data source.
Q4) What is a three-tier architecture?
Q5) What is XML,and why is it useful?
To view all questions and flashcards with answers, click on the resource link above. Page 10
Chapter 8: Big Data, data Warehouses, and Business Intelligence Systems
Available Study Resources on Quizplus for this Chatper
99 Verified Questions
99 Flashcards
Source URL: https://quizplus.com/quiz/24883
Sample Questions
Q1) What is a distributed database?
Q2) Apache Cassandra is an example of a(n)________ non-relational DBMS.
A) Key-Value
B) Document
C) Column Family
D) Graph
E) Object-Oriented
Q3) To use the Access 2013 database in an Excel 2013 PivotTable,it is generally useful to:
A) create a view-equivalent query in Access to organize the data.
B) store the needed data in an Excel worksheet.
C) store the needed data in a Word document.
D) store the needed data in a PowerPoint slide show.
E) store the needed data in a Visio diagram.
Q4) Business Intelligence (BI)systems support operational activities.
A)True
B)False
Q5) Excel 2013 allows us to ________ to an Access 2013 database when building a PivotTable.
Q6) Apache Cassandra is an example of a(n)________ non-relational DBMS.
To view all questions and flashcards with answers, click on the resource link above. Page 11
Chapter 9: Getting Started With Microsoft Sql Server 2012
Available Study Resources on Quizplus for this Chatper
40 Verified Questions
40 Flashcards
Source URL: https://quizplus.com/quiz/24868
Sample Questions
Q1) Users log into SQL Server 2014 Express using the ________ dialog box.
Q2) A new SQL Server database is created using:
A) the New Database dialog box.
B) the Create Database command.
C) the Create New Schema dialog box.
D) the Create Schema command.
E) the New Object dialog box.
Q3) To start working with SQL Server 2014 Express in Windows 8.1,use the command Start | All Programs | Microsoft SQL Server 2014 | SQL Server management Studio Express. A)True B)False
Q4) SQL Server 2014 Express requires that the .NET Framework version 2.0 be installed. A)True B)False
Q5) SQL query results are displayed in a tabbed ________ window.
Q6) SQL Server 2014 uses DBMS authentication by default. A)True B)False
To view all questions and flashcards with answers, click on the resource link above. Page 12
Chapter 10: Getting Started With Oracle Database 11g
Release 2
Available Study Resources on Quizplus for this Chatper
43 Verified Questions
43 Flashcards
Source URL: https://quizplus.com/quiz/24870
Sample Questions
Q1) Oracle Database XE 11.2 uses Application Express to create new workspaces.
A)True
B)False
Q2) Users log into the Oracle Database XE 11.2 utility using the ________ account.
Q3) Describe how to create and run an SQL query in Oracle Database 11g Release 2 .
Q4) Which of the following is an account name for which you would enter a password to connect to a workspace in Oracle SQL Developer?
A) Your own personal login
B) The user login associated with the workspace
C) INTERNAL
D) A and B
E) A, B and C
Q5) To run an SQL script,click the ________ button.
Q6) To run an SQL query,click the ________ button.
Q7) To run an SQL script in Oracle Database 11g Release 2:
A) click the Execute button.
B) click the Execute Script button.
C) click the Run Script button.
D) click the Ready button.
E) click the Results button. Page 13
To view all questions and flashcards with answers, click on the resource link above.
Page 14
Chapter 11: Getting Started With Mysql 56 Community Server
Available Study Resources on Quizplus for this Chatper
71 Verified Questions
71 Flashcards
Source URL: https://quizplus.com/quiz/24872
Sample Questions
Q1) A new MySQL database is created using the New Database dialog box.
A)True
B)False
Q2) SQL statements can be run individually or as part of a related group of SQL statements known as a script.
A)True
B)False
Q3) To create a new MySQL Workbench EER model,you can use the File | New Model command.
A)True
B)False
Q4) SQL statements can be run individually or as part of a related group of SQL statements known as a(n)________.
Q5) To run an SQL script or SQL command in MySQL Server Community Edition:
A) click the Execute button on the Query Toolbar.
B) click the Execute button on the Browser Toolbar.
C) click the Run button on the Query Toolbar.
D) click the Run button on the Browser Toolbar.
E) click the Execute SQL Script button on the Toolbar.
Q6) Describe how to create a new database design in the MySQL Workbench. Page 15
To view all questions and flashcards with answers, click on the resource link above.
Page 16
Chapter 12: James River Jewelry Project Questions
Available Study Resources on Quizplus for this Chatper
70 Verified Questions
70 Flashcards
Source URL: https://quizplus.com/quiz/24874
Sample Questions
Q1) SQL statements used to construct views cannot contain the ________ clause.
Q2) The SQL statement ALTER EXISTING VIEW ViewName AS is used to modify a view. A)True
B)False
Q3) Stored procedures have the advantage of greater security,decreased network traffic,SQL optimized by the DBMS compiler,and code sharing.
A)True
B)False
Q4) SQL triggers use the SQL keywords BEFORE,INSTEAD OF,and AFTER. A)True
B)False
Q5) SQL views are constructed from SQL ________ statements.
Q6) A stored program that is stored within the database and compiled when used is called a trigger.
A)True
B)False
Q7) SQL views can be used to hide table ________.
Q8) SQL statements used to construct views cannot contain the WHERE clause. A)True B)False
To view all questions and flashcards with answers, click on the resource link above. Page 17
Chapter 13: Sql Views
Available Study Resources on Quizplus for this Chatper
47 Verified Questions
47 Flashcards
Source URL: https://quizplus.com/quiz/24876
Sample Questions
Q1) A deliverable from the requirements analysis step is a(n):
A) user requirements document (URD).
B) user requirements statement (URS).
C) statement of work (SOW).
D) statement of requirements (SOR).
E) A and C
Q2) A business process is a set of activities that transforms materials into products.
A)True
B)False
Q3) Information systems are used to support business processes.
A)True
B)False
Q4) One definition of information is knowledge derived from data.
A)True
B)False
Q5) Michael Porter includes inbound logistics in his list of ________ activities.
Q6) ________ is facts and numbers.
Q7) One definition of ________ is knowledge derived from data.
Q8) Databases are created in a DBMS during the ________ step.
To view all questions and flashcards with answers, click on the resource link above. Page 18
Chapter 14: Getting Started in Systems Analysis and Design
Available Study Resources on Quizplus for this Chatper
34 Verified Questions
34 Flashcards
Source URL: https://quizplus.com/quiz/24878
Sample Questions
Q1) In Microsoft Visio 2013,both data models and database designs are created using the Crow's Foot Database Notation template.
A)True
B)False
Q2) In Microsoft Visio 2013,clicking the FILE command tab opens:
A) the File menu.
B) the Backstage view.
C) the Open dialog box.
D) the Save As dialog box.
E) the Save dialog box.
Q3) In Microsoft Visio 2013,we can create database designs using Entity and Dynamic connector objects.
A)True
B)False
Q4) In Microsoft Visio 2013,the data models in this book are created using:
A) the Chen's Database Notation template.
B) the UML database Notation template.
C) the IDEF1X Database Notation template.
D) the Crow's Foot Database Notation template.
E) the Wireframe Database Diagram template.
19
To view all questions and flashcards with answers, click on the resource link above.
Chapter 15: Getting Started With Microsoft Visio 2010
Available Study Resources on Quizplus for this Chatper
17 Verified Questions
17 Flashcards
Source URL: https://quizplus.com/quiz/24880
Sample Questions
Q1) Microsoft Access 2013 switchboards use text labels as part of the menu.
A)True
B)False
Q2) Microsoft Access 2013 switchboards build command buttons by using the ________.
Q3) Microsoft Access 2013 switchboards can be used to create:
A) application forms.
B) application reports.
C) application menus.
D) application databases.
E) All of the above
Q4) Microsoft Access 2013 provides application menuing capabilities by means of a(n)________.
Q5) Microsoft Access 2013 switchboards use ________ as part of the switchboard.
A) text buttons
B) report windows
C) Wizard buttons
D) command buttons
E) All of the above
Q6) Microsoft Access 2013 switchboards use ________ to allow users to implement application actions.
To view all questions and flashcards with answers, click on the resource link above. Page 20
Chapter 16: The Access Workbench-section Microsoft
Access
Available Study Resources on Quizplus for this Chatper
35 Verified Questions
35 Flashcards
Source URL: https://quizplus.com/quiz/24882
Sample Questions
Q1) For a workstation running the Windows operating system,a commonly used Web browser is Microsoft Internet Explorer.
A)True
B)False
Q2) For a workstation running the Windows operating system,the user file system permissions Modify and Write must be granted to the Users group at the ________ folder.
A) wwwroot
B) inetpub
C) web
D) eclipse
E) php
Q3) Below installing the NetBeans IDE,we have to install ________.
A) the Java JRE
B) the Java SDK
C) the Java JDK
D) the Java SRE
E) Any of the above will work.
Q4) What program must be installed before the installation of the NetBeans IDE,and how do you obtain and install this product?
To view all questions and flashcards with answers, click on the resource link above. Page 21
Chapter 17: Getting Started With Web Servers, php, and the
Netbeans IDE
Available Study Resources on Quizplus for this Chatper
98 Verified Questions
98 Flashcards
Source URL: https://quizplus.com/quiz/24884
Sample Questions
Q1) Business Intelligence (BI)________ uses sophisticated statistical and mathematical techniques to perform what-if analyses,to make predictions,and to facilitate decision making.
Q2) Business Intelligence (BI)systems fall into two broad categories: ________ and ________.
Q3) Business Intelligence (BI)________ are used to filter data,sort data,group data and make simple calculations based on the data.
Q4) Reports that do not change once prepared are called static reports.
A)True
B)False
Q5) Report modes include dynamic and static.
A)True
B)False
Q6) Problematic data include so-called "dirty data."
A)True
B)False
Q7) In a common form of RFM analysis,customers with an F score of ________ are in the 20% of customers who have the most frequent orders.
Q8) What is data mining application? Page 22
To view all questions and flashcards with answers, click on the resource link above.
Page 23
Chapter 18: Business Intelligence Systems
Available Study Resources on Quizplus for this Chatper
77 Verified Questions
77 Flashcards
Source URL: https://quizplus.com/quiz/24885
Sample Questions
Q1) XML documents that are not-type-valid can still be ________.
A) DTD-valid
B) XML-valid
C) DTD-compliant
D) XML-compliant
E) proper XML documents
Q2) An example of a document database is ________.
A) Dynamo
B) Couchbase Server
C) Bigtable
D) Neo4j
E) MySQL
Q3) XML Schemas consist of ________.
A) elements
B) attributes
C) properties
D) A and B
E) A, B, and C
Q4) In database/ XML applications,it is a recommended practice that ________ carry data,and that ________ carry metadata.
To view all questions and flashcards with answers, click on the resource link above. Page 24