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. Exceptions: Declare an exception called E.
E Exception;
inquiry
SYS_REFCURSOR
USING

2. Types: In addition to the SQL data types - PL/SQL has ___ more scalar data types.
after
can
4
IN - OUT - IN OUT

3. An autonomous program runs in its own __________.
SQL
transaction
TIMESTAMP.
API

4. Exceptions: The _________ package defines the PL/SQL environment.
WHERE CURRENT OF
autonomous transaction
STANDARD
server

5. %ROWTYPE gets the type of a table or _______.
cursor
TYPE tV IS VARRAY(100) OF NUMBER
END LOOP
autonomous triggers

6. The RESULT_CACHE clause has to be in both the declaration and in the ______ of the function.
strong
DML
definition
IN OUT

7. Triggers: Programmers (as opposed to DBAs) mostly make use of _____ triggers.
hardware
network
DML
%FOUND - %ISOPEN - %NOTFOUND - %ROWCOUNT

8. Web: PL/SQL ______ ______ (PSPs) let you develop web pages with dynamic content.
Server Pages
PLS_INTEGER
SESSION_USER
explicit cursor

9. Cursors: The first two keywords in a Cursor FOR loop.
SQL
always
definition
FOR - IN

10. Cursors: The values plugged into the DML in a FORALL must come from existing - populated _________.
fields
FALSE
name-value
collections

11. Cursors: Give the first 3 words to open a cursor variable called cv.
dynamic
CURSOR - RETURN
open cv for
propagates

12. Triggers: The code in a trigger is actually an ________ block.
REF CURSOR
anonymous
finishes
v1 OUT number default 10

13. Delimiters: The component indicator/selector.
.
OLD
an AUTHID property
inquiry

14. Cursors: How many implicit cursors can you access?
searched
1
$IF
<> - != - ^=

15. An INSTEAD OF trigger specifies what to do instead of a ___ statement.
UTL_FILE
DML
after insert on emps
cursor

16. PL/SQL lets you define two kinds of composite data types: _______ and _______
collections - records
'ENABLE:SEVERE' - 'ERROR:06002'
dense
DEFINER

17. Data dictionary view giving the AUTHID values on a user's objects.
database
ex := tbl1 MULTISET EXCEPT tbl2
USER_PROCEDURES
CURRENT OF

18. A unit with AUTHID = DEFINER is a ________ rights unit.

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

19. Where an external subprogram is stored.
in the database
savepoint ab
scalar
definition

20. I/O: This package handles HTTP.
an autonomous routine
simple and compound symbols
UTL_HTTP
query

21. Cursors: What implicit cursor attribute gives row counts for a FORALL statement?
%BULK_ROWCOUNT
$IF
EXIT WHEN
associative

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

23. Give the first line of the FOR loop with index i going from 1 to 10 in reverse.
end
FOR i IN REVERSE 1..10 LOOP
FETCH - INTO
WHERE CURRENT OF

24. DynSQL: EXECUTE IMMEDIATE can be used for any SQL statement or PL/SQL block - except for ________ queries.
Double quotes.
multi-row
Reserved words.
RECORD OF ARRAYS

25. Bulk: The keywords of a bulk collect FETCH statement.
FETCH - BULK COLLECT INTO
cursor
SESSION_USER
END CASE

26. To create a collection type - use the TYPE command in PL/SQL and the ______ _____ command in SQL.
exception handler
CREATE TYPE
static
2

27. The source for wrapping begins with the word ______.
Ada
<> - != - ^=
create
NUMBER

28. To run TCL or DDL statements - a trigger (must / must not) be autonomous .
must
collections - records
bind
EXECUTE

29. Fundamental: identifiers (include/do not include) reserved words.
invoker's
PUT
DML
include

30. The Wrap utility (does / does not) encrypt source code.
does not
DATE '2005-12-25'
source
SQLERRM

31. Make a FOR loop that executes NULL 10 times counting in reverse - using index i.
CLOSE_CURSOR
FOR i IN REVERSE 1..10 - LOOP - NULL; END LOOP;
code
ENABLE

32. A PL/SQL block that is not stored.
integrated
boolean
anonymous block
IN - OUT - IN OUT

33. Cursors: The three keywords in a full cursor declaration/definition (before the SELECT).
iname
CURSOR - RETURN - IS
TYPE tN IS TABLE of NUMBER
anonymous block

34. Unlike the CASE statement - the CASE expression does not have the...
USER_PLSQL_OBJECT_SETTINGS
32 -000
implicit CASE_NOT_FOUND exception
PUT_LINE

35. Which two of these built-in SQL functions can be used in procedural (PL/SQL) statements: DECODE - CORR - UPPER - SUM - COALESCE - DEREF.
implicit CASE_NOT_FOUND exception
vname CONSTANT VARCHAR2 := 'x';
upper - coalesce
collections - records

36. Delimiters: Host variable indicator.
WHERE CURRENT OF
...
integer
subtype

37. NAN stands for _________.
user-defined
not the same
transaction
not a number

38. Wrap ______=xxxx oname=zzzzz
portable
/*
iname
same arguments

39. Cursors: SYS_REFCURSOR is a predefined type based on _____ ______.
REF CURSOR
TYPE tV IS VARRAY(100) OF NUMBER
identifiers
1

40. Exceptions: The package that defines pre-defined exceptions.
STANDARD
DBMS_PREPROCESSOR
%TYPE
...

41. Cursors: Statement to end a loop when MyCur is used up: _____ ______ MyCur%NOTFOUND.
WHEN
SESSION_USER
EXIT WHEN
RELIES_ON

42. Exceptions: A GOTO statement cannot branch into an _______ ________.
buffer
query
exception handler
-20 -000

43. Mode designation for an output parameter.
$IF
OUT
forward
close C

44. I/O: This package does email.
Declaration
unhandled
-20 -000
UTL_SMTP

45. A nested table has to be initialized using a ________ - named the same as the type.
EXECUTE IMMEDIATE
NUMBER
constructor
searched

46. Exceptions: Pragma that links an exception to an Oracle error code.
1
column
EXCEPTION_INIT
network

47. FOR-Looping over a collection from FIRST to LAST only works if the collection is _______.
UTL_SMTP
IN - OUT - IN OUT
dense
simple

48. Types: ________ data types have no internal components.
scalar
preprocessor
USING
context

49. Cursors: The index variable in a cursor FOR loop (does/does not) need to be declared.
ex := tbl1 MULTISET EXCEPT tbl2
composite
associative
does not

50. The LIMIT method is only meaningful for _______.
slower
VARRAYs
PLSQL_CCFLAGS
column