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. If none of a CASE expression's conditions are TRUE - it returns _____.
enclosing

enabled
hardware

2. With conditional compilation you can avoid compiling debug code in the _______ environment.
END CASE
external subprogram
production
decimal

3. Clause added to a cursor to use it with WHERE CURRENT OF.
is
for update of
unhandled
DML

4. Types: One of the 4 PL/SQL things that have a data type (begins with 'p').
can
CLOSE_CURSOR
DML
parameter

5. Exceptions: Each internal exception has an Oracle ______ _______.
optional
error code
plb
static boolean

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

7. DynSQL: The three modes of arguments in the USING clause of EXECUTE IMMEDIATE.
IN - OUT - IN OUT
LOOP - END LOOP
cursor variable
3

8. Mode designation for an input parameter.
IN
block
cannot
Gateway

9. In a collection - the internal components always have the _____ data type.
IF - CASE or LOOP
is
same
PRAGMA AUTONOMOUS_TRANSACTION;

10. Fundamental: One of the 4 types of lexical units: c_____.
WHERE CURRENT OF
BOOLEAN
comments
NUMBER

11. Delimiters: Single-line comment marker.
elsif
-
anonymous block
LOOP - END LOOP

12. Pkgs: The _______ package gives access to such SQL things as ALTER SESSION.
DBMS_SESSION
DML
cursor
fetch cv into myvar

13. Exceptions: Start of the range of error codes for RAISE_APPLICATION_ERROR.
flushed
inclusive
-20 -000
type T is ref cursor

14. Cursors: What are the 3 possible values of SQL%FOUND and SQL%NOTFOUND?
code
TRUE - FALSE - NULL
suspended
Ordinary - Quoted.

15. Web: mod_plsql is an _______ module.
Apache
Wrap
raise_application_error
alter procedure

16. Web: PL/SQL _____ _______ lets you to develop Web applications made of PL/SQL procedures.
Web Toolkit
DBMS_SQL
1 million
reference

17. I/O: The output from DBMS_OUTPUT will display (during/after) program execution.
after
True
UTL_FILE
boolean

18. The command used to populate PLSQL_CCFLAGS.
after
ALTER SESSION
definer's
HTP

19. Dbms_sql: The return type DBMS_SQL.open_cursor.
lowest
a number := 10
CREATE TRIGGER
integer

20. IDs: Maximum number of bytes in a user-defined identifier.
HTF
transaction
EXIT WHEN cv%NOTFOUND
30

21. Which two of these built-in SQL functions can be used in procedural (PL/SQL) statements: DECODE - CORR - UPPER - SUM - COALESCE - DEREF.
RECORDS
CURRENT_USER - DEFINER
follows
upper - coalesce

22. Type: An ________ subtype has all the values of its base type.
unconstrained
FETCH - INTO
constant
do not

23. In 11g you can directly reference _____________ in PL/SQL.
network
%ROWTYPE
sequence pseudo-columns
composite

24. SIMPLE_INTEGER is like PLS_INTEGER - but it does not allow ____ values - and it does not raise overflow exceptions.

@
WHEN OTHERS THEN
integrated

25. The AUTHID property applies to PL/SQL objects that contain _____.
stored
Reserved words.
code
procedure - function

26. Exceptions: The keyword that begins an exception handler.
FORALL i IN MyList.FIRST..MyList.LAST
same
WHEN
searched

27. DynSQL: Maximum string length to pass to EXECUTE IMMEDIATE.
32 -000
4
.
current transaction

28. When a session starts - CURRENT_SCHEMA has the value of the schema owned by ___________.
SESSION_USER
v2 IN NUMBER default 20
lowest
inquiry

29. Types: One of the scalar data types specific to PL/SQL: B_______
timing
BINARY_INTEGER
name-value
*/

30. Types: One of the scalar data types specific to PL/SQL: b_____.
executable
BOOLEAN
1
DATE

31. A result-cached function caches its results in the _____ _____ ____ (SGA)
GET_LINE
IF - CASE or LOOP
system global area
SQLERRM

32. Characters that begin a multi-line comment.
versions
1
/*
PL/SQL Gateway

33. Declare a constrained subtype of NUMBER called N that is not null.
SUBTYPE n IS number not null;
RESULT_CACHE
inquiry
context

34. Give the first line of the FOR loop with index i going from 1 to 10 in reverse.
plb
FOR i IN REVERSE 1..10 LOOP
create
set serveroutput on

35. _____ arrays cannot be used as the type of an Oracle table column.
REF_CURSOR
is
exit when cgo%NOTFOUND
associative

36. A FOR-loop counter is defined only within the _____.
open C
loop
32 -000
optional

37. The FORALL statement to loop over a collection MyList using index i.
is
EVERE - PERFORMANCE - INFORMATIONAL
FORALL i IN MyList.FIRST..MyList.LAST
composite

38. DynSQL: EXECUTE IMMEDIATE does both dynamic SQL and dynamic _______.
OLD
elsif
PL/SQL
package

39. To recompile a procedure - use the _____ ______ command.
flushed
EXIT WHEN cv%NOTFOUND
3
alter procedure

40. Collections are one of the two kinds of PL/SQL _______ data types.
EXIT WHEN
composite
binding
USING

41. Triggers: The code in a trigger is actually an ________ block.
STANDARD
a cursor
True - false or NULL.
anonymous

42. Delimiters: Item separator.

BINARY_INTEGER
open cv for
SYS_CONTEXT

43. Unlike the CASE statement - the CASE expression does not have the...
$IF
cursor
dynamic
implicit CASE_NOT_FOUND exception

44. I/O: If the current (outermost) PL/SQL block ends with an unhandled exception - the output buffer will not be ___________.
DATE
BINARY_INTEGER
flushed
integrated

45. Cursors: The statement where you pass the parameters to a cursor.
OPEN
VARRAYs
same arguments
for each row

46. Triggers: If two or more triggers are defined with the same timing point - then you can control the firing order using the ________ clause.
Double quotes.
UTL_FILE
HTF
follows

47. The LIMIT method is only meaningful for _______.
VARRAYs
variable
-
NEW

48. When a parameter is passed by reference - changes made to it inside the procedure cannot be undone. True/False.
commit - rollback
compiles
True
package

49. Cursors: Define a ref cursor type called T.
static
TYPE rec IS RECORD (num NUMBER - name VARCHAR2(10));
definer's
type T is ref cursor

50. Cursors: Give the statement to fetch data from cursor C into variable V.
'
hardware
sequence pseudo-columns
fetch C into V