Enterprise Database Systems
Final Exam Questions
Course Introduction
Enterprise Database Systems explores the principles, architecture, and management of large-scale databases as used in modern organizations. The course covers relational and non-relational database models, advanced SQL, transaction management, concurrency control, backup and recovery, and distributed database systems. Students will learn how to design, implement, and optimize database solutions that meet the complex data requirements of enterprises, while ensuring data integrity, security, and scalability. Through hands-on exercises and real-world scenarios, participants gain practical experience with leading database management systems and develop the skills necessary to support organizational data-driven decision-making.
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) It can be more efficient to process ____________________ statements stored within the database versus those stored in application code.
Answer: SQL
Structured Query Language
Q2) <u>SQL</u> was originally modeled after Ada, a programming language built for the U.S. Department of Defense. _________________________
A)True
B)False
Answer: False
Q3) 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
Q4) Structured Query Language (SQL) is considered a procedural language.
A)True
B)False
Answer: False
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) The ____________________ statement is a mechanism that allows the checking of a condition to determine whether or not statements should be processed.
Answer: IF
Q2) A(n) ____________________ variable can hold only a single value.
Answer: scalar
Q3) The ____ section of a PL/SQL block contains code that creates variables, cursors, and types.
A) DECLARE
B) BEGIN
C) EXCEPTION
D) END
Answer: A
Q4) Which of the following can be referenced in the loop but cannot be assigned a value because it is controlled by the loop?
A) The counter variable
B) The IN clause
C) The INSERT INTO clause
D) The FOR clause
Answer: A
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) A(n) ____________________ is an ordered group of elements that allows the handling of multiple values of the same data type as a single unit.
Answer: collection
Q2) The<u> UPDATE</u> statement is sometimes called a jumping control because it instructs the program to "jump to" some specific area of the code.
A)True
B)False
Answer: False
Q3) Discuss the meaning of the term collection.
Answer: A collection is an ordered group of elements that allows the handling of multiple values of the same data type as a single unit. Collections are similar to arrays used on other languages and may hold many rows of data but only a single field. The values in each row of the collection must be of the same type and an index allows references to individual values or rows within the collection.
Q4) The ____________________ clause follows the SELECT clause and indicates which variables are to hold the values that are retrieved from the database.
Answer: INTO
To view all questions and flashcards with answers, click on the resource link above. Page 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) The ____ action used with an explicit cursor creates a named cursor identified by a SELECT statement.
A) OPEN
B) DECLARE
C) FETCH
D) CLOSE
Q2) The ____ is an Oracle built-in procedure that allows developers to associate their own error number and message to an error.
A) SQLCODE
B) SQLERRM
C) RAISE_APPLICATION_ERROR
D) WHEN OTHERS
Q3) Which of the following statements is correct?
A) The value of the SQLCODE can be used directly in an SQL statement.
B) The value of the SQLCODE is assigned to a variable.
C) The value of the SQLCODE can not be assigned to a variable.
D) The value of the SQLERRM can be used directly in an SQL statement.
Q4) An exception is a mechanism to trap an error that occurs in processing.
A)True
B)False
Page 6
To view all questions and flashcards with answers, click on the resource link above.
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) The term ____ refers to program code that resides on the user machine.
A) client-side
B) client/server
C) two-tier
D) server-side
Q2) In a(n) <u>positional </u>method, you associate a value to each parameter by name in the invoke statement. _________________________
A)True
B)False
Q3) Exception handling refers to the logical group of DML actions that is affected by a transaction control statement.
A)True
B)False
Q4) The term pragma refers to additional instructions for the PL/SQL compiler to use during program unit compilation.
A)True
B)False
Q5) Three pieces of information for each parameter must be provided in the header: name, mode, and ____________________.
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) The task of the ____________________ function is to use the two arguments provided, a numeric value and the degree of rounding, and return the resulting value.
Q2) A function is quite similar to a procedure in that it is a program unit that achieves a task, can receive input values, and returns values to the calling environment.
A)True
B)False
Q3) Procedures can be used in SQL statements.
A)True
B)False
Q4) Discuss the techniques available in PL/SQL for passing values between actual parameters and formal parameters.
Q5) Deleting a program unit can be accomplished by issuing a(n) <u>DEL</u> command. _________________________
A)True
B)False
Q6) ____________________ cannot be used in SQL statements.
Q7) A(n) ____________________ cannot serve as an entire statement.
Q8) What are the main differences between a function and a procedure?
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) CREATE OR REPLACE PACKAGE metric_pkg IS cup_to_liter CONSTANT NUMBER := .24; Pint_to_liter CONSTANT NUMBER := .47; Qrt_to_liter CONSTANT NUMBER := .95; END;
Which of the following statements about the code fragment above is correct?
A) The CONSTANT option allows the values of the variables to be modified.
B) There is no need to create a body for this package.
C) Program units are included in the package.
D) The package body must be created.
Q2) The ____ packaged function purity level does not modify packaged variables.
A) WNDS
B) RNDS
C) WNPS
D) RNPS
Q3) The term <u>user scope</u> is the range of visibility for a particular element or construct contained in a package. _________________________
A)True
B)False
Q4) The query to be used to populate a ____________________ data type can be determined at run time.
To view all questions and flashcards with answers, click on the resource link above. Page 9
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) The dependency tree utility allows the user to review direct and indirect dependencies of an object in either numeric order or indented format.
A)True
B)False
Q2) ____ can be used to manually recompile invalid program units.
A) COMPILE
B) ALTER RECOMPILE
C) ALTER COMPILE
D) RECOMPILE
Q3) Discuss two situations in which parameter modifications are not viewed as signature modifications and, therefore, do not prompt recompilation.
Q4) Compiler variables are used to enable compiler warning messages and conditional compilation.
A)True
B)False
Q5) The ____________________________ is a mechanism available in the Oracle system to provide a map to visualize both direct and indirect dependencies within the database.
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) The <u>WHEN</u> clause of a trigger can be used only in row level triggers.
A)True
B)False
Q2) Which trigger option will force the trigger to fire before the test_trg trigger.
A) BEFORE test_trg
B) PRECEDES test_trg
C) PRIOR test_trg
D) no option is available to control the firing order
Q3) Which of the following statements is correct?
A) If multiple triggers exist on a table, the order in which the triggers will be fired can be set.
B) A BEFORE statement level trigger will fire before a BEFORE row level trigger.
C) If you have two statement level triggers, the order in which they are fired is dependent on the order in which they were written.
D) Only one trigger can be constructed per table.
Q4) To rebuild a database from a script, if you are using SQL Developer, open the file and click the ____________________ button.
Q5) What is the difference between a mutating table and a key-preserved table?
To view all questions and flashcards with answers, click on the resource link above. Page 11
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) The ____ procedure of the DBMS_DDL package allows developers to programmatically compile database objects.
A) ALTER_RECOMPILE
B) ANALYZE_OBJECT
C) ALTER_COMPILE
D) DDL_ALTER
Q2) The ____ built-in package contains a miscellaneous group of programs ranging from capabilities to assist in procedure management to reporting error information.
A) DBMS_SESSION
B) DBMS_UTILITY
C) DBMS_XMLGEN
D) UTL_INADDR
Q3) What is the goal of dynamic SQL?
Q4) ____ retrieves the data returned by a query.
A) BIND_VARIABLE
B) FETCH_ROWS
C) COLUMN_VALUE
D) DEFINE_COLUMN
Q5) Describe the basic mechanics of the alert process.
To view all questions and flashcards with answers, click on the resource link above. Page 12