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. IDs: What a quoted user-defined identifier is enclosed in.
open C(p)
Double quotes.
plb
TYPE tN IS TABLE of NUMBER

2. Fundamental: One of the 4 types of lexical units: c_____.
statement
CLOSE_CURSOR
comments
close C

3. A PL/SQL block that is not stored.
create procedure
anonymous block
PLS_INTEGER
slower

4. Exceptions: The _________ package defines the PL/SQL environment.
EDITION_NAME
FGA
STANDARD
FETCH - BULK COLLECT INTO

5. A GOTO cannot branch into a...
suspended
DBMS_CRYPTO
Abstract
lower sub-block

6. The RESULT_CACHE clause comes (before / after) the RETURN clause.
after
production
bytecode
savepoint ab

7. Cursors: What implicit cursor attribute gives row counts for a FORALL statement?
DBMS_CRYPTO
%BULK_ROWCOUNT
national
scalar

8. Declare an output NUMBER parameter - v1 - that defaults to 10.
INTO
v1 OUT number default 10
cannot
index

9. Give the statement to make a program autonomous.
in the database
set serveroutput on
PRAGMA AUTONOMOUS_TRANSACTION;
sequence pseudo-columns

10. Conditional ______ allows backward compability with older database versions.
savepoint ab
compilation
PLS_INTEGER
unqualified

11. Types: ________ data types have internal components.
TIMESTAMP.
OUT
buffer
composite

12. What clause makes a compilation default to the PLSQL_CCFLAGS settings from the last compilation?
literal
code
REUSE SETTINGS
cannot

13. Cursors: The type definition of a WEAK ref cursor type has no _______ clause.
VARCHAR2
RETURN
mandatory
after

14. Cursors: The keyword that makes a ref cursor type STRONG.
CURRENT OF
RECORD OF ARRAYS
RETURN
always

15. Types: The only Oracle datetime type that doesn't begin with TIMESTAMP is ________.
delimiters
DATE
IF - CASE or LOOP
dynamic

16. Exceptions: PL/SQL exceptions are of two types: internal and _________.
STANDARD
FALSE
implicit
user-defined

17. IDs: You cannot use reserved words as ______ user-defined identifiers.
nested
DR
ordinary

18. Cursors: The SQL%BULK_ROWCOUNT attribute is an _________ -
array
TRUE - FALSE - NULL
scalar
USING

19. Keyword for doing assignment to a variable with SELECT.
INTO
PLS_INTEGER
CURSOR - RETURN - IS
cannot

20. Cursors: Give the statement to open cursor C.
statically
open C
network
1 million

21. A FOR loop can be indexed by numbers or by a ______.
NDS
FORALL i IN MyList.FIRST..MyList.LAST
cursor
Ada

22. Java - C or other program called directly in PL/SQL.
UTL_SMTP
SESSION_USER
*/
external subprogram

23. Pkgs: This procedure de-instantiates/resets all packages in this session.
DBMS_SESSION.RESET_PACKAGE
VARCHAR2
fetch cv into myvar
TIMESTAMP.

24. CREATE TYPE cannot be used for _______ array types.
STANDARD
execute immediate
associative
cannot

25. Cursors: A cursor FOR loop cannot use a _______ variable.
DBMS_PREPROCESSOR
index
delimiters
cursor

26. Cursors: An explicit cursor (can/cannot) accept parameters.
BOOLEAN
calls
CHAR - VARCHAR2
can

27. Set flag bb true: ALTER SESSION SET PLSQL_CCFLAGS= '____'
bb:true
scalable
a cursor
open C(p)

28. Web: PL/SQL _____ _______ lets you to develop Web applications made of PL/SQL procedures.
Web Toolkit
raise_application_error(-20 -100 - 'Bad');
compiles
NEW

29. Wrap ______=xxxx oname=zzzzz
anonymous block
bb:true
iname
REF CURSOR

30. Define a record variable r - of type tRec - initialized with values 9 and 'Jones' in its two fields.

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

31. I/O: This package has hypertext procedures that generate HTML tags
EXECUTE
1 million
static boolean
HTP

32. I/O: The DBMS_OUTPUT function that writes output without a newline character.
exit when cgo%NOTFOUND
PUT
timing
searched

33. The AUTHID property applies to PL/SQL objects that contain _____.
commit - rollback
code
executable
TYPE tN IS TABLE of NUMBER

34. Types: A data type family consists of a ______ type and its subtypes.
INTO
commit - rollback
END IF
base

35. ______ SQL is a PL/SQL feature that allows SQL syntax directly in a PL/SQL statement.
INTO
static
after insert on emps
view

36. Declare an unconstrained subtype of NUMBER called NUMB.
database
SQL
CLOSE_CURSOR
SUBTYPE numb IS number;

37. Give the value list in the PLSQL_WARNINGS parameter to turn on SEVERE compiler warnings and make compiler warning 06002 be an error.

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

38. In PL/SQL - what the variables in DML statements are turned into.
bind arguments
network
SQL
elements

39. Triggers: If two or more triggers are defined with the same timing point - then you can control the firing order using the ________ clause.
DBMS_SESSION
error code
external subprogram
follows

40. Exceptions: The ________ function returns the error message associated with an error code.
WHERE CURRENT OF
compiles
UTL_SMTP
SQLERRM

41. Types: One of the scalar data types specific to PL/SQL: B_______
elsif
after insert on emps
scalar
BINARY_INTEGER

42. To run TCL or DDL statements - a trigger (must / must not) be autonomous .
LOOP - END LOOP
subtype
must
value

43. The two kinds of CASE statements are simple and ________.
searched
binding
collections
FETCH - BULK COLLECT INTO

44. After the RESULT_CACHE clause - you can put a _________ clause to enable dependency-checking.
REF CURSOR
scalable
RELIES_ON
does not

45. Abbreviation of definer's rights
DR
unqualified
run
OPEN

46. (from inside a package) Declare a function f - that takes a number n - returns a number - and caches results - depending on table EMPS.
reference
function f (n number) return number result_cache relies_on (emps);
constant
COUNT

47. Fundamental: One of the 4 types of lexical units: L_____
identifiers
drop procedure
source
literals

48. Cursors: The first two keywords of a basic fetch statement.
FETCH - INTO
unconstrained
timing
single-line

49. Associative array types (can / cannot) be defined in the database.
cannot
open cv for
Apache
cached

50. A subprogram defined within another subprogram is a _______ subprogram.
associative
nested
cannot
END LOOP