Test your basic knowledge |

Oracle PL - SQL

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. Exceptions: An exception in the declarations section does not go to the __________ section.
return value
exception
UTL_FILE
EDITION_NAME

2. When a parameter is passed by reference - changes made to it inside the procedure cannot be undone. True/False.
CURRENT_USER - DEFINER
implicit
True
'ENABLE:SEVERE' - 'ERROR:06002'

3. You can put a label before any executable PL/SQL _________.
statement
name-value
SYS_REFCURSOR
EDITION_NAME

4. A type of compiler directive - begins with 's'.
versions
v2 IN NUMBER default 20
can
selection

5. What are the starting and ending keywords of a simple loop?
LOOP - END LOOP
Wrap
32 -000
simple

6. Conversion: It is best to use (implicit / explicit) conversion.
same
inquiry
explicit
NUMBER

7. Delimiters: Single-line comment marker.
ROLLBACK
-
memory
cannot

8. Dbms_sql: A cursor opened with OPEN_CURSOR (can/cannot) be reused for multiple queries without first closing it.
can
mandatory
name and datatype
RETURN

9. To enable result-caching for a function - use the _____________ clause.
statement
WHEN
can
RESULT_CACHE

10. Kind of code created by the PL/SQL compiler.
associative
$IF $THEN $ELSE $END
external subprogram
bytecode

11. The PL/SQL preprocessor passes ______ code to the compiler.
colon
aliases
explicit
source

12. Mode designation for an input/output parameter.
collections
FOR - IN
IN OUT
$$

13. What clause makes a compilation default to the PLSQL_CCFLAGS settings from the last compilation?
REUSE SETTINGS
associative arrays
executable
an enclosing block

14. Two types of stored subprograms.
Declaration
procedure - function
multi-row
database

15. The EXCEPTION section is (optional/mandatory).
for each row
optional
CASE_NOT_FOUND
do not

16. A CASE expression ends with _____.
Abstract
END
null string
integer

17. Cursors: The SQL%BULK_ROWCOUNT attribute is an _________ -
array
names
cursor number
$END

18. The lowest index of a VARRAY is ___.
1
NESTED TABLE myColl STORE AS myCollTab
:=
array

19. Bulk: The use of FORALL statements cuts down on ______ traffic.
increment
colon
network
information that changes infrequently

20. _________ exceptions can not be trapped with an error handler
Declaration
composite
API
TOO_MANY_ROWS

21. Assigning values to PL/SQL variables that appear in SQL statements is called _______.
collections
server
binding
not a number

22. Types: One of the 4 PL/SQL things that have a data type (begins with 'v').
memory
DR
is
variable

23. FOR-Looping over a collection from FIRST to LAST only works if the collection is _______.
CLOSE_CURSOR
FALSE
cannot
dense

24. Characters that end a multi-line comment.
CLOSE_CURSOR
quoted
FOR i IN REVERSE 1..10 LOOP
*/

25. Mode designation for an input parameter.
searched
IN
RESULT_CACHE
disable

26. Exceptions: User-defined exceptions must have _______.
HTF
names
RESULT_CACHE
SQL cursor

27. Types of blocks: A pl/sql block that is not stored in the database.
DATE '2005-12-25'
literal
RAISE
anonymous

28. A PL/SQL block that is not stored.
RECORD OF ARRAYS
decimal
unqualified
anonymous block

29. Cursors: Which cursor attribute is not meaningful for an implicit cursor?
%ISOPEN.
32 -000
suspended
3

30. What is the simplest statement for conditionally getting out of simple loop?
portable
lowest
EXIT WHEN
wrap

31. Advantage: PL/SQL runs anywhere Oracle runs - so it is very ________.
portable
WHERE CURRENT OF
FOR - IN
inclusive

32. PLSQL_CCFLAGS hold a comma-separated list of ______ pairs (hyphenated).
name-value
scalar
DATE '2005-12-25'
cannot

33. How many times are a FOR loop's index bounds evaluated?
once
EXECUTE IMMEDIATE
Declaration
STANDARD

34. Triggers: When using the NEW or OLD pseudo-records in the body of the trigger - they must be prefixed with a _______.
E Exception;
end
colon
raise_application_error(-20 -100 - 'Bad');

35. What do you FETCH from?
%BULK_ROWCOUNT
a cursor
transaction
%TYPE

36. A GOTO statement cannot branch from an exception handler back into the...
set serveroutput on
same
transaction
current BEGIN-END block

37. The first SQL statement in an autonomous routine begins a _______.
transaction
production
REF CURSOR
RESULT_CACHE

38. Cursors: A cursor variable's type must be a ____ ______ type.
select
cursor
loop
REF CURSOR

39. A SELECT statement with the FOR UPDATE clause puts a ______ on the selected rows.
$IF
lock
USER_PROCEDURES
END CASE

40. Clause added to a cursor to use it with WHERE CURRENT OF.
for update of
VARRAY - Nested table
DEFINER
HTP

41. Abbreviation of definer's rights
can
DR
FETCH
DML

42. A national character literal is composed of characters in the ________ character set.
cannot
national
%ISOPEN.
fetch C into V

43. Web: mod_plsql is an _______ module.
does not
block
Apache
statement

44. An INSTEAD OF trigger is used - e.g - when you want to insert into a complex _____.
select
a number := 10
view
USING

45. Where an external subprogram is stored.
in the database
WHERE CURRENT OF
can
Keywords and predefined names.

46. I/O: One of the 3 types of data that can be passed to the DBMS_OUTPUT buffer.
code
VARCHAR2
definer's
always

47. If a procedure fails - an OUT parameter passed to it by value (will / will not) be passed back with changes.
will not
REUSE SETTINGS
do not
type T is ref cursor

48. DBMS_DDL.CREATE_WRAPPED: wraps and _______ the source code passed to it.
INTO
compiles
4
a cursor

49. Advantage: Caching of programs and sharing among users lowers _______ requirements.
memory
anonymous block
EDITION_NAME
fine-grained auditing

50. The PL/SQL virtual machine turns bytecode into system ______.
external subprogram
calls
open C
compilation