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. CREATE TYPE cannot be used for _______ array types.
$$
'
name-value
associative

2. I/O: This DBMS_OUTPUT proc retrieves one line from the buffer.
GET_LINE
hardware
TYPE tV IS VARRAY(100) OF NUMBER
TYPE rec IS RECORD (num NUMBER - name VARCHAR2(10));

3. For a collection - the NEXT method gets the next higher (element / index).
index
error code
database
EXIT WHEN

4. Triggers: In a per-row trigger - the ____ record shows you the original state of an affected row.
DBMS_CRYPTO
does not
Server Pages
OLD

5. The $ERROR directive is used to make compilation ____.
fail
invoker's
unhandled
non-editioning views

6. Wrapped code (is / is not) not backward compatible.
pls_integer
is not
statement
must

7. The names of Java objects in Oracle can be up to __ characters in length.
FETCH - INTO
4K
exception handler
collections

8. Types: One of the 4 PL/SQL things that have a data type (begins with 'c').
Wrap
constant
OPEN_CURSOR
execute

9. Exceptions: Associate exception E with error code -1.
EXECUTE
True
:=
PRAGMA EXCEPTION_INIT (E - -1);

10. What do you FETCH from?
SYS_REFCURSOR
:=
transaction
a cursor

11. Cursors: A cursor FOR loop can use an explicit or an _______ cursor.
implicit
block
REF CURSOR
CREATE TRIGGER

12. Types: In addition to the SQL data types - PL/SQL has ___ more scalar data types.
order
4
-
commit - rollback

13. An editioning view can only select a subset of the columns from the base table and provide ________ for them
aliases
LOOP - END LOOP
mandatory
external subprogram

14. The LIMIT method is only meaningful for _______.
CREATE TYPE
network
VARRAYs
never

15. For an associative array - the FIRST method gets the (lowest / first-created) index.
definition
dynamic
lowest
EXIT

16. The compiler directive governing conditional compilation.
FETCH
statement
$IF
FOR - IN

17. Labels for blocks and statements are enclosed in '__' brackets.
WHERE CURRENT OF
IS
<<>>
colon

18. I/O: The most basic PL/SQL way to give output to the user.
dbms_output.put_line
Gateway
variable
TYPE tV IS VARRAY(100) OF NUMBER

19. The lowest index of a nested table is ___.
DBMS_SESSION
inclusive
transaction
1

20. Triggers: To simulate having triggers on SELECT statements - you can try ___ (3-letter acronym).
DML
FGA
end
network

21. Types: One of the scalar data types specific to PL/SQL: B_______
can
FETCH
BINARY_INTEGER
for each row

22. Types: Which type of arithmetic does NUMBER use - library or hardware?
sequence pseudo-columns
ADT
binding
library

23. IDs: What a quoted user-defined identifier is enclosed in.
hardware
Double quotes.
FETCH
for update of

24. Triggers: In a DML trigger - the phrase that makes the trigger run for every affected record.
for each row
enclosing
procedure P AUTHID current_user;
bytecode

25. You (can / cannot) wrap trigger source code.
is certain
execute
cannot
END

26. If an initialized collection has no elements - FIRST and LAST return _____.

composite
FETCH
suspended

27. Types: PL/SQL has all the _____ data types.
SQL
3
CLOSE_CURSOR
$IF

28. A GOTO statement cannot branch from an exception handler back into the...
GET_LINES
current BEGIN-END block
END LOOP
-

29. The AUTHID property applies to PL/SQL objects that contain _____.
bind
cannot
cursor
code

30. A unit with AUTHID = CURRENT_USER is an ________ rights unit.

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

31. Advantage: PL/SQL is tightly _______ with Oracle SQL.
2
integrated
GET_LINES
is certain

32. Declare a cursor c with no parameters - and return type rC.
inquiry
executable
cursor c RETURN rC;
END LOOP

33. The three possible values of a BOOLEAN literal.
is
True - false or NULL.
oname
..

34. Cursors: What are the 3 possible values of SQL%FOUND and SQL%NOTFOUND?
PRAGMA EXCEPTION_INIT (E - -1);
query
IF - CASE or LOOP
TRUE - FALSE - NULL

35. Advantage: Performance: Storing and runnng procedures on the server minimizes ______ traffic.
IF - CASE or LOOP
cannot
OLD
network

36. I/O: One of the 3 types of data stored in the DBMS_OUTPUT buffer.
constructor
invalid
DATE
invoker's

37. A __________ can have an AUTHID property

package
FETCH
an autonomous routine

38. A FOR-loop counter is defined only within the _____.
USER_PROCEDURES
<<
loop
Ordinary - Quoted.

39. Dbms_sql: The return type DBMS_SQL.open_cursor.
OPEN
DML
integer
literals

40. SIMPLE_INTEGER is like PLS_INTEGER - but it does not allow ____ values - and it does not raise overflow exceptions.
stored

DBMS_DDL
FETCH - BULK COLLECT INTO

41. I/O: The output from DBMS_OUTPUT will display (during/after) program execution.
after
literals
cannot
index

42. In the special IF syntax - is it ELSIF - or ELSEIF?
not the same
elsif
nested
SYS_CONTEXT

43. 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
machine code
closed
source code

44. The collection method that tells the number of elements in the collection.
after
COUNT
WHEN OTHERS THEN
loop

45. What is the exception that is implicitly raised in a CASE statement with no ELSE clause?
CASE_NOT_FOUND
aggregate - analytical
RECORDS
invoker's

46. The $IF must evaluate a ______ _______ expression.
static boolean
L.V
DATE '2005-12-25'
static

47. The EXCEPTION section is (optional/mandatory).
explicit
collections
order
optional

48. Advantage: PL/SQL gives SCALABILITY because stored procedures are executed on the _______.
server
DATE '2005-12-25'
elements
transaction

49. Types: A ______ has the same valid operations as its base type.
TYPE t IS TABLE OF rPerson INDEX BY PLS_INTEGER;
subtype
COMMIT - ROLLBACK - SAVEPOINT - SET TRANSACTION
cursor

50. How many times are a FOR loop's index bounds evaluated?
EXIT
once
statement
TYPE rec IS RECORD (num NUMBER - name VARCHAR2(10));