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 type of compiler directive - begins with 's'.
subtype
selection
PLS_INTEGER
commit - rollback

2. Define a collection type - tA - which is an associative array of NUMBERS - indexed with varchar2(20) values.
code
%ISOPEN.
TYPE tA IS TABLE OF NUMBER INDEX BY VARCHAR2(20)
column

3. Declare a package procedure P with no arguments - and give it invoker's rights.
<> - != - ^=
FOR i IN REVERSE 1..10 - LOOP - NULL; END LOOP;
procedure P AUTHID current_user;
ALTER SESSION

4. An $ERROR directive ends with _____.
..
Gateway
injection
$END

5. Cursors: The first two keywords in a Cursor FOR loop.
bytecode
FOR - IN
EXCEPTION_INIT
-

6. Fundamental: Maximum string length of a PL/SQL variable.
raise_application_error(-20 -100 - 'Bad');
error code
32 -000
fields

7. Assigning values to PL/SQL variables that appear in SQL statements is called _______.
Reserved words.
FETCH
3
binding

8. A pointer to a private SQL area that stores information about processing a specific SELECT or DML statement.
cursor
<> - != - ^=
FETCH - INTO
inclusive

9. Delimiters: Host variable indicator.
...
CURSOR - RETURN - IS
WHERE CURRENT OF
Keywords and predefined names.

10. Command to assign to variables from a cursor.
constrained
IN - OUT - IN OUT
4K
FETCH

11. Advantage: PL/SQL is tightly _______ with Oracle SQL.
cannot
integrated
user-defined
OLD

12. The allowed data types of user-defined conditional compilation directives are boolean and _______.
INTO
pls_integer
collections
same

13. 5 types of events that can have triggers: DML - DDL - INSTEAD OFs - database events - and ________ statements.
suspended
selection
predefined
Wrap

14. The FORALL statement to loop over a collection MyList using index i.
EXECUTE IMMEDIATE
FETCH - INTO
FORALL i IN MyList.FIRST..MyList.LAST
%TYPE

15. Fundamental: What is the range operator?
database
CHAR - VARCHAR2
..
Apache

16. Exceptions: User-defined exceptions must have _______.
names
lower sub-block
portable
in the database

17. A GOTO statement can branch from an exception handler into...
RETURN
execute
an enclosing block
associative

18. Exceptions: Some internal exceptions have ________ names.
IS
predefined
value
cursor c RETURN rC;

19. A GOTO cannot branch into a...
BOOLEAN
execute
value
lower sub-block

20. Exceptions: PL/SQL exceptions are of two types: internal and _________.
colon
CREATE TRIGGER
user-defined
exception

21. TCL: Create a savepoint called ab
FORALL and BULK COLLECT
5
once
savepoint ab

22. Exceptions: Pragma that links an exception to an Oracle error code.
variable
EXCEPTION_INIT
ADT
Wrap

23. A kind of variable used as a placeholder.
error code
bind
IN OUT
quoted

24. Triggers and views always have _________ rights.

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

25. The _______ package lets you wrap dynamically generated PL/SQL.
512
decimal
DBMS_DDL
name

26. The variable showing the user id that is automatically prepended to object names.
RESULT_CACHE
suspended
Ordinary - Quoted.
CURRENT_USER

27. By default - an IN parameter is passed by ______.
reference
cannot
IN OUT
v2 IN NUMBER default 20

28. In a collection - the internal components always have the _____ data type.
select
cannot
same
EVERE - PERFORMANCE - INFORMATIONAL

29. Cursors: The three keywords in a full cursor declaration/definition (before the SELECT).
CURSOR - RETURN - IS
3
select
an AUTHID property

30. I/O: dbms_output.put_line puts output into a _______.
OTHERS
buffer
FALSE
multi-row

31. A type of compiler directive - begins with 'i'.
dense
inquiry
query
..

32. Packaged constants can synchronize programs through use in _______ directives.
FOR - IN
selection
collections
autonomous triggers

33. Triggers: In a DML trigger - the phrase that makes the trigger run for every affected record.
associative
value
for each row
STANDARD

34. Assignment of PLSQL_CCFLAGS (cannot / can) be included in ALTER PROCEDURE ... COMPILE ...
1
%TYPE
can
raise_application_error(-20 -100 - 'Bad');

35. I/O: This package does email.
anonymous block
WHEN
UTL_SMTP
nested

36. Fundamental: What is the exponentiation operator?
fine-grained auditing
constrained
**
DATE

37. Conversion: It is best to use (implicit / explicit) conversion.
explicit
SQL
rollback to ab
$IF

38. Types: One of the 4 PL/SQL things that have a data type (begins with 'r').
EXIT WHEN
cursor
suspended
return value

39. I/O: The DBMS_OUTPUT function that writes output without a newline character.
PUT
SQL
stored
elements - type

40. Cursors: SYS_REFCURSOR is a predefined type based on _____ ______.
source code
REF CURSOR
anonymous
%

41. An editioning view can only select a subset of the columns from the base table and provide ________ for them
savepoint ab
name-value
aliases
DBMS_PIPE

42. To enable result-caching for a function - use the _____________ clause.
SYS_REFCURSOR
cannot
=>
RESULT_CACHE

43. You can have many autonomous transactions in ___________.
REF CURSOR
identifiers
DBMS_PREPROCESSOR
an autonomous routine

44. IDs: What a quoted user-defined identifier is enclosed in.
DATE '2005-12-25'
Double quotes.
TOO_MANY_ROWS
does not

45. True encryption is done with package __________.
before insert or update on emps
FETCH
implicit CASE_NOT_FOUND exception
DBMS_CRYPTO

46. Exceptions: Associate exception E with error code -1.
PRAGMA EXCEPTION_INIT (E - -1);
NEW
invoker's
execute

47. I/O: One of the 3 types of data stored in the DBMS_OUTPUT buffer.
autonomous transaction
current BEGIN-END block
NUMBER
SQL cursor

48. Triggers: INSTEAD OF triggers only run on ______ views.
after insert on emps
boolean
non-editioning views
create

49. Mode designation for an output parameter.
for each row
OUT
<> - != - ^=
current transaction

50. Cursors: Closing keywords of a cursor FETCH loop.
ALTER SESSION
unconstrained
implicit
END LOOP