Relational Database Management
Practice Questions
Course Introduction
This course provides an in-depth introduction to relational database management systems (RDBMS), focusing on the fundamental concepts, design, implementation, and management of relational databases. Topics include data modeling using Entity-Relationship diagrams, normalization techniques, Structured Query Language (SQL) for data definition and manipulation, indexing, transactions, concurrency, and security. The course emphasizes practical experience through designing, developing, and querying databases, preparing students to manage data effectively and apply best practices in real-world scenarios.
Recommended Textbook
Database Concepts 8th Edition by David M. Kroenke
Available Study Resources on Quizplus
18 Chapters
1259 Verified Questions
1259 Flashcards
Source URL: https://quizplus.com/study-set/898 Page 2
Chapter 1: Getting Started
Available Study Resources on Quizplus for this Chatper
82 Verified Questions
82 Flashcards
Source URL: https://quizplus.com/quiz/17704
Sample Questions
Q1) What is a surrogate key and how does Microsoft Access 2016 create surrogate keys?
Answer: A surrogate key is usually a computer-generated unique number that serves as the identifier of each row in a table.Microsoft Access 2016 generates surrogate keys by using the Access AutoNumber data type.
Q2) The Microsoft Access 2016 application generator provides the ability to create and store forms,reports,and queries.
A)True
B)False
Answer: True
Q3) Regarding Big Data,what does the term NoSQL really mean?
A) No SQL used
B) NortonOS Query Language
C) Notational Query Language
D) Non-Blocking Query Language
E) Non-Relational Database
Answer: E
Q4) In a database system,the ________ creates and processes forms.
Answer: database application
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
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/17706
Sample Questions
Q1) Since Microsoft Access is a personal database,it is not subject to the modification problems that occur in other relational databases.
A)True
B)False
Answer: False
Q2) Explain the concept of a functional dependency.
Answer: A functional dependency is a relationship that exists among the attributes of a relation,such that if the value of one attribute or group of attributes is known,the value of another attribute or group of attributes can be determined.In a functional dependency,the attribute(s)whose value determines the value of the other attribute is called the "determinant." The other attribute,whose value is determined by the determinant,is said to be functionally dependent on the determinant.
Q3) The primary key is used both to identify unique rows in a relation and to represent rows in relationships.
A)True
B)False
Answer: True
To view all questions and flashcards with answers, click on the resource link above.
4
Chapter 3: Structured Query Language
Available Study Resources on Quizplus for this Chatper
97 Verified Questions
97 Flashcards
Source URL: https://quizplus.com/quiz/17708
Sample Questions
Q1) What are SQL Built-in Functions?
Answer: SQL Built-in Functions are functions that manipulate the results of an SQL SELECT statement.The built-in functions for standard SQL are COUNT,SUM,AVG,MAX,and MIN.The COUNT function counts the number of rows in the result.The SUM function totals the values in a number-oriented field.The AVG function calculates the mean of the values in a number-oriented field.The MAX function determines the highest value,and the MIN function determines the lowest value,in a number-oriented field.
Q2) Which of the following is not a standard data type used in SQL?
A) Text
B) Char
C) Varchar
D) Integer
E) Numeric
Answer: A
Q3) Data is added to a table using the SQL INSERT command.
A)True
B)False
Answer: True
To view all questions and flashcards with answers, click on the resource link above.
5
Chapter 4: Data Modeling and the Entity Relationship Model
Available Study Resources on Quizplus for this Chatper
83 Verified Questions
83 Flashcards
Source URL: https://quizplus.com/quiz/17710
Sample Questions
Q1) Distinguish between a data model and a database design.
Q2) Identifiers of an entity that are composed of two or more attributes are called ________ identifiers.
Q3) Microsoft Access uses ________ form and report editors.
Q4) An entity cannot be both weak and strong.
A)True
B)False
Q5) What is a "use case" and how is it used?
Q6) An entity class is described by the structure of the entities in that class.
A)True
B)False
Q7) Microsoft Access wizards allow easy mock-ups of forms and reports for prototyping.
A)True B)False
Q8) Changing aspects of a source document is much more difficult than changing the actual database,once constructed.
A)True
B)False
Q9) ________ can be used to build prototype databases.
To view all questions and flashcards with answers, click on the resource link above. Page 6
Chapter 5: Database Design
Available Study Resources on Quizplus for this Chatper
81 Verified Questions
81 Flashcards
Source URL: https://quizplus.com/quiz/17712
Sample Questions
Q1) What relationship pattern is illustrated in the following schema?
PRODUCT (ProductID,Description)
SUPPLIER (SupplierID,ContactName,PhoneNumber)
PRODUCT_SUPPLIER (ProductID,SupplierID,Cost)
ProductID in PRODUCT_SUPPLIER must exist in ProductID in PRODUCT
SupplierID in PRODUCT_SUPPLIER must exist in SupplierID in PRODUCT
A) Association relationship
B) Intersection relationship
C) Recursive relationship
D) Strong entity relationship
E) Supertype/subtype relationship
Q2) There are cases where it is possible to normalize a table too far,in which case there may be a need for ________.
Q3) By default,the identifier of the entity becomes the foreign key of the corresponding table.
A)True
B)False
Q4) Once a table has been defined,it should be examined according to ________ criteria.
Q5) The first step of database design is to define a table for each ________.
Page 7
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
78 Verified Questions
78 Flashcards
Source URL: https://quizplus.com/quiz/17714
Sample Questions
Q1) Rollback requires the use of logs,but rollforward does not.
A)True
B)False
Q2) Statement level consistency means that all statements within a transaction will access consistent rows across the lifetime of the entire transaction.
A)True
B)False
Q3) When Microsoft Access 2016 uses user-level security with an Access 2003 database file,it stores the database in a(n)________ file.
Q4) What is the least restrictive isolation level that will prevent dirty reads?
A) Read Committed
B) Serializable
C) Read Uncommitted
D) Atomic Read
E) Repeatable Read
Q5) A(n)________ cursor takes a snapshot of a relation and processes that snapshot,while changes from others sources are not visible to this type of cursor.
Q6) What is the difference between authentication and authorization?
To view all questions and flashcards with answers, click on the resource link above. Page 8
Chapter 7: Database Processing Applications
Available Study Resources on Quizplus for this Chatper
84 Verified Questions
84 Flashcards
Source URL: https://quizplus.com/quiz/17716
Sample Questions
Q1) NetBeans is a(n)________.
Q2) The final step of using a PHP connection to a DBMS is to ________.
A) open the connection
B) test the connection
C) query the database
D) process the query results
E) close the connection
Q3) Before running Web pages in Internet Information Server (IIS)against a Microsoft Access database,we need to create a(n)________.
A) ODBC data source
B) JBDC data source
C) OLE DB data source
D) LAMP data source
E) WAMP data source
Q4) What are the common differences between a Web database processing system running on the Windows operating system and one running on a Linux operating system?
Q5) ODBC is an industry standard interface between programming code and DBMS APIs. A)True
B)False
9
To view all questions and flashcards with answers, click on the resource link above.
Chapter 8: Data Warehouses,Business Intelligence
Systems,and Big Data
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/17718
Sample Questions
Q1) Report delivery is more important for data mining than it is for reporting systems.
A)True
B)False
Q2) When distributed databases create copies of the database on different servers,this is known as ________.
A) replication
B) partitioning
C) disbursing
D) distributed two-phase locking
E) division
Q3) Slowly changing dimensions are handled by a(n)________.
A) operational database
B) dimensional database
C) structured storage
D) either A or B
E) distributed database
Q4) In the MapReduce process,the Reduce step is followed by the Map step.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 10
Chapter 9: Learn how to create a database in SQL Server
Available Study Resources on Quizplus for this Chatper
43 Verified Questions
43 Flashcards
Source URL: https://quizplus.com/quiz/17703
Sample Questions
Q1) SQL Server 2016 uses DBMS authentication by default.
A)True
B)False
Q2) Users log into SQL Server 2016 Express using the ________ dialog box.
Q3) The name of the SQL Server 2016 ODBC client as it appears in the ODBC Data Source Administrator is ________.
A) SQL Server ODBC Client 2016
B) ODBC Driver 13 for SQL Server
C) SQL Server Native Client 2008
D) SQL Server Native Client 2008 R2
E) SQL Server Native Client 11.0
Q4) SQL query results are displayed in a tabbed Results window.
A)True
B)False
Q5) An SQL command to add data into a database is ADD INTO A)True B)False
Q7) SQL Server 2016 uses ________ authentication by default. Page 11
Q6) Describe why SQL Server 2016 is sensitive to certain words being used in SQL commands or scripts,and what to do about it.
To view all questions and flashcards with answers, click on the resource link above. Page 12
Chapter 10: Learn how to create a database in Oracle
Database XE 11g Release 2
Available Study Resources on Quizplus for this Chatper
52 Verified Questions
52 Flashcards
Source URL: https://quizplus.com/quiz/17705
Sample Questions
Q1) The NextVal method provides the next value in a sequence.
A)True
B)False
Q2) The Oracle Database GUI tool used for application development is the Oracle SQL Developer.
A)True
B)False
Q3) 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) Database Username
B) Application Express Username
C) INTERNAL
D) Both A and B
E) A, B and C
Q4) The Oracle Database ODBC Client is installed ________ when Oracle Database Express Edition 11g Release 2 is installed.
Q5) Describe how to create and run an SQL script in Oracle Database Express Edition 11g Release 2.
Q6) What is SQL Developer?
To view all questions and flashcards with answers, click on the resource link above. Page 13
Chapter 11: Learn how to create a database in MySQL 57
Community Server Edition
Available Study Resources on Quizplus for this Chatper
72 Verified Questions
72 Flashcards
Source URL: https://quizplus.com/quiz/17707
Sample Questions
Q1) In the MySQL Workbench,a 1:N non-identifying relationship between two tables that already contain the needed primary and foreign keys is created using ________.
A) the <b>1:N Identifying Relationship </b>button
B) the <b>1:N Non-identifying Relationship </b>button
C) the <b>N:M Identifying Relationship </b>button
D) the <b>Place a Relationship Using Existing Columns</b> button
E) None of the above is correct.
Q2) The MySQL Workbench is included in the MySQL Community Server 5.7 installation when the MySQL Installer for Windows is used.
A)True
B)False
Q3) To run an SQL script,click the Execute button on the Query Toolbar.
A)True
B)False
Q4) Describe how to add a table object to a MySQL Workbench database design.
Q5) Users log into MySQL 5.7 Community Server Edition using the ________ dialog box.
Q6) Describe how to create a new database design in the MySQL Workbench.
To view all questions and flashcards with answers, click on the resource link above. Page 14
Q7) Describe how to create and run an SQL query in MySQL 5.7 Community Server Edition.
Chapter 12: Introduce the topic of importing Microsoft Excel
2016 data into a database table
Available Study Resources on Quizplus for this Chatper
84 Verified Questions
84 Flashcards
Source URL: https://quizplus.com/quiz/17709
Sample Questions
Q1) SQL triggers can be used when the DBMS receives an UPDATE request.
A)True
B)False
Q2) A relational database table meets the definition of a set.
A)True
B)False
Q3) Microsoft Access ________ can use previously stored view equivalent Access queries the same way an SQL SELECT statement uses SQL views.
Q4) SQL triggers use the SQL keywords BEFORE,INSTEAD OF,and AFTER.
A)True
B)False
Q5) Which of the following is not an SQL trigger?
A) BEFORE UPDATE
B) INSTEAD OF UPDATE
C) BEFORE INSERT
D) INSTEAD OF CONSTRAINT
E) AFTER DELETE
To view all questions and flashcards with answers, click on the resource link above. Page 15
Q6) Since an SQL view is essentially a stored query,Microsoft Access ________ can be used to implement SQL view equivalents.
Available Study Resources on Quizplus for this Chatper
54 Verified Questions
54 Flashcards
Source URL: https://quizplus.com/quiz/17711
Sample Questions
Q1) User interviews are conducted during the ________ step of the SDLC.
A) system definition
B) requirements analysis
C) component design
D) implementation
E) systems maintenance
Q2) The classic systems analysis methodology is called the ________.
Q3) ________ is a commonly used system for drawing business process models.
Q4) Database designs are created during the ________ step of the SDLC.
A) system definition
B) requirements analysis
C) component design
D) implementation
E) systems maintenance
Q5) Systems analysis and design is the process of ________ and ________ information systems.
Q6) Database designs are created during the ________ step.
Q7) A computer-based information system has ________ components.
Page 16
Q8) How does Michael Porter define primary or operational business activities?
Q9) Define and discuss an information system.
To view all questions and flashcards with answers, click on the resource link above.
Page 17
Chapter 14: Learn how to create E-R data models in Microsoft Visio 2016
Available Study Resources on Quizplus for this Chatper
33 Verified Questions
33 Flashcards
Source URL: https://quizplus.com/quiz/17713
Sample Questions
Q1) In Microsoft Visio 2016,how do we create data models?
Q2) In Microsoft Visio 2016,for a Relationship object relationship that is one-optional on the child side of the relationship,the correct setting in the Symbol menu is ________.
A) 1 and only 1
B) 1 or more
C) Zero or 1
D) Zero or more
E) Range [At least][At most]
Q3) In Microsoft Visio 2016,we can create data models using Entity and Relationship objects.
A)True
B)False
Q4) In Microsoft Visio 2016,the arrow end of the Dynamic connector object points to the table containing the primary key.
A)True
B)False
Q5) Microsoft Visio 2016 can be used to create data models,but not database designs.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 18
Chapter 15: Learn how to create Microsoft Access 2016 switchboards
Available Study Resources on Quizplus for this Chatper
17 Verified Questions
17 Flashcards
Source URL: https://quizplus.com/quiz/17715
Sample Questions
Q1) When using Microsoft Access 2016,how do we create a switchboard?
Q2) A Microsoft Access 2016 switchboard provides a button-based menu system in Microsoft Access 2016. A)True
B)False
Q3) Microsoft Access 2016 switchboards build command buttons by using the ________.
Q4) Microsoft Access 2016 switchboards use ________ to place text on switchboards.
Q5) Microsoft Access 2016 switchboards use command buttons as part of the menu. A)True B)False
Q6) Microsoft Access 2016 provides application menuing capabilities by means of a(n)________.
Q7) Microsoft Access 2016 command buttons are created using the Command Button Wizard. A)True B)False
Q8) Microsoft Access 2016 switchboards use ________ to allow users to implement application actions. Page 19
Q9) Microsoft Access 2016 switchboards are built using a Microsoft Access ________.
To view all questions and flashcards with answers, click on the resource link above.
Page 20
Chapter 16: Know how to configure and update PHP
Available Study Resources on Quizplus for this Chatper
36 Verified Questions
36 Flashcards
Source URL: https://quizplus.com/quiz/17717
Sample Questions
Q1) Installing PHP using the Microsoft Installer provides sufficient PHP support for use with Database Concepts 8th Edition.
A)True
B)False
Q2) The PHP installation in the text installed version ________ of PHP.
A) 5.2.13
B) 5.2.14
C) 5.3.0
D) 5.3.5
E) 5.3.28
Q3) For a workstation running the Windows operating system,the user file system permissions Modify and Write must be granted to ________ at the wwwroot folder.
A) the ISUR_{WebServerName} User
B) the IAPP_{WebServerName} User
C) the WebUsers group
D) the Users group
E) None of the above is correct.
Q4) What is PHP?
Q5) What is the NetBeans IDE?
To view all questions and flashcards with answers, click on the resource link above. Page 21
Chapter 17: Learn the basic concepts of business intelligence (BI)systems
Available Study Resources on Quizplus for this Chatper
98 Verified Questions
98 Flashcards
Source URL: https://quizplus.com/quiz/17719
Sample Questions
Q1) A report generated by a reporting system is delivered to the appropriate users via an electronic display customized for each user.This system uses which of the following media?
A) Paper
B) Web portal
C) Digital dashboard
D) E-mail
E) None of the above
Q2) Refer to the table above.What is the support for Drug A and Drug B?
A) .025
B) .075
C) .100
D) .125
E) .200
Q3) In market basket analysis,confidence is the probability that one particular product will be purchased.
A)True
B)False
Q4) What is data mining application?
To view all questions and flashcards with answers, click on the resource link above. Page 22
Q5) A(n)________ is an information system that helps users analyze and use data.
Chapter 18: Learn about replicated partitioned data stores for supporting clusters
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/17720
Sample Questions
Q1) ________ is a set of approaches for taking portions of a database and moving them to a different server in a cluster.
Q2) Which of the following is true about XML?
A) It allows the confounding of document structure, content, and format.
B) It is non-standardized to allow for extension by developers.
C) The structure of documents is formally defined.
D) XML tags, like some HTML tags, are vague and arbitrary.
E) None of the above
Q3) Graph databases are composed of three elements,one of which is the edge.
A)True
B)False
Q4) XML provides a standardized,non-customizable way to describe the content of a document.
A)True
B)False
Q5) The default cardinality for elements in an XML Schema is ________.
Q6) What is XML,and why is it significantly better than HTML?
Q8) Graph databases are composed of ________. Page 23
Q7) An important improvement of XML Schema over DTDs is that XML Schema are ________.
To view all questions and flashcards with answers, click on the resource link above.
Page 24