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. To enable result-caching for a function - use the _____________ clause.
non-editioning views
RESULT_CACHE
=>
INSTEAD OF

2. In interpreted mode - PL/SQL code is run in a _______ _______.
integer
virtual machine
select
PL/SQL

3. Pkgs: The _______ package gives access to such SQL things as ALTER SESSION.
32 -000
view
package
DBMS_SESSION

4. The FOR UPDATE OF clause references a (table / column).
column
EXECUTE IMMEDIATE
SQL
TYPE tA IS TABLE OF NUMBER INDEX BY VARCHAR2(20)

5. PLS_INTEGER has its arithmetic implemented in ________ - so it is very fast.
value
hardware
exit when cgo%NOTFOUND
network

6. I/O: This package has hypertext functions that generate HTML tags
order
5
current transaction
HTF

7. The LIMIT method is only meaningful for _______.
1
DML
VARRAYs
cursor

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

9. What is the exception that is implicitly raised in a CASE statement with no ELSE clause?
database
CASE_NOT_FOUND
NESTED TABLE myColl STORE AS myCollTab
1

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

11. Types: ________ data types have no internal components.
FOR UPDATE
scalar
CHAR - VARCHAR2
national

12. Exceptions: PL/SQL exceptions are of two types: internal and _________.
do not
enclosing
server
user-defined

13. Cursors: An explicit cursor (can/cannot) accept parameters.
can
PLS_INTEGER
lower sub-block
wrap

14. Fundamental: One of the 4 types of lexical units: d_____
delimiters
cannot
alter procedure
OTHERS

15. Keyword for doing assignment to a variable with SELECT.
not a number
literals
r t.%ROWTYPE;
INTO

16. Cursors: The keyword that makes a ref cursor type STRONG.
statically
RETURN
identifiers
mandatory

17. Triggers: In a per-row trigger - the ____ record shows you the original state of an affected row.
OLD
unconstrained
IN - OUT - IN OUT
FORALL and BULK COLLECT

18. PLSQL_CCFLAGS hold a comma-separated list of ______ pairs (hyphenated).
commit - rollback
inquiry
DML
name-value

19. The EXCEPTION section is (optional/mandatory).
rollback to ab
RAISE
procedure P AUTHID current_user;
optional

20. Dbms_sql: The return type DBMS_SQL.open_cursor.
include
Gateway
integer
timing

21. Web: mod_plsql is an implementation of the PL/SQL _________.
can
Gateway
order
EXIT

22. Exceptions: An exception raised inside an _______ _______ propagates immediately to the enclosing block
manageable
exception handler
FETCH
DML

23. GOTO branches to a ________.
label
EXECUTE
SYS_CONTEXT
virtual machine

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

25. I/O: One of the 3 types of data that can be passed to the DBMS_OUTPUT buffer.
VARCHAR2
elsif
RECORDS
invoker's

26. Types: PL/SQL has all the _____ data types.
simple
SQL
cannot
%TYPE

27. Simple CASE statement checks for different values of a single _________
INSTEAD OF
/*
never
expression

28. Fundamental: What is the exponentiation operator?
**
FOR i IN REVERSE 1..10 LOOP
lowest
suspended

29. Delimiters: Item separator.
-

OPEN
same arguments

30. Advantage: Having procedures stored and executed on the server makes PL/SQL ________.
Double quotes.
not the same
scalable
cannot

31. The Wrap utility ________ the source code.
procedure - function
open C
obfuscates
TIMESTAMP.

32. Official acronym for PL/SQL's runtime engine.
PVM
LOOP - END LOOP
GET_LINE
bytecode

33. TCL: Create a savepoint called ab
flushed
in the database
savepoint ab
IN

34. Statement to exit a cursor loop on cursor cGo when there are no more records.
IR
1
exit when cgo%NOTFOUND
not the same

35. DynSQL: In EXECUTE IMMEDIATE - the statement string can use either placeholders - or string ________.
%BULK_ROWCOUNT
iname
concatenation
elsif

36. Delimiters: Statement terminator.
Ordinary - Quoted.
CREATE TRIGGER
;
for update of

37. If a procedure fails - an OUT parameter passed to it by value (will / will not) be passed back with changes.
selection
base
nested tables - associative arrays
will not

38. Exceptions: Each internal exception has an Oracle ______ _______.
end
DML
query
error code

39. Nested tables are multisets - meaning that there is no inherent _____ of their elements.
order
%TYPE
1
dynamic

40. Triggers: The clause to make a trigger run once for every affected row.
disable
return value
optional
for each row

41. Cursors: The two keywords in a mere cursor declaration (one is optional).
timing
identifiers
finishes
CURSOR - RETURN

42. Triggers: To simulate having triggers on SELECT statements - you can try ___ (3-letter acronym).
hardware
hardware
FGA
null string

43. An $ERROR directive ends with _____.
$END
RECORDS
dynamic
can

44. A FOR-loop counter is defined only within the _____.
loop
DBMS_DDL
return value
%FOUND - %ISOPEN - %NOTFOUND - %ROWCOUNT

45. NAN stands for _________.
..
not a number
finishes
cannot

46. Characters that begin a single-line comment.
index
simple
E Exception;
-

47. An editioning view is like an ____ for a table.
source
SYS_CONTEXT
API
query

48. To run a PIPE ROW statement in your autonomous routine - you must close any _____________.
once
open C
autonomous transaction
enclosing

49. Exceptions: When an exception is raised inside a cursor FOR loop - the cursor is _______ implicitly.
1
closed
%FOUND - %ISOPEN - %NOTFOUND - %ROWCOUNT
name and datatype

50. A (simple / searched) CASE statement begins with CASE WHEN <boolean expression>.
information that changes infrequently
searched
IN
*/