Applied Database Systems
Final Exam
Course Introduction
Applied Database Systems explores the design, implementation, and management of modern database systems with a strong emphasis on practical applications. The course covers core concepts such as data modeling, relational databases, and SQL, as well as advanced topics including database normalization, transaction processing, indexing, and concurrency control. Students gain hands-on experience with popular database management systems and learn to solve real-world data challenges by designing, querying, and optimizing databases. The course also examines emerging trends such as NoSQL databases and cloud-based solutions, preparing students to build and maintain robust, scalable database applications in diverse technology environments.
Recommended Textbook
Database Processing Fundamentals Design and Implementation 14th Edition by David M. Kroenke
Available Study Resources on Quizplus
25 Chapters
1978 Verified Questions
1978 Flashcards
Source URL: https://quizplus.com/study-set/2437 Page 2
Chapter 1: Introduction
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/48385
Sample Questions
Q1) What components are included in a database?
Answer: The database contains user data,metadata,indexes and other overhead data,and application metadata.User data is the data from the user's environment that they want to track.Metadata is data about the structure of the database.Indexes and other overhead data are structures that the database uses to improve performance.Finally,the application metadata is data about forms,reports,and other application components that some databases,particularly those created with desktop DBMS products,store with the database.
Q2) In a database,each table stores data about a different type of thing.
A)True
B)False
Answer: True
Q3) A sales contact manager used by a salesperson is an example of a(n)________.
A)single-user database application
B)multiuser database application
C)e-commerce database application
D)data mining application
Answer: A
To view all questions and flashcards with answers, click on the resource link above.
3
Chapter 2: Introduction to Structured Query Language
Available Study Resources on Quizplus for this Chatper
114 Verified Questions
114 Flashcards
Source URL: https://quizplus.com/quiz/48388
Sample Questions
Q1) In an SQL query,which SQL keyword is used to determine if a column value is equal to any one of a set of values?
A)AND
B)EXISTS
C)OR
D)IN
Answer: D
Q2) Arithmetic in SQL statements is limited to the operations provided by the built-in functions.
A)True
B)False Answer: False
Q3) The SQL keyword SELECT is used to specify the columns to be listed in the query results.
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/48391
Sample Questions
Q1) A relation is in domain/key normal form if ________.
A)every key of the relation is a logical consequence of the definition of constraints and determinants
B)every key of the relation is a logical consequence of the definition of constraints and domains
C)every constraint on the relation is a logical consequence of the definition of keys and determinants
D)every constraint on the relation is a logical consequence of the definition of keys and domains
Answer: D
Q2) A relation is in 2NF if and only if it is in 1NF and all non-key attributes are determined by the entire primary key.
A)True
B)False
Answer: True
Q3) A determinant of a functional dependency may or may not be unique in a relation. 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/48393
Sample Questions
Q1) When you are given a set of tables and asked to create a database to store their data,the first step is to assess the tables' structure and content.
A)True
B)False
Q2) Multivalued dependencies create anomalies so serious that multivalued dependencies must always be eliminated.
A)True
B)False
Q3) When examining data values as a part of assessing table structure,you should try to determine three types of keys: the primary key,any candidate keys,and any foreign keys. A)True
B)False
Q4) Explain denormalization,and why it may be appropriate to denormalize a set of tables.
Q5) Denormalization reduces the complexity of the SQL statements needed in an application to read required data.
A)True B)False
To view all questions and flashcards with answers, click on the resource link above. Page 6
Chapter 5: Data Modeling With the Entity-Relationship
Model
Available Study Resources on Quizplus for this Chatper
104 Verified Questions
104 Flashcards
Source URL: https://quizplus.com/quiz/48395
Sample Questions
Q1) One example of a database design using an ID-dependent relationship is the archetype/instance pattern.
A)True
B)False
Q2) A line-item pattern must involve what kind of entity?
A)Strong entity
B)Supertype entity
C)Weak entity with one identifying relationship
D)Weak entity with two identifying relationships
Q3) A relationship's maximum cardinality indicates the maximum number of entities that can participate in the relationship.
A)True
B)False
Q4) A circle 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"
Q5) What is an ID-Dependent entity? Include an example.
Q6) How is minimum cardinality expressed in IE Crow's Foot E-R diagrams? Page 7
To view all questions and flashcards with answers, click on the resource link above.
Page 8
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/48397
Sample Questions
Q1) In 1:N relationships,the table on the "many" side is called the child.
A)True
B)False
Q2) When creating a table for an ID-dependent entity,both the key of the parent and the key of the entity itself must appear in the table.
A)True
B)False
Q3) An intersection table is always ID-dependent on both of its parent tables.
A)True
B)False
Q4) 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)Recursive relationships can be 1:1,1:N,or M:N relationships.
D)When the relationship is 1:N,a new table must be defined to represent the relationship.
Q5) In 1:N relationships,the table on the "one" side is called the parent.
A)True
B)False
Q6) Explain the pragmatic reason for using surrogate keys.
To view all questions and flashcards with answers, click on the resource link above. Page 9
Chapter 7: SQL for Database Construction and Application Processing
Available Study Resources on Quizplus for this Chatper
104 Verified Questions
104 Flashcards
Source URL: https://quizplus.com/quiz/48399
Sample Questions
Q1) Rows in a table can be changed by using the SQL UPDATE statement.
A)True
B)False
Q2) Which of the following does not describe a user-defined function?
A)It computes a numeric value
B)It can be called by name from within an SQL statement
C)It may have input parameters passed to it
D)It returns an output value to the calling statement
Q3) SQL views are constructed from SELECT statements.
A)True
B)False
Q4) SQL views can be used to hide columns.
A)True
B)False
Q5) A stored program that is attached to a table or view is called a stored procedure.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 10
Q6) What is embedded SQL,and what considerations are necessary when using it in an application?
Chapter 8: Database Redesign
Available Study Resources on Quizplus for this Chatper
103 Verified Questions
103 Flashcards
Source URL: https://quizplus.com/quiz/48401
Sample Questions
Q1) To add a NULL column to a table,we simply use the MODIFY TABLE statement.
A)True
B)False
Q2) There are several difficulties with increasing cardinalities from 1:1 to 1:N,one of which is preserving the existing relationships.
A)True
B)False
Q3) If a DEFAULT constraint is included when a new column is added to a table,the default value is applied to ________.
A)all existing rows at the time the column is added
B)all new rows
C)all new rows but only after the UPDATE command is issued
D)Both A and B are correct
Q4) What is the process for adding a NOT NULL column to a table?
Q5) The authors refer to the data model produced by reverse engineering as the RE data model.
A)True
B)False
Q6) What is a dependency graph,and what is it used for in database redesign?
Page 11
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/48403
Sample Questions
Q1) A transaction is a group of alternative database actions,from which the database can choose to perform only one of them.
A)True
B)False
Q2) Which of the following is not true about locks?
A)Locks with large granularity are easier for the DBMS to administer.
B)Locks with small granularity cause more conflicts.
C)Locks may have a database-level granularity.
D)Locks may have a table-level granularity.
Q3) One remedy for the inconsistencies caused by concurrent processing is ________.
A)concurrency
B)checkpointing
C)rollback
D)resource locking
Q4) To support rollforward and rollback recovery,transactions must be written to a script before they are applied to the database.
A)True
B)False
Q5) Distinguish between the four cursor types.
To view all questions and flashcards with answers, click on the resource link above. Page 12
Chapter 10: Managing Databases With SQL Server 2014
Available Study Resources on Quizplus for this Chatper
101 Verified Questions
101 Flashcards
Source URL: https://quizplus.com/quiz/48383
Sample Questions
Q1) Database views can only be created in SQL Server through the use of SQL commands.
A)True
B)False
Q2) SQL Server security roles provide a simple way to control user privileges in a database.
A)True
B)False
Q3) When viewing a table in the GUI tools table design window in SQL Server,the notation that should supply the values for a surrogate key is that the Identity property of that column is set to "Yes."
A)True
B)False
Q4) The name TRANSACTION is so special to SQL Server that no stored procedures will work on a table with that name.
A)True
B)False
Q5) Explain how to work around the SQL Server IDENTITY constraint when non-sequential data must be entered.
To view all questions and flashcards with answers, click on the resource link above. Page 13
Chapter 11: Managing Databases With Oracle Database
Available Study Resources on Quizplus for this Chatper
106 Verified Questions
106 Flashcards
Source URL: https://quizplus.com/quiz/48386
Sample Questions
Q1) The PL/SQL keyword BEGIN is used to define a group of PL/SQL statements.
A)True
B)False
Q2) The type of failure that occurs when Oracle Database is unable to write to a physical file is called a media failure.
A)True
B)False
Q3) In Oracle Database,to achieve transaction level consistency,which level of transaction isolation must be used?
A)Read Committed
B)Serializable
C)Repeatable Read
D)Read-only
Q4) Which of the following statements would cause Oracle Database to include a new column named C5,which is a two-digit whole number,to a table named T2?
A)UPDATE TABLE T2 ADD COLUMN C5 NUMBER (2);
B)ALTER TABLE T2 ADD C5 NUMBER (2);
C)UPDATE TABLE T2 INSERT C5 NUMBER (2,0);
D)ALTER TABLE T2 INSERT COLUMN C5 NUMBER (2,0);
To view all questions and flashcards with answers, click on the resource link above. Page 14
Chapter 12: Managing Databases With Mysql 56
Available Study Resources on Quizplus for this Chatper
101 Verified Questions
101 Flashcards
Source URL: https://quizplus.com/quiz/48389
Sample Questions
Q1) The MySQL statement used to define a set of MySQL procedure statements is
A)DECLARE
B)BEGIN
C)IF...THEN...ELSE...END IF D)REPEAT
Q2) MySQL Workbench is the MySQL GUI database administration utility.
A)True
B)False
Q3) Microsoft Windows users should install MySQL Community Edition using the MySQL Installer for Windows.
A)True
B)False
Q4) The MySQL LOOP statement is used to repeat a set of SQL statements as long as some condition is true.
A)True
B)False
Q5) MySQL users may be granted MySQL server administrative roles. A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 15
Chapter 13: The Web Server Environment
Available Study Resources on Quizplus for this Chatper
128 Verified Questions
128 Flashcards
Source URL: https://quizplus.com/quiz/48405
Sample Questions
Q1) An important method of a collection is a(n)________,which can be used to pass through or otherwise identify the items in the collection.
A)iterator
B)identifier
C)converter
D)transformer
Q2) OLE DB is an object-oriented interface.
A)True
B)False
Q3) Only open source products may be used in conjunction with JDBC.
A)True
B)False
Q4) Support for a scrollable cursor is a sign of what type of conformance in a DBMS driver?
A)Level 1 API
B)Extended SQL Grammar
C)Core API
D)Level 2 API
Q5) Compare and contrast servlets and applets.
Q6) Explain the process by which JSP pages are compiled.
Page 16
To view all questions and flashcards with answers, click on the resource link above.
Chapter 14: Big Data, Data-Warehouses, and Business Intelligence Systems
Available Study Resources on Quizplus for this Chatper
108 Verified Questions
108 Flashcards
Source URL: https://quizplus.com/quiz/48407
Sample Questions
Q1) Data mining uses sophisticated statistical and mathematical techniques to perform what-if analyses,to make predictions,and to facilitate decision making.
A)True
B)False
Q2) In RFM analysis,M stands for "how much money."
A)True
B)False
Q3) Problematic data are called dirty data.
A)True
B)False
Q4) Which of the following is not a component of a data warehouse?
A)Data extract,transform,and load (ETL)preparation programs
B)Data warehouse data
C)Operational database updates
D)Data warehouse metadata
Q5) Hadoop is a(n)________.
A)RDMBS
B)OODBMS
C)distributed file system (DFS)
D)Web server
To view all questions and flashcards with answers, click on the resource link above. Page 17
Chapter 15: Getting Started With Microsoft Access 2013
Available Study Resources on Quizplus for this Chatper
53 Verified Questions
53 Flashcards
Source URL: https://quizplus.com/quiz/48384
Sample Questions
Q1) Microsoft Access SQL commands are run within the SQL View of a Query window.
A)True
B)False
Q2) In Microsoft Access,referential integrity constraints are created ________.
A)by checking the Enforce Referential Integrity check box in the Edit Relationships dialog box
B)by setting a property value on the foreign key in the table which contains it
C)by setting a property value on the primary key in the Relationships window
D)by setting a property value on the foreign key in the Relationships window.
Q3) Microsoft uses the term object as a general name for various parts of a Microsoft Access 2013 database.
A)True
B)False
Q4) Microsoft Access 2013 uses the Access 2003 .mdb file format as the default file format for database files.
A)True
B)False
Q5) Microsoft Access database objects are displayed in the Browser Pane.
A)True
B)False
18
To view all questions and flashcards with answers, click on the resource link above.
Chapter 16: Getting Started With Systems Analysis and Design
Available Study Resources on Quizplus for this Chatper
37 Verified Questions
37 Flashcards
Source URL: https://quizplus.com/quiz/48387
Sample Questions
Q1) 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)
Q2) What activities take place during the component design step of the systems development life cycle (SDLC)?
Q3) An information system is a set of components that interact to achieve some purpose or goal.
A)True
B)False
Q4) How does Michael Porter define support business activities? What do they include?
Q5) User interviews are conducted during the requirements analysis step.
A)True
B)False
Q6) Data is facts and numbers.
A)True
B)False
19
Q7) 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.
Chapter 17: E-R Diagrams and the IDEF1X Standard
Available Study Resources on Quizplus for this Chatper
37 Verified Questions
37 Flashcards
Source URL: https://quizplus.com/quiz/48390
Sample Questions
Q1) In IDEF1X,extended E-R model N:M relationships are called ________.
A)nonidentifying connection relationships
B)identifying connection relationships
C)nonspecific relationships
D)category clusters
Q2) The IDEF1X equivalent of the extended E-R model subtype is the category entity,and category entities are placed in categorization clusters.
A)True
B)False
Q3) What are the IDEF1X equivalents of 1:1,1:N and N:M relationships?
Q4) IDEF1X category entities are mutually exclusive within a cluster.
A)True
B)False
Q5) IDEF1X nonspecific relationships correspond to N:M relationships in the extended E-R model.
A)True
B)False
Q6) A categorization relationship is an IS-A relationship.
A)True
B)False
Page 20
To view all questions and flashcards with answers, click on the resource link above.
Chapter 18: 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/48392
Sample Questions
Q1) What new contributions to data modeling do UML-style E-R diagrams introduce?
Q2) In the UML-style entity class ORDERS shown above,"SumOfOrders" is ________.
A)an entity attribute
B)a method
C)a constraint
D)a class attribute
Q3) What format is used for weak entities in UML-style E-R diagrams?
Q4) In the UML-style entity class ORDERS shown above,"GetOrderNo( )" is a ________.
A)private method
B)protected method
C)public constraint
D)public method
Q5) The classes of all entities to be stored in the database are labeled <<persistent>>.
A)True
B)False
Q6) What is OOP persistence,and how is it indicated in UML-style E-R diagrams?
Q7) Attributes preceded by a + are protected. A)True
B)False
Page 21
To view all questions and flashcards with answers, click on the resource link above.
Chapter 19: 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/48394
Sample Questions
Q1) In the MySQL Workbench,a 1:N identifying relationship between two tables that do not 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
Q2) In the MySQL Table Editor,the abbreviation for AUTO_INCREMENT is ________.
A)PK
B)NN
C)UQ
D)AI
Q3) Users should create a folder to hold EER models created with the MySQL Workbench.
A)True
B)False
Q4) The installation of the MySQL Community Edition 5.6 always includes the installation of the MySQL Workbench.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 22
Chapter 20: Getting Started With Microsoft Visio 2013
Available Study Resources on Quizplus for this Chatper
32 Verified Questions
32 Flashcards
Source URL: https://quizplus.com/quiz/48396
Sample Questions
Q1) In Microsoft Visio 2013,we can create data models using ________.
A)Entity and Dynamic connector objects
B)Entity and Relationship connector objects
C)Category and Dynamic connector objects
D)We cannot create data models in Microsoft Visio 2013.
Q2) In Microsoft Visio 2013,we can create supertype/subtype relationships in database designs using ________.
A)Entity and Dynamic connector objects
B)Entity and Relationship connector objects
C)Category and Relationship connector objects
D)We cannot create database designs in Microsoft Visio 2013.
Q3) In Microsoft Visio 2013,when the Entity object is placed in a diagram,it is labeled as a(n)________.
A)entity
B)table
C)relationship
D)dynamic connector
Q4) In Microsoft Visio 2013,how do we create database designs?
Q5) 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 23
Chapter 21: Data Structures for Database Processing
Available Study Resources on Quizplus for this Chatper
39 Verified Questions
39 Flashcards
Source URL: https://quizplus.com/quiz/48398
Sample Questions
Q1) Linked lists can be used to keep records in ________.
A)logical order
B)physical order
C)sequential order
D)pseudo order
Q2) A simple network is a collection of records and the 1:N relationships between them.
A)True
B)False
Q3) How does a DBMS store data on its direct access files?
Q4) Each of the following is an example of a data structure except ________.
A)binary relationship
B)sequential list
C)linked list
D)index
Q5) Linked lists can be used to keep records in a logical order even if they are not necessarily in physical order.
A)True
B)False
Q6) What are tree,simple networks and complex networks?
Page 24
To view all questions and flashcards with answers, click on the resource link above.
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/48400
Sample Questions
Q1) A simple object is a semantic object that contains only ________.
A)single-value,simple or group attributes
B)single-value,object attributes
C)single-value,simple attributes
D)multi-value,simple or group attributes
Q2) Explain why semantic object attributes are called paired attributes.
Q3) The relationship between a parent object and its associated subtype objects is a(n)________.
A)HAS-A relationship
B)WANTS-A relationship
C)NEEDS-A relationship
D)IS-A relationship
Q4) A semantic object must represent something with a physical existence.
A)True
B)False
Q5) Semantic objects are grouped into ________.
A)composites
B)entities
C)objects
D)classes
25
To view all questions and flashcards with answers, click on the resource link above.
Chapter 23: Getting Started With Web Servers, PHP, and the
Netbeans IDE
Available Study Resources on Quizplus for this Chatper
35 Verified Questions
35 Flashcards
Source URL: https://quizplus.com/quiz/48402
Sample Questions
Q1) The IIS Web server is managed using the ________.
A)Microsoft Internet Information Service (IIS)Manager
B)Microsoft SQL Server Management Studio
C)Microsoft Visual Studio
D)Microsoft IIS Workbench
Q2) For a workstation running the Windows operating system,a commonly used Web browser is Microsoft Internet Explorer.
A)True
B)False
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
Q4) There is only one way to install PHP.
A)True
B)False
Q5) What is theNetBeans IDE?
To view all questions and flashcards with answers, click on the resource link above. Page 26
Chapter 24: Business Intelligence Systems
Available Study Resources on Quizplus for this Chatper
82 Verified Questions
82 Flashcards
Source URL: https://quizplus.com/quiz/48404
Sample Questions
Q1) In market basket analysis,confidence is the probability that one particular product will be purchased.
A)True
B)False
Q2) Which of the following is a common supervised data mining technique?
A)Cluster analysis
B)Regression analysis
C)RFM analysis
D)SQL analysis
Q3) Refer to the table above.What is the lift for Drug B being purchased given that Drug A has been purchased?
A).200
B).250
C).333
D).667
Q4) Report modes include dynamic and static.
A)True
B)False
Q5) What are Business Intelligence (BI)systems?
Q6) What is a reporting system?
To view all questions and flashcards with answers, click on the resource link above. Page 27
Chapter 25: Big Data
Available Study Resources on Quizplus for this Chatper
81 Verified Questions
81 Flashcards
Source URL: https://quizplus.com/quiz/48406
Sample Questions
Q1) DBMSs associated with the NoSQL movement use all of the following kinds of database management systems except ________.
A)Key-Value
B)Document
C)Relational
D)Graph
Q2) SOAP was originally an XML-based standard for providing remote procedure calls over the Internet.
A)True
B)False
Q3) A document database may use either XML or JSON as the basis for storing data.
A)True
B)False
Q4) XML documents and XML Schemas are created in different languages.
A)True
B)False
Q5) One of the four categories of NoSQL databases used in the text is the Column Family database.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 28