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. Exceptions: An unhandled exception ________ to the enclosing block.
ALTER SESSION
propagates
DML
IN OUT

2. PLS_INTEGER has its arithmetic implemented in ________ - so it is very fast.
bytecode
create procedure
nested
hardware

3. An INSTEAD OF trigger is used - e.g - when you want to insert into a complex _____.
view
UTL_HTTP
implicit cursor
can

4. Types: A data type family consists of a ______ type and its subtypes.
open cv for
base
FOR i IN REVERSE 1..10 LOOP
LOOP

5. What do you FETCH from?
# - $ - _
a cursor
STANDARD
memory

6. Set flag bb true: ALTER SESSION SET PLSQL_CCFLAGS= '____'
composite
can
$$
bb:true

7. The four keywords that define a PL/SQL block.
DECLARE - BEGIN - EXCEPTION - END
cannot
IN OUT
cannot

8. Clause added to a cursor to use it with WHERE CURRENT OF.
library
OTHERS
for update of
collections

9. Type: A __________ subtype has only a subset of the values of its base type.
Ada
cannot
constrained
not a number

10. Kind of datatypes that support object-oriented programming in PL/SQL.
Abstract
elements
SESSION_USER
current transaction

11. Triggers: INSTEAD OF triggers only run on ______ views.
binding
non-editioning views
Gateway
optional

12. Exceptions: Declare an exception called E.
E Exception;
predefined
-
PLS_INTEGER

13. Delimiters: Statement terminator.
1
STANDARD
exception
;

14. Which collection type is bounded?
statement
TYPE rec IS RECORD (num NUMBER - name VARCHAR2(10));
constrained
varray

15. Exceptions: A GOTO statement cannot branch into an _______ ________.
fields
current transaction
exception handler
inquiry

16. The allowed data types of user-defined conditional compilation directives are boolean and _______.
END
CLOSE
specification - body
pls_integer

17. 5 types of events that can have triggers: DML - DDL - INSTEAD OFs - database events - and ________ statements.
cannot
versions
static
suspended

18. To use a TYPE declared in the database - a PL/SQL block has to have _______ privilege on the type.
error
varray
:=
select

19. Cursors: The SQL%FOUND attribute has how many possible values?
an enclosing block
p.v
With a letter.
3

20. The FOR UPDATE OF clause references a (table / column).
autonomous triggers
upper - coalesce
column
SQL

21. If an initialized collection has no elements - FIRST and LAST return _____.
exit when cgo%NOTFOUND
is

TYPE rec IS RECORD (num NUMBER - name VARCHAR2(10));

22. Cursors: The values plugged into the DML in a FORALL must come from existing - populated _________.
END
DATE
versions
collections

23. Triggers: A compound trigger can fire at more than one ______ point.
preprocessor
UTL_FILE
query
timing

24. Keyword for doing assignment to a variable with SELECT.
v3 IN OUT NUMBER
non-editioning views
1
INTO

25. Triggers: Unlike a stored procedure - you can enable and _____ a trigger.
disable
True
RECORD OF ARRAYS
OLD

26. Triggers: An INSTEAD OF trigger (can/cannot) be conditional.
compilation
OPEN_CURSOR
cannot
implicit CASE_NOT_FOUND exception

27. _______ arrays can be sparse or dense - depending on how you fill them.
commit - rollback
same
end
associative

28. Cursors: Closing keywords of a cursor FETCH loop.
significant
END LOOP
sequence pseudo-columns
DR

29. The BEGIN section is (optional/mandatory)
mandatory
DBMS_PIPE
%BULK_ROWCOUNT
propagates

30. Cursors: Give the statement for getting out of a FETCH loop for cursor CV.
PLSQL_CCFLAGS
cannot
current BEGIN-END block
EXIT WHEN cv%NOTFOUND

31. I/O: Max number of bytes DBMS_OUTPUT can handle in a session.
RETURN
1 million
decimal
cursor

32. Associative array types (can / cannot) be defined in the database.
strong
bind
in the database
cannot

33. A unit with AUTHID = DEFINER is a ________ rights unit.

34. The names of Java objects in Oracle can be up to __ characters in length.
%BULK_ROWCOUNT
DATE
4K
value

35. A national character literal is composed of characters in the ________ character set.
cannot
national
$$
suspended

36. Exceptions: The ________ function returns the current error code.
SQLCODE
can
oname
collections - records

37. $$PLSQL_LINE and $$PLSQL_UNIT are ______-ly defined inquiry directives.
WHERE CURRENT OF
finishes
composite
implicit

38. Advantage: Performance: Stored subprograms are ______ in memory.
EXIT WHEN
cached
UTL_FILE
preprocessor

39. In interpreted mode - PL/SQL code is run in a _______ _______.
virtual machine
pseudocolumn
execute
name

40. When a session starts - CURRENT_SCHEMA has the value of the schema owned by ___________.
delimiters
variable
SESSION_USER
bind

41. Cursors: The first two keywords of a basic fetch statement.
Server Pages
procedure P AUTHID definer;
FETCH - INTO
%FOUND - %ISOPEN - %NOTFOUND - %ROWCOUNT

42. Default file extension of wrap's output file.
predefined
..
plb
FETCH

43. You (can / cannot) wrap trigger source code.
is certain
cannot
<> - != - ^=
vname CONSTANT VARCHAR2 := 'x';

44. IDs: The type of words that cannot be user-defined identifiers.
Reserved words.
procedure P AUTHID current_user;
sequence pseudo-columns
before insert or update on emps

45. The source for wrapping begins with the word ______.
create
FGA
...
specification - body

46. Exceptions: The ________ handler must always be the last handler.
OTHERS
TRUE - FALSE and NULL
buffer
code

47. Types: The storage size of a NUMBER value is based on the number of ______ digits.
buffer
identifiers
USER_PLSQL_OBJECT_SETTINGS
significant

48. Triggers: When using the NEW or OLD pseudo-records in the body of the trigger - they must be prefixed with a _______.
do not
colon
ordinary
EXIT

49. Bulk: The two features that comprise Bulk SQL are:
SQLERRM
%TYPE
single-line
FORALL and BULK COLLECT

50. A GOTO statement cannot branch from an exception handler back into the...
current BEGIN-END block
$IF $THEN $ELSE $END
FETCH
invoker's