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. To enable result-caching for a function - use the _____________ clause.
REF CURSOR
32 -000
RESULT_CACHE
timing

2. Exceptions: Some internal exceptions have ________ names.
cursor
boolean
NDS
predefined

3. Types: One of the 4 PL/SQL things that have a data type (begins with 'v').
DML
variable
same
%FOUND - %ISOPEN - %NOTFOUND - %ROWCOUNT

4. PL/SQL does not automatically create bind variables in ________ SQL.
dynamic
CURRENT OF
FETCH
IN

5. Bytecode is _______ _______ code.
DATE '2005-12-25'
virtual machine
specification - body
CREATE TYPE

6. Delimiters: the attribute indicator.
composite
FORALL and BULK COLLECT
%
USER_PROCEDURES

7. DynSQL: Maximum string length to pass to EXECUTE IMMEDIATE.
cannot
=
USING
32 -000

8. Fundamental: One of the 4 types of lexical units: c_____.
$END
context
$IF
comments

9. Dbms_sql: The DBMS_SQL procedure that closes a cursor.
CLOSE_CURSOR
EXIT
an autonomous routine
hardware

10. Cursors: WHERE _______ ______ makes an UPDATE or DELETE apply to the current row of a cursor.
unqualified
return value
$END
CURRENT OF

11. VARRAYs are (always / never) sparse.
commit - rollback
do not
never
512

12. Types: One of the 4 PL/SQL things that have a data type (begins with 'c').
SQLCODE
associative
constant
FGA

13. The two kinds of CASE statements are simple and ________.
DML
composite
stored
searched

14. Cursors: How many DML statements can a FORALL statement contain?
implicit CASE_NOT_FOUND exception
INTO
1
DATE

15. Cursors: The value of SQL%ISOPEN is always ______.
boolean
FALSE
hardware
Apache

16. Exceptions: Start of the range of error codes for RAISE_APPLICATION_ERROR.
DEFINER
rollback to ab
index
-20 -000

17. The FOR UPDATE OF clause references a (table / column).
statement
suspended
cannot
column

18. A unit with AUTHID = CURRENT_USER is an ________ rights unit.

Warning: Invalid argument supplied for foreach() in /var/www/html/basicversity.com/show_quiz.php on line 183

19. Triggers: You (can/cannot) explicitly invoke a trigger.
cannot
-20 -000
PLS_INTEGER
include

20. Language that PL/SQL is derived from.
savepoint ab
Ada
DECLARE - BEGIN - EXCEPTION - END
varray

21. The command used to populate PLSQL_CCFLAGS.
ALTER SESSION
TYPE rec IS RECORD (num NUMBER - name VARCHAR2(10));
error
multi-row

22. A GOTO statement can branch from an exception handler into...
DBMS_SQL
an enclosing block
timing
CHAR - VARCHAR2

23. Conditional compilation is useful for compiling a program under different ______ of Oracle.
dense
-20 -000
compilation
versions

24. Wrap iname=xxxx _____=zzzzz
oname
stored
RETURN
PLS_INTEGER

25. A (simple / searched) CASE statement begins with CASE <expression>.
implicit cursor
CLOSE
1
simple

26. Fundamental: identifiers (include/do not include) reserved words.
CURSOR - RETURN - IS
include
DML
source

27. PLSQL_CCFLAGS hold a comma-separated list of ______ pairs (hyphenated).
FORALL i IN MyList.FIRST..MyList.LAST
SESSION_USER
name-value
unhandled

28. By default - an IN parameter is passed by ______.
reference
SESSION_USER
VARRAYs
information that changes infrequently

29. The values defined in PLSQL_CCFLAGS can be referenced as _____ directives.
inquiry
NDS
REUSE SETTINGS
%FOUND - %ISOPEN - %NOTFOUND - %ROWCOUNT

30. Cursors: The four cursor attributes - in alphabetical order.
%FOUND - %ISOPEN - %NOTFOUND - %ROWCOUNT
Reserved words.
PLSQL_OPTIMIZE_LEVEL
an AUTHID property

31. Cursors: The SQL%FOUND attribute has how many possible values?
3
alter procedure
cursor
EXECUTE

32. Cursors: A cursor variable's type must be a ____ ______ type.
exit when cgo%NOTFOUND
32 -000
REF CURSOR
associative arrays

33. Bulk: The keywords of a bulk collect FETCH statement.
PUT
PLS_INTEGER
cannot
FETCH - BULK COLLECT INTO

34. Fundamental: Which one of these is a simple symbol: a - = - !=
REF CURSOR
=
explicit cursor
TYPE tN IS TABLE of NUMBER

35. Exceptions: Type ______ to re-raise the current exception.
WHEN OTHERS THEN
VARRAYs
RAISE
RETURN

36. I/O: The output from DBMS_OUTPUT will display (during/after) program execution.
aggregate - analytical
SQLERRM
TYPE tA IS TABLE OF NUMBER INDEX BY VARCHAR2(20)
after

37. A value that is neither represented by an identifier nor calculated from other values.
SYS_CONTEXT
plb
literal
elsif

38. Cursors: A cursor that lives in session memory until the session ends.
session cursor
CHAR - VARCHAR2
FETCH
Gateway

39. You cannot bulk collect into an ARRAY OF ________.
static boolean
OPEN
RETURN
RECORDS

40. A pointer to a private SQL area that stores information about processing a specific SELECT or DML statement.
Wrap
follows
cursor
PRAGMA EXCEPTION_INIT (E - -1);

41. Delimiters: The component indicator/selector.
fine-grained auditing
.
COUNT
CURRENT OF

42. Cursors: What implicit cursor attribute gives row counts for a FORALL statement?
DML
error code
same arguments
%BULK_ROWCOUNT

43. I/O: This package has hypertext procedures that generate HTML tags
HTP
never
cannot
lower sub-block

44. Command to delete a procedure.
1
inquiry
drop procedure
bind arguments

45. You have to use _______ SQL to run DDL statements n PL/SQL.
FOR i IN REVERSE 1..10 LOOP
anonymous block
comments
dynamic

46. Cursors: The statement where you pass the parameters to a cursor.
OPEN
integer
index
SQLCODE

47. This is a CASE (expression / statement): CASE num WHEN 1 THEN goto LABEL1 WHEN 2 THEN var := 2 END CASE;
512
statement
associative
RETURN

48. The three sorts of date/time types are DATE - INTERVAL and _________.
procedure P AUTHID definer;
TIMESTAMP.
DBMS_PIPE
<<>>

49. Delimiters: The association operator.
is
FETCH
same
=>

50. Advantage: PL/SQL gives SCALABILITY because stored procedures are executed on the _______.
server
v1 OUT number default 10
FOR UPDATE
SYS_CONTEXT