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. I/O: This package handles HTTP.
DBMS_SQL
deletions
UTL_HTTP
r t.%ROWTYPE;

2. Statement to exit a cursor loop on cursor cGo when there are no more records.
exit when cgo%NOTFOUND
UTL_HTTP
closed
constructor

3. Exceptions: The _________ package defines the PL/SQL environment.
STANDARD
invoker's
unqualified
END IF

4. After the RESULT_CACHE clause - you can put a _________ clause to enable dependency-checking.
END LOOP
EXIT
RELIES_ON
FORALL i IN MyList.FIRST..MyList.LAST

5. Exceptions: An exception raised inside an _______ _______ propagates immediately to the enclosing block
exception handler
PUT_LINE
package
enabled

6. The FORALL statement to loop over a collection MyList using index i.
%ISOPEN.
FORALL i IN MyList.FIRST..MyList.LAST
not a number
HTP

7. Conditional ______ allows backward compability with older database versions.
FETCH - INTO
ex := tbl1 MULTISET EXCEPT tbl2
comments
compilation

8. A pointer to a private SQL area that stores information about processing a specific SELECT or DML statement.
cursor
%FOUND - %ISOPEN - %NOTFOUND - %ROWCOUNT
machine code

9. Cursors: The first two keywords of a basic fetch statement.
FETCH - INTO
currval and nextval
virtual machine
an autonomous routine

10. I/O: Max number of bytes to pass in a call to DBMS_OUTPUT.PUT_LINE.
PUT
literal
definer's
255

11. Declare a package procedure P with no arguments - and give it invoker's rights.
NUMBER
RAISE
procedure P AUTHID current_user;
exception handler

12. Fundamental: What are the 3 compound symbols for 'not equal to'?
optional
RETURN
<> - != - ^=
PUT

13. Cursors: A cursor variable's type must be a ____ ______ type.
REF CURSOR
machine
RETURN
WHERE CURRENT OF

14. In short-circuit evaluation - IF-conditions are only evaluated up to where the outcome ___________.
dynamic
is certain
TIMESTAMP.
decimal

15. Fundamental: Maximum string length of a PL/SQL variable.
index
comments
32 -000
WHEN

16. DynSQL: The three modes of arguments in the USING clause of EXECUTE IMMEDIATE.
Keywords and predefined names.
NESTED TABLE myColl STORE AS myCollTab
IN - OUT - IN OUT
WHEN

17. DynSQL: EXECUTE IMMEDIATE does both dynamic SQL and dynamic _______.
open cv for
names
PL/SQL
'

18. Term for a character literal with zero characters.
FGA
CHAR - VARCHAR2
bind
null string

19. Cursors: The four cursor attributes - in alphabetical order.
implicit cursor
%FOUND - %ISOPEN - %NOTFOUND - %ROWCOUNT
open cv for
Declaration

20. Triggers: A compound trigger can fire at more than one ______ point.
a number := 10
INTO
an autonomous routine
timing

21. Cursors: The Oracle predefined REF CURSOR type.
STANDARD
SYS_REFCURSOR
finishes
EXIT

22. Cursors: A cursor FOR loop cannot use a _______ variable.
cursor
constructor
LOOP
collections

23. In Native Mode - PL/SQL code is compiled into ______ ______.
bb:true
DEFINER
machine code
FOR - IN

24. Cursors: The second keyword of a FETCH statement.
value
mandatory
index
INTO

25. Pkgs: The _______ package gives access to such SQL things as ALTER SESSION.
statement
$IF
manageable
DBMS_SESSION

26. To enable result-caching for a function - use the _____________ clause.
statement
nested
NUMBER
RESULT_CACHE

27. Give the first line of the FOR loop with index i going from 1 to 10 in reverse.
ordinary
PL/SQL Gateway
FOR i IN REVERSE 1..10 LOOP
disable

28. The valid values of the AUTHID property.
an enclosing block
finishes
always
CURRENT_USER - DEFINER

29. Mode designation for an input parameter.
can
IN
statically
Declaration

30. I/O: One of the 3 types of data stored in the DBMS_OUTPUT buffer.
autonomous triggers
%
DATE
cannot

31. Advantage: Performance: PL/SQL automatically creates ______ variables for variables in WHERE and VALUES clauses.
finishes
bind
compiles
autonomous triggers

32. PLSQL_CCFLAGS hold a comma-separated list of ______ pairs (hyphenated).
name-value
implicit
SYS_REFCURSOR
name and datatype

33. Exceptions: Type ______ to re-raise the current exception.
RAISE
procedure - function
memory
external subprogram

34. Loops: What is the index range operator in a FOR loop?
DML
..
PRAGMA EXCEPTION_INIT (E - -1);
finishes

35. This is a CASE (expression / statement): CASE num WHEN 1 THEN goto LABEL1 WHEN 2 THEN var := 2 END CASE;
statement
plb
STANDARD
optional

36. DynSQL: In EXECUTE IMMEDIATE - the statement string can use either placeholders - or string ________.
SQLCODE
concatenation
associative
code

37. Default file extension of wrap's input file.
sql
cursor
user-defined
commit - rollback

38. With an sparse - integer-indexed associative array - you (can / cannot) use a regular FOR loop.
name and datatype
cannot
-
simple and compound symbols

39. Fundamental: A label can be used to name an ______ block.
alter procedure
commit - rollback
4
anonymous

40. _________ exceptions can not be trapped with an error handler
SUBTYPE numb IS number;
DBMS_OUTPUT
is
Declaration

41. Default file extension of wrap's output file.
array
Ada
after
plb

42. Abbreviation of definer's rights
ENABLE
EXTEND
Gateway
DR

43. In the special IF syntax - is it ELSIF - or ELSEIF?
suspended
elsif
system global area
CLOSE_CURSOR

44. Cursors: If an exception is raised inside a cursor loop - the cursor (is / is not) also closed automatically.
cannot
is
/*
SQLPlus

45. Wrapping can be done with the ____ executable.
1
fields
wrap
BINARY_INTEGER

46. What do you FETCH from?
a cursor
external subprogram
SQL
ALTER SESSION

47. Assigning values to PL/SQL variables that appear in SQL statements is called _______.
FORALL i IN MyList.FIRST..MyList.LAST
EVERE - PERFORMANCE - INFORMATIONAL
index
binding

48. Declare a number variable - A - initialized to 10.
a number := 10
DECLARE - BEGIN - EXCEPTION - END
v3 IN OUT NUMBER
single-line

49. PLS_INTEGER has its arithmetic implemented in ________ - so it is very fast.
hardware
slower
transaction
select

50. Triggers: You create a trigger with the _______ ________ statement.
EVERE - PERFORMANCE - INFORMATIONAL
cursor
RAISE
CREATE TRIGGER