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. Searchable CASE statement: Each WHEN has its own _______ condition.
boolean
;
cannot
lock

2. Fundamental: One of the 4 types of lexical units: L_____
dbms_output.put_line
simple and compound symbols
forward
literals

3. Conversion: It is best to use (implicit / explicit) conversion.
never
for each row
explicit
context

4. In PL/SQL - what the variables in DML statements are turned into.
never
bind arguments
OLD
DBMS_SQL

5. The Wrap utility ________ the source code.
obfuscates
<<
OLD
PSP

6. Advantage: PL/SQL runs anywhere Oracle runs - so it is very ________.
BOOLEAN
portable
ROLLBACK
comments

7. The declaration section is (optional/mandatory).
CURRENT_USER
optional
FALSE
5

8. I/O: The DBMS_OUTPUT function that writes output without a newline character.
PUT
context
<> - != - ^=
LOOP

9. Fundamental: Which one of these is a simple symbol: a - = - !=
=
SQLPlus
EXTEND
REUSE SETTINGS

10. When a session starts - CURRENT_SCHEMA has the value of the schema owned by ___________.
definer's
SESSION_USER
not the same
upper - coalesce

11. You (can/cannot) put a label before an END LOOP statement.
base
RETURN
binding
cannot

12. The values defined in PLSQL_CCFLAGS can be referenced as _____ directives.
inquiry
CURRENT_USER
'
raise_application_error(-20 -100 - 'Bad');

13. Delimiters: Statement terminator.
;
name-value
ordinary
%TYPE

14. Abbreviation of invoker's rights
IR
set serveroutput on
do not
OTHERS

15. Exceptions: Start of the range of error codes for RAISE_APPLICATION_ERROR.
-20 -000
optional
30
source

16. A GOTO cannot branch into a...
bytecode
cursor
OTHERS
lower sub-block

17. Cursors: Only a _____ _____ cursor can appear in the CURRENT OF clause of an UPDATE or DELETE statement.
FOR UPDATE
@
literal
composite

18. Triggers: INSTEAD OF triggers only run on ______ views.
cursor number
non-editioning views
an autonomous routine
timing

19. How many times are a FOR loop's index bounds evaluated?
wrap
once
inquiry
current transaction

20. Types: The PL/SQL type that is identical to PLS_INTEGER.
cursor
BINARY_INTEGER
not a number
inclusive

21. Types: The only PL/SQL type for which you can specify a range constraint.
composite
PLS_INTEGER
INTO
current

22. With Edition-based Redefinition enabled - the unique specification of an object requires OWNER - OBJECT_NAME and ___________.
EXIT WHEN
oname
EDITION_NAME
1

23. I/O: The DBMS_OUTPUT buffer will not be flushed until it is full or until the current PL/SQL block _________.
fail
loop
finishes
create procedure

24. Command to assign to variables from a cursor.
end
FETCH
current transaction
With a letter.

25. Command to delete a procedure.
before insert or update on emps
PUT_LINE
NUMBER
drop procedure

26. After the RESULT_CACHE clause - you can put a _________ clause to enable dependency-checking.
RELIES_ON
package
view
STANDARD

27. For a collection - the NEXT method returns ____ when there is no next index value.
FORALL and BULK COLLECT

same
will not

28. Conditional compilation is useful for compiling a program under different ______ of Oracle.
FORALL i IN MyList.FIRST..MyList.LAST
invalid
versions
CREATE TRIGGER

29. IDs: You cannot use reserved words as ______ user-defined identifiers.
strong
%BULK_ROWCOUNT
GET_LINES
ordinary

30. Types: A ______ has the same valid operations as its base type.
INTO
elsif
for each row
subtype

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

32. IDs: The type of words that cannot be user-defined identifiers.
Apache
CHARARR
DML
Reserved words.

33. Types: A data type family consists of a ______ type and its subtypes.
**
base
cursor
delimiters

34. You cannot bulk collect into an ARRAY OF ________.
invoker's
bind
PVM
RECORDS

35. A type of compiler directive - begins with 'i'.
inquiry
can
OLD
NUMBER

36. Characters that end a multi-line comment.
*/
CHAR - VARCHAR2
vname CONSTANT VARCHAR2 := 'x';
SESSION_USER

37. _______ arrays can be sparse or dense - depending on how you fill them.
EDITION_NAME
associative
ALTER SESSION
elsif

38. Give the statement to make a program autonomous.
PRAGMA AUTONOMOUS_TRANSACTION;
invoker's
PVM
for each row

39. Exceptions: The three words that can be used to guarantee all exceptions will be handled.
RETURN
FETCH
30
WHEN OTHERS THEN

40. Define a nested table type - tN - which is a table NUMBERs.
REUSE SETTINGS
$$PLSQL_LINE
TYPE tN IS TABLE of NUMBER
VARRAYs

41. Conditional ______ allows backward compability with older database versions.
do not
DML
do not
compilation

42. I/O: The most basic PL/SQL way to give output to the user.
memory
dbms_output.put_line
sequence pseudo-columns
in the database

43. Cursors: If an exception is raised inside a cursor loop - the cursor (is / is not) also closed automatically.
is
32 -000
DATE '2005-12-25'
exception handler

44. To recompile a procedure - use the _____ ______ command.
alter procedure
%ROWTYPE
associative
1

45. Keyword for doing assignment to a variable with SELECT.
follows
INTO
DBMS_OUTPUT
package

46. Cursors: If no SELECT or DML statement has run - the value of SQL%ROWCOUNT is what?
error
Server Pages
Declaration

47. Types: ________ data types have internal components.
composite
DBMS_DDL
PUT
ROLLBACK

48. Define a collection type - tA - which is an associative array of NUMBERS - indexed with varchar2(20) values.
unhandled
TYPE tA IS TABLE OF NUMBER INDEX BY VARCHAR2(20)
BINARY_INTEGER
finishes

49. Wrap ______=xxxx oname=zzzzz
HTP
RECORD OF ARRAYS
iname
manageable

50. NAN stands for _________.
EXIT WHEN
CHARARR
not a number
lowest