Database Applications Development
Pre-Test Questions
Course Introduction
Database Applications Development focuses on the design, implementation, and management of database-driven applications. This course covers fundamental concepts of relational databases, including data modeling, SQL queries, and transaction management, while also introducing advanced topics such as stored procedures, triggers, and database security. Students will gain practical experience by developing applications that interact with databases using programming languages and frameworks, emphasizing best practices in database integration and application performance. By the end of the course, students will be equipped to build robust, scalable database applications relevant to real-world business and technology environments.
Recommended Textbook
Modern Database Management 12th Edition by
Jeffrey A. Hoffer
Available Study Resources on Quizplus 14 Chapters
1469 Verified Questions
1469 Flashcards
Source URL: https://quizplus.com/study-set/1058
Page 2
Chapter 1: The Database Environment and Development Process
Available Study Resources on Quizplus for this Chatper
116 Verified Questions
116 Flashcards
Source URL: https://quizplus.com/quiz/20934
Sample Questions
Q1) One of the most popular RAD methods is:
A) automated design.
B) structured walkthrough.
C) prototyping.
D) crafting.
Answer: C
Q2) Although personal databases improve productivity, one risk is that data cannot be shared with other users.
A)True
B)False
Answer: True
Q3) A data model is a graphical system used to capture the nature and relationships among data.
A)True
B)False
Answer: True
Q4) Prototyping is a type of rapid application development.
A)True
B)False
Answer: True
To view all questions and flashcards with answers, click on the resource link above. Page 3
Chapter 2: Modeling Data in the Organization
Available Study Resources on Quizplus for this Chatper
103 Verified Questions
103 Flashcards
Source URL: https://quizplus.com/quiz/20935
Sample Questions
Q1) A single occurrence of an entity is called an entity instance.
A)True
B)False
Answer: True
Q2) A simultaneous relationship among the instances of three entity types is called a ________ relationship.
A) ternary
B) tertiary
C) primary
D) binary Answer: A
Q3) It is not permissible to associate attributes with relationships.
A)True
B)False Answer: False
Q4) A ternary relationship is equivalent to three binary relationships.
A)True
B)False Answer: False
To view all questions and flashcards with answers, click on the resource link above. Page 4
Chapter 3: The Enhanced E-R Model
Available Study Resources on Quizplus for this Chatper
103 Verified Questions
103 Flashcards
Source URL: https://quizplus.com/quiz/20936
Sample Questions
Q1) The overlap rule specifies that if an entity instance of the supertype is a member of one subtype, it can simultaneously be a member of two (or more) subtypes.
A)True
B)False
Answer: True
Q2) One of the major challenges in data modeling is to recognize and clearly represent entities that are almost the same.
A)True
B)False
Answer: True
Q3) The ________ rule specifies that an entity can be a member of only one subtype at a time.
A) exclusion
B) disjoint
C) removal
D) inclusion
Answer: B
To view all questions and flashcards with answers, click on the resource link above. Page 5
Chapter 4: Logical Database Design and the Relational Model
Available Study Resources on Quizplus for this Chatper
102 Verified Questions
102 Flashcards
Source URL: https://quizplus.com/quiz/20937
Sample Questions
Q1) There can be multivalued attributes in a relation.
A)True
B)False
Q2) A relation that contains minimal redundancy and allows easy use is considered to be:
A) clean.
B) simple.
C) complex.
D) well-structured.
Q3) A primary key is an attribute that uniquely identifies each row in a relation.
A)True
B)False
Q4) When a regular entity type contains a multivalued attribute, two new relations are created.
A)True
B)False
Q5) When transforming a unary many-to-many relationship to relations, a recursive foreign key is used.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 6
Chapter 5: Physical Database Design and Performance
Available Study Resources on Quizplus for this Chatper
103 Verified Questions
103 Flashcards
Source URL: https://quizplus.com/quiz/20938
Sample Questions
Q1) SOX stands for the Sorbet-Oxford Act.
A)True
B)False
Q2) Explain what primary, secondary and unique key indexes are.
Q3) The logical database design always forms the best foundation for grouping attributes in the physical design.
A)True
B)False
Q4) When would you use horizontal partitioning, and when would you use vertical partitioning?
Q5) A key is a data structure used to determine the location of rows in a file that satisfy some condition.
A)True
B)False
Q6) All of the following are objectives when selecting a data type EXCEPT:
A) represent all possible values.
B) improve data integrity.
C) support all data manipulations.
D) use a lot of storage space.
Q7) What is a hashing algorithm and how is it used in hashed file organizations?
To view all questions and flashcards with answers, click on the resource link above. Page 7
Chapter 6: Introduction to SQL
Available Study Resources on Quizplus for this Chatper
105 Verified Questions
105 Flashcards
Source URL: https://quizplus.com/quiz/20939
Sample Questions
Q1) Given a table named store with 5 fields: store_id, address, city, state, zipcode, why would the following insert command not work? insert into store values ('234 Park Street')
A) It would work just fine.
B) You must specify the fields to insert if you are only inserting some of the fields.
C) There is no table keyword.
D) Insert into should be INSERT to.
Q2) What will result from the following SQL Select statement? Select min(Product_Description)
From Product_V;
A) The minimum value of Product_Description will be displayed.
B) An error message will be generated.
C) The first product description alphabetically in Product_V will be shown.
D) SELECT @ will be displayed.
Q3) A view may not be updated directly if it contains:
A) the SELECT clause.
B) the HAVING clause.
C) the FROM clause.
D) the WHERE clause.
To view all questions and flashcards with answers, click on the resource link above.
8
Chapter 7: Advanced SQL
Available Study Resources on Quizplus for this Chatper
107 Verified Questions
107 Flashcards
Source URL: https://quizplus.com/quiz/20940
Sample Questions
Q1) Triggers have three parts: the event, the condition, and the action.
A)True
B)False
Q2) The following code is an example of a Subquery.
SELECT Customer_T.CustomerID, Order_T.CustomerID, CustomerName, OrderID
FROM Customer_T, Order_T
WHERE Customer_T.CustomerID = Order_T. CustomerID; A)True
B)False
Q3) An operation to join a table to itself is called a(n): A) sufficient-join.
B) inner join.
C) outer join.
D) self-join.
Q4) An SQL query that implements an outer join will return rows that do not have matching values in common columns.
A)True
B)False
Q5) What is a self-join and how is it used?
Page 9
To view all questions and flashcards with answers, click on the resource link above.
Chapter 8: Database Application Development
Available Study Resources on Quizplus for this Chatper
105 Verified Questions
105 Flashcards
Source URL: https://quizplus.com/quiz/20941
Sample Questions
Q1) Document Type Declarations (DTDs) are unable to specify data types.
A)True
B)False
Q2) An HTTP Schema Definition is a language used for defining XML databases.
A)True
B)False
Q3) XML-based vocabularies, such as XBRL, do not allow meaningful comparisons to be made of data across many organizations.
A)True
B)False
Q4) XQuery is an XML transformation language for querying relational data as well as XML databases.
A)True
B)False
Q5) An XML-based grammar used to describe a Web service is called:
A) Web Service Description Language (WSDL).
B) WIDL.
C) WISL.
D) Business-to-Business (B2B).
Q6) Explain how XML documents are retrieved.
To view all questions and flashcards with answers, click on the resource link above. Page 10
Chapter 9: Data Warehousing
Available Study Resources on Quizplus for this Chatper
103 Verified Questions
103 Flashcards
Source URL: https://quizplus.com/quiz/20942
Sample Questions
Q1) What is the surrogate key rule for the star schema, and what are the main reasons for this rule?
Q2) A snowflake schema is usually heavily aggregated.
A)True
B)False
Q3) The representation of data in a graphical format is called data mining.
A)True
B)False
Q4) Discuss the four key terms (subject-oriented, integrated, time-variant, and nonupdateable) related to data warehousing.
Q5) Organizations adopt data mart architectures because it is easier to have separate, small data warehouses than to get all organizational parties to agree to one view of the organization in a central data warehouse.
A)True
B)False
Q6) When would it be appropriate to use factless fact tables?
Q7) Independent data marts do not generally lead to redundant data and efforts.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 11
Chapter 10: Data Quality and Integration
Available Study Resources on Quizplus for this Chatper
105 Verified Questions
105 Flashcards
Source URL: https://quizplus.com/quiz/20943
Sample Questions
Q1) Quality data does not have to be unique.
A)True
B)False
Q2) Data governance can be defined as:
A) a means to slow down the speed of data.
B) high-level organizational groups and processes that oversee data stewardship.
C) a government task force for defining data quality.
D) a means to increase the speed of data.
Q3) Informational and operational data differ in all of the following ways EXCEPT:
A) level of detail.
B) normalization level.
C) scope of data.
D) data quality.
Q4) The process of transforming data from detailed to summary levels is called normalization.
A)True
B)False
Q5) Completeness means that all data that must have a value does not have a value.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 12
Chapter 11: Big Data and Analytics
Available Study Resources on Quizplus for this Chatper
102 Verified Questions
102 Flashcards
Source URL: https://quizplus.com/quiz/20944
Sample Questions
Q1) NoSQL systems enable automated ________ to allow distribution of the data among multiple nodes to allow servers to operate independently on the data located on it.
A) sharing
B) sharding
C) SQL
D) mongo
Q2) When a data repository (including internal and external data) does NOT follow a predefined schema, this is called a:
A) data dump.
B) data ocean.
C) data lake.
D) data stream.
Q3) The NoSQL model that is specifically designed to maintain information regarding the relationships (often real-world instances of entities) between data items is called a:
A) key-value score.
B) document store.
C) wide-column store.
D) graph-oriented database.
To view all questions and flashcards with answers, click on the resource link above.
Page 13
Chapter 12: Data and Database Administration
Available Study Resources on Quizplus for this Chatper
110 Verified Questions
110 Flashcards
Source URL: https://quizplus.com/quiz/20945
Sample Questions
Q1) The restoration manager allows the DBMS to restore the database to a correct condition and restart processing transactions.
A)True
B)False
Q2) While views promote security by restricting user access to data, they are not adequate security measures because:
A) an unauthorized person may gain access to a view through experimentation.
B) all users can read any view.
C) a view's data does not change.
D) views are not possible to create in most DBMS.
Q3) The record log is a record of the essential data for each transaction that has been processed against the database.
A)True
B)False
Q4) Specifications for transactions do not need to be reviewed quickly.
A)True
B)False
Q5) What are the most important security features for data management software?
Q6) What are integrity controls? Describe the different types.
Page 14
To view all questions and flashcards with answers, click on the resource link above.
Chapter 13: Distributed Databases
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/20946
Sample Questions
Q1) Distributed databases do not easily satisfy both transaction and analytical processing systems.
A)True
B)False
Q2) A distributed database is a single logical database spread physically across computers in multiple locations that are connected by a data communications link.
A)True
B)False
Q3) Horizontal partitioning is implemented by placing some rows of a table at one site and other rows at another site.
A)True
B)False
Q4) A design goal for distributed databases that states that although a distributed database runs many transactions, it appears that a given transaction is the only one in the system is called:
A) linear run.
B) concurrency transparency.
C) transaction CPU transparency.
D) location transparency.
To view all questions and flashcards with answers, click on the resource link above. Page 15
Chapter 14: Object-Oriented Data Modeling
Available Study Resources on Quizplus for this Chatper
105 Verified Questions
105 Flashcards
Source URL: https://quizplus.com/quiz/20947
Sample Questions
Q1) Encapsulation is the technique of hiding the internal implementation details of an object from its external view.
A)True
B)False
Q2) An association ________ is an association that has attributes or operations of its own.
A) link
B) group
C) class
D) body
Q3) According to the UML Notation Guide, complete means:
A) a descendant may come from more than one supertype.
B) a descendant may be not descended from more than one of the subclasses.
C) all subclasses have been specified, and no others are expected.
D) the list of objects is NOT stable.
Q4) An instance of a subclass is not always an instance of its superclass.
A)True
B)False
Q5) What is encapsulation?
Q6) What is polymorphism?
To view all questions and flashcards with answers, click on the resource link above. Page 16