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. A subprogram created inside a block is a _________ subprogram.
nested
CREATE TRIGGER
national
IR


2. A numeric FOR loop cannot _________ by other than 1?
external subprogram
increment
lock
base


3. Delimiters: The component indicator/selector.
fields
simple and compound symbols
.
associative arrays


4. Cursors: A pointer to a cursor is called a ______ _______.
cannot
bind
hardware
cursor variable


5. Exceptions: An exception in the declarations section does not go to the __________ section.
WHERE CURRENT OF
a cursor
exception
library


6. Cursors: The SQL%BULK_ROWCOUNT attribute is an _________ -
<<
suspended
array
comments


7. Bytecode is _______ _______ code.
before insert or update on emps
virtual machine
associative
scalable


8. DynSQL: In EXECUTE IMMEDIATE - the statement string can use either placeholders - or string ________.
forward
NDS
SQLPlus
concatenation


9. The DEFINITION of a cursor is the part after the keyword __.
ENABLE
PL/SQL Gateway
IS
L.V


10. You (can/cannot) put a label before an END LOOP statement.
executable
VARCHAR2
END IF
cannot


11. The NOCOPY option on an OUT or IN OUT parameter - causes it to be passed by ______.
reference
$$PLSQL_LINE
REF CURSOR
Server Pages


12. Triggers: In a per-row trigger - the ____ record shows you the changed state of an affected row.
pls_integer
names
raise_application_error(-20 -100 - 'Bad');
NEW


13. I/O: The most basic PL/SQL way to give output to the user.
will not
dbms_output.put_line
selection
preprocessor


14. IDs: You can use a reserved word as a _______ user-defined identifier.
quoted
DBMS_PREPROCESSOR
block
RESULT_CACHE


15. Conversion: If the specific value is suitable - ____ or _______ values can convert to almost any datatype
'ENABLE:SEVERE' - 'ERROR:06002'
CHAR - VARCHAR2
True - false or NULL.
exit when cgo%NOTFOUND


16. _________ exceptions can not be trapped with an error handler
index
LOOP - END LOOP
source code
Declaration


17. Exceptions: The maximum length of an Oracle error message is ____ characters
512
INSTEAD OF
source code
can


18. Unlike the CASE statement - the CASE expression does not have the...
drop procedure
does not
EXECUTE IMMEDIATE
implicit CASE_NOT_FOUND exception


19. Associative arrays (do / do not) have to be initialized with a constructor.
do not
TRUE - FALSE - NULL
WHERE CURRENT OF
2


20. A national character literal is composed of characters in the ________ character set.
EVERE - PERFORMANCE - INFORMATIONAL
COUNT
national
optional


21. The 4 keywords in the $IF compiler directive.
$IF $THEN $ELSE $END
network
forward
query


22. Language that PL/SQL is derived from.
associative
IN - OUT - IN OUT
Ada
DBMS_OUTPUT


23. Data dictionary view that shows the compiler settings for each compiled object.
DBMS_PIPE
bytecode
USER_PLSQL_OBJECT_SETTINGS
implicit cursor


24. In short-circuit evaluation - IF-conditions are only evaluated up to where the outcome ___________.
manageable
buffer
is certain
commit - rollback


25. I/O: This DBMS_OUTPUT proc retrieves one line from the buffer.
GET_LINE
return value
v1 OUT number default 10
CHAR - VARCHAR2


26. For a collection - the NEXT method gets the next higher (element / index).
BINARY_INTEGER
simple and compound symbols
GET_LINE
index


27. Declaration of a varchar2 constant - called vname - with value 'x'.

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


28. Give the value list in the PLSQL_WARNINGS parameter to turn on SEVERE compiler warnings and make compiler warning 06002 be an error.

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


29. I/O: One of the 3 types of data stored in the DBMS_OUTPUT buffer.
procedure P AUTHID current_user;
DATE
PL/SQL
'


30. An editioning view is like an ____ for a table.
scalar
API
2
1


31. Dbms_sql: A cursor opened with OPEN_CURSOR (can/cannot) be reused for multiple queries without first closing it.
can
# - $ - _
.
dbms_output.put_line


32. For an associative array - the FIRST method gets the (lowest / first-created) index.
same arguments
before insert or update on emps
lowest
integrated


33. True encryption is done with package __________.
autonomous triggers
SQL
%BULK_ROWCOUNT
DBMS_CRYPTO


34. For a collection - the NEXT method returns ____ when there is no next index value.
OLD

executable
simple and compound symbols


35. The SET TRANSACTION statement affects only the ____________.
definer's
never
index
current transaction


36. Triggers: INSTEAD OF triggers only run on ______ views.
SQL
ENABLE
-
non-editioning views


37. Exceptions: An exception raised inside an _______ _______ propagates immediately to the enclosing block
%ISOPEN.
elsif
# - $ - _
exception handler


38. DBMS_DDL.CREATE_WRAPPED: wraps and _______ the source code passed to it.
FETCH
order
PLS_INTEGER
compiles


39. In a collection - the internal components are called _______.
4K
elements
varray
dynamic


40. Types of blocks: Procedures and functions are _______ blocks.
same arguments
30
stored
is


41. Cursors: What are the 3 possible values of SQL%FOUND and SQL%NOTFOUND?
EXCEPTION_INIT
does not
composite
TRUE - FALSE - NULL


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

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


43. Fundamental: Which one of these is a simple symbol: a - = - !=
IN - OUT - IN OUT
a number := 10
reference
=


44. Java - C or other program called directly in PL/SQL.
SYS_REFCURSOR
quoted
:=
external subprogram


45. A unit with AUTHID = CURRENT_USER is an ________ rights unit.

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


46. Delimiters: Item separator.
mandatory

non-editioning views
SESSION_USER


47. Cursors: Only a _____ _____ cursor can appear in the CURRENT OF clause of an UPDATE or DELETE statement.
FOR UPDATE
WHEN OTHERS THEN
ADT
buffer


48. An anonymous block always has _________ rights.

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


49. Cursors: The values plugged into the DML in a FORALL must come from existing - populated _________.
does not
collections
executable
VARCHAR2


50. FOR-Looping over a collection from FIRST to LAST only works if the collection is _______.
dense
boolean
selection
scalable