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. You (can/cannot) put a label before an END LOOP statement.
SQL
Apache
PUT_LINE
cannot

2. Cursors: The value of SQL%ISOPEN is always ______.
FALSE
timing
Declaration
%BULK_ROWCOUNT

3. PL/SQL does not automatically create bind variables in ________ SQL.
specification - body
dynamic
PRAGMA AUTONOMOUS_TRANSACTION;
define

4. Cursors: If an exception is raised inside a cursor loop - the cursor (is / is not) also closed automatically.
for each row
is
cursor variable
FORALL and BULK COLLECT

5. What is the simplest statement for getting out of simple loop?
.
EXIT
..
UTL_FILE

6. Triggers: An INSTEAD OF trigger is (always/never) a row-level trigger.
PLS_INTEGER
USER_PROCEDURES
can
always

7. $$PLSQL_LINE and $$PLSQL_UNIT are ______-ly defined inquiry directives.
open cv for
..
invoker's
implicit

8. IDs: You can use a reserved word as a _______ user-defined identifier.
include
quoted
autonomous triggers
DML

9. Which collection type is bounded?
1
anonymous block
varray
virtual machine

10. Triggers: The code in a trigger is actually an ________ block.
anonymous
not the same
Ada
-20 -000

11. The BEGIN section is (optional/mandatory)
mandatory
timing
integer
block

12. Cursors: Give the statement for getting out of a FETCH loop for cursor CV.
dynamic
fetch C into V
r t.%ROWTYPE;
EXIT WHEN cv%NOTFOUND

13. Triggers: On a non-editioning view - you can only define __________ triggers.
INSTEAD OF
cursor c;
CREATE TRIGGER
cannot

14. Abbreviation of definer's rights
selection
invalid
EXCEPTION_INIT
DR

15. Native compilation turns bytecode into ________ code.
machine
can
package
E Exception;

16. Cursors: You cannot use cursor attributes in _______ statements.
SQL
inquiry
DBMS_DDL
will not

17. The 2 characters that begin all inquiry directives.
exception
GET_LINES
name
$$

18. You cannot bulk collect into an ARRAY OF RECORDS. You can into a ________________ (3 words).
DBMS_SQL
FOR - IN
RECORD OF ARRAYS
bytecode

19. The RESULT_CACHE clause comes (before / after) the RETURN clause.
after
EXIT WHEN
TOO_MANY_ROWS
define

20. A PL/SQL extension to the WHERE clause of the SQL statements UPDATE and DELETE
cursor c;
virtual machine
WHERE CURRENT OF
%

21. Delimiters: The component indicator/selector.
CURRENT_USER - DEFINER
END CASE
CHAR - VARCHAR2
.

22. GOTO branches to a ________.
label
transaction
$IF
RECORDS

23. Delimiters: Host variable indicator.
...
cursor
hardware
elsif

24. IDs: You cannot use reserved words as ______ user-defined identifiers.
fail
ordinary
CLOSE
PL/SQL Gateway

25. _________ exceptions can not be trapped with an error handler
dynamic
Declaration
SESSION_USER
searched

26. Exceptions: A GOTO statement cannot branch into an _______ ________.
exception handler
PLS_INTEGER
do not
GET_LINE

27. Cursors: If you use an EXIT statement to exit a cursor FOR loop prematurely - the cursor (is / is not) closed automatically.
REF CURSOR
is
HTP
CHARARR

28. I/O: The DBMS_OUTPUT function that writes output without a newline character.
PUT
WHERE CURRENT OF
FETCH - INTO
index

29. In a collection - the internal components are called _______.
oname
Apache
elements
can

30. Fundamental: Character used to escape a single quote inside a literal.

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

31. Cursors: A session cursor that is automatically created and managed by PL/SQL.
PUT_LINE
inquiry
implicit cursor
cannot

32. Triggers: If two or more triggers are defined with the same timing point - then you can control the firing order using the ________ clause.
USING
follows
current BEGIN-END block
upper - coalesce

33. I/O: The DBMS_OUTPUT function that writes output WITH a newline character.
cursor c RETURN rC;
obfuscates
PUT_LINE
%BULK_ROWCOUNT

34. Triggers: In a per-row trigger - the ____ record shows you the changed state of an affected row.
DBMS_OUTPUT
NEW
FETCH - INTO
base

35. Conversion: Implicit conversion can be (faster / slower) than explicit conversion.
explicit
WHEN OTHERS THEN
EVERE - PERFORMANCE - INFORMATIONAL
slower

36. Delimiters: Item separator.
NUMBER

FETCH
cannot

37. I/O: The PL/SQL I/O packages (can/cannot) accept input directly from the keyboard.
WHERE CURRENT OF
versions
cursor
cannot

38. NAN stands for _________.
not a number
;
IN - OUT - IN OUT
plb

39. An anonymous block is a(n) ____ statement.
SQL
sequence pseudo-columns
explicit
optional

40. Bulk: The two features that comprise Bulk SQL are:
SQL
executable
propagates
FORALL and BULK COLLECT

41. DynSQL: The colon-prefixed names used in EXECUTE IMMEDIATE are called ________.
an AUTHID property
after insert on emps
bind
placeholders

42. Exceptions: Type ______ to re-raise the current exception.
E Exception;
END
RAISE
-

43. Exceptions: The keyword that begins an exception handler.
same
v2 IN NUMBER default 20
Abstract
WHEN

44. (from inside a package) Declare a function f - that takes a number n - returns a number - and caches results - depending on table EMPS.
Ordinary - Quoted.
do not
integer
function f (n number) return number result_cache relies_on (emps);

45. Pkgs: RESET_PACKAGE only takes effect after the outermost PL/SQL proc that called it ________.
finishes
TRUE - FALSE - NULL
DBMS_OUTPUT
definition

46. Web: Abbreviation of PL/SQL Server Page.
PSP
label
cannot
unqualified

47. Cursors: What are the 3 possible values of SQL%FOUND and SQL%NOTFOUND?
UTL_HTTP
collections - records
VARCHAR2
TRUE - FALSE - NULL

48. The three types of compiler warnings.
cursor c;
an AUTHID property
v1 OUT number default 10
EVERE - PERFORMANCE - INFORMATIONAL

49. Advantage: Having procedures stored and executed on the server makes PL/SQL ________.
specification - body
scalable
executable
SQLCODE

50. How many PL/SQL collection types are there?
commit - rollback
3
autonomous transaction
REF CURSOR