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. Types: Which type of arithmetic does NUMBER use - library or hardware?
expression
32 -000
library
is not

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

3. In interpreted mode - the PL/SQL VM interprets the _________.
bytecode
lock
cursor variable
suspended

4. I/O: To make sure the DBMS_OUTPUT buffer will be flushed - put a WHEN ______ clause in the EXCEPTION section of your outer block.
USING
order
OTHERS
DML

5. Clause added to a cursor to use it with WHERE CURRENT OF.
simple and compound symbols
for update of
pls_integer
INTO

6. IDs: The 3 non-alphanumeric characters that can be in an ordinary user-defined identifier.
# - $ - _
scalable
an autonomous routine
create

7. Triggers: There are __ types of triggers.
5
CREATE TRIGGER
IN OUT
nested

8. The Wrap utility ________ the source code.
:=
obfuscates
scalable
v1 OUT number default 10

9. IDs: The two types of words that can - but should not - be used as user-defined identifiers.
binding
TOO_MANY_ROWS
Keywords and predefined names.
1

10. I/O: This package handles HTTP.
UTL_HTTP
1
RESULT_CACHE
DEFINER

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

12. PL/SQL is a ________ typed programming language.
Abstract
statically
cannot
FORALL and BULK COLLECT

13. The statement that is used to execute most (native) dynamic SQL.
nested
current transaction
hardware
execute immediate

14. Cursors: A cursor with a name is an _________ cursor.
r t.%ROWTYPE;
oname
same
explicit

15. Assigning values to PL/SQL variables that appear in SQL statements is called _______.
binding
*/
can
executable

16. Types: ________ data types have internal components.
REUSE SETTINGS
lower sub-block
invoker's
composite

17. The _____ and ____ _____ collection types can be used in database table columns.
variable
VARRAY - Nested table
Gateway
TYPE rec IS RECORD (num NUMBER - name VARCHAR2(10));

18. Collections are one of the two kinds of PL/SQL _______ data types.
cannot
autonomous transaction
composite
expression

19. True encryption is done with package __________.
Oracle
WHERE CURRENT OF
DBMS_CRYPTO
p.v

20. Make a FOR loop that executes NULL 10 times counting in reverse - using index i.
procedure - function
FOR i IN REVERSE 1..10 - LOOP - NULL; END LOOP;
current
static boolean

21. Fundamental: identifiers (include/do not include) reserved words.
invoker's
SQLERRM
bind
include

22. Triggers: The clause to make a trigger run before inserting or updating table EMPS.
FOR i IN REVERSE 1..10 LOOP
code
before insert or update on emps
cannot

23. INSTEAD OF triggers are alternatives to ___ triggers
machine
national
DML
same

24. A subprogram defined within another subprogram is a _______ subprogram.
nested
STANDARD
create
FETCH

25. _________ exceptions can not be trapped with an error handler
<> - != - ^=
a number := 10
Declaration
function f (n number) return number result_cache relies_on (emps);

26. PLS_INTEGER has its arithmetic implemented in ________ - so it is very fast.
cursor c;
cannot
hardware
DEFINER

27. User-defined compiler directives are defined in this system compile parameter.
PLSQL_CCFLAGS
CURRENT_USER
NUMBER
code

28. Delimiters: Statement terminator.
;
IS
explicit cursor
STANDARD

29. Delimiters: Item separator.

SESSION_USER
=>
SQL

30. Types: The only PL/SQL type for which you can specify a range constraint.
associative
PLS_INTEGER
label
after insert on emps

31. What clause makes a compilation default to the PLSQL_CCFLAGS settings from the last compilation?
REUSE SETTINGS
exception handler
anonymous
1

32. Wrap iname=xxxx _____=zzzzz
searched
associative
oname
optional

33. The FIRST method gets the first (element / index) of a collection.
executable
order
fetch C into V
index

34. The default value of the AUTHID property.
follows
unqualified
DEFINER
PL/SQL

35. Triggers and views always have _________ rights.

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

36. Cursors: Give the statement for getting out of a FETCH loop for cursor CV.
FOR i IN REVERSE 1..10 - LOOP - NULL; END LOOP;
4K
nested
EXIT WHEN cv%NOTFOUND

37. Characters that begin a multi-line comment.
TIMESTAMP.
/*
TYPE rec IS RECORD (num NUMBER - name VARCHAR2(10));
cannot

38. The variable showing the user id of the session owner.
DBMS_SESSION
current BEGIN-END block
IN OUT
SESSION_USER

39. If an initialized collection has no elements - FIRST and LAST return _____.
value
executable

can

40. Conversion: Just about everything will implicitly convert to _____ or _________.
error code
CHAR - VARCHAR2
obfuscates
scalar

41. Exceptions: The maximum length of an Oracle error message is ____ characters
USER_PROCEDURES
collections - records
512
OLD

42. PL/SQL lets you define two kinds of composite data types: _______ and _______
4K
collections - records
associative
FOR UPDATE

43. The valid values of the AUTHID property.
INTO
255
can
CURRENT_USER - DEFINER

44. Types: A ______ has the same valid operations as its base type.
DR
native dynamic
CHARARR
subtype

45. Set flag bb true: ALTER SESSION SET PLSQL_CCFLAGS= '____'
exit when cgo%NOTFOUND
bb:true
current BEGIN-END block
cursor

46. Cursors: Give the statement to fetch data from cursor C into variable V.
fetch C into V
FGA
before insert or update on emps
NEW

47. Package for getting the postprocessed source of a program.
portable
DBMS_PREPROCESSOR
-
HTF

48. I/O: The output from DBMS_OUTPUT will display (during/after) program execution.
for update of
placeholders
<<
after

49. A CASE expression ends with _____.
not the same
END
HTP
dbms_output.put_line

50. Exceptions: A GOTO statement CAN branch from an exception handler into an ________ block.
associative
constrained
return value
enclosing