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. IDs: The type of words that cannot be user-defined identifiers.
FOR i IN REVERSE 1..10 LOOP
aliases
Reserved words.
cannot

2. When a parameter is passed by reference - changes made to it inside the procedure cannot be undone. True/False.
bind
cursor
COUNT
True

3. Exceptions: The package that defines pre-defined exceptions.
not a number
HTP
non-editioning views
STANDARD

4. Types: The PL/SQL type that is identical to PLS_INTEGER.
...
current
BINARY_INTEGER
create

5. The valid values of the AUTHID property.
REF CURSOR
CURRENT_USER - DEFINER
REUSE SETTINGS
32 -000

6. Mode designation for an output parameter.
aliases
PLSQL_CCFLAGS
END IF
OUT

7. Declare a package procedure P with no arguments - and give it invoker's rights.
define
$IF $THEN $ELSE $END
enabled
procedure P AUTHID current_user;

8. Conversion: It is best to use (implicit / explicit) conversion.
autonomous transaction
explicit
5
define

9. Native compilation turns bytecode into ________ code.
Gateway
fine-grained auditing
machine
deletions

10. ______ SQL is a PL/SQL feature that allows SQL syntax directly in a PL/SQL statement.
parameter
static
in the database
2

11. Delimiters: Single-line comment marker.
expression
reference
procedure P AUTHID definer;
-

12. A record is a group of related data items stored in fields - each with its own...
name and datatype
timing
deletions
invalid

13. Fundamental: One of the 4 types of lexical units: i_____
INTO
*/
identifiers
pseudocolumn

14. A GOTO statement can branch from an exception handler into...
run
an enclosing block
single-line
unhandled

15. Where an external subprogram is stored.
statement
FOR i IN REVERSE 1..10 LOOP
in the database
cannot

16. A value that is neither represented by an identifier nor calculated from other values.
literal
currval and nextval
execute
SUBTYPE n IS number not null;

17. The PL/SQL virtual machine turns bytecode into system ______.
significant
*/
an enclosing block
calls

18. The $ERROR directive is used to make compilation ____.
DML
after
1
fail

19. A CASE expression ends with _____.
:=
NESTED TABLE myColl STORE AS myCollTab
END
WHEN

20. Kind of code created by the PL/SQL compiler.
pseudocolumn
sequence pseudo-columns
bytecode
%ISOPEN.

21. You can define PL/SQL collections using TYPEs defined in the _______.
wrap
30
database
index

22. Types: A ______ has the same valid operations as its base type.
definition
subtype
p.v
fetch C into V

23. Types: One of the scalar data types specific to PL/SQL: P________
PLS_INTEGER
PL/SQL Gateway
%FOUND - %ISOPEN - %NOTFOUND - %ROWCOUNT
for each row

24. Statement to set current schema to x: _____ _____ SET CURRENT_SCHEMA = 'x';
END LOOP
fine-grained auditing
ALTER SESSION
Web Toolkit

25. An editioning view can only select a subset of the columns from the base table and provide ________ for them
aliases
ALTER SESSION
:=
L.V

26. For an associative array - the FIRST method gets the (lowest / first-created) index.
bind
lowest
Ada
Web Toolkit

27. Advantage: Having procedures stored and executed on the server makes PL/SQL ________.
procedure P AUTHID definer;
BOOLEAN
scalable
compile

28. An incomplete type only has a ____.
is not
same arguments
name
DBMS_SESSION

29. PLS_INTEGER has its arithmetic implemented in ________ - so it is very fast.
FORALL and BULK COLLECT
TYPE tA IS TABLE OF NUMBER INDEX BY VARCHAR2(20)
hardware
expression

30. Statement to exit a cursor loop on cursor cGo when there are no more records.
lowest
FETCH - BULK COLLECT INTO
DML
exit when cgo%NOTFOUND

31. FOR-Looping over a collection from FIRST to LAST only works if the collection is _______.
dense
delimiters
implicit
compile

32. Triggers: In a DML trigger - the phrase that makes the trigger run for every affected record.
statically
for each row
bytecode
NESTED TABLE myColl STORE AS myCollTab

33. Exceptions: The keyword that begins an exception handler.
cannot
open C
searched
WHEN

34. The compiler directive used to select which code to compile.
inclusive
$IF
TYPE t IS TABLE OF rPerson INDEX BY PLS_INTEGER;
FOR i IN REVERSE 1..10 LOOP

35. I/O: The DBMS_OUTPUT procedure that sets the size of the output buffer.
block
EXECUTE IMMEDIATE
ENABLE
raise_application_error(-20 -100 - 'Bad');

36. A GOTO cannot branch into an...
DR
IF - CASE or LOOP
%ISOPEN.
TYPE t IS TABLE OF rPerson INDEX BY PLS_INTEGER;

37. Cursors: A cursor with a name is an _________ cursor.
native dynamic
will not
explicit
buffer

38. DynSQL: The three modes of arguments in the USING clause of EXECUTE IMMEDIATE.
DBMS_CRYPTO
CURSOR - RETURN - IS
1
IN - OUT - IN OUT

39. Cursors: How many implicit cursors can you access?
array
INTO
1
SQL

40. You cannot bulk collect into an ARRAY OF RECORDS. You can into a ________________ (3 words).
searched
OPEN_CURSOR
RECORD OF ARRAYS
elsif

41. A CASE statement ends with ____ ____.
compilation
END CASE
RETURN
information that changes infrequently

42. I/O: If the current (outermost) PL/SQL block ends with an unhandled exception - the output buffer will not be ___________.
associative
OTHERS
context
flushed

43. The Wrap utility (does / does not) encrypt source code.
True
does not
nested
machine

44. Types: ________ data types have internal components.
PVM
composite
30
set serveroutput on

45. Cursors: Give the first 3 words to open a cursor variable called cv.
drop procedure
invoker's
open cv for
VARRAYs

46. A PL/SQL extension to the WHERE clause of the SQL statements UPDATE and DELETE
WHERE CURRENT OF
unhandled
slower
TYPE rec IS RECORD (num NUMBER - name VARCHAR2(10));

47. Bytecode is _______ _______ code.
not the same
name
HTP
virtual machine

48. With static typing - type checking is done at ______ time.
flushed
before insert or update on emps
searched
compile

49. I/O: The buffered output of dbms_output.put_line is retrieved by _______.
SQLPlus
inquiry
GET_LINE
slower

50. IDs: Predefined identifiers are declared in this package.
STANDARD
cannot
external subprogram
FORALL i IN MyList.FIRST..MyList.LAST