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. Advantage: PL/SQL is tightly _______ with Oracle SQL.
integrated
EXCEPTION_INIT
ALTER SESSION
loop

2. Types: One of the scalar data types specific to PL/SQL: P________
cursor number
invalid
PLS_INTEGER
alter procedure

3. Cursors: The SQL%FOUND attribute has how many possible values?
3
boolean
STANDARD
..

4. Official acronym for PL/SQL's runtime engine.
EXIT WHEN
SIMPLE_INTEGER
PVM
r tRec := tRec(9 - 'Jones');

5. The DEFINITION of a cursor is the _____ that returns the records.
v3 IN OUT NUMBER
specification - body
..
query

6. Bulk: The implicit cursor attribute that gives the number of rows affected by each DML statement in a FORALL statement.
%BULK_ROWCOUNT
Declaration
SQL
anonymous block

7. The BETWEEN operator is (inclusive / exclusive).
inclusive
compilation
RETURN
same

8. Value of a character literal with zero characters.
close C

CHAR - VARCHAR2
Keywords and predefined names.

9. A collection is an ordered group of ________ - all of the same ____
nested
NUMBER
elements - type
literal

10. You can have many autonomous transactions in ___________.
UTL_FILE
.
an autonomous routine
static

11. A result-cached function caches its results in the _____ _____ ____ (SGA)
system global area
invoker's
v3 IN OUT NUMBER
3

12. Assignment of PLSQL_CCFLAGS (cannot / can) be included in ALTER PROCEDURE ... COMPILE ...
FOR i IN REVERSE 1..10 - LOOP - NULL; END LOOP;
unhandled
can
HTP

13. Nested tables are multisets - meaning that there is no inherent _____ of their elements.
include
order
an autonomous routine
DBMS_PIPE

14. DynSQL: Maximum string length to pass to EXECUTE IMMEDIATE.
wrap
associative
32 -000
pls_integer

15. I/O: To make sure the DBMS_OUTPUT buffer will be flushed - put a WHEN ______ clause in the EXCEPTION section of your outer block.
EXIT
$IF
for each row
OTHERS

16. Exceptions: A GOTO statement CAN branch from an exception handler into an ________ block.
enclosing
invoker's
BINARY_INTEGER
obfuscates

17. Triggers: An INSTEAD OF trigger (can/cannot) be conditional.
cannot
SESSION_USER
closed
PLS_INTEGER

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. With an sparse - integer-indexed associative array - you (can / cannot) use a regular FOR loop.
cannot
SQL
literals
DML

20. A null string and a BOOLEAN null are _______ (same/not the same).
REF_CURSOR
DML
aliases
not the same

21. A record is a group of related data items stored in fields - each with its own...
anonymous block
name and datatype
RECORDS
create procedure

22. Fundamental: A label can be used to name an ______ block.
manageable
anonymous
wrap
SQL cursor

23. The declaration section is (optional/mandatory).
optional
statement
:=
network

24. Cursors: An explicit cursor (can/cannot) accept parameters.
DBMS_OUTPUT
is
explicit
can

25. Delimiters: The association operator.
compiles
executable
=>
unqualified

26. The meaning of 'FGA'.
DATE
TRUE - FALSE - NULL
fine-grained auditing
explicit

27. DynSQL: The standard package that does dynamic SQL.
DBMS_SQL
static boolean
# - $ - _
always

28. If an initialized collection has no elements - FIRST and LAST return _____.
exception handler

specification - body
after

29. Characters that end a multi-line comment.
*/
-
INSTEAD OF
create

30. The PL/SQL virtual machine turns bytecode into system ______.
calls
SQLERRM
colon
non-editioning views

31. When a session starts - CURRENT_SCHEMA has the value of the schema owned by ___________.
%FOUND - %ISOPEN - %NOTFOUND - %ROWCOUNT
FOR UPDATE
SESSION_USER
TRUE - FALSE - NULL

32. I/O: One of the 3 types of data stored in the DBMS_OUTPUT buffer.
commit - rollback
optional
REF CURSOR
NUMBER

33. Triggers: When using the NEW or OLD pseudo-records in the body of the trigger - they must be prefixed with a _______.
colon
UTL_HTTP
SQL
invoker's

34. The method to add one or more elements to a nested table or VARRAY is ______.
FETCH - BULK COLLECT INTO
EXTEND
commit - rollback
view

35. DynSQL: The clause that receives single-row query output from EXECUTE IMMEDIATE.
searched
names
INTO
expression

36. Collections are one of the two kinds of PL/SQL _______ data types.
suspended
composite
slower
external subprogram

37. IDs: You can use a reserved word as a _______ user-defined identifier.
quoted
RAISE
v1 OUT number default 10
definer's

38. Give the first line of the FOR loop with index i going from 1 to 10 in reverse.
bytecode
1
FOR i IN REVERSE 1..10 LOOP
PUT_LINE

39. DynSQL: The three modes of arguments in the USING clause of EXECUTE IMMEDIATE.
searched
composite
IN - OUT - IN OUT
for update of

40. True encryption is done with package __________.
EXECUTE
lowest
compilation
DBMS_CRYPTO

41. Triggers: On a non-editioning view - you can only define __________ triggers.
INSTEAD OF
WHEN
RECORDS
REF_CURSOR

42. The values defined in PLSQL_CCFLAGS can be referenced as _____ directives.
FETCH
order
inquiry
implicit

43. Cursors: If an exception is raised inside a cursor loop - the cursor (is / is not) also closed automatically.
is
;
inquiry
open cv for

44. A PL/SQL block that is not stored.
anonymous block
close C
...
%BULK_ROWCOUNT

45. What are two categories of SQL functions that cannot be used in procedural statements?
aggregate - analytical
finishes
1
package

46. In Native Mode - PL/SQL code is compiled into ______ ______.
FETCH
cursor
cannot
machine code

47. Cursors: A cursor FOR loop can use an explicit or an _______ cursor.
.
enclosing
end
implicit

48. DynSQL: The clause that supplies bind arguments to EXECUTE IMMEDIATE.
USING
REUSE SETTINGS
STANDARD
DBMS_OUTPUT

49. A value that is neither represented by an identifier nor calculated from other values.
255
CURRENT OF
compiles
literal

50. Cursors: A session cursor that is automatically created and managed by PL/SQL.
bind
TYPE rec IS RECORD (num NUMBER - name VARCHAR2(10));
implicit cursor
ex := tbl1 MULTISET EXCEPT tbl2