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. Conversion: It is best to use (implicit / explicit) conversion.
error
$IF
explicit
can

2. The best candidates for result-caching are functions that are invoked frequently but depend on __________________ or never.
buffer
information that changes infrequently
UTL_SMTP
optional

3. Assignment of PLSQL_CCFLAGS (cannot / can) be included in ALTER PROCEDURE ... COMPILE ...
cannot
can
Double quotes.
LOOP

4. I/O: This package sends text output to SQLPlus
DBMS_OUTPUT
national
not the same
is

5. An anonymous block is a(n) ____ statement.
delimiters
SQL
significant
finishes

6. Triggers: An INSTEAD OF trigger (can/cannot) be conditional.
commit - rollback
DATE '2005-12-25'
cannot
r t.%ROWTYPE;

7. The FOR UPDATE OF clause references a (table / column).
loop
user-defined
column
%BULK_ROWCOUNT

8. Types: ________ data types have no internal components.
dense
<> - != - ^=
scalar
definer's

9. Nested tables are multisets - meaning that there is no inherent _____ of their elements.
create
order
..
COUNT

10. Advantage: PL/SQL is tightly _______ with Oracle SQL.
VARRAY - Nested table
v1 OUT number default 10
upper - coalesce
integrated

11. Cursors: SYS_REFCURSOR is a predefined type based on _____ ______.
REF CURSOR
literal
is not
EXECUTE

12. Web: mod_plsql is an _______ module.
EXIT WHEN
Apache
2
drop procedure

13. FOR-Looping over a collection from FIRST to LAST only works if the collection is _______.
dense
optional
r t.%ROWTYPE;
BINARY_INTEGER

14. In a cursor loop - the clause added to an INSERT or UPDATE to point at the current record.
WHERE CURRENT OF
RELIES_ON
close C
EXIT WHEN

15. Abbreviation of invoker's rights
$IF
=
IR
implicit

16. Cursors: The values plugged into the DML in a FORALL must come from existing - populated _________.
collections
cannot
exception
sql

17. After the RESULT_CACHE clause - you can put a _________ clause to enable dependency-checking.
RELIES_ON
finishes
RETURN
FOR i IN REVERSE 1..10 LOOP

18. An anonymous block always has _________ rights.

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

19. I/O: The DBMS_OUTPUT procedure that sets the size of the output buffer.
DBMS_SESSION.RESET_PACKAGE
ENABLE
Wrap
an enclosing block

20. Cursors: The SQL%FOUND attribute has how many possible values?
3
user-defined
Declaration
RELIES_ON

21. DynSQL: In EXECUTE IMMEDIATE - the statement string can use either placeholders - or string ________.
30
lowest
concatenation
strong

22. Assigning values to PL/SQL variables that appear in SQL statements is called _______.
binding
statement
IR
RETURN

23. Delimiters: The component indicator/selector.
commit - rollback
an autonomous routine
SYS_CONTEXT
.

24. The source for wrapping begins with the word ______.
library
statically
create
stored

25. Cursors: A session cursor that a PL/SQL user creates and manages.
procedure P AUTHID current_user;
explicit cursor
SUBTYPE numb IS number;
run

26. A FOR loop can be indexed by numbers or by a ______.
FORALL i IN MyList.FIRST..MyList.LAST
static boolean
cannot
cursor

27. A type of compiler directive - begins with 's'.
:=
cannot
optional
selection

28. The _______ package lets you wrap dynamically generated PL/SQL.
DBMS_DDL
INTO
associative
after insert on emps

29. Declare a number variable - A - initialized to 10.
PLS_INTEGER
a number := 10
Gateway
GET_LINE

30. Native compilation turns bytecode into ________ code.
HTP
DBMS_OUTPUT
machine
SESSION_USER

31. To enable result-caching for a function - use the _____________ clause.
RESULT_CACHE
network
can
an autonomous routine

32. In a FORALL loop - you (can / cannot) use the index variable for purposes other than indexing into the collection.
cannot
IN
TYPE tA IS TABLE OF NUMBER INDEX BY VARCHAR2(20)
boolean

33. In short-circuit evaluation - IF-conditions are only evaluated up to where the outcome ___________.
is certain
names
IN
PL/SQL Gateway

34. Mode designation for an input parameter.
IN
INTO
cursor c;
is

35. The BEGIN section is (optional/mandatory)
mandatory
OTHERS
anonymous block
ROLLBACK

36. I/O: One of the 3 types of data stored in the DBMS_OUTPUT buffer.
NUMBER
%ISOPEN.
SUBTYPE numb IS number;
currval and nextval

37. Advantage: PL/SQL is PORTABLE to any OS where ________ runs.
associative
Web Toolkit
Oracle
elements - type

38. Advantage: Performance: PL/SQL automatically creates ______ variables for variables in WHERE and VALUES clauses.
anonymous
WHERE CURRENT OF
$IF
bind

39. The LIMIT method is only meaningful for _______.
do not
VARRAYs
procedure P AUTHID current_user;
disable

40. The three types of compiler warnings.
oname
user-defined
EVERE - PERFORMANCE - INFORMATIONAL
DR

41. The names of Java objects in Oracle can be up to __ characters in length.
4K
FORALL i IN MyList.FIRST..MyList.LAST
vname CONSTANT VARCHAR2 := 'x';
cannot

42. IDs: What a quoted user-defined identifier is enclosed in.
exception handler
TRUE - FALSE and NULL
BINARY_INTEGER
Double quotes.

43. In the IF syntax - is if ENDIF or END IF?
network
cursor c RETURN rC;
END IF
$$

44. Exceptions: Some internal exceptions have ________ names.
:=
predefined
1
RELIES_ON

45. If a result-cached function's data source (based on the RELIES_ON clause) is updated - any cached results become _______.
invalid
definition
virtual machine
drop procedure

46. Exceptions: You can pass an ______ ________ to SQLERRM.
column
selection
SQL
error code

47. Types: One of the 4 PL/SQL things that have a data type (begins with 'p').
parameter
PRAGMA EXCEPTION_INIT (E - -1);
expression
before insert or update on emps

48. I/O: This package does email.
COMMIT - ROLLBACK - SAVEPOINT - SET TRANSACTION
UTL_SMTP
execute immediate
PRAGMA AUTONOMOUS_TRANSACTION;

49. CREATE TYPE cannot be used for _______ array types.
sequence pseudo-columns
associative
executable
COMMIT - ROLLBACK - SAVEPOINT - SET TRANSACTION

50. A result-cached function caches its results in the _____ _____ ____ (SGA)
API
OTHERS
after
system global area