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: dbms_output.put_line puts output into a _______.
buffer
Ada
return value
production

2. Exceptions: The keyword that begins an exception handler.
cursor
WHEN
oname
cursor

3. Command to assign to variables from a cursor.
SQLPlus
memory
FETCH
procedure P AUTHID definer;

4. _______ arrays can be sparse or dense - depending on how you fill them.
associative
DBMS_SESSION.RESET_PACKAGE
an enclosing block
pseudocolumn

5. Dbms_sql: The integer returned by OPEN_CURSOR is a _____ _____.
query
PL/SQL
E Exception;
cursor number

6. I/O: This package lets PL/SQL programs read and write OS files.
CHAR - VARCHAR2
transaction
SUBTYPE numb IS number;
UTL_FILE

7. I/O: This DBMS_OUTPUT proc retrieves multiple lines from the buffer.
TOO_MANY_ROWS
elements
GET_LINES
RECORDS

8. Cursors: If no SELECT or DML statement has run - the value of SQL%ROWCOUNT is what?
CHARARR

FETCH - BULK COLLECT INTO
SIMPLE_INTEGER

9. A subprogram created inside a block is a _________ subprogram.
external subprogram
IN OUT
nested
composite

10. I/O: The string table type in DBMS_OUTPUT for holding lines of text.
finishes
VARCHAR2
CHARARR
3

11. Advantage: PL/SQL is PORTABLE to any OS where ________ runs.
compile
associative arrays
transaction
Oracle

12. Exceptions: The package that defines pre-defined exceptions.
slower
for each row
BOOLEAN
STANDARD

13. In a cursor loop - the clause added to an INSERT or UPDATE to point at the current record.
cursor
WHERE CURRENT OF
stored
VARRAY - Nested table

14. For a collection - the NEXT method returns ____ when there is no next index value.
r tRec := tRec(9 - 'Jones');
DATE '2005-12-25'

Reserved words.

15. The BEGIN section is (optional/mandatory)
FOR i IN REVERSE 1..10 - LOOP - NULL; END LOOP;
scalar
mandatory
TYPE rec IS RECORD (num NUMBER - name VARCHAR2(10));

16. Web: mod_plsql is an _______ module.
wrap
$$
Apache
label

17. The lowest index of a nested table is ___.
SQLCODE
enabled
autonomous triggers
1

18. Triggers and views always have _________ rights.

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

19. In a sparse collection - the indexes of defined elements (do / do not) run in consecutive order.
do not
never
'ENABLE:SEVERE' - 'ERROR:06002'
subtype

20. Cursors: Give the statement to open cursor C that takes parameter p.
open C(p)
optional
bytecode
subtype

21. A FOR loop can be indexed by numbers or by a ______.
specification - body
iname
API
cursor

22. DynSQL: The colon-prefixed names used in EXECUTE IMMEDIATE are called ________.
bb:true
is certain
commit - rollback
placeholders

23. Pkgs: The _______ package gives access to such SQL things as ALTER SESSION.
colon
suspended
DBMS_SESSION
searched

24. DynSQL: The three modes of arguments in the USING clause of EXECUTE IMMEDIATE.
bb:true
source code
IN - OUT - IN OUT
1

25. Cursors: A session cursor that a PL/SQL user creates and manages.
elsif
explicit cursor
%BULK_ROWCOUNT
..

26. I/O: The DBMS_OUTPUT buffer will not be flushed until it is full or until the current PL/SQL block _________.
system global area
always
RETURN
finishes

27. I/O: The DBMS_OUTPUT procedure that sets the size of the output buffer.
ENABLE
inquiry
TYPE tV IS VARRAY(100) OF NUMBER
select

28. Triggers: The clause to make a trigger run before inserting or updating table EMPS.
before insert or update on emps
5
INTO
slower

29. TCL: Undo changes back to savepoint ab.
1 million
scalar
rollback to ab
elements

30. A __________ can have an AUTHID property
UTL_SMTP
package
@
GET_LINE

31. The four keywords that define a PL/SQL block.
REF_CURSOR
<> - != - ^=
DECLARE - BEGIN - EXCEPTION - END
STANDARD

32. Cursors: The two keywords in a mere cursor declaration (one is optional).
FETCH
scalar
CURSOR - RETURN
single-line

33. This is a CASE (expression / statement): myvar := CASE num WHEN 1 THEN 'good' WHEN 2 THEN 'bad' END;
expression
compile
USER_PLSQL_OBJECT_SETTINGS
.

34. Exceptions: An exception in the declarations section propagates to the enclosing _______.
PLS_INTEGER
ALTER SESSION
INTO
block

35. Exceptions: When an exception is raised inside a cursor FOR loop - the cursor is _______ implicitly.
variable
closed
predefined
FOR - IN

36. Cursors: The values plugged into the DML in a FORALL must come from existing - populated _________.
collections
255
$$
optional

37. DBMS_DDL.CREATE_WRAPPED: wraps and _______ the source code passed to it.
anonymous
compiles
nested

38. The PL/SQL ________ evaluates compiler directives.
preprocessor
HTP
enclosing
wrap

39. Command to create a procedure.
EXCEPTION_INIT
r t.%ROWTYPE;
create procedure
RECORDS

40. In a collection - the internal components are called _______.
3
end
elements
PLSQL_CCFLAGS

41. Exceptions: PL/SQL exceptions are of two types: internal and _________.
user-defined
E Exception;
national
before insert or update on emps

42. Exceptions: You cannot GOTO from an exception handler back into the __________ block.
memory
procedure P AUTHID definer;
label
current

43. Kind of comment not to put in a PL/SQL block to be processed dynamically by an Oracle Precompiler program.
RECORD OF ARRAYS
:=
increment
single-line

44. Types: ________ data types have no internal components.
variable
scalar
exception handler
bind

45. A PL/SQL block that is not stored.
REF CURSOR
transaction
native dynamic
anonymous block

46. What are the two sequence pseudo-columns?
currval and nextval
can
DML
query

47. You can define PL/SQL collections using TYPEs defined in the _______.
INTO
database
UTL_SMTP
definer's

48. Cursors: A cursor variable's type must be a ____ ______ type.
%BULK_ROWCOUNT
once
REF CURSOR
'ENABLE:SEVERE' - 'ERROR:06002'

49. I/O: The most basic PL/SQL way to give output to the user.
dbms_output.put_line
vname CONSTANT VARCHAR2 := 'x';
compilation
anonymous

50. I/O: One of the 3 types of data stored in the DBMS_OUTPUT buffer.
portable
DATE
hardware
BINARY_INTEGER