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. Java - C or other program called directly in PL/SQL.
WHERE CURRENT OF
PSP
DATE
external subprogram

2. An INSTEAD OF trigger is used - e.g - when you want to insert into a complex _____.
view
for each row
FETCH
SQL

3. A user-defined TYPE can have...
implicit cursor
do not
an AUTHID property
4K

4. Abbreviation for Abstract Data Type.
ADT
TYPE tA IS TABLE OF NUMBER INDEX BY VARCHAR2(20)
create procedure
significant

5. Bulk: The keywords of a bulk collect FETCH statement.
FETCH - BULK COLLECT INTO
explicit
EXIT WHEN
set serveroutput on

6. The command used to populate PLSQL_CCFLAGS.
associative arrays
ALTER SESSION
server
CURRENT_USER

7. To use a TYPE declared in the database - a PL/SQL block has to have _______ privilege on the type.
select
package
current
DEFINER

8. A (simple / searched) CASE statement begins with CASE WHEN <boolean expression>.
searched
bytecode
scalar
TYPE tA IS TABLE OF NUMBER INDEX BY VARCHAR2(20)

9. The EXTEND method is not used with ______ _______.
Ordinary - Quoted.
PLS_INTEGER
associative arrays
BINARY_INTEGER

10. Exceptions: An exception raised inside an _______ _______ propagates immediately to the enclosing block
optional
exception handler
EXIT
NDS

11. Cursors: Closing keywords of a cursor FETCH loop.
RETURN
commit - rollback
Declaration
END LOOP

12. Where an external subprogram is stored.
With a letter.
CHARARR
block
in the database

13. I/O: The output from DBMS_OUTPUT will display (during/after) program execution.
explicit
RETURN
savepoint ab
after

14. Value of a character literal with zero characters.

raise_application_error
constructor
block

15. Native compilation turns bytecode into ________ code.
machine
disable
GET_LINE
for update of

16. Declare a cursor c with no parameters or return type.
IF - CASE or LOOP
EXIT WHEN
Keywords and predefined names.
cursor c;

17. Types: The storage size of a NUMBER value is based on the number of ______ digits.
significant
FETCH
EXECUTE IMMEDIATE
bind arguments

18. Conditional ______ allows backward compability with older database versions.
OPEN_CURSOR
With a letter.
propagates
compilation

19. Web: mod_plsql is an implementation of the PL/SQL _________.
Gateway
simple
inquiry
select

20. Types: One of the scalar data types specific to PL/SQL: B_______
memory
BINARY_INTEGER
DBMS_SQL
EVERE - PERFORMANCE - INFORMATIONAL

21. Labels for blocks and statements are enclosed in '__' brackets.
OTHERS
v3 IN OUT NUMBER
<<>>
expression

22. Bulk: The implicit cursor attribute that gives the number of rows affected by each DML statement in a FORALL statement.
TRUE - FALSE and NULL
stored
%BULK_ROWCOUNT
GET_LINE

23. IDs: List the two types of user-defined identifiers.
Ordinary - Quoted.
Web Toolkit
$IF
REF_CURSOR

24. Exceptions: The keyword that begins an exception handler.
WHEN
CURRENT_USER - DEFINER
PRAGMA AUTONOMOUS_TRANSACTION;
TOO_MANY_ROWS

25. Declare an input/output NUMBER parameter - v3.
INSTEAD OF
flushed
colon
v3 IN OUT NUMBER

26. Types: In addition to the SQL data types - PL/SQL has ___ more scalar data types.
v3 IN OUT NUMBER
open cv for
4
object

27. One good use of bind variables is to guard against SQL _______.
RECORDS
injection
UTL_FILE
implicit CASE_NOT_FOUND exception

28. Cursors: The value of SQL%ISOPEN is always ______.
USING
FALSE
explicit cursor
EXIT WHEN

29. Fundamental: Which one of these is a simple symbol: a - = - !=
name
OTHERS
=
loop

30. Collections are one of the two kinds of PL/SQL _______ data types.
CHAR - VARCHAR2
is
composite
STANDARD

31. (from inside a package) Declare a function f - that takes a number n - returns a number - and caches results - depending on table EMPS.
TYPE tA IS TABLE OF NUMBER INDEX BY VARCHAR2(20)
exception handler
function f (n number) return number result_cache relies_on (emps);
Double quotes.

32. Delimiters: Host variable indicator.
DBMS_DDL
...
unqualified
dbms_output.put_line

33. Delimiters: The assignment operator.
SQL
cannot
:=
Ada

34. _______ arrays can be sparse or dense - depending on how you fill them.
optional
associative
ADT
varray

35. The DEFINITION of a cursor is the part after the keyword __.
SIMPLE_INTEGER
IS
include
255

36. How many types of compiler directives are there?
server
constrained
3

37. An ordinary character literal is composed of characters in the ________ character set.
30
package
database
4K

38. With Edition-based Redefinition enabled - the unique specification of an object requires OWNER - OBJECT_NAME and ___________.
REUSE SETTINGS
EDITION_NAME
DATE '2005-12-25'
cannot

39. To insert or update on a table that has a collection column - you have to have _______ privilege on the collection type.
EXECUTE
sql
Reserved words.
Abstract

40. Wrap ______=xxxx oname=zzzzz
bind
iname
'ENABLE:SEVERE' - 'ERROR:06002'
searched

41. To exit an active autonomous transaction without causing an exception - you must issue _____ or ______.
value
TYPE rec IS RECORD (num NUMBER - name VARCHAR2(10));
for each row
commit - rollback

42. Fundamental: Character used to escape a single quote inside a literal.

43. A subprogram defined within another subprogram is a _______ subprogram.
cannot
nested
package
literals

44. DynSQL: Native Dynamic SQL
return value
NDS
stored
32 -000

45. GOTO branches to a ________.
label

composite
WHERE CURRENT OF

46. Define a collection type - tV - which is a varray of 100 NUMBERs.
cannot
FORALL and BULK COLLECT
EXECUTE IMMEDIATE
TYPE tV IS VARRAY(100) OF NUMBER

47. In the IF syntax - is if ENDIF or END IF?
SUBTYPE numb IS number;
execute
-20 -000
END IF

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

49. A national character literal is composed of characters in the ________ character set.
national
CHAR - VARCHAR2
database
disable

50. The variable showing the user id of the session owner.
1 million
transaction
SESSION_USER
*/