Database Application Development
Exam Questions
Course Introduction
Database Application Development explores the principles and practices involved in designing, implementing, and managing database-driven applications. This course covers concepts such as relational database models, structured query language (SQL), data normalization, transaction management, and database security. Students will learn to build real-world applications that interact with databases, utilizing languages and frameworks such as SQL, JDBC, or ORM tools within programming environments like Java or Python. Emphasis is placed on developing robust, efficient, and scalable applications through hands-on projects and case studies, preparing students for roles in software development and data management.
Recommended Textbook
Oracle 11G PL SQL Programming 2nd Edition by Joan Casteel
Available Study Resources on Quizplus
10 Chapters
645 Verified Questions
645 Flashcards
Source URL: https://quizplus.com/study-set/1149 Page 2
Chapter 1: Introduction To PL/SQL
Available Study Resources on Quizplus for this Chatper
54 Verified Questions
54 Flashcards
Source URL: https://quizplus.com/quiz/22517
Sample Questions
Q1) A program that can run on any platform is considered ____________________.
Answer: portable
Q2) A programming language allows the actions of an end user to be converted into instructions that a computer can understand.
A)True
B)False
Answer: True
Q3) <u>PL/SQL</u> supports the use of SQL data manipulation, transaction control, functions, cursors, operators, and pseudocolumns. _________________________
A)True
B)False
Answer: True
Q4) The <u>three-tier</u> application model is also referred to as a client/server application. _________________________
A)True
B)False
Answer: False
Q5) A(n) ____________________ typically returns only one value. Answer: Function
To view all questions and flashcards with answers, click on the resource link above. Page 3
Chapter 2: Basic PL/SQL Block Structures
Available Study Resources on Quizplus for this Chatper
81 Verified Questions
81 Flashcards
Source URL: https://quizplus.com/quiz/22518
Sample Questions
Q1) Which of the following allow us to repeat the processing of a desired portion of code?
A) Functions
B) Looping constructs
C) IF statements
D) CASE expressions
Answer: B
Q2) An infinite loop causes a program to loop indefinitely, disrupting the ability of the code to continue with any processing beyond the loop.
A)True
B)False
Answer: True
Q3) The BEGIN section of a PL/SQL block contains code that creates variables, cursors, and types.
A)True
B)False
Answer: False
Q4) A(n) ____________________ variable can hold only a single value.
Answer: scalar
To view all questions and flashcards with answers, click on the resource link above. Page 4
Chapter 3: Handling Data In PL/SQL Blocks
Available Study Resources on Quizplus for this Chatper
51 Verified Questions
51 Flashcards
Source URL: https://quizplus.com/quiz/22519
Sample Questions
Q1) Which of the following associative array attributes checks to see if a value has been entered for the stated index number?
A) COUNT
B) FIRST
C) EXISTS
D) PRIOR
Answer: C
Q2) The<u> REF </u>attribute tells the system to look up the data type of a database column and use it for the declared variable. _________________________
A)True
B)False
Answer: False
Q3) A(n) ____ is a variable that can handle many rows of data but only one field.
A) assignment statement
B) associative array
C) collection
D) table attribute
Answer: B
To view all questions and flashcards with answers, click on the resource link above.
5
Chapter 4: Cursors and Exception Handling
Available Study Resources on Quizplus for this Chatper
65 Verified Questions
65 Flashcards
Source URL: https://quizplus.com/quiz/22520
Sample Questions
Q1) ____ are values passed into the cursor when opened and used in the SELECT statement of the cursor to determine what value it will contain.
A) Collections
B) Subqueries
C) Parameters
D) Variables
Q2) What can be used to simplify processing each row of a set retrieved from a database?
A) CURSOR
B) CURSOR For LOOP
C) LOOP
D) CURSOR Attribute
Q3) If the<u> INTO </u>clause of a SELECT statement contains either scalar or record variables and if more than one row is selected, the TOO_MANY_ROWS error is raised.
A)True
B)False
Q4) When processing many rows in a query, ____________________ can be used to improve performance.
To view all questions and flashcards with answers, click on the resource link above. Page 6
Chapter 5: Procedures
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/22521
Sample Questions
Q1) What information must be provided in the header section of a PL/SQL block for each parameter? Provide an explanation for each.
Q2) The term ____ refers to program code that resides on the user machine.
A) client-side
B) client/server
C) two-tier
D) server-side
Q3) If a table column data type is modified, no changes to associated variables are required because the ____ attribute always uses the column's current data type.
A) TYPE
B) :=
C) =>
D) %TYPE
Q4) <u>Stored procedures</u> and functions are saved in an Oracle11g application or library on the client-side. _________________________
A)True
B)False
Q5) What is the difference between a function and a procedure?
To view all questions and flashcards with answers, click on the resource link above. Page 7
Chapter 6: Functions
Available Study Resources on Quizplus for this Chatper
51 Verified Questions
51 Flashcards
Source URL: https://quizplus.com/quiz/22522
Sample Questions
Q1) Which of the following statements is incorrect?
A) A procedure can serve as an entire statement.
B) A function is part of an expression.
C) Procedures can be used in SQL statements.
D) A function cannot serve as an entire statement.
Q2) A good method to handle the size issue when declaring variables that hold values from a database table is to use the ____ attribute to use the size of the database column.
A) NOCOPY
B) %TYPE
C) << >>
D) TYPE
Q3) ____ refer to the arguments that are used when calling or invoking the program unit.
A) Actual parameters
B) Functions
C) Formal parameters
D) Procedures
Q4) It is considered good form to return only one value from a function and to do so using the ____________________ statement.
Page 8
To view all questions and flashcards with answers, click on the resource link above.
Chapter 7: PL/SQL Packages
Available Study Resources on Quizplus for this Chatper
68 Verified Questions
68 Flashcards
Source URL: https://quizplus.com/quiz/22523
Sample Questions
Q1) The ____________________ serves as a map to what program units are available in the package and the parameters of the program unit.
Q2) Full procedures or function codes are contained in the ____.
A) package specification
B) package body
C) package header
D) anonymous block
Q3) The ____ defines the type of data structures the function reads or modifies.
A) cursor
B) purity level
C) package scope
D) one time only procedure
Q4) Package elements are considered <u>public</u> if they can be called only from other program units within the same package. _________________________
A)True
B)False
Q5) The ____________________ data dictionary view is also useful to identify what packages exist on the system.
Q6) What is meant by the term package body?
Page 9
To view all questions and flashcards with answers, click on the resource link above.
Chapter 8: Program Unit Dependencies
Available Study Resources on Quizplus for this Chatper
61 Verified Questions
61 Flashcards
Source URL: https://quizplus.com/quiz/22524
Sample Questions
Q1) ____ can be used to check the status of database objects.
A) USER_OBJECTS
B) USER_REFERENCE
C) USER_CHECK
D) USER_SOURCE
Q2) Which of the following data dictionarty view can verify compiler parameter settings for an object?
A) PARAMETER_SETTINGS
B) PLSQL_OBJECT_SETTINGS
C) USER_OBJECT_SETTINGS
D) USER_PLSQL_OBJECT_SETTINGS
Q3) The timestamp model is not the default method and, if desired, needs to be set in the system using one of several commands available.
A)True
B)False
Q4) Only modifications to the package specification or the program unit header section can raise the ____________________________ status of dependent objects.
Q5) What is the difference between the timestamp model and the signature model?
Q6) What is the purpose of the %TYPE and %ROWTYPE attributes?
Page 10
To view all questions and flashcards with answers, click on the resource link above.
Chapter 9: Database Triggers
Available Study Resources on Quizplus for this Chatper
54 Verified Questions
54 Flashcards
Source URL: https://quizplus.com/quiz/22525
Sample Questions
Q1) CREATE [OR REPLACE] TRIGGER trigger_name [BEFORE, AFTER] [List of DDL or Database System Events] [ON DATABASE | SCHEMA] Trigger body; The syntax above represents that of a(n) ____ trigger.
A) statement
B) row level
C) system
D) Instead-Of
Q2) The FOLLOWS trigger option enables a developer to control the firing order of triggers.
A)True
B)False
Q3) To remove a trigger from the system, the <u>DEL TRIGGER</u> statement is used.
A)True
B)False
Q4) LONG or LONG RAW variables can be declared in triggers and the NEW and OLD qualifiers cannot refer to these types of columns.
A)True
B)False
Page 11
To view all questions and flashcards with answers, click on the resource link above.
Chapter
Hiding Source Code
Available Study Resources on Quizplus for this Chatper
85 Verified Questions
85 Flashcards
Source URL: https://quizplus.com/quiz/22526
Sample Questions
Q1) ____ frees the resources allocated to the cursor.
A) EXIT_CURSOR
B) FETCH_ROWS
C) EXECUTE
D) CLOSE_CURSOR
Q2) The _________________________ package is used to display messages to the screen from a stored program unit or an anonymous block.
Q3) BEGIN
DBMS_OUTPUT.PUT('This');
DBMS_OUTPUT.PUT(' is a');
DBMS_OUTPUT.PUT(' test');
DBMS_OUTPUT.PUT_LINE('This is test2');
DBMS_OUTPUT.PUT('Working?'); END;
The code fragment above is an example of a(n) ____.
A) cursor
B) alert
C) anonymous block
D) trigger
To view all questions and flashcards with answers, click on the resource link above. Page 12
Q4) A(n) _________________________ is a pointer to a cursor or SQL work area.