SUBJECTS
|
BROWSE
|
CAREER CENTER
|
POPULAR
|
JOIN
|
LOGIN
Business Skills
|
Soft Skills
|
Basic Literacy
|
Certifications
About
|
Help
|
Privacy
|
Terms
|
Email
Search
Test your basic knowledge |
Oracle PL - SQL
Start Test
Study First
Subjects
:
oracle
,
it-skills
Instructions:
Answer 50 questions in 15 minutes.
If you are not ready to take this test, you can
study here
.
Match each statement with the correct term.
Don't refresh. All questions and answers are randomly picked and ordered every time you load a test.
This is a study tool. The 3 wrong answers for each question are randomly chosen from answers to other questions. So, you might find at times the answers obvious, but you will see it re-enforces your understanding as you take the test each time.
1. Parameter that controls how much Oracle optimizes your PL/SQL code on compilation.
for update of
<> - != - ^=
PLSQL_OPTIMIZE_LEVEL
open C
2. Cursors: A pointer to a cursor is called a ______ _______.
fail
DEFINER
cursor variable
PRAGMA AUTONOMOUS_TRANSACTION;
3. A (simple / searched) CASE statement begins with CASE WHEN <boolean expression>.
*/
RECORD OF ARRAYS
GET_LINES
searched
4. If a procedure fails - an OUT parameter passed to it by value (will / will not) be passed back with changes.
simple and compound symbols
Apache
server
will not
5. Types: One of the 4 PL/SQL things that have a data type (begins with 'v').
before insert or update on emps
REUSE SETTINGS
variable
cannot
6. True encryption is done with package __________.
DBMS_CRYPTO
REF CURSOR
EVERE - PERFORMANCE - INFORMATIONAL
..
7. Abbreviation for Abstract Data Type.
object
CHARARR
ADT
OPEN
8. Cursors: The values plugged into the DML in a FORALL must come from existing - populated _________.
FETCH
CHARARR
collections
DML
9. Command to assign to variables from a cursor.
exception handler
FETCH
array
FOR UPDATE
10. Exceptions: The _________ package defines the PL/SQL environment.
obfuscates
PUT_LINE
%ISOPEN.
STANDARD
11. How to reference a variable V declared in a block labelled L: ____.
L.V
OTHERS
collections - records
an enclosing block
12. I/O: This package does email.
integer
UTL_SMTP
True - false or NULL.
SQL
13. Collections are one of the two kinds of PL/SQL _______ data types.
composite
explicit cursor
nested tables - associative arrays
executable
14. Delimiters: The assignment operator.
set serveroutput on
:=
DECLARE - BEGIN - EXCEPTION - END
is not
15. How many times are a FOR loop's index bounds evaluated?
invoker's
DECLARE - BEGIN - EXCEPTION - END
once
EXECUTE IMMEDIATE
16. TCL: Create a savepoint called ab
DBMS_CRYPTO
CURRENT_USER - DEFINER
IS
savepoint ab
17. Exceptions: An exception in the declarations section propagates to the enclosing _______.
block
static
REUSE SETTINGS
open C(p)
18. In short-circuit evaluation - IF-conditions are only evaluated up to where the outcome ___________.
is certain
unqualified
SESSION_USER
Gateway
19. In a record - the internal components are called ______.
constructor
fields
USER_PLSQL_OBJECT_SETTINGS
.
20. Triggers: You (can/cannot) explicitly invoke a trigger.
TYPE t IS TABLE OF rPerson INDEX BY PLS_INTEGER;
cannot
STANDARD
context
21. A type of compiler directive - begins with 's'.
$IF $THEN $ELSE $END
API
selection
PL/SQL Gateway
22. Exceptions: The built-in procedure for raising an application-defined error.
transaction
exception handler
OPEN
raise_application_error
23. Cursors: Give the first 3 words to open a cursor variable called cv.
open cv for
INTO
EXECUTE IMMEDIATE
TRUE - FALSE - NULL
24. Abbreviation of definer's rights
can
DR
Wrap
1 million
25. What do you FETCH from?
a cursor
scalable
HTF
virtual machine
26. Nested tables are multisets - meaning that there is no inherent _____ of their elements.
Server Pages
Keywords and predefined names.
order
significant
27. Triggers: An INSTEAD OF trigger (can/cannot) be conditional.
cannot
native dynamic
<<
COMMIT - ROLLBACK - SAVEPOINT - SET TRANSACTION
28. Web: PL/SQL ______ ______ (PSPs) let you develop web pages with dynamic content.
implicit
database
RECORDS
Server Pages
29. Advantage: Having procedures stored and executed on the server makes PL/SQL ________.
nested
scalable
VARRAY - Nested table
integrated
30. DynSQL: The three modes of arguments in the USING clause of EXECUTE IMMEDIATE.
IN - OUT - IN OUT
multi-row
bind arguments
$END
31. For a collection - the NEXT method gets the next higher (element / index).
EXIT WHEN cv%NOTFOUND
unconstrained
index
current transaction
32. A nested table has to be initialized using a ________ - named the same as the type.
constructor
=
VARRAY - Nested table
EXIT WHEN
33. Conversion: Just about everything will implicitly convert to _____ or _________.
CHAR - VARCHAR2
context
TOO_MANY_ROWS
cannot
34. Cursors: An explicit cursor (can/cannot) accept parameters.
lowest
wrap
can
searched
35. Declaration of a varchar2 constant - called vname - with value 'x'.
Warning
: Invalid argument supplied for foreach() in
/var/www/html/basicversity.com/show_quiz.php
on line
183
36. Advantage: PL/SQL gives SCALABILITY because stored procedures are executed on the _______.
HTP
cannot
server
definer's
37. A CASE expression ends with _____.
RESULT_CACHE
END
cursor
procedure - function
38. Fundamental: One of the 4 types of lexical units: d_____
delimiters
network
parameter
%
39. I/O: The DBMS_OUTPUT function that writes output WITH a newline character.
identifiers
PUT_LINE
array
portable
40. Bulk: The two features that comprise Bulk SQL are:
cursor c;
current BEGIN-END block
v2 IN NUMBER default 20
FORALL and BULK COLLECT
41. What is the exception that is implicitly raised in a CASE statement with no ELSE clause?
CASE_NOT_FOUND
do not
executable
composite
42. The _____ and ____ _____ collection types can be used in database table columns.
VARRAY - Nested table
-
..
source
43. The EXCEPTION section is (optional/mandatory).
composite
optional
LOOP - END LOOP
r tRec := tRec(9 - 'Jones');
44. Advantage: PL/SQL is PORTABLE to any OS where ________ runs.
open C(p)
statement
PSP
Oracle
45. I/O: The DBMS_OUTPUT buffer will not be flushed until it is full or until the current PL/SQL block _________.
finishes
v3 IN OUT NUMBER
IN - OUT - IN OUT
constant
46. 5 types of events that can have triggers: DML - DDL - INSTEAD OFs - database events - and ________ statements.
suspended
scalar
virtual machine
SESSION_USER
47. DynSQL: The main command for Native Dynamic SQL.
a cursor
suspended
EXECUTE IMMEDIATE
unconstrained
48. A collection is an ordered group of ________ - all of the same ____
invoker's
closed
255
elements - type
49. Delimiters: Host variable indicator.
CURSOR - RETURN - IS
...
CREATE TRIGGER
enabled
50. The source for wrapping begins with the word ______.
create
OTHERS
current BEGIN-END block
simple and compound symbols