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 inquiry directive that gives the current line number in the procedure.
$$PLSQL_LINE
TYPE tA IS TABLE OF NUMBER INDEX BY VARCHAR2(20)
EXIT WHEN
REF CURSOR

2. Types: Which type of arithmetic does PLS_INTEGER use - library or hardware?
hardware
WHEN
*/
a number := 10

3. A user-defined TYPE can have...
Declaration
can
an AUTHID property
reference

4. When a session starts - CURRENT_SCHEMA has the value of the schema owned by ___________.
simple and compound symbols
REUSE SETTINGS
SESSION_USER
INTO

5. A FOR loop can be indexed by numbers or by a ______.
package
-
cursor
single-line

6. The attribute used to get the type of a column or variable without knowing what it is.
once
is not
inquiry
%TYPE

7. Set flag bb true: ALTER SESSION SET PLSQL_CCFLAGS= '____'
native dynamic
bb:true
sequence pseudo-columns
r tRec := tRec(9 - 'Jones');

8. I/O: The DBMS_OUTPUT function that writes output without a newline character.
cannot
30
5
PUT

9. The FORALL statement to loop over a collection MyList using index i.
cannot
FORALL i IN MyList.FIRST..MyList.LAST
fields
EXECUTE IMMEDIATE

10. Triggers: In a per-row trigger - the ____ record shows you the original state of an affected row.
OUT
OLD
do not
PUT_LINE

11. Types: The storage size of a NUMBER value is based on the number of ______ digits.
FETCH - BULK COLLECT INTO
significant
anonymous
array

12. Exceptions: An exception in the declarations section does not go to the __________ section.
exception
mandatory
2
SQL

13. Triggers and views always have _________ rights.

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

14. Define a record variable r - of type tRec - initialized with values 9 and 'Jones' in its two fields.

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

15. The collection method that tells the number of elements in the collection.
COUNT
ex := tbl1 MULTISET EXCEPT tbl2
create
current

16. Records are one of the two kinds of PL/SQL _______ data types.
Ordinary - Quoted.
static boolean
composite
DBMS_DDL

17. INSTEAD OF triggers are alternatives to ___ triggers
name-value
memory
inquiry
DML

18. DynSQL: The clause that receives single-row query output from EXECUTE IMMEDIATE.
can
FALSE
significant
INTO

19. 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

20. If a result-cached function's data source (based on the RELIES_ON clause) is updated - any cached results become _______.
does not
1 million
invalid
SESSION_USER

21. Declare an output NUMBER parameter - v1 - that defaults to 10.
can
invoker's
elements
v1 OUT number default 10

22. Bulk: The keywords of a bulk collect FETCH statement.
composite
REF CURSOR
..
FETCH - BULK COLLECT INTO

23. A null string and a BOOLEAN null are _______ (same/not the same).
constant
SQL
PUT_LINE
not the same

24. Types: The only PL/SQL type for which you can specify a range constraint.
PLS_INTEGER
for each row
end
slower

25. The SET TRANSACTION statement affects only the ____________.
EXIT
Keywords and predefined names.
current transaction
p.v

26. Default value of PLSQL_OPTIMIZE_LEVEL.
2
optional
disable
PLSQL_OPTIMIZE_LEVEL

27. Types: The predefined subtype of PLS_INTEGER that has the NOT NULL constraint.
virtual machine
IN OUT
collections
SIMPLE_INTEGER

28. %ROWTYPE gets the type of a table or _______.
is not
autonomous transaction
EXTEND
cursor

29. Advantage: PL/SQL runs anywhere Oracle runs - so it is very ________.
portable
associative
fetch C into V
upper - coalesce

30. Exceptions: The keyword that begins an exception handler.
dynamic
WHEN
=
raise_application_error(-20 -100 - 'Bad');

31. Exceptions: A GOTO statement CAN branch from an exception handler into an ________ block.
fail
EXIT
1
enclosing

32. With an sparse - integer-indexed associative array - you (can / cannot) use a regular FOR loop.
null string
PUT_LINE
composite
cannot

33. The NOCOPY option on an OUT or IN OUT parameter - causes it to be passed by ______.
identifiers
reference
searched
run

34. Conversion: It is best to use (implicit / explicit) conversion.
explicit
ALTER SESSION
3
unhandled

35. Types: PL/SQL has all the _____ data types.
Ordinary - Quoted.
SQL
expression
.

36. Type: A __________ subtype has only a subset of the values of its base type.
name
scalar
constrained
RAISE

37. Abbreviation of invoker's rights
IR
DATE
...
rollback to ab

38. This is a CASE (expression / statement): myvar := CASE num WHEN 1 THEN 'good' WHEN 2 THEN 'bad' END;
fetch C into V
expression
user-defined
anonymous

39. Triggers: In a DML trigger - the phrase that makes the trigger run for every affected record.
for each row
exception handler
rollback to ab
never

40. Kind of comment not to put in a PL/SQL block to be processed dynamically by an Oracle Precompiler program.
single-line
for update of
ALTER SESSION
$$

41. A type of compiler directive - begins with 'i'.
inquiry
elements - type
placeholders
4K

42. Delimiters: The association operator.
=>
define
database
STANDARD

43. IDs: You cannot use reserved words as ______ user-defined identifiers.
SESSION_USER
cannot
ordinary
collections

44. CREATE TYPE cannot be used for _______ array types.
bytecode
associative
DBMS_SQL
EXECUTE IMMEDIATE

45. For an associative array - the FIRST method gets the (lowest / first-created) index.
code
lowest
DML
invoker's

46. ______ SQL is a PL/SQL feature that allows SQL syntax directly in a PL/SQL statement.
Web Toolkit
<<
unconstrained
static

47. A GOTO cannot branch into an...
EXTEND
IF - CASE or LOOP
$END
external subprogram

48. Nested tables can become sparse via ______.
explicit
deletions
..
definition

49. Cursors: Give the first 3 words to open a cursor variable called cv.
PLS_INTEGER
open cv for
DML
finishes

50. DynSQL: The clause that supplies bind arguments to EXECUTE IMMEDIATE.
USING
EXIT
composite
CASE_NOT_FOUND