Database Application Development Exam Review
Course Introduction
This course offers a comprehensive exploration of database application development, focusing on the principles, tools, and techniques required to design, implement, and maintain robust, scalable database-driven applications. Students will learn about database architectures, data modeling, SQL, and advanced querying, as well as integrating databases with programming languages to build dynamic, interactive applications. The course also covers best practices for security, performance optimization, and application testing. Through hands-on projects and case studies, students gain practical experience in developing solutions for real-world data management challenges.
Recommended Textbook
Database Processing Fundamentals Design and Implementation 14th Edition by
Available Study Resources on Quizplus
25 Chapters
1978 Verified Questions
1978 Flashcards
Source URL: https://quizplus.com/study-set/2437
Page 2
David M. Kroenke
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) A database consists of integrated tables,which store ________. A)reports
B)data and relationships among the data C)forms
D)Both A and C are correct
Answer: B
Q2) In database systems,indexes are held in the database. A)True
B)False
Answer: True
Q3) Data is recorded facts and figures;information is knowledge derived from data. A)True
B)False Answer: True
Q4) The DBMS ranked as being the "easiest to use" in the text is Microsoft's SQL Server. A)True
B)False
Answer: False
To view all questions and flashcards with answers, click on the resource link above.
Page 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 implement a subquery?
A)GROUP BY
B)HAVING
C)ORDER BY
D)SELECT
Answer: D
Q2) An asterisk (*)following the SELECT verb means that all columns are to be displayed.
A)True
B)False
Answer: True
Q3) To refer to a set of values in a condition,the values are placed inside parentheses ( )and separated by commas.
A)True
B)False Answer: True
Q4) SQL is not a complete programming language.Rather it is a data sublanguage.
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 multivalued dependency exists when a determinant is matched to a set of values.
A)True
B)False
Answer: True
Q2) A determinant that determines all the other columns in a relation is a ________.
A)record
B)surrogate key
C)foreign key
D)candidate key
Answer: D
Q3) A ________ is used to limit the possible values of a foreign key.
A)composite key
B)surrogate key
C)functional dependency
D)referential integrity constraint
Answer: D
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 ________.
A)assess the existing tables' structure and content
B)design the database structure
C)create one or more new tables
D)move the data into the new database
Q2) A null value can indicate which of the following conditions?
A)The value is incorrect.
B)The value is appropriate but unknown.
C)The value has been updated.
D)The value can never be changed.
Q3) The SQL INSERT statement can be used to populate normalized tables.
A)True
B)False
Q4) SQL statements that can be used to create referential integrity statements for normalized tables are created during the normalization process.
A)True
B)False
Q5) What are inconsistent values,and why are they a problem?
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) 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"
Q2) The supremetype entity contains the attributes that are common to all subtypes.
A)True
B)False
Q3) In today's E-R models,attributes of relationships are still used.
A)True
B)False
Q4) Attributes may be ________.
A)complete
B)optional
C)multivalued
D)required
Q5) The notation 1:N shows a relationship's maximum cardinalities.
A)True
B)False
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/48397
Sample Questions
Q1) When the key of one table is placed into a second table to represent a relationship,the key is called a relational key in the second table.
A)True
B)False
Q2) A referential integrity constraint policy that insures that foreign key values in a table are correctly maintained when there is a change to the primary key value in the parent table is called ________.
A)incremental updates
B)incremental deletes
C)cascading updates
D)cascading deletes
Q3) Recursive M:N relationships are represented with an intersection table that shows pairs of related rows from a single table.
A)True
B)False
Q4) The last step in creating a table is to verify table normalization.
A)True
B)False
Q5) What are MUST NOT and MUST COVER constraints?
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
104 Verified Questions
104 Flashcards
Source URL: https://quizplus.com/quiz/48399
Sample Questions
Q1) When a trigger is fired,the DBMS makes the appropriate data available to
A)the SQL interpreter
B)the application code
C)the embedded SQL code
D)the trigger code
Q2) The Oracle DBMS supports the SQL BEFORE trigger.
A)True
B)False
Q3) A set of SQL statements stored in an application written in a standard programming language is called embedded SQL.
A)True
B)False
Q4) One advantage of using the CONSTRAINT phrase to define a primary key is that the database designer controls the ________.
A)name of the table
B)name of the foreign key field
C)name of the constraint
D)name of the primary key field
To view all questions and flashcards with answers, click on the resource link above. Page 9
Q5) Explain the essential format of the CREATE TABLE statement. Include an example.
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) What is the process and what are the considerations when changing a table name?
Q2) There is a common trap in writing a correlated subquery,which will cause no rows to ever be displayed in the results.
A)True
B)False
Q3) In a correlated subquery,the same table is used in the upper and lower SELECT statements.
A)True
B)False
Q4) To change a table name,we ________.
A)use the SQL RENAME TABLE command
B)use the SQL ALTER TABLENAME command
C)use the SQL MODIFY TABLENAME command
D)create a new table,move the data,and drop the old table
Q5) What is reverse engineering and how well does it work?
Q6) Converting date,money,or other more specific data types to char or varchar will usually succeed.
A)True
B)False
Q7) What is the process for adding a NOT NULL column to a table?
To view all questions and flashcards with answers, click on the resource link above. Page 10
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) The database is most vulnerable to failure after a change to its structure.
A)True
B)False
Q2) Locks that are placed assuming that a conflict will occur are called ________.
A)explicit locks
B)implicit locks
C)optimistic locks
D)pessimistic locks
Q3) A dynamic cursor saves primary key values when the cursor is opened and retrieves the values for each row as the application program accesses it.
A)True
B)False
Q4) A series of actions to be taken on the database such that either all actions are completed successfully,or none of them can be completed,is known as a ________.
A)checkpoint
B)log
C)lock
D)transaction
Q5) Explain the purpose of transaction logs and checkpoints.
To view all questions and flashcards with answers, click on the resource link above. Page 11
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) For triggers on insert and update actions,the new column values are stored in
A)a table named new:TableName
B)a table named old:TableName
C)a pseudotable name inserted
D)a pseudotable named deleted
Q2) Locking hints included in an SQL statement will override locking behavior based on explicit transaction isolation level statements.
A)True
B)False
Q3) SQL Server AFTER triggers may be used with insert and update actions,but not delete actions.
A)True
B)False
Q4) Stored procedures and triggers in SQL Server may become confused while executing stored procedures and triggers when SQL Server special words such as TRANSACTION appear as table or other names,even if they are enclosed in square brackets [ ].
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 12
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) Oracle Database provides only one method for creating an Oracle Database database.
A)True
B)False
Q2) The Oracle Database PL/SQL statement used to complete the basic PL/SQL block structure is ________.
A)DECLARE
B)BEGIN
C)IF...ELSE...END IF
D)END;
Q3) When creating a new database in Oracle Database,two new account passwords are automatically created in the database.
A)True
B)False
Q4) Oracle Database uses the SQL ALTER TABLE command to change the structure of a table.
A)True
B)False
Q5) What is the Oracle Enterprise Manager Database Express?
Q6) Explain the Oracle Database PL/SQL cursor statements.
To view all questions and flashcards with answers, click on the resource link above. Page 13
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 SQL/PSM statement used to test for a condition and then direct which blocks of code should be run depending on the outcome of the test is ________.
A)DECLARE
B)BEGIN
C)IF...THEN...ELSE...END IF
D)REPEAT
Q2) The MySQL keyword to create a cursor is ________.
A)DECLARE CURSOR {CursorName}
B)OPEN {CursorName}
C)FETCH
D)CLOSE {CursorName}
Q3) MySQL supports BEFORE triggers.
A)True
B)False
Q4) The SQL query data results are displayed ________.
A)in the Navigator window
B)in a tabbed Result Grid
C)in a Messages window
D)in a tabbed Action Output window
Q5) Explain the MySQL Block Structure.
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
128 Verified Questions
128 Flashcards
Source URL: https://quizplus.com/quiz/48405
Sample Questions
Q1) Which of the following is true of JDBC?
A)Programs must be written in Java.
B)JDBC only works with open-source products.
C)JDBC is only available for Unix-like operating systems,such as Linux.
D)JDBC is actually a DBMS.
Q2) A Java virtual machine is actually a ________.
A)program compiler
B)JDBC data source
C)bytecode interpreter
D)JDBC driver
Q3) Only open source products may be used in conjunction with JDBC.
A)True
B)False
Q4) In PHP,any programming language statements that are to be processed on the server must be enclosed in ________.
A)<!-- and --!>
B)[php and php]
C)(php and php)
D)<?php and ?>
Q5) Briefly describe PHP.
To view all questions and flashcards with answers, click on the resource link above. Page 15
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) Hadoop is a(n)________.
A)RDMBS
B)OODBMS
C)distributed file system (DFS)
D)Web server
Q2) Google's Bigtable was an early example of structured storage.
A)True
B)False
Q3) Which of the following is not a reason that operational data are difficult to read?
A)Dirty data
B)Current data
C)Nonintegrated data
D)Missing values
Q4) Business Intelligence (BI)reporting systems summarize the current status of business activities and compare that status with past events,but not with predicted future activities.
A)True
B)False
Q5) What is a data warehouse?
To view all questions and flashcards with answers, click on the resource link above. Page 16
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 can run QBE queries,but not SQL queries.
A)True
B)False
Q2) The Microsoft Access window Close button is actually a close-and-exit button.
A)True
B)False
Q3) In Microsoft Access,relationships between tables are created in the Relationships window.
A)True
B)False
Q4) In addition to the basic command tabs,Microsoft Access 2013 also has additional contextual command tabs.
A)True
B)False
Q5) In Microsoft Access,the relationship between two tables is not actually created until
A)the OK button in the Create Relationships dialog box is clicked
B)the Create button in the Create Relationships dialog box is clicked
C)the OK button in the Edit Relationships dialog box is clicked
D)the Create button in the Edit Relationships dialog box is clicked
To view all questions and flashcards with answers, click on the resource link above. Page 17
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) Databases are created in a DBMS during the ________ step of the SDLC.
A)system definition
B)requirements analysis
C)component design
D)implementation
Q2) Information systems are used to support business processes.
A)True
B)False
Q3) How does Michael Porter define support business activities? What do they include?
Q4) Which of the following does a User Requirements Document (URD)typically NOT contain?
A)A data model
B)Functional requirements
C)The scope of the work to be done
D)Project delivery requirements
Q5) One deliverable from the requirements analysis step is a statement of requirements (SOR).
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 18
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) Extended E-R model 1:N relationships are called identifying connection relationships in IDEF1X.
A)True
B)False
Q2) In IDEF1X,a type domain allows ________.
A)different data types
B)different values
C)greater specificity of values
D)default values
Q3) The IDEF1X default cardinality of a nonidentifying connection relationship is indicated by a dashed line with a filled-in circle by the child and no other notation.
A)True
B)False
Q4) In IDEF1X,the named set of values that an attribute can have is called a ________.
A)domain
B)base domain
C)type domain
D)domain cluster
To view all questions and flashcards with answers, click on the resource link above. Page 19
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) 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
Q3) In UML,an attribute that is accessible only by methods of its entity class is said to be
A)private
B)exclusive
C)protected
D)public
Q4) Which of the following is not a true statement about the current version of UML?
A)UML places a filled-in diamond on the parent of a weak entity.
B)UML provides a means to document exclusivity among subtypes.
C)UML uses the label <identifying> to document an ID-dependent relationship.
D)UML shows the cardinality on the parent entity of a weak entity as simply "1."
Q5) What is OOP persistence,and how is it indicated in UML-style E-R diagrams?
To view all questions and flashcards with answers, click on the resource link above. Page 20
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) To create a new MySQL Workbench EER model,you can use ________.
A)the add Model link on the Home page
B)the File | New Model command
C)the Start new EER command
D)Both A or B are correct
Q2) In the MySQL Table Editor,the abbreviation for AUTO_INCREMENT is ________.
A)PK
B)NN
C)UQ
D)AI
Q3) In the MySQL Table Editor,the abbreviation for NOT NULL is ________.
A)PK
B)NN
C)UQ
D)BIN
Q4) To create a new MySQL Workbench EER model,you can use the File | New Model command.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 21
Q5) Describe how to create relationships in a MySQL Workbench database design.
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,the Crow's Foot Database Notation stencil objects include a Category object.
A)True
B)False
Q2) 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)Both A and B are correct
Q3) In Microsoft Visio 2013,the cardinalities of the Relationship connector object end points are formatted using ________.
A)the Set Begin Symbol command
B)the Set End Symbol command
C)the Set Non-primary Key Unique column
D)Both A and B are correct
Q4) Microsoft Visio 2013 can be used to create data models.
A)True
B)False
Q5) In Microsoft Visio 2013,how do we create data models?
To view all questions and flashcards with answers, click on the resource link above. Page 22
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) What is a set?
Q2) What is a B-tree?
Q3) A complex network cannot be decomposed into trees or simple networks.
A)True
B)False
Q4) The term set refers to all records having the same nonunique secondary key.
A)True
B)False
Q5) Simple networks can be represented by using ________.
A)indexes or linked lists
B)linked lists or sequential lists
C)sequential lists or indexes
D)complex networks
Q6) A ________ is a file that has no repeating groups.
A)flat file
B)stacked file
C)record file
D)key file
Q7) How does a DBMS store data on its direct access files?
Q8) What are tree,simple networks and complex networks?
To view all questions and flashcards with answers, click on the resource link above. Page 23
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 version object ________.
A)may be a composite object
B)typically contains the archetype object in its identifier
C)typically is a simple object
D)produces archetype objects
Q2) 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
Q3) Describe the two ways that semantic object views can be used.
Q4) A simple attribute has only one element.
A)True
B)False
Q5) A semantic object must represent something with a physical existence. A)True
B)False
Q6) A "simple object" can contain only simple attributes.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 24
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 Microsoft Internet Information Service (IIS)Manager.
A)True
B)False
Q2) The Java JRE is installed directly from the Java download page at ________.
A)www.oracle.com
B)www.jre.com
C)www.jdk.com
D)www.sun.com
Q3) 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
Q4) Apache is the Web server typically used on computers running the Windows operating system.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 25
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) 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
Q2) We have obtained access to the company's operational data.In one record,we find that a customer's age has been recorded as "337".This is an example of ________.
A)dirty data
B)inconsistent data
C)non-integrated data
D)a "wrong format" problem
Q3) Data mining applications are used accomplish all of the following tasks except ________.
A)update the database
B)make predications
C)facilitate decision making
D)perform what-if analysis
Q4) Why is operational data sometimes unusable for Business Intelligence use?
To view all questions and flashcards with answers, click on the resource link above. Page 26
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) SOAP was originally an XML-based standard for providing remote procedure calls over the Internet.
A)True
B)False
Q2) The SQL Server XML SELECT statements can be applied to ________.
A)single table SELECT statements
B)multiple table SELECT statements
C)XML Schema statements
D)Both A and B are correct
Q3) What is XML,and why is it significantly better than HTML?
Q4) An example of a document database is ________.
A)Dynamo
B)Couchbase Server
C)Bigtable
D)Neo4j
Q5) For database/XML applications,a good rule to follow is that elements are used to carry data and attributes are used to carry metadata.
A)True
B)False
Q6) What is an XML Schema?
Page 27
To view all questions and flashcards with answers, click on the resource link above.