Oracle Database Administration
Exam Preparation Guide
Course Introduction
Oracle Database Administration is a comprehensive course that introduces students to the core concepts, architecture, and practical skills required to manage Oracle databases effectively. Participants learn to install, configure, and upgrade Oracle Database environments, implement security measures, manage user accounts, and control access privileges. The course also covers essential topics such as backup and recovery strategies, monitoring database performance, tuning queries, and automating administrative tasks. Through hands-on labs and real-world scenarios, students develop the expertise needed to maintain data integrity, ensure high availability, and support enterprise applications on Oracle platforms.
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
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) Describe the three-tier application model.
Answer: The three-tier model is growing in popularity because it attempts to ease application maintenance and enables the support of larger numbers of users. In this scenario, the user interface is typically presented via a Web browser and is often referred to as a thin client. Application code is not loaded onto the client machine; all the application code now resides on an application server, which is also referred to as the middle tier.
Three layers now exist in this model: the user interface, the application server, and the database server. The Oracle application server allows the deployment of Oracle Forms applications via the Web. The application server contains the user interface and processing logic, which together, respond to user actions and, in turn, send appropriate code to the database server for processing.
Q2) Which of the following typically returns only one value?
A) Procedure
B) Function
C) Database trigger
D) Package
Answer: B
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 ____ section of a PL/SQL block contains handlers that allow you to control what the application will do if an error occurs when the executable statements are processed.
A) EXCEPTION
B) BEGIN
C) DECLARE
D) END
Answer: A
Q2) The <u>basic</u> loop uses the LOOP and END LOOP markers to begin and end the loop code. _________________________
A)True
B)False
Answer: True
Q3) By indicating a numeric range, the ____________________ dictates exactly how many times the loop should run in the opening LOOP clause.
A)True
B)False
Answer: False
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 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
Q2) Which of the following attributes is available to enable movement through the associative array data?
A) COUNT
B) DELETE
C) PRIOR
D) EXISTS
Answer: C
Q3) A(n) ____ of data typically includes a number of different fields.
A) row
B) collection
C) assignment statement
D) variable
Answer: A
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) 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
Q2) ____ is used to trap errors not specifically addressed in one of the exception handlers.
A) WHERE
B) EXIT WHEN
C) WHEN OTHERS
D) EXCEPTION
Q3) ____ refers to an attempted violation of a unique or primary key column constraint.
A) NO_DATA_FOUND
B) TOO_MANY_ROWS
C) DUP_VAL_ON_INDEX
D) CASE_NOT_FOUND
Q4) A good programming practice is to include ____________________ in your code to document what is being accomplished throughout the program.
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) In a(n) <u>positional </u>method, you associate a value to each parameter by name in the invoke statement. _________________________
A)True
B)False
Q2) ____ are mechanisms used to send values into and out of a program unit.
A) Parameters
B) Procedures
C) Database triggers
D) Packages
Q3) Only the program unit in which a subprogram is declared can use that subprogram.
A)True
B)False
Q4) ____________________ indicate which way the value provided for the parameter flows: into the procedure, out of the procedure, or both.
Q5) The parameters in the procedure declaration of an application are called <u>actual parameters</u>.
A)True
B)False
Q6) What is the difference between a function and a procedure?
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) The term "passed by reference" means that the value is copied from the actual parameter to the formal parameter.
A)True
B)False
Q2) The term ____ is identified with a set of acronyms that indicate the restrictions on using the function.
A) compiler hint
B) purity level
C) pass by reference
D) pass by value
Q3) Which of the following statements is True?
A) After IN OUT parameters are included in functions, the function can no longer be used in SQL statements.
B) After OUT parameters are included in functions, the function can no longer be used in SQL statements.
C) After INOUT parameters are included in functions, the function can no longer be used in SQL statements.
D) After IN parameters are included in functions, the function can no longer be used in SQL statements.
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) The <u>USER_OBJECTS</u> data dictionary view allows us to view the source code of packages. _________________________
A)True
B)False
Q2) A(n) ____________________ procedure is a procedure in a package that runs only once, when the package is initially invoked.
Q3) Functions cannot be used in a(n) ____________________ constraint or as a default value of a table column.
Q4) A(n)<u> program declaration</u> is a declaration of a program unit in a package body by placing the header code at the top of the package body code.
A)True B)False
Q5) Full procedures or function codes are contained in the ____.
A) package specification
B) package body
C) package header
D) anonymous block
Q6) What is meant by the term package body?
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 ____________________________ data dictionary view reveals all the privileges of the current schema.
Q2) ____ can be used to check the status of database objects.
A) USER_OBJECTS
B) USER_REFERENCE
C) USER_CHECK
D) USER_SOURCE
Q3) When a procedure is compiled, it stores the ____ of any referenced objects.
A) datestamp
B) signature
C) timestamp
D) recordstamp
Q4) If a dependent object has an older ____ than the referenced object when called, the dependent object is flagged as INVALID and needs to be recompiled.
A) signature
B) record
C) timestamp
D) datestamp
Q5) What is the purpose of the %TYPE and %ROWTYPE attributes?
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) One prominent limitation in the use of triggers is that they cannot issue transaction control statements of COMMIT, ROLLBACK, and SAVEPOINT.
A)True
B)False
Q2) A constraining table is one that is being modified by a DML action when a trigger is fired.
A)True B)False
Q3) If multiple triggers exist on a table, there is no guarantee about the order in which the triggers will be fired.
A)True
B)False
Q4) The <u>WHEN</u> clause of a trigger can be used only in row level triggers.
A)True B)False
Q5) The ___________________________ level option is applicable only for UPDATE and DELETE events.
Q6) What is the difference between a mutating table and a key-preserved table?
Page 11
To view all questions and flashcards with answers, click on the resource link above.
Chapter 10:
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) In the UTL_HTTP package, the ____ function is used to retrieve the HTML source from a specified URL.
A) REQUEST_PIECES
B) NOOP
C) RCPT
D) RSET
Q2) The ____ parameter of the ANALYZE_OBJECT procedure dictates that the value provided must be either TABLE, INDEX, or CLUSTER.
A) TYPE
B) SCHEMA
C) NAME
D) PARTNAME
Q3) The basic mechanics of the alert process include registering an alert name, setting up when an alert should signal, and enabling the appropriate users to receive the alert.
A)True
B)False
Q4) Attempting to use a(n) _________________________ to provide an identifier, such as a column name or table name, in an SQL statement within PL/SQL raises an error.
Page 12
To view all questions and flashcards with answers, click on the resource link above.