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. TCL: Create a savepoint called ab
%BULK_ROWCOUNT

savepoint ab
EXIT

2. Define a record type REC with number num and varchar2(10) name.
enabled
an AUTHID property
TYPE rec IS RECORD (num NUMBER - name VARCHAR2(10));
1

3. What is the exception that is implicitly raised in a CASE statement with no ELSE clause?
EXECUTE
implicit
CASE_NOT_FOUND
EXIT WHEN

4. 5 types of events that can have triggers: DML - DDL - INSTEAD OFs - database events - and ________ statements.
statement
:=
suspended
TRUE - FALSE and NULL

5. CREATE TYPE cannot be used for _______ array types.
flushed
associative
database
EXTEND

6. Exceptions: When an exception is raised inside a cursor FOR loop - the cursor is _______ implicitly.
procedure P AUTHID current_user;
closed
enabled
cursor number

7. A numeric FOR loop cannot _________ by other than 1?
sql
$IF
lower sub-block
increment

8. A result-cached function caches its results in the _____ _____ ____ (SGA)
system global area
current
DBMS_SQL
TRUE - FALSE and NULL

9. By default - an IN parameter is passed by ______.
WHERE CURRENT OF
=
reference
savepoint ab

10. Associative array types (can / cannot) be defined in the database.
cannot
DML
True - false or NULL.
significant

11. Advantage: PL/SQL runs anywhere Oracle runs - so it is very ________.
PUT
function f (n number) return number result_cache relies_on (emps);
portable
lock

12. Exceptions: Start of the range of error codes for RAISE_APPLICATION_ERROR.
1
an autonomous routine
3
-20 -000

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

14. The method to add one or more elements to a nested table or VARRAY is ______.
machine code
EXTEND
significant
order

15. You can define PL/SQL collections using TYPEs defined in the _______.
searched
flushed
database
DR

16. Web: PL/SQL ______ ______ (PSPs) let you develop web pages with dynamic content.
Server Pages
executable
value
optional

17. Delimiters: the attribute indicator.
finishes
%
statement
30

18. The $ERROR directive is used to make compilation ____.
simple
TIMESTAMP.
constant
fail

19. Cursors: How many DML statements can a FORALL statement contain?
1
definition
fine-grained auditing
nested

20. A nested table has to be initialized using a ________ - named the same as the type.
constructor
multi-row
database
pls_integer

21. In the special IF syntax - is it ELSIF - or ELSEIF?
REF CURSOR
*/
same
elsif

22. The EXTEND method is not used with ______ _______.
associative arrays
system global area
1
flushed

23. A PL/SQL extension to the WHERE clause of the SQL statements UPDATE and DELETE
is not
quoted
TRUE - FALSE and NULL
WHERE CURRENT OF

24. After the RESULT_CACHE clause - you can put a _________ clause to enable dependency-checking.
RELIES_ON
$END
function f (n number) return number result_cache relies_on (emps);
after

25. I/O: This DBMS_OUTPUT proc retrieves multiple lines from the buffer.
$IF
PUT
fail
GET_LINES

26. Define a collection type - tV - which is a varray of 100 NUMBERs.
PSP
composite
Declaration
TYPE tV IS VARRAY(100) OF NUMBER

27. If an initialized collection has no elements - FIRST and LAST return _____.

%
SUBTYPE numb IS number;
TRUE - FALSE and NULL

28. _____ arrays cannot be used as the type of an Oracle table column.
object
associative
loop
create

29. An $ERROR directive ends with _____.
$END
v1 OUT number default 10
name
anonymous

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. Web: PL/SQL _____ _______ lets you to develop Web applications made of PL/SQL procedures.
REF_CURSOR
:=
cursor c RETURN rC;
Web Toolkit

32. An incomplete type only has a ____.
FALSE
collections
1
name

33. Exceptions: The three words that can be used to guarantee all exceptions will be handled.
EXIT WHEN cv%NOTFOUND
end
cursor c;
WHEN OTHERS THEN

34. Characters that end a multi-line comment.
inquiry
*/
an AUTHID property
stored

35. Dbms_sql: The DBMS_SQL procedure that will execute a DDL or DML statement.
execute
PL/SQL Gateway
delimiters
WHERE CURRENT OF

36. Dbms_sql: The return type DBMS_SQL.open_cursor.
integer
pls_integer
autonomous transaction
FGA

37. The command used to populate PLSQL_CCFLAGS.
searched
v2 IN NUMBER default 20
bind arguments
ALTER SESSION

38. Data dictionary view giving the AUTHID values on a user's objects.
bind
open C
LOOP - END LOOP
USER_PROCEDURES

39. Cursors: Give the statement to close cursor C.
close C
cursor
NDS
ordinary

40. The three possible values of a BOOLEAN literal.
$IF $THEN $ELSE $END
True - false or NULL.
suspended
oname

41. You cannot bulk collect into an ARRAY OF ________.
package
TYPE tA IS TABLE OF NUMBER INDEX BY VARCHAR2(20)
RETURN
RECORDS

42. I/O: This DBMS_OUTPUT proc retrieves one line from the buffer.
GET_LINE
library
loop
numeric and cursor

43. Types of blocks: Procedures and functions are _______ blocks.
inquiry
block
E Exception;
stored

44. Mode designation for an input/output parameter.
CHAR - VARCHAR2
IN OUT
in the database
512

45. A null string and a BOOLEAN null are _______ (same/not the same).
not the same
OUT
versions
Oracle

46. Advantage: Performance: PL/SQL automatically creates ______ variables for variables in WHERE and VALUES clauses.
1 million
inquiry
bind
expression

47. Cursors: The two keywords in a mere cursor declaration (one is optional).
external subprogram
FOR i IN REVERSE 1..10 LOOP
CURSOR - RETURN
pls_integer

48. Mode designation for an input parameter.
IN
name
IF - CASE or LOOP
boolean

49. Exceptions: Some internal exceptions have ________ names.
COUNT
HTP
predefined
source

50. The declaration section is (optional/mandatory).
CURRENT_USER
HTF
definer's
optional