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. I/O: To make sure the DBMS_OUTPUT buffer will be flushed - put a WHEN ______ clause in the EXCEPTION section of your outer block.
VARRAY - Nested table
server
associative arrays
OTHERS

2. Define a collection type - tA - which is an associative array of NUMBERS - indexed with varchar2(20) values.
USING
Ada
TYPE tA IS TABLE OF NUMBER INDEX BY VARCHAR2(20)
associative arrays

3. User-defined compiler directives are defined in this system compile parameter.
order
IF - CASE or LOOP
PLSQL_CCFLAGS
value

4. The $IF must evaluate a ______ _______ expression.
static boolean
anonymous
CURSOR - RETURN
anonymous

5. (from inside a package) Declare a function f - that takes a number n - returns a number - and caches results - depending on table EMPS.
TOO_MANY_ROWS
function f (n number) return number result_cache relies_on (emps);
<<
implicit

6. Cursors: The SQL%FOUND attribute has how many possible values?
3
DML
include
CHARARR

7. The attribute used to get the type of a column or variable without knowing what it is.
expression
%TYPE
error code
external subprogram

8. Kind of comment not to put in a PL/SQL block to be processed dynamically by an Oracle Precompiler program.
invoker's
single-line
IS
REUSE SETTINGS

9. Conversion: Implicit conversion is not always predictable; it is _______-sensitive. And its rules might change.
slower
constant
TOO_MANY_ROWS
context

10. A GOTO cannot branch into an...
END
IF - CASE or LOOP
30
implicit CASE_NOT_FOUND exception

11. Types: The storage size of a NUMBER value is based on the number of ______ digits.
significant
not the same
.
$IF $THEN $ELSE $END

12. I/O: The string table type in DBMS_OUTPUT for holding lines of text.
rollback to ab
CHARARR
OTHERS
RETURN

13. Package for getting the postprocessed source of a program.
once
EXIT
DBMS_PREPROCESSOR
index

14. Mode designation for an input parameter.
-
IN
DATE
%

15. Exceptions: A GOTO statement CAN branch from an exception handler into an ________ block.
PSP
enclosing
WHEN OTHERS THEN
L.V

16. Dbms_sql: DBMS_SQL package is compiled with _______ rights.

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

17. Cursors: The FOR UPDATE phrase goes at the (beginning/end) of the cursor definition.
PL/SQL
end
buffer
inclusive

18. Cursors: A cursor with a name is an _________ cursor.
explicit
suspended
PLSQL_CCFLAGS
value

19. The compiler directive governing conditional compilation.
$IF
Ada
cursor
executable

20. A GOTO cannot branch into a...
lower sub-block
dynamic
query
RECORDS

21. The lowest index of a nested table is ___.
1
cursor
aliases
open C

22. Declare an input/output NUMBER parameter - v3.
dense
after insert on emps
vname CONSTANT VARCHAR2 := 'x';
v3 IN OUT NUMBER

23. Clause added to a cursor to use it with WHERE CURRENT OF.
statically
WHEN OTHERS THEN
for update of
lower sub-block

24. Cursors: A session cursor that is automatically created and managed by PL/SQL.
implicit cursor
PUT_LINE
DATE
a number := 10

25. Wrap ______=xxxx oname=zzzzz
cursor
iname
<> - != - ^=
varray

26. Associative arrays (do / do not) have to be initialized with a constructor.
fields
$$PLSQL_LINE
slower
do not

27. Types: One of the scalar data types specific to PL/SQL: P________
EVERE - PERFORMANCE - INFORMATIONAL
DR
PLS_INTEGER
$IF

28. Cursors: You cannot use cursor attributes in _______ statements.
SQL
explicit
cannot
decimal

29. I/O: The most basic PL/SQL way to give output to the user.
dbms_output.put_line
boolean
raise_application_error(-20 -100 - 'Bad');
implicit CASE_NOT_FOUND exception

30. Triggers: The clause to make a trigger run before inserting or updating table EMPS.
before insert or update on emps
.
TRUE - FALSE - NULL
PSP

31. Types of blocks: Procedures and functions are _______ blocks.
USER_PLSQL_OBJECT_SETTINGS
create
3
stored

32. Types: ________ data types have no internal components.
$IF
scalar
run
2

33. With Edition-based Redefinition enabled - the unique specification of an object requires OWNER - OBJECT_NAME and ___________.
EDITION_NAME
collections
'ENABLE:SEVERE' - 'ERROR:06002'
buffer

34. Cursors: Give the statement for getting out of a FETCH loop for cursor CV.
OLD
FOR i IN REVERSE 1..10 LOOP
EXIT WHEN cv%NOTFOUND
COMMIT - ROLLBACK - SAVEPOINT - SET TRANSACTION

35. Cursors: The statement where you pass the parameters to a cursor.
CURRENT_USER - DEFINER
composite
OPEN
literal

36. Nested tables are multisets - meaning that there is no inherent _____ of their elements.
cannot
bb:true
order
32 -000

37. In a collection - the internal components always have the _____ data type.
native dynamic
current transaction
finishes
same

38. A kind of variable used as a placeholder.
versions
bind
calls
EXIT WHEN

39. Exceptions: Some internal exceptions have ________ names.
predefined
currval and nextval
collections - records
WHERE CURRENT OF

40. The meaning of 'FGA'.
SESSION_USER
fine-grained auditing
%ISOPEN.
4

41. When a parameter is passed by reference - changes made to it inside the procedure cannot be undone. True/False.
True
CREATE TRIGGER
WHERE CURRENT OF
implicit CASE_NOT_FOUND exception

42. Web: PL/SQL _____ _______ lets you to develop Web applications made of PL/SQL procedures.
code
With a letter.
ex := tbl1 MULTISET EXCEPT tbl2
Web Toolkit

43. Statement to exit a cursor loop on cursor cGo when there are no more records.
exit when cgo%NOTFOUND
type T is ref cursor
comments
production

44. Internally - the NUMBER type is stored as ______. Therefore - decimal numbers (such as prices) are stored exactly - with no rounding.
decimal
will not
anonymous block
inclusive

45. Triggers: On a non-editioning view - you can only define __________ triggers.
plb
INSTEAD OF
versions
mandatory

46. Dbms_sql: The return type DBMS_SQL.open_cursor.
integer
CLOSE
compilation
transaction

47. Cursors: The first two keywords in a Cursor FOR loop.
procedure P AUTHID current_user;
FOR - IN
raise_application_error
current transaction

48. Declare an associative array type - t - whose elements are of type rPerson - and whose index is PLS_INTEGER.
TYPE t IS TABLE OF rPerson INDEX BY PLS_INTEGER;
DATE
explicit cursor
CHARARR

49. I/O: This package handles HTTP.
VARRAY - Nested table
UTL_HTTP
EXCEPTION_INIT
v1 OUT number default 10

50. Pkgs: This procedure de-instantiates/resets all packages in this session.
label
1
DBMS_SESSION.RESET_PACKAGE
disable