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. In a collection - the internal components always have the _____ data type.
UTL_FILE
same
DECLARE - BEGIN - EXCEPTION - END
associative arrays

2. You (can/cannot) put a label before an END LOOP statement.
cannot
reference
significant
selection

3. DBMS_DDL.WRAP returns a string containing wrapped _____ _____.
include
source code
dbms_output.put_line
suspended

4. A type of compiler directive - begins with 'e'.
COUNT
error
RETURN
same

5. Setting CURRENT_SCHEMA only changes what is prepended to __________ references.
unqualified
collections - records
BOOLEAN
fields

6. Default file extension of wrap's input file.
an autonomous routine
DBMS_PREPROCESSOR
FETCH - BULK COLLECT INTO
sql

7. Delimiters: The component indicator/selector.
2
timing
increment
.

8. Language that PL/SQL is derived from.
Apache
label
Ada
SIMPLE_INTEGER

9. The $ERROR directive is used to make compilation ____.
fail
STANDARD
anonymous
literals

10. I/O: This package lets two or more sessions in the same instance communicate.
END CASE
TOO_MANY_ROWS
DBMS_PIPE
CURRENT OF

11. Command to make a no-op (omit semicolon).
USER_PLSQL_OBJECT_SETTINGS
cannot
procedure P AUTHID definer;

12. Advantage: Performance: Storing and runnng procedures on the server minimizes ______ traffic.
REF_CURSOR
variable
network
anonymous

13. Delimiters: Statement terminator.
;
versions
SQL
virtual machine

14. An incomplete type is a type created by a ______ type definition.
TOO_MANY_ROWS
machine
forward
30

15. Cursors: Give the statement to close cursor C.
# - $ - _
close C
statement
CURSOR - RETURN - IS

16. The variable showing the user id of the session owner.
lowest
SESSION_USER
bind
scalar

17. Conversion: Just about everything will implicitly convert to _____ or _________.
FORALL and BULK COLLECT
column
CHAR - VARCHAR2
package

18. Triggers: In a trigger - you cannot issue a COMMIT or a ______.
ROLLBACK
create
never
DBMS_SESSION

19. Delimiters: Item separator.
exception

INTO
include

20. Cursors: The first two keywords of a basic fetch statement.
calls
ADT
FETCH - INTO
STANDARD

21. Which two of these built-in SQL functions can be used in procedural (PL/SQL) statements: DECODE - CORR - UPPER - SUM - COALESCE - DEREF.
DBMS_OUTPUT
national
IN OUT
upper - coalesce

22. Labels for blocks and statements are enclosed in '__' brackets.
package
definer's
<<>>
cursor c;

23. Define a nested table type - tN - which is a table NUMBERs.
upper - coalesce
TYPE tN IS TABLE of NUMBER
Server Pages
do not

24. What are the 3 values of the BOOLEAN data type?
GET_LINES
national
TRUE - FALSE and NULL
cursor number

25. The SET TRANSACTION statement affects only the ____________.
v2 IN NUMBER default 20
hardware
current transaction
NESTED TABLE myColl STORE AS myCollTab

26. Cursors: A cursor that lives in session memory until the session ends.
can
implicit CASE_NOT_FOUND exception
Ada
session cursor

27. Cursors: A cursor FOR loop can use an explicit or an _______ cursor.
implicit
EVERE - PERFORMANCE - INFORMATIONAL
can
savepoint ab

28. Loops: What is the index range operator in a FOR loop?
..
USER_PLSQL_OBJECT_SETTINGS
cannot
currval and nextval

29. A (simple / searched) CASE statement begins with CASE <expression>.
simple
IR
TYPE rec IS RECORD (num NUMBER - name VARCHAR2(10));
PL/SQL

30. Give the ANSI Date literal for December 25 - 2005.

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

31. Which two collection types are unbounded?
fields
exception handler
p.v
nested tables - associative arrays

32. I/O: To make sure the DBMS_OUTPUT buffer will be flushed - put a WHEN ______ clause in the EXCEPTION section of your outer block.
OTHERS
CREATE TRIGGER
numeric and cursor
execute

33. In interpreted mode - PL/SQL code is run in a _______ _______.
VARRAYs
virtual machine
<> - != - ^=
invoker's

34. Dbms_sql: The integer returned by OPEN_CURSOR is a _____ _____.
slower
cursor number
timing
PVM

35. The BETWEEN operator is (inclusive / exclusive).
4
inclusive
injection
RETURN

36. Declare an output NUMBER parameter - v1 - that defaults to 10.
SQL cursor
anonymous
v1 OUT number default 10
DBMS_PIPE

37. I/O: This package handles HTTP.
UTL_HTTP
in the database
cursor
create procedure

38. A null string and a BOOLEAN null are _______ (same/not the same).
not the same
VARCHAR2
aggregate - analytical
DML

39. Types: One of the 4 PL/SQL things that have a data type (begins with 'v').
collections
plb
variable
DBMS_PIPE

40. I/O: The buffered output of dbms_output.put_line is retrieved by _______.
static
SQLPlus
implicit cursor
1

41. Dbms_sql: DBMS_SQL package is compiled with _______ rights.

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

42. I/O: Max number of bytes to pass in a call to DBMS_OUTPUT.PUT_LINE.
COMMIT - ROLLBACK - SAVEPOINT - SET TRANSACTION
255
calls
implicit

43. Types: One of the scalar data types specific to PL/SQL: P________
$$PLSQL_LINE
error code
PLS_INTEGER
hardware

44. Triggers and views always have _________ rights.

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

45. A numeric FOR loop cannot _________ by other than 1?
timing
reference
increment
explicit

46. To run a PIPE ROW statement in your autonomous routine - you must close any _____________.
associative
END LOOP
%
autonomous transaction

47. Exceptions: Start of the range of error codes for RAISE_APPLICATION_ERROR.
quoted
-20 -000
manageable
END LOOP

48. Exceptions: You cannot GOTO from an exception handler back into the __________ block.
upper - coalesce
network
anonymous
current

49. Cursors: You cannot use cursor attributes in _______ statements.
Server Pages
SQL
unconstrained
definition

50. IDs: Maximum number of bytes in a user-defined identifier.
30
IS
DEFINER
PRAGMA EXCEPTION_INIT (E - -1);