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. Which collection type is bounded?
DR
query
varray
cannot

2. Cursors: You can just declare a cursor at first - then _______ it later.
query
not a number
4K
define

3. Bulk: The two features that comprise Bulk SQL are:
FORALL and BULK COLLECT
Wrap
..
1

4. Exceptions: The package that defines pre-defined exceptions.
DML
STANDARD
variable
fine-grained auditing

5. Cursors: The two keywords in a mere cursor declaration (one is optional).
hardware
collections - records
CURSOR - RETURN
LOOP

6. A pointer to a private SQL area that stores information about processing a specific SELECT or DML statement.
invoker's
cursor
IF - CASE or LOOP
UTL_SMTP

7. By default - an IN parameter is passed by ______.
can
network
LOOP
reference

8. What are the starting and ending keywords of a simple loop?
32 -000
LOOP - END LOOP
expression
FOR UPDATE

9. Triggers: Unlike a stored procedure - you can enable and _____ a trigger.
source code
EXIT WHEN
aggregate - analytical
disable

10. With Edition-based Redefinition enabled - the unique specification of an object requires OWNER - OBJECT_NAME and ___________.
portable
EXECUTE IMMEDIATE
<> - != - ^=
EDITION_NAME

11. Types: The predefined subtype of PLS_INTEGER that has the NOT NULL constraint.
network
server
SIMPLE_INTEGER
nested

12. Wrap ______=xxxx oname=zzzzz
expression
inquiry
null string
iname

13. I/O: The PL/SQL I/O packages (can/cannot) accept input directly from the keyboard.
3
END
DML
cannot

14. Fundamental: Maximum string length of a PL/SQL variable.
hardware
4
after insert on emps
32 -000

15. TCL: Undo changes back to savepoint ab.
rollback to ab
SQL
definer's
DATE '2005-12-25'

16. The default value of the AUTHID property.
INTO
1
1
DEFINER

17. A large OUT or IN OUT parameter will waste a lot of space and CPU if it is passed by _____.
can
value
binding
API

18. An INSTEAD OF trigger is used - e.g - when you want to insert into a complex _____.
view
machine code
cannot
RELIES_ON

19. An ordinary character literal is composed of characters in the ________ character set.
DEFINER
anonymous block
database
USING

20. Cursors: Opening keyword of a cursor FETCH loop.
30
anonymous
LOOP
3

21. Declare an unconstrained subtype of NUMBER called NUMB.
dynamic
suspended
cannot
SUBTYPE numb IS number;

22. Cursors: Statement to end a loop when MyCur is used up: _____ ______ MyCur%NOTFOUND.
EXIT WHEN
anonymous block
pls_integer
does not

23. Triggers: The clause to make a trigger run after inserting into table EMPS.
after insert on emps
define
server
open cv for

24. (from inside a package) Declare a function f - that takes a number n - returns a number - and caches results - depending on table EMPS.
enabled
function f (n number) return number result_cache relies_on (emps);
anonymous block
%TYPE

25. Packaged constants can synchronize programs through use in _______ directives.
selection
32 -000
composite
CURRENT_USER

26. Exceptions: Type ______ to re-raise the current exception.
EXIT WHEN
sequence pseudo-columns
RAISE
network

27. I/O: The DBMS_OUTPUT function that writes output WITH a newline character.
an autonomous routine
PUT_LINE
constructor
<> - != - ^=

28. Exceptions: If there is no handler for an exception - PL/SQL returns an ________ exception error to the invoker or host environment.
DBMS_CRYPTO
unhandled
subtype
PVM

29. Value of a character literal with zero characters.
fetch cv into myvar
FETCH

LOOP

30. Type: An ________ subtype has all the values of its base type.

unconstrained
v3 IN OUT NUMBER
CASE_NOT_FOUND

31. I/O: To make sure the DBMS_OUTPUT buffer will be flushed - put a WHEN ______ clause in the EXCEPTION section of your outer block.
OPEN
anonymous
external subprogram
OTHERS

32. A record is a group of related data items stored in fields - each with its own...
not a number
virtual machine
lowest
name and datatype

33. Characters that end a multi-line comment.
*/
does not
parameter
deletions

34. Fundamental: Which one of these is a simple symbol: a - = - !=
SQLPlus
DBMS_SESSION.RESET_PACKAGE
close C
=

35. An incomplete type only has a ____.
FETCH
TIMESTAMP.
name
currval and nextval

36. The three possible values of a BOOLEAN literal.
$IF
machine code
True - false or NULL.
dynamic

37. A type of compiler directive - begins with 'e'.
implicit
cursor c;
stored
error

38. The names of Java objects in Oracle can be up to __ characters in length.
4K
is not
FGA
OUT

39. How to reference a variable V declared in a block labelled L: ____.
cursor c RETURN rC;
memory
L.V
Ada

40. The Wrap utility (does / does not) encrypt source code.
a number := 10
exception handler
does not
memory

41. Cursors: A pointer to a cursor is called a ______ _______.
system global area
DBMS_PREPROCESSOR
cursor variable
variable

42. For an associative array - the FIRST method gets the (lowest / first-created) index.
SESSION_USER
lowest
EVERE - PERFORMANCE - INFORMATIONAL
TYPE tN IS TABLE of NUMBER

43. Fundamental: One of the 4 types of lexical units: c_____.
SQLPlus
NESTED TABLE myColl STORE AS myCollTab
label
comments

44. Term for a character literal with zero characters.
PRAGMA AUTONOMOUS_TRANSACTION;
VARCHAR2
placeholders
null string

45. The DEFINITION of a cursor is the part after the keyword __.
TRUE - FALSE - NULL
EXECUTE IMMEDIATE
pls_integer
IS

46. The lowest index of a nested table is ___.
sequence pseudo-columns
exception handler
1
is not

47. Set flag bb true: ALTER SESSION SET PLSQL_CCFLAGS= '____'
ROLLBACK
IN
literal
bb:true

48. To exit an active autonomous transaction without causing an exception - you must issue _____ or ______.
decimal
v1 OUT number default 10
# - $ - _
commit - rollback

49. Exceptions: Some internal exceptions have ________ names.
FOR - IN
GET_LINE
NEW
predefined

50. Unlike the CASE statement - the CASE expression does not have the...
Declaration
implicit CASE_NOT_FOUND exception
exit when cgo%NOTFOUND
SQL