Enterprise Database Systems
Practice Exam
Course Introduction
Enterprise Database Systems provides an in-depth exploration of modern database technologies, architectures, and design principles used in large-scale organizations. Students will learn about relational and non-relational database models, data modeling, normalization, distributed databases, and data warehousing. Emphasis is placed on advanced SQL, transaction management, concurrency control, backup and recovery, and database security. The course addresses high availability, scalability, and integration with business applications, preparing students to design, implement, and manage robust database solutions that meet enterprise needs.
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 database model is a general framework or design that describes how the various components of an application will be addressed.
A)True
B)False
Answer: False
Q2) Which of the following is an example of an event?
A) User interface
B) Application logic
C) Clicking a button on the screen
D) Server-side processing
Answer: C
Q3) <u>SQL</u> is a procedural language that allows a programmer to code a logical sequence of steps to make decisions. _________________________
A)True
B)False
Answer: False
Q4) A program that can run on any platform is considered ____________________. Answer: portable
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 following loop terminates when the lv_cnt_num variable holds a value of 6. BEGIN WHILE lv_cnt_num <= 5 LOOP DBMS_OUTPUT.PUT_LINE( lv_cnt_num ); lv_cnt_num := lv_cnt_num + 1; END LOOP; END;
A)True
B)False
Answer: True
Q2) The code order NUMBER(2) := 6; is an example of a(n) ____________________. Answer: assignment statement
Q3) The term anonymous blocks refers to blocks of code that are not stored for reuse and do not exist after being executed. A)True
B)False
Answer: True
Q4) _____________________ statements are used to put or change values in variables.
Answer: Assignment
Page 4
To view all questions and flashcards with answers, click on the resource link above.
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 allows a table of records value to persist for a user session?
A) Declaring the table of records variable in a row specification.
B) Declaring the table of records variable in a cursor specification.
C) Declaring the table of records variable in a record specification.
D) Declaring the table of records variable in a package specification.
Answer: D
Q2) A variable declared with a record type can hold one row of data consisting of a number of column values.
A)True
B)False
Answer: True
Q3) tbl_basketitems(5).idproduct := :g_prod; According to the above statement, which of the following indicates the field into which a value will be placed?
A) idproduct
B) tbl_basketitems
C) :g_row
D) :g_prod
Answer: A
To view all questions and flashcards with answers, click on the resource link above.
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 ____ section of a PL/SQL block addresses two situations: either an Oracle error is raised or a user-defined error is raised.
A) DECLARE
B) BEGIN
C) EXCEPTION
D) UPDATE
Q2) An exception is a mechanism to trap an error that occurs in processing.
A)True
B)False
Q3) The ____ option groups rows of queries or DML statements for processing.
A) FORALL
B) COLLECT BULK
C) BULK COLLECT
D) LIMIT
Q4) Implicit and explicit cursors are considered dynamic because they are associated with specific queries.
A)True
B)False
Q5) Discuss the meaning of the term exception handler.
Q6) An attempted division by zero causes the ____________________ exception.
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) ____are transactions created within another transaction.
A) Pragma transactions
B) Dynamic transactions
C) Autonomous transactions
D) Subprograms
Q2) ____ is an acceptable error number for the RAISE_APPLICATION_ERROR function.
A) -18,000
B) -19,000
C) -20,002
D) -21,000
Q3) The parameters in the procedure declaration of an application are called <u>actual parameters</u>. _________________________
A)True
B)False
Q4) What is the difference between a database trigger and an application trigger?
Q5) Three pieces of information for each parameter must be provided in the header: name, mode, and ____________________.
Q6) A(n) ____________________ contains a RETURN clause and is used to manipulate data and return a single resulting value.
Page 7
To view all questions and flashcards with answers, click on the resource link above.
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) It is possible to reference a data dictionary to determine what code is contained in a program unit.
A)True
B)False
Q2) How many input values does the following code require? CREATE OR REPLACE FUNCTION memfmt1_sf (p_id IN NUMBER, P_first IN VARCHAR2, P_last IN VARCHAR2)
RETURN VARCHAR2 IS Lv_mem_txt VARCHAR2(35); BEGIN
Lv_mem_txt := 'Member ' ||p_id|| ' - ' ||p_first|| ' ' ||p_last; RETURN lv_mem_txt; END;
A) 1
B) 2
C) 3
D) 4
To view all questions and flashcards with answers, click on the resource link above.
Page 8
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) A one time only procedure is included in a package body as an anonymous PL/SQL block at the end of the body code.
A)True
B)False
Q2) The <u>USER_SOURCE</u> data dictionary view is useful to identify what packages exist on the system. _________________________
A)True
B)False
Q3) The ____ is referred to as the package header.
A) purity level
B) construct scope
C) program units
D) package specification
Q4) Functions written in other languages such as JAVA can also be called from Oracle programs.
A)True
B)False
Q5) When compiling objects that call packaged program units, only the ____________________ is used for verification.
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) ____ allows users to create program units in any schema and does not allow the modification or dropping of program units.
A) CREATE PROCEDURE
B) CREATE ANY PROCEDURE
C) ALTER PROCEDURE
D) EXECUTE ANY PROCEDURE
Q2) The ____________________________ data dictionary view allows users to review object status and referenced objects.
Q3) A program unit is said to contain ____ when it includes references to database objects that in turn references other database objects.
A) remote dependencies
B) user_dependencies
C) direct dependencies
D) indirect dependencies
Q4) Oracle offers two models or methods to determine invalidation of remote dependent objects at runtime: timestamp and ____________________________.
Q5) What is the purpose of the %TYPE and %ROWTYPE attributes?
Q6) What is the difference between the timestamp model and the signature model?
To view all questions and flashcards with answers, click on the resource link above. Page 10
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) 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
Q2) The ___________________________ level option is applicable only for UPDATE and DELETE events.
Q3) 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
Q4) A(n) ___________________________ is one that is referenced via a foreign key constraint on the table that a trigger is modifying.
Q5) Discuss three critical pieces of information regarding the WHEN clause of a trigger.
Q6) The FOLLOWS trigger option enables a developer to control the firing order of triggers.
A)True B)False
To view all questions and flashcards with answers, click on the resource link above. Page 11
Chapter 10: Oracle-Supplied Packages, Dynamic SQL, and 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 ability to send e-mails from within PL/SQL code has been simplified with the introduction of the DBMS_ALERT package.
A)True
B)False
Q2) The <u>UTL_HTTP</u> package provides the capability to make Hypertext Transfer Protocol (HTTP) calls from within PL/SQL programs. _________________________
A)True
B)False
Q3) All of the following procedures are included in the DBMS_ALERT package, except
A) REGISTER
B) SIGNAL
C) WAIT
D) WAITONE
Q4) The UTL_FILE package contains a PUT_LINE data type that is used to declare a file variable.
A)True
B)False
Q5) What is the difference between a mutator and an observer?
To view all questions and flashcards with answers, click on the resource link above. Page 12