Database Applications Development
Exam Answer Key
Course Introduction
This course explores the principles and practices of developing applications that interact with modern database systems. Students will learn to design, implement, and optimize data-driven solutions by integrating databases with various application programming environments. Key topics include relational database fundamentals, SQL query development, data modeling, transaction management, security, and best practices for interfacing applications with databases. The course also introduces students to advanced topics such as stored procedures, triggers, and web-based database applications, equipping them with practical skills for building robust and scalable database solutions.
Recommended Textbook
A Guide to SQL 8th Edition by Philip J. Pratt
Available Study Resources on Quizplus
8 Chapters
600 Verified Questions
600 Flashcards
Source URL: https://quizplus.com/study-set/1123 Page 2
Chapter 1: Introduction to Premiere Products, Henry Books, and Alexamara Marina Group
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/22071
Sample Questions
Q1) The Premiere Products database contains information that relates sales reps to the customers they represent and customers to the ____________________ they have placed.
Answer: orders
Q2) Alexamara provides a variety of boat repair and maintenance services to the boat owners.
A)True
B)False
Answer: True
Q3) Alexamara stores information about its marinas in the ____ table.
A) SERVICE
B) MARINAS
C) MARINA
D) ALEXAMARA
Answer: C
Q4) A(n) ____________________ is a structure that contains different categories of information and the relationships between these categories.
Answer: database
Page 3
To view all questions and flashcards with answers, click on the resource link above.
Chapter 2: Database Design Fundamentals
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/22072
Sample Questions
Q1) In a relation, the ____________________ of the rows and columns is immaterial.
Answer: order
Q2) A primary key always comprises a single column.
A)True
B)False
Answer: False
Q3) ______________________________ is another name given to third normal form in this text.
Answer: BCNF (Boyce-Codd normal form)
Boyce-Codd normal form (BCNF)
Boyce-Codd
BCNF
Q4) Because there is a one-to-many relationship between sales reps and customers in the Premiere Products database, one sales rep can be associated with zero, one, or more customers.
A)True
B)False
Answer: True
Q5) A(n) ____________________ is another name for a record or a row.
Answer: tuple
4
To view all questions and flashcards with answers, click on the resource link above.
Chapter 3: Creating Tables
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/22073
Sample Questions
Q1) Dropping a table also deletes any data that you entered into the table.
A)True
B)False
Answer: True
Q2) To list all the columns in a table, use the LIST COLUMNS command.
A)True
B)False Answer: False
Q3) Oracle stores script files is a special location called Saved Commands.
A)True
B)False
Answer: False
Q4) The data type DECIMAL(5,2) represents a number with ____________________ places to the left and two places to the right of the decimal.
Answer: three 3
Q5) In Access, it is common to create a table using SQL.
A)True
B)False
Answer: False
Page 5
To view all questions and flashcards with answers, click on the resource link above.
Chapter 4: Single-Table Queries
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/22074
Sample Questions
Q1) How do you construct the SELECT query?
Q2) When the ____________________ operator connects simple conditions, all the simple conditions must be true in order for the compound condition to be true.
Q3) The ____ wildcard symbol represents any individual character.
A) %
B) _
C) /
D) \
Q4) When you use the ____ function, you can use the asterisk (*) to represent any column.
A) SUM
B) COUNT
C) MAX
D) MIN
Q5) A(n) ____________________ is simply a question represented in a way that the DBMS can understand.
Q6) The ____________________ operator finds rows that contain a null value in the specified column.
Q7) Compare the WHERE and HAVING clauses.
To view all questions and flashcards with answers, click on the resource link above. Page 6
Chapter 5: Multiple-Table Queries
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/22075
Sample Questions
Q1) If you precede a subquery by the ____________________ operator, the condition is true only if it satisfies all values produced by the subquery.
Q2) You join tables in SQL by including a condition in the ____________________ clause to ensure that matching columns contain equal values.
Q3) Two tables are ____________________ compatible if they have the same number of columns and if their corresponding columns have identical data types and lengths.
Q4) Oracle and SQL Server support the ____ operator but Microsoft Access does not.
A) UNION
B) INTERSECT
C) MINUS
D) ALL
Q5) The ____________________ of two tables is a table containing all rows that are in both tables.
Q6) You can perform special operations, such an self-joins, within SQL.
A)True
B)False
Q7) A subquery within a subquery is called a(n) ____________________ subquery.
Q8) Describe the types of outer joins.
To view all questions and flashcards with answers, click on the resource link above. Page 7
Chapter 6: Updating Data
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/22076
Sample Questions
Q1) You can change the characteristics of existing columns by using the ____________________ clause of the ALTER TABLE command.
Q2) In SQL Server, execute the sp_columns command to list all the columns in a table.
A)True
B)False
Q3) If you specify NOT NULL for a column when you create a table, you are prohibited from changing a value in the column to null.
A)True
B)False
Q4) In order to use the COMMIT command in Oracle, you need to clear the check mark from the ____ check box.
A) Transaction
B) Autocommit
C) Permanent
D) Temporary
Q5) To add a new column, use the ____________________ clause of the ALTER TABLE command.
Q6) Describe the format of the ALTER TABLE command to add a new column.
To view all questions and flashcards with answers, click on the resource link above. Page 8
Chapter 7: Database Administration
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/22077
Sample Questions
Q1) Normally, when the database administrator grants a particular privilege to a user, the user cannot pass that privilege along to other users.
A)True
B)False
Q2) The types of constraints supported in SQL are ____.
A) primary keys
B) foreign keys
C) legal values
D) All of the above
Q3) To create a view in Access, create a query to define the view and then save the query object in the database.
A)True
B)False
Q4) Explain what happens when you create a query that involves a view.
Q5) The DROP VIEW command removes the tables and data on which the view is based.
A)True
B)False
Q6) What are the benefits of using views?
Q7) To create a view definition, use the ____________________ command.
Page 9
To view all questions and flashcards with answers, click on the resource link above.
Chapter 8: SQL Functions and Procedures
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/22078
Sample Questions
Q1) A procedure that updates data is called a(n) ____________________ procedure.
Q2) To truncate (remove) everything to the right of the decimal point, use the TRUNCATE function.
A)True
B)False
Q3) In procedural languages, you can accomplish many tasks using a single command.
A)True
B)False
Q4) In T-SQL, arguments should have the same data type and length as the particular column in a table that they represent.
A)True
B)False
Q5) In the function UPPER(LAST_NAME), the item in parentheses (LAST_NAME) is called the ____________________ for the function.
Q6) To close a cursor and deactivate it, use the ____________________ command.
Q7) To handle processing of errors, include a(n) ____________________ clause in stored procedure.
Page 10
Q8) A(n) ____________________ is a computer that is connected to a network and has access through the server to the database.
To view all questions and flashcards with answers, click on the resource link above.