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. A user-defined TYPE can have...
$IF
an AUTHID property
255
%FOUND - %ISOPEN - %NOTFOUND - %ROWCOUNT

2. Packaged constants can synchronize programs through use in _______ directives.
compiles
selection
set serveroutput on
oname

3. I/O: Max number of bytes to pass in a call to DBMS_OUTPUT.PUT_LINE.
IR
FGA
/*
255

4. Term for a character literal with zero characters.
SUBTYPE numb IS number;
Declaration
RELIES_ON
null string

5. The $IF must evaluate a ______ _______ expression.
alter procedure
r tRec := tRec(9 - 'Jones');
SYS_REFCURSOR
static boolean

6. An ordinary character literal is composed of characters in the ________ character set.
@
ALTER SESSION
1 million
database

7. If none of a CASE expression's conditions are TRUE - it returns _____.
1

slower
TYPE rec IS RECORD (num NUMBER - name VARCHAR2(10));

8. INSTEAD OF triggers are alternatives to ___ triggers
DML
EXIT WHEN
is
exception

9. The Wrap utility (does / does not) encrypt source code.
database
512
does not
cannot

10. User-defined compiler directives are defined in this system compile parameter.
;
IN
anonymous block
PLSQL_CCFLAGS

11. An $ERROR directive ends with _____.
TYPE tV IS VARRAY(100) OF NUMBER
value
end
$END

12. Fundamental: Labels furnish targets for GOTO and _____ statements.
'ENABLE:SEVERE' - 'ERROR:06002'
Server Pages
EXIT
TYPE tV IS VARRAY(100) OF NUMBER

13. DynSQL: The main command for Native Dynamic SQL.
explicit
compilation

EXECUTE IMMEDIATE

14. A kind of variable used as a placeholder.
static boolean
source code
bind
error code

15. Exceptions: The package that defines pre-defined exceptions.
iname
finishes
PVM
STANDARD

16. Conversion: Implicit conversion is not always predictable; it is _______-sensitive. And its rules might change.
REUSE SETTINGS
1
FOR i IN REVERSE 1..10 LOOP
context

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

18. Associative array types (can / cannot) be defined in the database.
TRUE - FALSE - NULL
oname
closed
cannot

19. DynSQL: The colon-prefixed names used in EXECUTE IMMEDIATE are called ________.
FETCH - INTO
an AUTHID property
placeholders
bytecode

20. Type: An ________ subtype has all the values of its base type.
unconstrained
inquiry
increment
SUBTYPE numb IS number;

21. What are the starting and ending keywords of a simple loop?
USING
SQLERRM
LOOP - END LOOP
VARRAY - Nested table

22. DynSQL: EXECUTE IMMEDIATE does both dynamic SQL and dynamic _______.
SQLCODE
forward
:=
PL/SQL

23. Name the two types of FOR loop.
numeric and cursor
cursor variable
bind
varray

24. IDs: What a quoted user-defined identifier is enclosed in.
Double quotes.
dynamic
-
cannot

25. Exceptions: Write the call (2 args) to associate message 'Bad' with error code -20 -100.

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

26. Cursors: The second keyword of a FETCH statement.
cursor number
DECLARE - BEGIN - EXCEPTION - END
INTO
finishes

27. Package for getting the postprocessed source of a program.
DBMS_PREPROCESSOR
cannot
TRUE - FALSE and NULL
fetch C into V

28. The $ERROR directive is used to make compilation ____.
ex := tbl1 MULTISET EXCEPT tbl2
fail
-
REF CURSOR

29. DynSQL: The standard package that does dynamic SQL.
'
anonymous block
value
DBMS_SQL

30. In PL/SQL - what the variables in DML statements are turned into.
aggregate - analytical
bind arguments
<<>>
USER_PROCEDURES

31. Language that PL/SQL is derived from.
loop
Ada
%BULK_ROWCOUNT
OUT

32. If a procedure fails - an OUT parameter passed to it by value (will / will not) be passed back with changes.
cannot
will not
package
include

33. Which two collection types are unbounded?
error code
simple and compound symbols
nested tables - associative arrays
not a number

34. Characters that begin a multi-line comment.
/*
national
create
FOR - IN

35. I/O: The output from DBMS_OUTPUT will display (during/after) program execution.
ALTER SESSION
query
after
error code

36. I/O: This package has hypertext procedures that generate HTML tags
COUNT
USER_PROCEDURES
CURRENT OF
HTP

37. Set flag bb true: ALTER SESSION SET PLSQL_CCFLAGS= '____'
bb:true
vname CONSTANT VARCHAR2 := 'x';
increment
in the database

38. Delimiters: Statement terminator.
5
PRAGMA EXCEPTION_INIT (E - -1);
;
binding

39. Conditional ______ allows backward compability with older database versions.
invoker's
savepoint ab
compilation
expression

40. Delimiters: Item separator.
can
FALSE

With a letter.

41. The command used to populate PLSQL_CCFLAGS.
True - false or NULL.
ALTER SESSION
SQL cursor
USER_PLSQL_OBJECT_SETTINGS

42. Triggers: The clause to make a trigger run before inserting or updating table EMPS.
before insert or update on emps
composite
portable
fail

43. Types: The only PL/SQL type for which you can specify a range constraint.
CHAR - VARCHAR2
deletions
PLS_INTEGER
return value

44. Two types of stored subprograms.
fields
null string
procedure - function
hardware

45. Types: One of the scalar data types specific to PL/SQL: P________
<> - != - ^=
portable
PLS_INTEGER
execute immediate

46. The 4 keywords in the $IF compiler directive.
elements - type
TYPE t IS TABLE OF rPerson INDEX BY PLS_INTEGER;
E Exception;
$IF $THEN $ELSE $END

47. FOR-Looping over a collection from FIRST to LAST only works if the collection is _______.
include
dense
open C(p)
PVM

48. A nested table has to be initialized using a ________ - named the same as the type.
%
constructor
DEFINER
scalar

49. Native compilation turns bytecode into ________ code.
machine
base
DBMS_PREPROCESSOR
DBMS_SESSION

50. The FORALL statement to loop over a collection MyList using index i.
IN OUT
CHAR - VARCHAR2
FORALL i IN MyList.FIRST..MyList.LAST
'