Database Applications
Midterm Exam
Course Introduction
This course provides an in-depth exploration of database concepts, emphasizing the design, development, and implementation of database applications. Students will learn relational database theory, data modeling techniques, and Structured Query Language (SQL) for managing and manipulating data. The course covers normalization, transaction management, security concepts, and introduces advanced topics such as stored procedures, triggers, and web database connectivity. Through practical projects, students apply theoretical knowledge to real-world scenarios, preparing them to develop efficient, scalable, and secure database applications used in various business and technology environments.
Recommended Textbook
Database Processing Fundamentals Design and Implementation 14th Edition by David
Available Study Resources on Quizplus
25 Chapters
1978 Verified Questions
1978 Flashcards
Source URL: https://quizplus.com/study-set/2437 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/48385
Sample Questions
Q1) Business organizations have resisted adopting object-oriented database systems because the cost of purchasing OODBMS packages is prohibitively high.
A)True
B)False
Answer: False
Q2) Which of the following statements is not true for primary keys in a relational database system?
A)They can be used to create relationships between tables.
B)They must contain numeric data.
C)They uniquely identify a row in a table.
D)They can be part of relational integrity constraints.
Answer: B
Q3) A Customer Resource Management (CRM)system is an example of a(n)________.
A)single-user database application
B)multiuser database application
C)e-commerce database application
D)digital dashboard
Answer: B
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) Assuming the "Quantity" column of an ORDER table contains integer data,what does COUNT(Quantity)compute?
A)The number of rows in the ORDER table
B)The number of non-zero values in the Quantity column
C)The number of distinct values in the Quantity column
D)The number of non-null values in the Quantity column
Answer: D
Q2) The SQL built-in function COUNT computes the number of rows in a query.
A)True
B)False
Answer: True
Q3) In an SQL query,which built-in function is used to compute the number of rows in a table?
A)AVG
B)COUNT
C)MAX
D)SUM
Answer: B
To view all questions and flashcards with answers, click on the resource link above.
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) If by knowing the value of A we can find the value of B,then we would say that B is functionally dependent on A.
A)True
B)False
Answer: True
Q2) Given the functional dependency A (B, C), then it is true that A B and A C.
A)True
B)False
Answer: True
Q3) Every time we break up a relation during the normalization process,we may have to create a referential integrity constraint.
A)True
B)False
Answer: True
Q4) Given the functional dependency A B,then it is necessarily true that B A. A)True
B)False
Answer: False
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) Read-only databases seldom use more than one copy of a set of the same data.
A)True
B)False
Q2) Writing SQL subqueries and joins against normalized tables is simple compared to the code that must be written to handle anomalies from multivalued dependencies.
A)True
B)False
Q3) 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
Q4) Multivalued dependencies create anomalies so serious that multivalued dependencies must always be eliminated.
A)True
B)False
Q5) Explain denormalization,and why it may be appropriate to denormalize a set of tables.
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) In an E-R model,the three types of maximum cardinality are 1:1,1:N,and N:M.
A)True
B)False
Q2) An identifier of an entity instance is one or more attributes that name or identify entity instances.
A)True
B)False
Q3) In E-R modeling,entities within an entity class may have different attributes.
A)True
B)False
Q4) The degree of a relationship is the number of entity classes in the relationship. A)True
B)False
Q5) Which of the following is not a good reason for designing a data model?
A)It's easier to change things in the data model than it is in the actual DBMS.
B)The data model provides a simplified view of the database that can be shown to people who don't need to see all the details.
C)Creating a data model will help you understand the application area better.
D)The data model can be discarded after the database is operational.
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) All identifying relationships are 1:N.
A)True
B)False
Q2) Discriminator attributes can be represented in relational designs.
A)True
B)False
Q3) When the parent entity is required (M)in a relationship,every row of the child table must have a valid,non-null value of the foreign key.
A)True
B)False
Q4) When transforming an ID-dependent E-R data model relationship into a relational database design where the child entity is designed to use a surrogate key,the relationship changes to a weak but not ID-dependent relationship.
A)True
B)False
Q5) In 1:N relationships,the table on the "one" side is called the parent.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 8
Q6) How are one-to-one recursive relationships addressed using the relational model?
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) What are SQL triggers and how are they used?
Q2) Because SQL statements are table-oriented,whereas programs are variable-oriented,the results of SQL statements used in programs are accessed using an SQL cursor.
A)True
B)False
Q3) An SQL virtual table is called a view.
A)True
B)False
Q4) If the table PRODUCT has a column PRICE,and PRICE has the data type Numeric (8,2),the value 98765 stored in that field will be displayed by the DBMS as 98765.00.
A)True
B)False
Q5) When a trigger is fired,the DBMS makes the appropriate data available to the trigger code.
A)True
B)False
Q6) Explain how relationships are created using SQL.Include an example.
Page 9
Q7) Distinguish between Char and VarChar data types.Include examples and tradeoffs.
To view all questions and flashcards with answers, click on the resource link above.
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) SQL queries that use EXISTS and NOT EXISTS are ________.
A)normal subqueries
B)correlated subqueries
C)uncorrelated subqueries
D)constraint dependent subqueries
Q2) In order to make sure the database redesign is working properly during the redesign testing process,a means must be created to ________.
A)reverse engineer all test databases
B)graph dependencies in all test databases
C)recover all test databases to their original state
D)re-interview all relevant users
Q3) A means must be created to recover all test databases to their original state during the redesign testing process.
A)True
B)False
Q4) The data model produced by reverse engineering is a true conceptual schema.
A)True
B)False
Q5) What is reverse engineering and how well does it work?
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 DBA should periodically analyze run-time statistics of database performance to help manage the DBMS.
A)True
B)False
Q2) Both rollforward and rollback require the use of a log of transaction results.
A)True
B)False
Q3) Explain the concept of an atomic transaction.
Q4) With pessimistic locking,the assumption is made that a conflict will occur.
A)True
B)False
Q5) Processing rights may be implemented at the DBMS level.
A)True
B)False
Q6) In regard to database security,neither the DBMS nor the database applications can enforce processing responsibilities.
A)True
B)False
Q7) Briefly define the four isolation levels and the problems they prevent.
Q8) Explain the concept of serializable transactions.
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) Which of the following is true about the SQL Server Import and Export Wizard?
A)The spreadsheet data must already be normalized in order to be imported.
B)There may be problems importing Excel 2013 data and we may need to install Excel 2007 compatibility software.
C)The Import and Export Wizard sometimes creates blank rows at the end of the imported table.
D)Both B and C are correct.
Q2) The Microsoft SQL Server Management Studio cannot verify SQL statements until they are executed.
A)True
B)False
Q3) When using SQL Server,developers place explicit locks.
A)True
B)False
Q4) In SQL Server,SCROLL_LOCK is a version of pessimistic locking.
A)True
B)False
Q5) The default cursor concurrency for a dynamic cursor in SQL Server is optimistic. 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) Which of the following is an account name for which you are asked to enter a password when Oracle Database creates a new database?
A)ORACLE
B)SYS
C)INTERNAL
D)DBA
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) For which of the following types of failure would Oracle Database use Offline ReDo files as part of a recovery effort?
A)Instance failure
B)Application failure
C)Media failure
D)Logic failure
Q4) INSTEAD OF triggers are placed on views.
A)True
B)False
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) What is MySQL?
Q2) Which of the following set of MySQL authorizations can be specifically assigned to a user account?
A)Administrative roles
B)Schema privileges
C)Root user equivalence
D)Both A and B are correct
Q3) The main MySQL GUI utility is ________.
A)MySQL Management Studio
B)MySQL Developer
C)My SQL Workbench
D)Both A and B are correct
Q4) MySQL supports AFTER triggers.
A)True
B)False
Q5) The MySQL statement BEGIN is used to define a set of MySQL procedure statements.
A)True
B)False
Q6) What is the MySQL Command-Line Client?
Q7) Explain the MySQL Block Structure.
To view all questions and flashcards with answers, click on the resource link above. Page 14
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) With ODBC,a database and the DBMS that processes it are identified by the data source.
A)True
B)False
Q2) 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)Only Type 1 and Type 2
B)All four Types
C)Only Type 3 and Type 4
D)Only Type 2 and Type 3
Q3) Object classes have properties that represent characteristics of the objects in the class.
A)True
B)False
Q4) An OLE DB service provider accepts data from an OLE DB tabular data provider.
A)True
B)False
Q5) What is XML,and why is it significantly better than HTML?
Q6) Give an example of how XML can be used with a DBMS.
Q7) Briefly describe NetBeans.
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) The movement that uses different database methods than the relational model and/or SQL is called the NoSQL movement.
A)True
B)False
Q2) Microsoft Excel 2013 allows us to connect directly to an SQL Server 2014 database when building a PivotTable.
A)True
B)False
Q3) What is the NoSQL movement?
Q4) Virtualization is an attempt to do a better job of using which hardware resources in a computer?
A)Memory and monitors
B)CPU and memory
C)Operating system
D)Database tables
Q5) NoSQL really stands of "Not only SQL."
A)True
B)False
Q6) What is a slowly changing dimension? Include an example.
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) In Microsoft Access 2013,the maximum length in characters of a "Short Text" data type column is ________.
A)25
B)255
C)65535
D)unlimited
Q2) Microsoft Access is considered a "personal database" product.What is a personal database?
Q3) Each Microsoft Access 2013 command tab contains a set of tools grouped into sets of related commands.
A)True
B)False
Q4) What Microsoft Access file format is used by default in Microsoft Access 2013? When was it introduced,and what was the previous format?
Q5) Microsoft Access SQL commands are run within the SQL View of a Query window. A)True
B)False
Q6) What is a surrogate key and how does Microsoft Access 2013 create surrogate keys?
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) Which of the following is not a component of a computer-based information system?
A)Hardware
B)Software
C)The inventory in the warehouse
D)Data
Q2) Database designs are created during the ________ step of the SDLC.
A)system definition
B)requirements analysis
C)component design
D)implementation
Q3) Data is facts and numbers.
A)True
B)False
Q4) User interviews are conducted during the requirements analysis step.
A)True
B)False
Q5) How does Michael Porter define support business activities? What do they include?
To view all questions and flashcards with answers, click on the resource link above. Page 18
Q6) What are the five steps or stages of the systems development life cycle (SDLC)?
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,a type domain allows ________.
A)different data types
B)different values
C)greater specificity of values
D)default values
Q2) In IDEF1X,extended E-R model weak,but non-ID-dependent relationships are called ________.
A)identifying connection relationships
B)nonspecific relationships
C)category clusters
D)There is no equivalent IDEF1X term.
Q3) What line symbols are used in IDEF1X diagrams to represent relationships?
Q4) In an IDEF1X identifying connection relationship,________.
A)the identifier of the child is always part of the identifier of the parent
B)the identifier of the parent is always part of the identifier of the child
C)the identifier of the parent is always the same as the identifier of the child
D)the identifier of the parent is optional
Q5) A categorization relationship is an IS-A relationship.
A)True
B)False
Page 19
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 format is used for weak entities in UML-style E-R diagrams?
Q2) Which of the following would indicate a minimum cardinality of 1 and a maximum cardinality of many in UML notation?
A)1:N
B)1 ..N
C)1 ..*
D)1:*
Q3) In UML notation,the relationship line in a relationship with an non-ID-dependent weak entity is labeled as ________.
A)<persistent>
B)<identifying>
C)<nonidentifying> D)There is no label used.
Q4) In UML-style E-R diagrams,a weak entity is shown by placing a filled-in diamond on the parent of the weak entity.
A)True
B)False
Q5) What cardinality format is used in UML-style E-R diagrams?
Q6) What new contributions to data modeling do UML-style E-R diagrams introduce?
Page 20
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) Users should create a MySQL Workspace folder to hold documents created with the MySQL Workbench.
A)True
B)False
Q2) In the MySQL Table Editor,the abbreviation for NOT NULL is ________.
A)PK
B)NN
C)UQ
D)BIN
Q3) Describe how to get started creating a new database design in the MySQL Workbench.
Q4) In the MySQL Table Editor,the abbreviation AI stands for AUTO_INCREMENT.
A)True
B)False
Q5) In the MySQL Table Editor,the abbreviation PK stands for partial key. A)True
B)False
B)False Page 21
Q6) In the MySQL Table Editor,the abbreviation NN stands for NOT NULL. A)True
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,the arrow end of the Dynamic connector object points to the table containing the primary key.
A)True
B)False
Q2) Microsoft Visio 2013 can be used to create data models.
A)True
B)False
Q3) In Microsoft Visio 2010,which object can be formatted with the line end symbols needed to create IE Crow's Foot notation?
A)Relationship connector object
B)Category object
C)Parent to category connector object
D)Category to child connector object
Q4) Microsoft Visio 2013 is a component of Microsoft Office 2013.
A)True
B)False
Q5) In Microsoft Visio 2013,clicking the File command tab opens the Backstage view. A)True
B)False
Q6) In Microsoft Visio 2013,how do we create data models?
Page 23
To view all questions and flashcards with answers, click on the resource link above.
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) The term set refers to all records having the same nonunique secondary key.
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) 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)
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) What are tree,simple networks and complex networks?
Q6) What is a linked list?
Q7) How does a DBMS store data on its direct access files?
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) The first attribute of a subtype object is the childID attribute.
A)True
B)False
Q2) Which of the following statements about Subtype objects is not true?
A)Subtypes can be Inclusive (an object may be more than one subtype).
B)Subtypes can be Exclusive (an object may only be one of the subtypes).
C)Subtypes can be Nested.
D)All relations between the parent and subtype are 1:N.
Q3) Explain the differences between the E-R model and the semantic object model.
Q4) 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
Q5) What type of attribute is composed of other attributes?
A)Simple
B)Group
C)Compound
D)Composite
Q6) Describe the two ways that semantic object views can be used.
Q7) Explain the concept of semantic objects as being a sufficient description.
To view all questions and flashcards with answers, click on the resource link above. Page 25
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 default Web page for the IIS Web server is ________.
A)startup.html
B)startup.htm
C)index.htm
D)iisstart.htm
Q2) What is theNetBeans IDE?
Q3) The IIS Web server is automatically installed when the Windows operating system is installed,and no additional steps are necessary to either install or activate it.
A)True
B)False
Q4) There is only one way to install PHP.
A)True
B)False
Q5) Installing PHP using the Microsoft Web Platform Installer always installs the most current version of PHP.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 26
Q6) What is the Microsoft Web Platform Installer,and what are the advantages and disadvantages of using it to install PHP?
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) What is a star schema?
Q2) Refer to the table above.What is the definition of support for Drug A and Drug B?
A)The probability that Drug A will be purchased.
B)The probability that Drug B will be purchased.
C)The probability that both Drug A and Drug B will be purchased.
D)The probability that Drug A will be purchased given that Drug B has been purchased.
Q3) In market basket analysis,lift is confidence divided by support.
A)True
B)False
Q4) Business Intelligence (BI)reporting systems can analyze data using standard SQL.
A)True
B)False
Q5) What is data mining application?
Q6) A digital dashboard is an electronic display customized for an individual user.
A)True
B)False
Q7) What is a data warehouse?
Q8) What is a reporting system?
27
To view all questions and flashcards with answers, click on the resource link above.
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) An important improvement of XML Schema over DTDs is that ________.
A)XML Schema can be stored external to the document
B)XML Schema support XQL queries
C)XML Schema are XML documents
D)XML Schema are not required
Q2) An example of a document database is ________.
A)Dynamo
B)Couchbase Server
C)Bigtable
D)Neo4j
Q3) Graph databases are composed of three elements,one of which is the node.
A)True
B)False
Q4) NoSQL really stands for "Not only SQL."
A)True
B)False
Q5) What is an XML DTD?
Q6) What is the CAP theorem,and what does it show?
Q7) Specify the four categories of NoSQL databases used in the text,and give an example of each.
To view all questions and flashcards with answers, click on the resource link above. Page 28