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. I/O: The output from DBMS_OUTPUT will display (during/after) program execution.
after
UTL_SMTP
USER_PLSQL_OBJECT_SETTINGS
elements

2. By default - an IN parameter is passed by ______.
reference
DBMS_PREPROCESSOR
'ENABLE:SEVERE' - 'ERROR:06002'
statically

3. DynSQL: The three modes of arguments in the USING clause of EXECUTE IMMEDIATE.
IN - OUT - IN OUT
r tRec := tRec(9 - 'Jones');
PLSQL_CCFLAGS
unconstrained

4. Fundamental: What is the range operator?
..
implicit
aliases
SQLERRM

5. You can use the BULK COLLECT INTO clause in a SELECT or a ______.
FETCH
v3 IN OUT NUMBER
procedure P AUTHID definer;
fine-grained auditing

6. Cursors: Give the statement to open cursor C that takes parameter p.
INTO
BINARY_INTEGER
open C(p)
# - $ - _

7. Labels for blocks and statements are enclosed in '__' brackets.
error code
user-defined
<<>>
fetch C into V

8. Declare a number variable - A - initialized to 10.
compilation
:=
INSTEAD OF
a number := 10

9. Declare an unconstrained subtype of NUMBER called NUMB.
FETCH
SUBTYPE numb IS number;
decimal
OPEN_CURSOR

10. The EXTEND method is not used with ______ _______.
associative arrays
select
3
specification - body

11. Exceptions: The three words that can be used to guarantee all exceptions will be handled.
OPEN_CURSOR
create procedure
procedure - function
WHEN OTHERS THEN

12. Types: The predefined subtype of PLS_INTEGER that has the NOT NULL constraint.
package
CURRENT OF
SIMPLE_INTEGER
CLOSE_CURSOR

13. Bytecode is _______ _______ code.
Declaration
inquiry
after
virtual machine

14. The first SQL statement in an autonomous routine begins a _______.
transaction
fine-grained auditing
base
include

15. Fundamental: What is the exponentiation operator?
**
open cv for
in the database
alter procedure

16. What are the two sequence pseudo-columns?
simple and compound symbols
WHERE CURRENT OF
ROLLBACK
currval and nextval

17. PL/SQL is a ________ typed programming language.
statically
*/
expression
is certain

18. A type of compiler directive - begins with 'i'.
LOOP
CLOSE
EXECUTE
inquiry

19. Cursors: The statement where you pass the parameters to a cursor.
cursor c;
1
OPEN
CLOSE

20. You can define PL/SQL collections using TYPEs defined in the _______.
database
$IF $THEN $ELSE $END
DEFINER
FETCH - INTO

21. The AUTHID property applies to PL/SQL objects that contain _____.
bind
TYPE t IS TABLE OF rPerson INDEX BY PLS_INTEGER;
code
cursor

22. Cursors: What is the 'name' of the implicit cursor?
SQL
include
literal
GET_LINE

23. Triggers: If two or more triggers are defined with the same timing point - then you can control the firing order using the ________ clause.
1
**
follows
cannot

24. Exceptions: If there is no handler for an exception - PL/SQL returns an ________ exception error to the invoker or host environment.
TRUE - FALSE - NULL
DBMS_SESSION
unhandled
IN - OUT - IN OUT

25. A type of compiler directive - begins with 'e'.
VARRAY - Nested table
simple and compound symbols
WHEN OTHERS THEN
error

26. Exceptions: The package that defines pre-defined exceptions.
CURRENT_USER
literals
STANDARD
error code

27. Types: One of the 4 PL/SQL things that have a data type (begins with 'c').
1 million
delimiters
constant
RETURN

28. Cursors: An implicit cursor is also called a/n ________ ________ -
SQL cursor
CURSOR - RETURN
must
exit when cgo%NOTFOUND

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

30. In interpreted mode - the PL/SQL VM interprets the _________.
cursor
nested
bytecode
SQL

31. Cursors: Only a _____ _____ cursor can appear in the CURRENT OF clause of an UPDATE or DELETE statement.
invoker's
FOR UPDATE
DBMS_OUTPUT
hardware

32. Default file extension of wrap's input file.
library
definition
30
sql

33. The DECLARE keyword is only required in an _______ _______.
set serveroutput on
significant
database
anonymous block

34. GOTO branches to a ________.
expression
scalable
label
boolean

35. Are good for logging table DML operations.
autonomous triggers
CREATE TRIGGER
cursor c RETURN rC;
package

36. Command used to execute dynamic SQL.
closed
suspended
EXECUTE IMMEDIATE
..

37. Exceptions: An unhandled exception ________ to the enclosing block.
anonymous
timing
propagates
DECLARE - BEGIN - EXCEPTION - END

38. Define a collection type - tV - which is a varray of 100 NUMBERs.
TRUE - FALSE and NULL
v2 IN NUMBER default 20
%ISOPEN.
TYPE tV IS VARRAY(100) OF NUMBER

39. Fundamental: One of the 4 types of lexical units: i_____
identifiers
bytecode
DML
error code

40. Advantage: Performance: Stored subprograms are ______ in memory.
DBMS_OUTPUT
cached
SQL cursor
USER_PROCEDURES

41. Types: PL/SQL has all the _____ data types.
variable
closed
SQL
object

42. Name the two types of FOR loop.
Declaration
numeric and cursor
query
FETCH - INTO

43. A GOTO statement can branch from an exception handler into...
an enclosing block
unconstrained
savepoint ab
decimal

44. To recompile a procedure - use the _____ ______ command.
always
alter procedure
DECLARE - BEGIN - EXCEPTION - END
after

45. Mode designation for an input/output parameter.
IN OUT
IS
Abstract
pls_integer

46. A SELECT statement with the FOR UPDATE clause puts a ______ on the selected rows.
lock
TYPE t IS TABLE OF rPerson INDEX BY PLS_INTEGER;
<<>>
significant

47. Web: PL/SQL _____ _______ lets you to develop Web applications made of PL/SQL procedures.
IR
Web Toolkit
DBMS_PIPE
L.V

48. Dbms_sql: The DBMS_SQL procedure that will execute a DDL or DML statement.
do not
DBMS_SESSION
execute
server

49. Delimiters: Single-line comment marker.
1
before insert or update on emps
;
-

50. Assigning values to PL/SQL variables that appear in SQL statements is called _______.
ex := tbl1 MULTISET EXCEPT tbl2
CURRENT_USER - DEFINER
binding
index