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: List the two types of user-defined identifiers.
Ordinary - Quoted.
same
'
SQL

2. With dynamic typing - type checking is done at ______time.
fail
run
OTHERS
deletions

3. The variable showing the user id that is automatically prepended to object names.
define
CURRENT_USER
before insert or update on emps
compilation

4. Fundamental: A label can be used to name an ______ block.
ALTER SESSION
PSP
anonymous
True

5. Fundamental: What are the 3 compound symbols for 'not equal to'?
<> - != - ^=
library
flushed
API

6. Types: One of the scalar data types specific to PL/SQL: B_______
constrained
implicit CASE_NOT_FOUND exception
BINARY_INTEGER
Ada

7. A PL/SQL block that is not stored.
a number := 10
anonymous block
EXECUTE
finishes

8. Exceptions: Start of the range of error codes for RAISE_APPLICATION_ERROR.
DML
-20 -000
WHEN
ALTER SESSION

9. You (can / cannot) wrap trigger source code.
*/
SYS_CONTEXT
CHARARR
cannot

10. Delimiters: The assignment operator.
portable
:=
procedure P AUTHID definer;
REF_CURSOR

11. I/O: This package lets two or more sessions in the same instance communicate.
DBMS_PIPE
SQL
disable
SQL

12. Exceptions: The keyword that begins an exception handler.
%BULK_ROWCOUNT
WHEN
exception handler
memory

13. Which two collection types are unbounded?
OUT
cursor
nested tables - associative arrays
$END

14. Cursors: SYS_REFCURSOR is a predefined type based on _____ ______.
<<>>
REF CURSOR
set serveroutput on
cursor number

15. The exception raised when a SELECT INTO statement returns more than one row.
DBMS_CRYPTO
an enclosing block
CREATE TRIGGER
TOO_MANY_ROWS

16. Default file extension of wrap's input file.
sql
dynamic
open C(p)
CASE_NOT_FOUND

17. The default value of the AUTHID property.
transaction
DEFINER
DBMS_OUTPUT
query

18. The lowest index of a nested table is ___.
$END
colon
1
disable

19. The FORALL statement to loop over a collection MyList using index i.
FORALL i IN MyList.FIRST..MyList.LAST
inquiry
literals
static

20. Cursors: A cursor FOR loop cannot use a _______ variable.
slower
unhandled
cursor
TYPE rec IS RECORD (num NUMBER - name VARCHAR2(10));

21. Fundamental: Delimiters are _____ and _____ symbols.
simple and compound symbols
# - $ - _
1
FORALL i IN MyList.FIRST..MyList.LAST

22. To insert or update on a table that has a collection column - you have to have _______ privilege on the collection type.
anonymous
can
FETCH
EXECUTE

23. Cursors: Opening keyword of a cursor FETCH loop.
LOOP
anonymous block
EXIT WHEN
GET_LINE

24. Triggers: The clause to make a trigger run after inserting into table EMPS.
after insert on emps
VARRAYs
DBMS_PIPE
-20 -000

25. Triggers: When using the NEW or OLD pseudo-records in the body of the trigger - they must be prefixed with a _______.
Apache
colon
subtype
nested tables - associative arrays

26. Assignment of PLSQL_CCFLAGS (cannot / can) be included in ALTER PROCEDURE ... COMPILE ...
*/
32 -000
can
FORALL i IN MyList.FIRST..MyList.LAST

27. DynSQL: Maximum string length to pass to EXECUTE IMMEDIATE.
=
national
32 -000
error code

28. The two main parts of a package are the ____ and the _____.
specification - body
Ada
single-line
loop

29. I/O: This package lets PL/SQL programs read and write OS files.
UTL_FILE
RETURN
quoted
compiles

30. I/O: This package sends text output to SQLPlus
aggregate - analytical
slower
after
DBMS_OUTPUT

31. IDs: How an ordinary user-defined identifier must begin.
CHARARR
library
With a letter.
index

32. Language that PL/SQL is derived from.
integer
DBMS_OUTPUT
implicit CASE_NOT_FOUND exception
Ada

33. Define a collection type - tV - which is a varray of 100 NUMBERs.
decimal
TYPE tV IS VARRAY(100) OF NUMBER
always
searched

34. IDs: You (can/cannot) use keywords as ordinary user-defined identifiers.
name and datatype
can
RESULT_CACHE
array

35. I/O: This package has hypertext procedures that generate HTML tags
mandatory
1
HTP
non-editioning views

36. When an autonomous routine begins execution - the main transaction is ________.
IN - OUT - IN OUT
name and datatype
suspended
DATE

37. DynSQL: EXECUTE IMMEDIATE can be used for any SQL statement or PL/SQL block - except for ________ queries.
cannot
obfuscates
multi-row
reference

38. By default - OUT and IN OUT parameters are passed by _____.
value
error code
function f (n number) return number result_cache relies_on (emps);
RAISE

39. I/O: The DBMS_OUTPUT function that writes output WITH a newline character.
finishes
REF CURSOR
PUT_LINE
fail

40. I/O: If the current (outermost) PL/SQL block ends with an unhandled exception - the output buffer will not be ___________.
iname
PLS_INTEGER
flushed
32 -000

41. Cursors: Closing keywords of a cursor FETCH loop.
END LOOP
before insert or update on emps
30
r t.%ROWTYPE;

42. Pkgs: The _______ package gives access to such SQL things as ALTER SESSION.
dbms_output.put_line
DBMS_SESSION
multi-row
sequence pseudo-columns

43. An INSTEAD OF trigger specifies what to do instead of a ___ statement.
BINARY_INTEGER
v2 IN NUMBER default 20
collections - records
DML

44. TCL: Undo changes back to savepoint ab.
slower
array
SQLCODE
rollback to ab

45. User-defined compiler directives are defined in this system compile parameter.
PSP
EXECUTE IMMEDIATE
PLSQL_CCFLAGS
cannot

46. The PL/SQL virtual machine turns bytecode into system ______.
once
calls
PL/SQL
USING

47. 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

48. Cursors: The three keywords in a full cursor declaration/definition (before the SELECT).
DR
CURSOR - RETURN - IS
in the database
USER_PLSQL_OBJECT_SETTINGS

49. Command to delete a procedure.
FOR i IN REVERSE 1..10 LOOP
cursor variable
order
drop procedure

50. Official acronym for PL/SQL's runtime engine.
PVM
PL/SQL
SYS_REFCURSOR
network