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. Delimiters: The left label delimiter.
<<
32 -000
do not
p.v

2. In a collection - the internal components always have the _____ data type.
package
Double quotes.
same
dynamic

3. Package for getting the postprocessed source of a program.
SYS_REFCURSOR
DBMS_PREPROCESSOR
iname
FETCH

4. Cursors: How many implicit cursors can you access?
1
# - $ - _
native dynamic
can

5. If none of a CASE expression's conditions are TRUE - it returns _____.
non-editioning views
PLSQL_CCFLAGS
fail

6. Exceptions: The maximum length of an Oracle error message is ____ characters
nested tables - associative arrays
512
FALSE
boolean

7. Clause added to a cursor to use it with WHERE CURRENT OF.
cannot
FETCH - INTO
for update of
integer

8. Cursors: The second keyword of a FETCH statement.
pls_integer
INTO
%BULK_ROWCOUNT
drop procedure

9. Cursors: Give the first 3 words to open a cursor variable called cv.
open cv for
Declaration
CLOSE_CURSOR
FETCH

10. DBMS_DDL.WRAP returns a string containing wrapped _____ _____.
implicit
source code
NDS
UTL_SMTP

11. Declare an input/output NUMBER parameter - v3.
invoker's
propagates
v3 IN OUT NUMBER
inquiry

12. When a parameter is passed by reference - changes made to it inside the procedure cannot be undone. True/False.
NESTED TABLE myColl STORE AS myCollTab
DBMS_SQL
True
...

13. A GOTO cannot branch into a...
after
lower sub-block
reference
FOR i IN REVERSE 1..10 LOOP

14. An editioning view is like an ____ for a table.
.
API
CURSOR - RETURN
SUBTYPE numb IS number;

15. I/O: The DBMS_OUTPUT function that writes output without a newline character.
PUT
DECLARE - BEGIN - EXCEPTION - END
EXIT WHEN cv%NOTFOUND
base

16. The four keywords that define a PL/SQL block.
FALSE
compile
DECLARE - BEGIN - EXCEPTION - END
pls_integer

17. A result-cached function caches its results in the _____ _____ ____ (SGA)
cannot
system global area
optional
current

18. CREATE TYPE cannot be used for _______ array types.
statically
open cv for
associative
...

19. PL/SQL is a ________ typed programming language.
statically
cannot
static boolean
**

20. The EXCEPTION section is (optional/mandatory).
GET_LINE
GET_LINES
COMMIT - ROLLBACK - SAVEPOINT - SET TRANSACTION
optional

21. Declare an unconstrained subtype of NUMBER called NUMB.
RESULT_CACHE
CURRENT OF
PRAGMA AUTONOMOUS_TRANSACTION;
SUBTYPE numb IS number;

22. In a record - the internal components are called ______.
network
fields
fetch cv into myvar
multi-row

23. Data dictionary view that shows the compiler settings for each compiled object.
USER_PLSQL_OBJECT_SETTINGS
1
rollback to ab
drop procedure

24. The Wrap utility ________ the source code.
Abstract
obfuscates
define
anonymous

25. DynSQL: The main command for Native Dynamic SQL.
EXECUTE IMMEDIATE
variable
HTF
API

26. I/O: SQLPlus command for turning on buffered output.
session cursor
*/
set serveroutput on
IR

27. The PL/SQL ________ evaluates compiler directives.
p.v
preprocessor
machine
3

28. Advantage: PL/SQL programs are stored centrally - making them more ______.
manageable
v1 OUT number default 10
CASE_NOT_FOUND
will not

29. Triggers: In a trigger - you cannot issue a COMMIT or a ______.
upper - coalesce
RECORDS
propagates
ROLLBACK

30. Cursors: If no SELECT or DML statement has run - the value of SQL%ROWCOUNT is what?
ordinary

SYS_CONTEXT
name and datatype

31. Declare an input NUMBER parameter - v2 - that defaults to 20.
v2 IN NUMBER default 20
do not
32 -000
type T is ref cursor

32. Fundamental: What is the exponentiation operator?
include
USER_PROCEDURES
**
close C

33. The PL/SQL preprocessor passes ______ code to the compiler.
manageable
package
32 -000
source

34. Exceptions: Start of the range of error codes for RAISE_APPLICATION_ERROR.
Keywords and predefined names.
implicit cursor
-20 -000
transaction

35. An ordinary character literal is composed of characters in the ________ character set.
1
aggregate - analytical
information that changes infrequently
database

36. A nested table has to be initialized using a ________ - named the same as the type.
constructor
ALTER SESSION
obfuscates
unhandled

37. Triggers: When using the NEW or OLD pseudo-records in the body of the trigger - they must be prefixed with a _______.
colon
enabled
%TYPE
SQLPlus

38. A GOTO cannot branch into an...
inclusive
IF - CASE or LOOP
executable
dynamic

39. Delimiters: The remote access symbol.
ENABLE
DEFINER
does not
@

40. Web: Abbreviation of PL/SQL Server Page.
$IF $THEN $ELSE $END
PSP
Double quotes.
EXCEPTION_INIT

41. To create a collection type - use the TYPE command in PL/SQL and the ______ _____ command in SQL.
CREATE TYPE
DML
explicit cursor
error

42. Pkgs: The _______ package gives access to such SQL things as ALTER SESSION.
FETCH - INTO
unconstrained
after
DBMS_SESSION

43. Exceptions: The ________ function returns the error message associated with an error code.
LOOP - END LOOP
array
SQLERRM
RETURN

44. Nested tables can become sparse via ______.
STANDARD
deletions
CREATE TRIGGER
cursor c;

45. Exceptions: User-defined exceptions must have _______.
ADT
collections
value
names

46. Cursors: The statement that closes a cursor.
CLOSE
LOOP
cannot
Declaration

47. You cannot bulk collect into an ARRAY OF ________.
Oracle
implicit cursor
RECORDS
HTF

48. The compiler directive used to select which code to compile.
$IF
'ENABLE:SEVERE' - 'ERROR:06002'
fetch C into V
for each row

49. Triggers: On a non-editioning view - you can only define __________ triggers.
/*
INSTEAD OF
mandatory
define

50. DBMS_DDL.CREATE_WRAPPED: wraps and _______ the source code passed to it.
GET_LINES
compiles
scalable
EXECUTE