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. In Native Mode - PL/SQL code is compiled into ______ ______.
..
machine code
cursor c RETURN rC;
DML

2. I/O: This package has hypertext functions that generate HTML tags
3
HTF
definition
=>

3. Nested tables can become sparse via ______.
DATE
SQL
deletions
pseudocolumn

4. Exceptions: Start of the range of error codes for RAISE_APPLICATION_ERROR.
..
-20 -000
composite
scalar

5. DynSQL: The standard package that does dynamic SQL.
DBMS_SQL
WHEN OTHERS THEN
DATE
DBMS_SESSION.RESET_PACKAGE

6. I/O: SQLPlus command for turning on buffered output.
unqualified
sql
BINARY_INTEGER
set serveroutput on

7. A CASE expression ends with _____.
1
END
drop procedure
aggregate - analytical

8. Cursors: What are the 3 possible values of SQL%FOUND and SQL%NOTFOUND?
TRUE - FALSE - NULL
finishes
elements
<<

9. Types: One of the 4 PL/SQL things that have a data type (begins with 'r').
return value
$$
cannot
plb

10. A type of compiler directive - begins with 's'.
selection
block
4
SQL

11. Give the clause you add to a CREATE TABLE statement - when there is a collection column myColl - that you want to be stored in a table called myCollTab.
single-line
NESTED TABLE myColl STORE AS myCollTab
is certain
invoker's

12. Cursors: Define a ref cursor type called T.
COMMIT - ROLLBACK - SAVEPOINT - SET TRANSACTION
boolean
type T is ref cursor
do not

13. Term for a character literal with zero characters.
IR
null string
order
Oracle

14. You (can/cannot) put a label before an END LOOP statement.
CHAR - VARCHAR2
SQL cursor
fail
cannot

15. A subprogram defined within another subprogram is a _______ subprogram.
fetch cv into myvar
FOR - IN
nested
%ROWTYPE

16. Cursors: The statement where you pass the parameters to a cursor.
calls
OPEN
autonomous transaction
information that changes infrequently

17. Triggers: You (can/cannot) explicitly invoke a trigger.
BINARY_INTEGER
CURRENT OF
can
cannot

18. How many times are a FOR loop's index bounds evaluated?
4
null string
once
SQL cursor

19. The three sorts of date/time types are DATE - INTERVAL and _________.
TIMESTAMP.
unqualified
:=
after insert on emps

20. An anonymous block is a(n) ____ statement.
SQL
END
1
PSP

21. The FIRST method gets the first (element / index) of a collection.
index
not the same
<<
'ENABLE:SEVERE' - 'ERROR:06002'

22. In the IF syntax - is if ENDIF or END IF?
value
END
END IF
current

23. Types: One of the 4 PL/SQL things that have a data type (begins with 'p').
parameter
scalar
anonymous block
slower

24. Conditional compilation is useful for compiling a program under different ______ of Oracle.
pseudocolumn
BINARY_INTEGER
after
versions

25. I/O: The PL/SQL I/O packages (can/cannot) accept input directly from the keyboard.
an AUTHID property
cannot
TRUE - FALSE and NULL
1

26. A CASE statement (can / cannot) execute more than one group of statements.
FETCH - BULK COLLECT INTO
FOR i IN REVERSE 1..10 LOOP
for update of
cannot

27. Give the statement to make a program autonomous.
OPEN
BINARY_INTEGER
PRAGMA AUTONOMOUS_TRANSACTION;
run

28. Clause added to a cursor to use it with WHERE CURRENT OF.
r t.%ROWTYPE;
for update of
source
error code

29. Triggers: In a per-row trigger - the ____ record shows you the original state of an affected row.
OLD
ADT
fail
nested

30. Exceptions: The package that defines pre-defined exceptions.
ROLLBACK
pls_integer
simple
STANDARD

31. Exceptions: PL/SQL exceptions are of two types: internal and _________.
simple
TIMESTAMP.
user-defined
...

32. From a block nested inside a procedure P - reference variable V of the outer procedure.
literals
;
p.v
statement

33. In the special IF syntax - is it ELSIF - or ELSEIF?
elsif
IR
not the same
not a number

34. Cursors: The FOR UPDATE phrase goes at the (beginning/end) of the cursor definition.
end
RETURN
a cursor
INTO

35. TCL: Create a savepoint called ab
varray
savepoint ab
/*
Reserved words.

36. The AUTHID property applies to PL/SQL objects that contain _____.
code
invoker's
query
executable

37. Triggers: By default - a trigger is created in the ______ state.
enabled
'
drop procedure
BINARY_INTEGER

38. The SET TRANSACTION statement affects only the ____________.
virtual machine
never
current transaction
cached

39. A GOTO cannot branch into an...
associative arrays
include
API
IF - CASE or LOOP

40. Cursors: Give the statement to fetch data from cursor variable CV into MyVar.
definition
r t.%ROWTYPE;
fetch cv into myvar
scalar

41. A collection is an ordered group of ________ - all of the same ____
NESTED TABLE myColl STORE AS myCollTab
elements - type
source code
Wrap

42. DynSQL: Maximum string length to pass to EXECUTE IMMEDIATE.
1 million
integrated
end
32 -000

43. Keyword for doing assignment to a variable with SELECT.
package
INTO
IS
block

44. Exceptions: When an exception is raised inside a cursor FOR loop - the cursor is _______ implicitly.
closed
literals
anonymous
base

45. Exceptions: The built-in procedure for raising an application-defined error.
exception
raise_application_error
cannot
index

46. Cursors: If an exception is raised inside a cursor loop - the cursor (is / is not) also closed automatically.
suspended
5
ADT
is

47. An $ERROR directive ends with _____.
-
Server Pages
PSP
$END

48. Fundamental: One of the 4 types of lexical units: i_____
TYPE rec IS RECORD (num NUMBER - name VARCHAR2(10));
CHARARR
identifiers
INTO

49. The two kinds of CASE statements are simple and ________.
v1 OUT number default 10
searched
query
lower sub-block

50. Assignment of PLSQL_CCFLAGS (cannot / can) be included in ALTER PROCEDURE ... COMPILE ...
preprocessor
can
fetch C into V
source