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. The AUTHID property applies to PL/SQL objects that contain _____.
package
invalid
GET_LINES
code

2. I/O: The DBMS_OUTPUT buffer will not be flushed until it is full or until the current PL/SQL block _________.
Keywords and predefined names.
RETURN
-
finishes

3. The FORALL statement to loop over a collection MyList using index i.
nested
mandatory
Wrap
FORALL i IN MyList.FIRST..MyList.LAST

4. IDs: The two types of words that can - but should not - be used as user-defined identifiers.
implicit CASE_NOT_FOUND exception
executable
Keywords and predefined names.
SIMPLE_INTEGER

5. You can put a label before any executable PL/SQL _________.
statement
EXIT
fetch cv into myvar
specification - body

6. Nested tables can become sparse via ______.
OPEN_CURSOR
deletions
error code
expression

7. TCL: Undo changes back to savepoint ab.
SUBTYPE n IS number not null;
2
rollback to ab
INTO

8. I/O: This package lets PL/SQL programs read and write OS files.
explicit
slower
STANDARD
UTL_FILE

9. IDs: Maximum number of bytes in a user-defined identifier.
30
v3 IN OUT NUMBER
lock
package

10. The meaning of 'FGA'.
fine-grained auditing
never
oname
delimiters

11. Advantage: PL/SQL programs are stored centrally - making them more ______.
TYPE tV IS VARRAY(100) OF NUMBER
FETCH
manageable
ex := tbl1 MULTISET EXCEPT tbl2

12. Cursors: The second keyword of a FETCH statement.
LOOP - END LOOP
a number := 10
name and datatype
INTO

13. If a procedure fails - an OUT parameter passed to it by value (will / will not) be passed back with changes.
FOR i IN REVERSE 1..10 LOOP
will not
concatenation
NDS

14. Advantage: PL/SQL supports ______-oriented programming.
set serveroutput on
object
5
SQL

15. Pkgs: The _______ package gives access to such SQL things as ALTER SESSION.
enabled
inquiry
current
DBMS_SESSION

16. For a collection - the NEXT method gets the next higher (element / index).
autonomous triggers
LOOP
index
unconstrained

17. By default - an IN parameter is passed by ______.
expression
reference
Declaration
names

18. Command to assign to variables from a cursor.
include
boolean
composite
FETCH

19. Records are one of the two kinds of PL/SQL _______ data types.
<<>>
'ENABLE:SEVERE' - 'ERROR:06002'
composite
inquiry

20. Advantage: PL/SQL gives SCALABILITY because stored procedures are executed on the _______.
exception handler
server
1
reference

21. Types: A ______ has the same valid operations as its base type.
END IF
subtype
statically
server

22. The values defined in PLSQL_CCFLAGS can be referenced as _____ directives.
PRAGMA EXCEPTION_INIT (E - -1);
anonymous
ALTER SESSION
inquiry

23. Exceptions: Each internal exception has an Oracle ______ _______.
bb:true
PSP
error code
before insert or update on emps

24. With an sparse - integer-indexed associative array - you (can / cannot) use a regular FOR loop.
bb:true
cannot
DML
production

25. DynSQL: Maximum string length to pass to EXECUTE IMMEDIATE.
END IF
enclosing
TOO_MANY_ROWS
32 -000

26. Exceptions: An exception in the declarations section propagates to the enclosing _______.
PSP
cannot
INTO
block

27. Cursors: A cursor variable's type must be a ____ ______ type.
REF CURSOR
disable
name-value
EDITION_NAME

28. I/O: The buffered output of dbms_output.put_line is retrieved by _______.
SQLPlus
%BULK_ROWCOUNT
code
unqualified

29. Static typing is also called _____ typing.
CURRENT_USER - DEFINER
bb:true
index
strong

30. Cursors: The four cursor attributes - in alphabetical order.
simple and compound symbols
SQL
PL/SQL Gateway
%FOUND - %ISOPEN - %NOTFOUND - %ROWCOUNT

31. The three types of compiler warnings.
.
versions
type T is ref cursor
EVERE - PERFORMANCE - INFORMATIONAL

32. The RESULT_CACHE clause has to be in both the declaration and in the ______ of the function.
definition
USER_PROCEDURES
integrated
<<>>

33. Dbms_sql: The integer returned by OPEN_CURSOR is a _____ _____.
stored
512
index
cursor number

34. Cursors: SYS_REFCURSOR is a predefined type based on _____ ______.
autonomous transaction
PLSQL_OPTIMIZE_LEVEL
REF CURSOR
stored

35. The FOR UPDATE OF clause references a (table / column).
EXECUTE
upper - coalesce
column
never

36. Web: mod_plsql is an _______ module.
literals
IF - CASE or LOOP
iname
Apache

37. Types: One of the 4 PL/SQL things that have a data type (begins with 'p').
REF CURSOR
parameter
calls
EXIT

38. Delimiters: Host variable indicator.
...
exception handler
PLSQL_OPTIMIZE_LEVEL
literals

39. Mode designation for an output parameter.
TIMESTAMP.
FOR UPDATE
OUT
value

40. PL/SQL lets you define two kinds of composite data types: _______ and _______
DBMS_DDL
=>
SQL cursor
collections - records

41. Cursors: If you use an EXIT statement to exit a cursor FOR loop prematurely - the cursor (is / is not) closed automatically.
is
bb:true
FETCH
select

42. The DECLARE keyword is only required in an _______ _______.
USER_PROCEDURES
anonymous block
DEFINER
LOOP - END LOOP

43. In Native Mode - PL/SQL code is compiled into ______ ______.
FORALL and BULK COLLECT
PVM
machine code
cursor number

44. The PL/SQL virtual machine turns bytecode into system ______.
INSTEAD OF
vname CONSTANT VARCHAR2 := 'x';
Abstract
calls

45. Name the two types of FOR loop.
numeric and cursor
USER_PROCEDURES
Server Pages
implicit

46. DynSQL: The clause that receives single-row query output from EXECUTE IMMEDIATE.
REF CURSOR
SIMPLE_INTEGER
INTO
cached

47. Web: PL/SQL ______ ______ (PSPs) let you develop web pages with dynamic content.
FETCH
is certain
rollback to ab
Server Pages

48. Cursors: A session cursor that a PL/SQL user creates and manages.
hardware
UTL_FILE
explicit cursor
non-editioning views

49. Fundamental: One of the 4 types of lexical units: L_____
...
cannot
literals
database

50. Cursors: If an exception is raised inside a cursor loop - the cursor (is / is not) also closed automatically.
GET_LINE
%ROWTYPE
is
-