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. TCL: Undo changes back to savepoint ab.
p.v
rollback to ab
definition
explicit cursor

2. PL/SQL is a ________ typed programming language.
statically
oname
optional
preprocessor

3. Triggers: You create a trigger with the _______ ________ statement.
CREATE TRIGGER
TIMESTAMP.
currval and nextval
obfuscates

4. The BEGIN section is (optional/mandatory)
Keywords and predefined names.
not the same
mandatory
concatenation

5. A __________ can have an AUTHID property
package
Declaration
SQL
is certain

6. TCL: Create a savepoint called ab
aliases
ROLLBACK
savepoint ab
do not

7. This is a CASE (expression / statement): CASE num WHEN 1 THEN goto LABEL1 WHEN 2 THEN var := 2 END CASE;
32 -000
statement
single-line
not a number

8. Exceptions: PL/SQL exceptions are of two types: internal and _________.
exception
index
open cv for
user-defined

9. What word is in a function header but not in a procedure header?
DML
error code
RETURN
does not

10. User-defined compiler directives are defined in this system compile parameter.
RETURN
PLSQL_CCFLAGS
network
invoker's

11. Web: PL/SQL ______ ______ (PSPs) let you develop web pages with dynamic content.
Server Pages
cannot
composite
$$PLSQL_LINE

12. DynSQL: The clause that supplies bind arguments to EXECUTE IMMEDIATE.
STANDARD
USING
FETCH - BULK COLLECT INTO
EXECUTE IMMEDIATE

13. Cursors: The values plugged into the DML in a FORALL must come from existing - populated _________.
sql
closed
invoker's
collections

14. A result-cached function caches its results in the _____ _____ ____ (SGA)
system global area
Gateway
is certain
FETCH

15. Cursors: The statement that closes a cursor.
compiles
package
name
CLOSE

16. Triggers: In a per-row trigger - the ____ record shows you the changed state of an affected row.
cursor variable
NEW
ENABLE
LOOP - END LOOP

17. To enable result-caching for a function - use the _____________ clause.
r t.%ROWTYPE;
dbms_output.put_line
RESULT_CACHE
<<>>

18. With static typing - type checking is done at ______ time.
compile
STANDARD
CREATE TRIGGER
session cursor

19. Conditional compilation is useful for compiling a program under different ______ of Oracle.
versions
SQLCODE
an autonomous routine
cannot

20. Cursors: The FOR UPDATE phrase goes at the (beginning/end) of the cursor definition.
end
optional
subtype
finishes

21. Kind of code created by the PL/SQL compiler.
calls
expression
bytecode
DATE

22. Exceptions: You cannot GOTO from an exception handler back into the __________ block.
3
procedure - function
current
FOR - IN

23. The lowest index of a VARRAY is ___.
$END
1
selection
fail

24. Cursors: If no SELECT or DML statement has run - the value of SQL%ROWCOUNT is what?
do not

define
open C

25. For an associative array - the FIRST method gets the (lowest / first-created) index.
lowest
unhandled
END
OPEN_CURSOR

26. Cursors: A session cursor that a PL/SQL user creates and manages.
explicit cursor
portable
1
Abstract

27. The $IF must evaluate a ______ _______ expression.
INTO
flushed
function f (n number) return number result_cache relies_on (emps);
static boolean

28. Mode designation for an input/output parameter.
EXECUTE
IN OUT
1
anonymous

29. Wrap iname=xxxx _____=zzzzz
DML
static
inquiry
oname

30. Parameter that controls how much Oracle optimizes your PL/SQL code on compilation.
FORALL i IN MyList.FIRST..MyList.LAST
PLSQL_OPTIMIZE_LEVEL
inquiry
%ISOPEN.

31. $$PLSQL_LINE and $$PLSQL_UNIT are ______-ly defined inquiry directives.
error
iname
implicit
statement

32. Triggers: By default - a trigger is created in the ______ state.
enabled
explicit cursor
invoker's
searched

33. Types: One of the scalar data types specific to PL/SQL: R_________.
FORALL and BULK COLLECT
REF_CURSOR
CLOSE
collections

34. Cursors: An explicit cursor (can/cannot) accept parameters.
can
optional
sql
cursor number

35. I/O: This package has hypertext procedures that generate HTML tags
EVERE - PERFORMANCE - INFORMATIONAL
DEFINER
external subprogram
HTP

36. To run TCL or DDL statements - a trigger (must / must not) be autonomous .
LOOP
column
must
null string

37. I/O: dbms_output.put_line puts output into a _______.
buffer
select
%FOUND - %ISOPEN - %NOTFOUND - %ROWCOUNT
invoker's

38. I/O: To make sure the DBMS_OUTPUT buffer will be flushed - put a WHEN ______ clause in the EXCEPTION section of your outer block.
wrap
order
predefined
OTHERS

39. A numeric FOR loop cannot _________ by other than 1?
CLOSE
object
increment
SQLPlus

40. After the RESULT_CACHE clause - you can put a _________ clause to enable dependency-checking.
RELIES_ON
expression
CLOSE
same arguments

41. I/O: The buffered output of dbms_output.put_line is retrieved by _______.
SQLPlus
$$
constructor
compile

42. Keyword for doing assignment to a variable with SELECT.
EXECUTE
INTO
integer
NDS

43. Cursors: A Cursor FOR loop does not use a ______ statement.
FETCH
PL/SQL
once
OPEN_CURSOR

44. If none of a CASE expression's conditions are TRUE - it returns _____.
USER_PLSQL_OBJECT_SETTINGS
finishes
user-defined

45. Nested tables are multisets - meaning that there is no inherent _____ of their elements.
propagates
SYS_CONTEXT
SQL
order

46. Associative array types (can / cannot) be defined in the database.
library
=>
cannot
implicit cursor

47. In a sparse collection - the indexes of defined elements (do / do not) run in consecutive order.
do not
=>
closed
FETCH

48. Triggers: An INSTEAD OF trigger (can/cannot) be conditional.
null string
REF_CURSOR
cannot
not the same

49. Dbms_sql: The integer returned by OPEN_CURSOR is a _____ _____.
cursor number
CLOSE_CURSOR
IR
literals

50. I/O: The output from DBMS_OUTPUT will display (during/after) program execution.
FOR i IN REVERSE 1..10 LOOP
PRAGMA EXCEPTION_INIT (E - -1);
return value
after