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. Advantage: PL/SQL is tightly _______ with Oracle SQL.
USER_PROCEDURES
savepoint ab
integrated
REF_CURSOR

2. In a collection - the internal components are called _______.
v3 IN OUT NUMBER
elements
anonymous
VARCHAR2

3. Exceptions: Associate exception E with error code -1.
aliases
SESSION_USER
PRAGMA EXCEPTION_INIT (E - -1);
database

4. Web: PL/SQL _______ enables a Web browser to invoke a PL/SQL stored subprogram through an HTTP listener.
placeholders
source code
exception
Gateway

5. The statement that is used to execute most (native) dynamic SQL.
end
execute immediate
REF CURSOR
can

6. Triggers: To simulate having triggers on SELECT statements - you can try ___ (3-letter acronym).
FALSE
a number := 10
EXCEPTION_INIT
FGA

7. A GOTO statement can branch from an exception handler into...
ordinary
DR
an enclosing block
FETCH - BULK COLLECT INTO

8. Types: Which type of arithmetic does PLS_INTEGER use - library or hardware?
DR
hardware
512
label

9. Triggers: When using the NEW or OLD pseudo-records in the body of the trigger - they must be prefixed with a _______.
an AUTHID property
colon
Web Toolkit
same

10. Fundamental: One of the 4 types of lexical units: i_____
iname
can
identifiers
CURRENT OF

11. Delimiters: The remote access symbol.
composite
E Exception;
INTO
@

12. Types: A data type family consists of a ______ type and its subtypes.
exception handler
L.V
base
cannot

13. Cursors: A cursor that lives in session memory until the session ends.
procedure P AUTHID definer;
executable
object
session cursor

14. Nested tables can become sparse via ______.
CHAR - VARCHAR2
deletions
reference
PVM

15. I/O: This DBMS_OUTPUT proc retrieves multiple lines from the buffer.
USING
loop
TRUE - FALSE and NULL
GET_LINES

16. Characters that begin a single-line comment.
$$PLSQL_LINE
TOO_MANY_ROWS
-
cannot

17. Web: PL/SQL ______ ______ (PSPs) let you develop web pages with dynamic content.
can
currval and nextval
Server Pages
ALTER SESSION

18. Statement to exit a cursor loop on cursor cGo when there are no more records.
UTL_HTTP
TIMESTAMP.
predefined
exit when cgo%NOTFOUND

19. Fundamental: Which one of these is a simple symbol: a - = - !=
collections
specification - body
DECLARE - BEGIN - EXCEPTION - END
=

20. Dbms_sql: The return type DBMS_SQL.open_cursor.
integer
package
3
TOO_MANY_ROWS

21. With dynamic typing - type checking is done at ______time.
implicit cursor
base
run
calls

22. If an initialized collection has no elements - FIRST and LAST return _____.

fields
DBMS_SQL
30

23. Fundamental: A label can only go directly before an _______ statement.
fine-grained auditing
IN
TIMESTAMP.
executable

24. In PL/SQL - what the variables in DML statements are turned into.
bind arguments
PL/SQL Gateway
selection
timing

25. Conversion: Implicit conversion is not always predictable; it is _______-sensitive. And its rules might change.
lower sub-block
context
VARCHAR2
$IF

26. An anonymous block always has _________ rights.

27. CREATE TYPE cannot be used for _______ array types.
significant
an enclosing block
associative
cursor variable

28. A type of compiler directive - begins with 's'.
return value
memory
DEFINER
selection

29. Declare a variable r whose type is that of the records in table t.
definition
system global area
SYS_REFCURSOR
r t.%ROWTYPE;

30. Two types of stored subprograms.
FORALL i IN MyList.FIRST..MyList.LAST
WHERE CURRENT OF
%ISOPEN.
procedure - function

31. Cursors: Closing keywords of a cursor FETCH loop.
selection
END LOOP
pls_integer
create procedure

32. I/O: If the current (outermost) PL/SQL block ends with an unhandled exception - the output buffer will not be ___________.
function f (n number) return number result_cache relies_on (emps);
4
PSP
flushed

33. Triggers: By default - a trigger is created in the ______ state.
enabled
TYPE rec IS RECORD (num NUMBER - name VARCHAR2(10));
END CASE
not a number

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

35. Cursors: The SQL%FOUND attribute has how many possible values?
CHAR - VARCHAR2
Keywords and predefined names.
anonymous block
3

36. How to reference a variable V declared in a block labelled L: ____.
predefined
aggregate - analytical
NEW
L.V

37. Wrapped code (is / is not) not backward compatible.
variable
invoker's
-
is not

38. Exceptions: The three words that can be used to guarantee all exceptions will be handled.
$IF $THEN $ELSE $END
explicit
WHEN OTHERS THEN
variable

39. The valid values of the AUTHID property.
aggregate - analytical
32 -000
CURRENT_USER - DEFINER
LOOP - END LOOP

40. Types: One of the 4 PL/SQL things that have a data type (begins with 'c').
statement
error code
%BULK_ROWCOUNT
constant

41. Fundamental: Delimiters are _____ and _____ symbols.
elements
procedure - function
simple and compound symbols
do not

42. A SELECT statement with the FOR UPDATE clause puts a ______ on the selected rows.
lock
PUT_LINE
cached
cannot

43. An INSTEAD OF trigger is used - e.g - when you want to insert into a complex _____.
procedure P AUTHID definer;
NDS
view
is

44. IDs: You cannot use reserved words as ______ user-defined identifiers.
label
expression
ordinary
FORALL i IN MyList.FIRST..MyList.LAST

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

46. Triggers: You create a trigger with the _______ ________ statement.
CREATE TRIGGER
before insert or update on emps
plb
NESTED TABLE myColl STORE AS myCollTab

47. DynSQL: The main command for Native Dynamic SQL.
EXECUTE IMMEDIATE
EDITION_NAME
Gateway
RECORDS

48. Conditional compilation is useful for compiling a program under different ______ of Oracle.
null string
versions
can
RECORDS

49. Cursors: You give an explicit cursor a name and associate it with a _______.
%ISOPEN.
raise_application_error
native dynamic
query

50. The BETWEEN operator is (inclusive / exclusive).
fetch C into V
inclusive
strong
invalid