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. Declare a number variable - A - initialized to 10.
obfuscates
propagates
LOOP
a number := 10

2. %ROWTYPE gets the type of a table or _______.
error code
does not
error
cursor

3. To run a PIPE ROW statement in your autonomous routine - you must close any _____________.
timing
EXIT
autonomous transaction
DBMS_SESSION

4. Delimiters: Item separator.

enclosing
SUBTYPE n IS number not null;
PVM

5. Advantage: PL/SQL runs anywhere Oracle runs - so it is very ________.
portable
preprocessor
**
same

6. What do you FETCH from?
EXCEPTION_INIT
timing
a cursor
..

7. A FOR loop can be indexed by numbers or by a ______.
for update of
increment
lower sub-block
cursor

8. Declare a constrained subtype of NUMBER called N that is not null.
open cv for
SUBTYPE n IS number not null;
will not
Server Pages

9. Cursors: What implicit cursor attribute gives row counts for a FORALL statement?
COUNT
%BULK_ROWCOUNT
PSP
drop procedure

10. To insert or update on a table that has a collection column - you have to have _______ privilege on the collection type.
subtype
CURRENT_USER - DEFINER
EXECUTE
cursor variable

11. I/O: This package lets PL/SQL programs read and write OS files.
for update of
national
statement
UTL_FILE

12. Delimiters: the attribute indicator.
lowest
%
predefined
PRAGMA EXCEPTION_INIT (E - -1);

13. What is the simplest statement for conditionally getting out of simple loop?
RETURN
function f (n number) return number result_cache relies_on (emps);
EXIT WHEN
dense

14. The method to add one or more elements to a nested table or VARRAY is ______.
associative arrays
SQLERRM
invoker's
EXTEND

15. What are the two sequence pseudo-columns?
user-defined
currval and nextval
FOR i IN REVERSE 1..10 LOOP
cannot

16. DynSQL: The clause that receives single-row query output from EXECUTE IMMEDIATE.
PLS_INTEGER
EXIT WHEN
INTO
create

17. Define a record type REC with number num and varchar2(10) name.
TYPE rec IS RECORD (num NUMBER - name VARCHAR2(10));
strong
%BULK_ROWCOUNT
DBMS_PIPE

18. Dbms_sql: The return type DBMS_SQL.open_cursor.
include
NESTED TABLE myColl STORE AS myCollTab
current BEGIN-END block
integer

19. Dbms_sql: The DBMS_SQL procedure that closes a cursor.
reference
lower sub-block
CLOSE_CURSOR
IN

20. Characters that begin a multi-line comment.
$$PLSQL_LINE
can
wrap
/*

21. I/O: dbms_output.put_line puts output into a _______.
buffer
EXECUTE IMMEDIATE
lowest
name

22. Fundamental: Labels furnish targets for GOTO and _____ statements.
EXIT
r t.%ROWTYPE;
TYPE rec IS RECORD (num NUMBER - name VARCHAR2(10));
raise_application_error(-20 -100 - 'Bad');

23. To run DDL statements - a trigger must be autonomous and must use ______ ______ SQL.
3
FETCH
native dynamic
reference

24. Cursors: What is the 'name' of the implicit cursor?
SQL
manageable
anonymous
name and datatype

25. Native compilation turns bytecode into ________ code.
machine
constructor
bb:true
INTO

26. Triggers: When using the NEW or OLD pseudo-records in the body of the trigger - they must be prefixed with a _______.
CLOSE
SQLERRM
colon
do not

27. Exceptions: The built-in procedure for raising an application-defined error.
=
can
SQL
raise_application_error

28. I/O: Max number of bytes to pass in a call to DBMS_OUTPUT.PUT_LINE.
WHEN
FETCH - INTO
1
255

29. To get the current value of CURRENT_SCHEMA - CURRENT_USER - or SESSION_USER - use the ____ function.
SYS_CONTEXT
end
finishes
vname CONSTANT VARCHAR2 := 'x';

30. A GOTO statement can branch from an exception handler into...
user-defined
an enclosing block
value
SESSION_USER

31. TCL: Create a savepoint called ab
savepoint ab
TYPE tN IS TABLE of NUMBER
FOR UPDATE
collections - records

32. Fundamental: Which one of these is a compound symbol: = - :=
:=
STANDARD
error
portable

33. Are good for logging table DML operations.
name
statement
SQL
autonomous triggers

34. PL/SQL is a ________ typed programming language.
loop
network
Server Pages
statically

35. An anonymous block is a(n) ____ statement.
reference
associative
PLSQL_CCFLAGS
SQL

36. For an associative array - the FIRST method gets the (lowest / first-created) index.
CHAR - VARCHAR2
DML
%TYPE
lowest

37. Nested tables can become sparse via ______.
deletions
open cv for
cannot
TYPE tV IS VARRAY(100) OF NUMBER

38. Cursors: The statement where you pass the parameters to a cursor.
STANDARD
disable
boolean
OPEN

39. IDs: Maximum number of bytes in a user-defined identifier.
30
current
package
iname

40. A kind of variable used as a placeholder.
bind
after
executable
injection

41. Fundamental: Maximum string length of a PL/SQL variable.
EXECUTE IMMEDIATE
VARRAYs
OTHERS
32 -000

42. The two main parts of a package are the ____ and the _____.
finishes
specification - body
external subprogram
CLOSE_CURSOR

43. Cursors: You can just declare a cursor at first - then _______ it later.
1
an AUTHID property
define
32 -000

44. Types: One of the scalar data types specific to PL/SQL: b_____.
nested
BOOLEAN
memory
open cv for

45. With a result-cached function - it uses a cached value when the function is called again with the...
boolean
same arguments
1
unhandled

46. IDs: How an ordinary user-defined identifier must begin.
With a letter.
$IF
pseudocolumn
TOO_MANY_ROWS

47. Triggers: You create a trigger with the _______ ________ statement.
CREATE TRIGGER
boolean
cannot
FETCH

48. In the special IF syntax - is it ELSIF - or ELSEIF?
elsif
CHAR - VARCHAR2
does not
cursor c;

49. Assigning values to PL/SQL variables that appear in SQL statements is called _______.
must
binding
will not
fetch cv into myvar

50. 5 types of events that can have triggers: DML - DDL - INSTEAD OFs - database events - and ________ statements.
GET_LINES
suspended
=
concatenation