Database Applications Development
Exam Questions
Course Introduction
Database Applications Development introduces students to the principles and practices essential for designing, building, and deploying database-driven software applications. The course covers relational database concepts, data modeling, SQL programming, and integration of databases with various programming languages and development frameworks. Emphasis is placed on designing efficient schemas, ensuring data integrity, and managing transactions. Students will also learn how to develop user interfaces that interact with databases, implement security best practices, and optimize application performance. Through hands-on projects and case studies, learners gain practical experience developing robust, scalable database applications for real-world scenarios.
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) For each book, Ray at Henry Books tracks the book code, ____________________, publisher code, type of book, price and whether the book is paperback.
Answer: title
Q2) An owner number in the OWNER table at Alexamara Marina consists of ____ uppercase letters followed by a two-digit number.
A) 2
B) 3
C) 4
D) 5
Answer: A
Q3) The order number appears in the ORDERS table and the ____________________ table in the Premiere Products database.
Answer: ORDER_LINE
Q4) Each book at Henry Books is uniquely identified with a(n) ____.
A) title
B) code
C) publisher
D) author
Answer: B
To view all questions and flashcards with answers, click on the resource link above. Page 3
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) A field is another term for a(n) ____.
A) tuple
B) row
C) column
D) entity
Answer: C
Q2) In one style of entity-relationship (E-R) diagrams, a crow's foot is used to represent the ____________________ side of a relationship.
Answer: many
Q3) A relation is in ____ if it does not contain any repeating groups.
A) first normal form
B) second normal form
C) third normal form
D) Boyce-Codd normal form
Answer: A
Q4) If B is functionally dependent on A, you also can say that A functionally ____________________ B.
Answer: determines
Q5) A(n) ____________________ is the association between entities.
Answer: relationship
To view all questions and flashcards with answers, click on the resource link above. Page 4
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) 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
Q2) To create a table, type the word TABLE followed by the name of the table to be created and then by the names and data types of the columns that will comprise the table.
A)True
B)False
Answer: False
Q3) In SQL, you cannot enter an apostrophe into a column whose type is character (CHAR).
A)True
B)False
Answer: False
Q4) You can delete the entire table using the ____________________ TABLE command.
Answer: DROP
Q5) SQL is Structured ____________________ Language.
Answer: Query
To view all questions and flashcards with answers, click on the resource link above. Page 5
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) The WHERE clause is used to limit the rows that are included in a query's result.
A)True
B)False
Q2) The ____ clause lets you group data on a particular column.
A) GROUP
B) GROUP BY
C) SET GROUP
D) GROUPING
Q3) Oracle supports only the <> version of the "not equal to" comparison operator.
A)True
B)False
Q4) To sort records in descending order, follow the name of the sort key with the ____________________ operator.
Q5) The only arithmetic operators that can be used in SELECT statements are + for addition and - for subtraction.
A)True
B)False
Q6) The column on which data is to be sorted is called a sort ____________________.
Q7) Describe simple and compound conditions.
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) It is easy to create a product inadvertently by omitting the WHERE clause when you are attempting to join tables.
A)True
B)False
Q2) In a nested query, the outer query is evaluated first.
A)True
B)False
Q3) The ____________________ of two tables is the combination of all rows in the first table and all rows in the second table.
Q4) One reason for using an alias is simplicity.
A)True
B)False
Q5) When joining tables, it is always necessary to qualify a column name.
A)True
B)False
Q6) Occasionally, a self-join might involve the primary key of a table.
A)True
B)False
Q7) Describe the types of outer joins.
To view all questions and flashcards with answers, click on the resource link above. Page 7
Q8) A subquery within a subquery is called a(n) ____________________ subquery.
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) 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
Q2) The format for the ALTER TABLE command is the words ALTER TABLE followed by the name of the ____________________ to be altered, followed by an appropriate clause.
Q3) By placing a(n) ____________________ command in an INSERT command, you can add the query results to a table.
Q4) To change a column that currently rejects null values so that it accepts null vlaues, use the ____________________ clause in the ALTER TABLE command.
Q5) To delete data from the database, use the ____ command.
A) ROLLBACK
B) COMMIT
C) DELETE
D) UPDATE
Q6) Access does not support the COMMIT or ROLLBACK commands.
A)True
B)False
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) A view is defined by creating a defining ____________________, which indicates the rows and columns to include in the view.
Q2) Which of the following commands deletes an index?
A) DELETE INDEX
B) REMOVE INDEX
C) UNINDEX
D) DROP INDEX
Q3) Information about tables in the database is kept in the system ____________________.
Q4) The database administrator uses the ____________________ command to revoke privileges from users.
Q5) Explain what happens when you create a query that involves a view.
Q6) In Oracle, the ____ table contains information about the tables known to SQL.
A) DBA_TABLES
B) SHOW_TABLES
C) ALL_TABLES
D) SP_TABLES
Q7) To add a primary key after creating a table, you can use the ____________________ clause of the ALTER TABLE 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) In Access, use the & symbol to concatenate columns.
A)True
B)False
Q2) PL/SQL can process only one record at a time.
A)True
B)False
Q3) In SQL Server, you deactivate a cursor by using the ____________________ command.
Q4) A(n) ____ is a procedure that is executed automatically in response to an associated database operation.
A) cursor
B) trigger
C) waypoint
D) fetchpoint
Q5) To handle processing of errors, include an ABORT clause in a stored procedure.
A)True
B)False
Q6) When you use a cursor, the ____________________ command opens the cursor and causes the query to be executed, making the results available to the procedure.
Page 10
To view all questions and flashcards with answers, click on the resource link above.