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. Advantage: PL/SQL supports ______-oriented programming.
TYPE tN IS TABLE of NUMBER
1
CHAR - VARCHAR2
object

2. Declare an unconstrained subtype of NUMBER called NUMB.
drop procedure
SUBTYPE numb IS number;
production
TYPE tN IS TABLE of NUMBER

3. Fundamental: What are the 3 compound symbols for 'not equal to'?
EXTEND
LOOP - END LOOP
v3 IN OUT NUMBER
<> - != - ^=

4. IDs: The two types of words that can - but should not - be used as user-defined identifiers.
is certain
Keywords and predefined names.
EXIT
concatenation

5. DynSQL: The three modes of arguments in the USING clause of EXECUTE IMMEDIATE.
run
IN - OUT - IN OUT
ROLLBACK
implicit CASE_NOT_FOUND exception

6. You (can/cannot) put a label before an END LOOP statement.
cannot
COMMIT - ROLLBACK - SAVEPOINT - SET TRANSACTION
EXECUTE IMMEDIATE
propagates

7. FOR-Looping over a collection from FIRST to LAST only works if the collection is _______.
sequence pseudo-columns
savepoint ab
dense
disable

8. What is the simplest statement for conditionally getting out of simple loop?
fail
EXIT WHEN
WHERE CURRENT OF
current

9. IDs: The type of words that cannot be user-defined identifiers.
will not
Reserved words.
FALSE
INTO

10. The declaration section is (optional/mandatory).
preprocessor
mandatory
optional
...

11. Dbms_sql: The integer returned by OPEN_CURSOR is a _____ _____.
DECLARE - BEGIN - EXCEPTION - END
1
associative
cursor number

12. The allowed data types of user-defined conditional compilation directives are boolean and _______.
anonymous block
SYS_REFCURSOR
boolean
pls_integer

13. Define a record type REC with number num and varchar2(10) name.
TYPE rec IS RECORD (num NUMBER - name VARCHAR2(10));
USER_PROCEDURES
drop procedure
oname

14. Types: ________ data types have no internal components.
scalar
compile
Abstract
define

15. In a cursor loop - the clause added to an INSERT or UPDATE to point at the current record.
ENABLE
WHERE CURRENT OF
fine-grained auditing
IN

16. Internally - the NUMBER type is stored as ______. Therefore - decimal numbers (such as prices) are stored exactly - with no rounding.
function f (n number) return number result_cache relies_on (emps);
transaction
decimal
cursor

17. Conversion: If the specific value is suitable - ____ or _______ values can convert to almost any datatype
external subprogram
%BULK_ROWCOUNT
CHAR - VARCHAR2
REF_CURSOR

18. I/O: The PL/SQL I/O packages (can/cannot) accept input directly from the keyboard.
compile
autonomous transaction
cannot
index

19. Triggers: You create a trigger with the _______ ________ statement.
injection
Oracle
CREATE TRIGGER
base

20. The _______ package lets you wrap dynamically generated PL/SQL.
SESSION_USER
DBMS_DDL
WHERE CURRENT OF
multi-row

21. In short-circuit evaluation - IF-conditions are only evaluated up to where the outcome ___________.
CHARARR
Gateway
procedure P AUTHID current_user;
is certain

22. Cursors: A cursor FOR loop cannot use a _______ variable.
PLS_INTEGER
nested tables - associative arrays
%ROWTYPE
cursor

23. Bytecode is _______ _______ code.
lower sub-block
a cursor
plb
virtual machine

24. Triggers: In a DML trigger - the phrase that makes the trigger run for every affected record.
name and datatype
L.V
selection
for each row

25. Cursors: Give the statement to close cursor C.
close C
True
is
<<>>

26. I/O: dbms_output.put_line puts output into a _______.
IN - OUT - IN OUT
EXIT WHEN
optional
buffer

27. I/O: The most basic PL/SQL way to give output to the user.
cursor
dbms_output.put_line
implicit cursor
external subprogram

28. The $ERROR directive is used to make compilation ____.
closed
r tRec := tRec(9 - 'Jones');
fail
simple and compound symbols

29. Fundamental: A label can be used to name an ______ block.
database
procedure P AUTHID current_user;
DBMS_SQL
anonymous

30. Web: mod_plsql is an implementation of the PL/SQL _________.
Gateway
compiles
-20 -000
after

31. Triggers: The clause to make a trigger run before inserting or updating table EMPS.
before insert or update on emps
FOR - IN
is not
timing

32. Triggers: An INSTEAD OF trigger (can/cannot) be conditional.
Ordinary - Quoted.
sql
cannot
simple and compound symbols

33. _____ arrays cannot be used as the type of an Oracle table column.
SQL
SQL
fail
associative

34. Advantage: Performance: Storing and runnng procedures on the server minimizes ______ traffic.
$IF $THEN $ELSE $END
composite
network
lower sub-block

35. Abbreviation of definer's rights
execute immediate
error
suspended
DR

36. A kind of variable used as a placeholder.
dynamic
bind
END
before insert or update on emps

37. A PL/SQL block that is not stored.
RECORDS
bb:true
function f (n number) return number result_cache relies_on (emps);
anonymous block

38. Types of blocks: Procedures and functions are _______ blocks.
cannot
invoker's
stored
FORALL and BULK COLLECT

39. I/O: The buffered output of dbms_output.put_line is retrieved by _______.
SQLPlus
database
NDS
external subprogram

40. The three types of compiler warnings.
EVERE - PERFORMANCE - INFORMATIONAL
source code
anonymous
plb

41. Name the two types of FOR loop.
REF CURSOR
exit when cgo%NOTFOUND
HTF
numeric and cursor

42. Bulk: The two features that comprise Bulk SQL are:
SUBTYPE numb IS number;
implicit cursor
FORALL and BULK COLLECT
bind

43. Fundamental: A label can only go directly before an _______ statement.
executable
selection
...
open C(p)

44. The attribute used to get the type of a column or variable without knowing what it is.
finishes
invoker's
obfuscates
%TYPE

45. The first SQL statement in an autonomous routine begins a _______.
transaction
ENABLE
EXIT
query

46. The BEGIN section is (optional/mandatory)
varray
mandatory
do not
%ROWTYPE

47. Cursors: Opening keyword of a cursor FETCH loop.
object
LOOP
is
explicit

48. Cursors: If an exception is raised inside a cursor loop - the cursor (is / is not) also closed automatically.
NESTED TABLE myColl STORE AS myCollTab
is
execute
implicit cursor

49. What do you FETCH from?
bytecode
512
block
a cursor

50. Types of blocks: A pl/sql block that is not stored in the database.
2
versions
anonymous
USING