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. Cursors: A cursor that lives in session memory until the session ends.
%
session cursor
LOOP - END LOOP
bind

2. Bulk: The implicit cursor attribute that gives the number of rows affected by each DML statement in a FORALL statement.
%BULK_ROWCOUNT
DECLARE - BEGIN - EXCEPTION - END
not a number
concatenation

3. A type of compiler directive - begins with 'e'.
error
-
scalable
compile

4. Types: A data type family consists of a ______ type and its subtypes.
DATE
base
DBMS_SESSION
run

5. Exceptions: The built-in procedure for raising an application-defined error.
exception handler
raise_application_error
UTL_SMTP
finishes

6. Declare a variable r whose type is that of the records in table t.
sql
DBMS_PIPE
anonymous
r t.%ROWTYPE;

7. Cursors: What implicit cursor attribute gives row counts for a FORALL statement?
can
in the database
%BULK_ROWCOUNT
cannot

8. Exceptions: The _________ package defines the PL/SQL environment.
multi-row
manageable
STANDARD
comments

9. Keyword for doing assignment to a variable with SELECT.
can
cannot
INTO
fetch cv into myvar

10. In a sparse collection - the indexes of defined elements (do / do not) run in consecutive order.
error
do not
1
can

11. I/O: This DBMS_OUTPUT proc retrieves multiple lines from the buffer.
CURRENT OF
nested
GET_LINES
RETURN

12. PLSQL_CCFLAGS hold a comma-separated list of ______ pairs (hyphenated).
FETCH - INTO
name-value
lowest
lower sub-block

13. Triggers: You create a trigger with the _______ ________ statement.
IS
cursor
CREATE TRIGGER
SQL

14. The Wrap utility (does / does not) encrypt source code.
constrained
pseudocolumn
does not
autonomous transaction

15. Web: PL/SQL _____ _______ lets you to develop Web applications made of PL/SQL procedures.
TYPE rec IS RECORD (num NUMBER - name VARCHAR2(10));
Web Toolkit
PVM
can

16. Triggers: The clause to make a trigger run before inserting or updating table EMPS.
production
does not
STANDARD
before insert or update on emps

17. Cursors: Give the statement to open cursor C.
cannot
open C
*/
IN

18. Cursors: A session cursor that is automatically created and managed by PL/SQL.
fail
run
implicit cursor
TYPE tN IS TABLE of NUMBER

19. A record is a group of related data items stored in fields - each with its own...
name and datatype
CASE_NOT_FOUND
3
names

20. The 2 characters that begin all inquiry directives.
TIMESTAMP.
aggregate - analytical
$$
EXECUTE

21. Default value of PLSQL_OPTIMIZE_LEVEL.
cursor c RETURN rC;
inquiry
2
REF CURSOR

22. Triggers: In a per-row trigger - the ____ record shows you the changed state of an affected row.
NEW
static
variable
REF_CURSOR

23. I/O: If the current (outermost) PL/SQL block ends with an unhandled exception - the output buffer will not be ___________.
dbms_output.put_line
flushed
hardware
ordinary

24. Which two collection types are unbounded?
an enclosing block
for update of
nested tables - associative arrays
-20 -000

25. Types: One of the 4 PL/SQL things that have a data type (begins with 'c').
machine
concatenation
Ada
constant

26. Delimiters: Single-line comment marker.
FOR i IN REVERSE 1..10 - LOOP - NULL; END LOOP;
suspended
cannot
-

27. Statement to exit a cursor loop on cursor cGo when there are no more records.
FETCH
exit when cgo%NOTFOUND
OLD
$IF

28. By default - OUT and IN OUT parameters are passed by _____.
True
DML
value
Wrap

29. Wrap ______=xxxx oname=zzzzz
iname
EXTEND
EDITION_NAME
bb:true

30. Abbreviation of invoker's rights
IN
dynamic
IR
plb

31. IDs: The 3 non-alphanumeric characters that can be in an ordinary user-defined identifier.
view
# - $ - _
BINARY_INTEGER
CHARARR

32. To recompile a procedure - use the _____ ______ command.
$$PLSQL_LINE
alter procedure
literal
selection

33. In the IF syntax - is if ENDIF or END IF?
does not
return value
END IF
DATE '2005-12-25'

34. I/O: Max number of bytes to pass in a call to DBMS_OUTPUT.PUT_LINE.
255
Keywords and predefined names.
elements
*/

35. Abbreviation for Abstract Data Type.
COMMIT - ROLLBACK - SAVEPOINT - SET TRANSACTION
vname CONSTANT VARCHAR2 := 'x';
integrated
ADT

36. Cursors: Which cursor attribute is not meaningful for an implicit cursor?
RETURN
cannot
%ISOPEN.
EXIT WHEN

37. Wrap iname=xxxx _____=zzzzz
oname
FOR i IN REVERSE 1..10 LOOP
SUBTYPE numb IS number;
ROLLBACK

38. The values defined in PLSQL_CCFLAGS can be referenced as _____ directives.
$$PLSQL_LINE
FETCH
inquiry
cannot

39. SIMPLE_INTEGER is like PLS_INTEGER - but it does not allow ____ values - and it does not raise overflow exceptions.
Keywords and predefined names.

implicit
*/

40. What word is in a function header but not in a procedure header?
multi-row
execute immediate
transaction
RETURN

41. Java - C or other program called directly in PL/SQL.
bind
for update of
invoker's
external subprogram

42. I/O: This package lets PL/SQL programs read and write OS files.
ALTER SESSION
:=
PRAGMA AUTONOMOUS_TRANSACTION;
UTL_FILE

43. Fundamental: What are the 3 compound symbols for 'not equal to'?
OPEN_CURSOR
SESSION_USER
<> - != - ^=
definition

44. A __________ can have an AUTHID property
package
OTHERS
implicit CASE_NOT_FOUND exception
RESULT_CACHE

45. FOR-Looping over a collection from FIRST to LAST only works if the collection is _______.
cannot
constructor
RETURN
dense

46. How many PL/SQL collection types are there?
3
FOR i IN REVERSE 1..10 - LOOP - NULL; END LOOP;
SQL
DATE '2005-12-25'

47. I/O: The most basic PL/SQL way to give output to the user.
literal
dbms_output.put_line
suspended
scalar

48. Delimiters: Statement terminator.
enabled
;
select
Web Toolkit

49. The four keywords that define a PL/SQL block.
name and datatype
lower sub-block
%BULK_ROWCOUNT
DECLARE - BEGIN - EXCEPTION - END

50. Cursors: The value of SQL%ROWCOUNT after a SELECT INTO statement returns more than one row.
1
5
%TYPE
value