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. Types: The only PL/SQL type for which you can specify a range constraint.
PLS_INTEGER
DBMS_OUTPUT
transaction
can

2. Exceptions: When an exception is raised inside a cursor FOR loop - the cursor is _______ implicitly.
open cv for
%TYPE
significant
closed

3. The meaning of 'FGA'.
fine-grained auditing
-
1
alter procedure

4. Native compilation turns bytecode into ________ code.
machine
enabled
same
definer's

5. To exit an active autonomous transaction without causing an exception - you must issue _____ or ______.
identifiers
commit - rollback
not a number
decimal

6. An $ERROR directive ends with _____.
/*
CASE_NOT_FOUND
$END
definer's

7. An editioning view is like an ____ for a table.
DBMS_PREPROCESSOR
timing
OLD
API

8. $$PLSQL_LINE and $$PLSQL_UNIT are ______-ly defined inquiry directives.
delimiters
implicit
function f (n number) return number result_cache relies_on (emps);
IS

9. Exceptions: Pragma that links an exception to an Oracle error code.
currval and nextval
composite
EXCEPTION_INIT
..

10. Parameter that controls how much Oracle optimizes your PL/SQL code on compilation.
ENABLE
PLSQL_OPTIMIZE_LEVEL
upper - coalesce
RECORD OF ARRAYS

11. Cursors: Give the statement to open cursor C that takes parameter p.
SESSION_USER
fields
SQLCODE
open C(p)

12. I/O: The DBMS_OUTPUT procedure that sets the size of the output buffer.
bind
unhandled
ENABLE
TOO_MANY_ROWS

13. Bulk: The two features that comprise Bulk SQL are:
END
COMMIT - ROLLBACK - SAVEPOINT - SET TRANSACTION
FORALL and BULK COLLECT
view

14. You (can / cannot) wrap trigger source code.
%FOUND - %ISOPEN - %NOTFOUND - %ROWCOUNT
commit - rollback
integrated
cannot

15. I/O: This DBMS_OUTPUT proc retrieves one line from the buffer.
GET_LINE
elements - type
alter procedure
specification - body

16. Declare a variable r whose type is that of the records in table t.
r t.%ROWTYPE;
TYPE tA IS TABLE OF NUMBER INDEX BY VARCHAR2(20)
PVM
IR

17. An anonymous block always has _________ rights.

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

18. Define a record type REC with number num and varchar2(10) name.
END CASE
TYPE rec IS RECORD (num NUMBER - name VARCHAR2(10));
non-editioning views
INTO

19. Dbms_sql: The DBMS_SQL procedure that closes a cursor.
CLOSE_CURSOR
IN
for each row
composite

20. Types: One of the 4 PL/SQL things that have a data type (begins with 'v').
compile
variable
SQL
end

21. Cursors: The keyword that makes a ref cursor type STRONG.
RETURN
dynamic
TYPE tA IS TABLE OF NUMBER INDEX BY VARCHAR2(20)
calls

22. For an associative array - the FIRST method gets the (lowest / first-created) index.
lowest
strong
versions
significant

23. In a record - the internal components are called ______.
query
$END
DML
fields

24. Declare an unconstrained subtype of NUMBER called NUMB.
WHEN
cached
SUBTYPE numb IS number;
1

25. IDs: You (can/cannot) use keywords as ordinary user-defined identifiers.

obfuscates
alter procedure
can

26. PL/SQL is a ________ typed programming language.
PUT
statically
PLS_INTEGER
server

27. _______ arrays can be sparse or dense - depending on how you fill them.
associative
cannot
can
E Exception;

28. What word is in a function header but not in a procedure header?
cannot
With a letter.
RETURN
after

29. Bulk: The keywords of a bulk collect FETCH statement.
FETCH - BULK COLLECT INTO
FETCH - INTO
execute
1

30. The EXTEND method is not used with ______ _______.
TYPE rec IS RECORD (num NUMBER - name VARCHAR2(10));
associative arrays
for each row
DBMS_PIPE

31. The SET TRANSACTION statement affects only the ____________.
current transaction
system global area
OPEN
varray

32. The RESULT_CACHE clause comes (before / after) the RETURN clause.
virtual machine
SQLCODE
concatenation
after

33. Triggers: In a per-row trigger - the ____ record shows you the changed state of an affected row.
NEW
associative
PLS_INTEGER
an enclosing block

34. With a result-cached function - it uses a cached value when the function is called again with the...
is certain
external subprogram
REUSE SETTINGS
same arguments

35. A FOR loop can be indexed by numbers or by a ______.
compile
cursor
open C(p)
v1 OUT number default 10

36. Delimiters: the attribute indicator.
*/
%
$$PLSQL_LINE
$END

37. Fundamental: Which one of these is a compound symbol: = - :=
bytecode
cached
exception handler
:=

38. What are the two sequence pseudo-columns?
expression
bind
currval and nextval
base

39. The variable showing the user id of the session owner.
rollback to ab
calls
dynamic
SESSION_USER

40. Value of a character literal with zero characters.
expression

%ROWTYPE
in the database

41. An autonomous program runs in its own __________.
transaction
ENABLE
SYS_REFCURSOR
TIMESTAMP.

42. A (simple / searched) CASE statement begins with CASE <expression>.
for each row
simple
comments
enclosing

43. Cursors: The values plugged into the DML in a FORALL must come from existing - populated _________.
collections
bytecode
does not
True

44. The RESULT_CACHE clause has to be in both the declaration and in the ______ of the function.
definition
boolean
error code
:=

45. The three possible values of a BOOLEAN literal.
32 -000
True - false or NULL.
CREATE TRIGGER
512

46. The BETWEEN operator is (inclusive / exclusive).
inclusive
constant
after
can

47. The PL/SQL ________ evaluates compiler directives.
preprocessor
delimiters
STANDARD
compilation

48. An INSTEAD OF trigger specifies what to do instead of a ___ statement.
DML
PUT_LINE
selection
PLS_INTEGER

49. Cursors: The FOR UPDATE phrase goes at the (beginning/end) of the cursor definition.
inquiry
context
GET_LINE
end

50. True encryption is done with package __________.
PLSQL_OPTIMIZE_LEVEL
RELIES_ON
DBMS_CRYPTO
unconstrained