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. After the RESULT_CACHE clause - you can put a _________ clause to enable dependency-checking.
RELIES_ON
single-line
identifiers
VARCHAR2

2. Fundamental: One of the 4 types of lexical units: c_____.
cannot
3
comments
ENABLE

3. Triggers: There are __ types of triggers.
associative
USER_PLSQL_OBJECT_SETTINGS
5
UTL_FILE

4. From a block nested inside a procedure P - reference variable V of the outer procedure.
DBMS_OUTPUT
p.v
FGA
EXECUTE IMMEDIATE

5. Triggers: In a per-row trigger - the ____ record shows you the original state of an affected row.
..
FORALL i IN MyList.FIRST..MyList.LAST
DML
OLD

6. Types: In addition to the SQL data types - PL/SQL has ___ more scalar data types.
4
can
PUT
do not

7. The Wrap utility (does / does not) encrypt source code.
Abstract
does not
forward
searched

8. The inquiry directive that gives the current line number in the procedure.
$$PLSQL_LINE
a number := 10
flushed
does not

9. Command to make a no-op (omit semicolon).
function f (n number) return number result_cache relies_on (emps);

do not
suspended

10. In short-circuit evaluation - IF-conditions are only evaluated up to where the outcome ___________.
WHEN OTHERS THEN
is certain
$IF
INTO

11. Define a nested table type - tN - which is a table NUMBERs.
TYPE tN IS TABLE of NUMBER
cursor c RETURN rC;
BINARY_INTEGER
invoker's

12. Delimiters: The remote access symbol.
@
fine-grained auditing
OPEN
composite

13. What is the exception that is implicitly raised in a CASE statement with no ELSE clause?
CASE_NOT_FOUND
implicit cursor
Web Toolkit
definition

14. DBMS_DDL.WRAP returns a string containing wrapped _____ _____.
cannot
VARCHAR2
invoker's
source code

15. Dbms_sql: A cursor opened with OPEN_CURSOR (can/cannot) be reused for multiple queries without first closing it.
can
never
DBMS_PREPROCESSOR
<<

16. Wrap iname=xxxx _____=zzzzz
oname
calls
constructor
error code

17. Type: An ________ subtype has all the values of its base type.
ALTER SESSION
loop
unconstrained
forward

18. The variable showing the user id of the session owner.
1
current
SESSION_USER
after insert on emps

19. A national character literal is composed of characters in the ________ character set.
2
v3 IN OUT NUMBER
national
1 million

20. Types: ______ data types are those storing values with no internal components.
TYPE tA IS TABLE OF NUMBER INDEX BY VARCHAR2(20)
STANDARD
scalar
3

21. Triggers: If two or more triggers are defined with the same timing point - then you can control the firing order using the ________ clause.
follows
source code
after insert on emps
PLS_INTEGER

22. The collection method that tells the number of elements in the collection.
literals
COUNT
Wrap
is

23. The BETWEEN operator is (inclusive / exclusive).
FOR i IN REVERSE 1..10 - LOOP - NULL; END LOOP;
inclusive
invoker's
closed

24. Exceptions: The ________ function returns the error message associated with an error code.
cannot
SQLERRM
sequence pseudo-columns
not a number

25. Give the statement to make a program autonomous.
*/
invoker's
PRAGMA AUTONOMOUS_TRANSACTION;
%TYPE

26. Exceptions: The ________ handler must always be the last handler.
3
include
Double quotes.
OTHERS

27. An incomplete type is a type created by a ______ type definition.
Abstract
:=
forward
source code

28. Statement to exit a cursor loop on cursor cGo when there are no more records.
EXIT
exit when cgo%NOTFOUND
after insert on emps
FALSE

29. Declare an input NUMBER parameter - v2 - that defaults to 20.
v2 IN NUMBER default 20
context
for each row
null string

30. Abbreviation of invoker's rights
session cursor
RECORDS
IR
dynamic

31. An autonomous program runs in its own __________.
transaction
cannot
machine code
pseudocolumn

32. The attribute used to get the type of a row without knowing what it is.
VARRAY - Nested table
expression
%ROWTYPE
ordinary

33. How many types of compiler directives are there?
-
selection
DR
3

34. In 11g you can directly reference _____________ in PL/SQL.
4
.
cannot
sequence pseudo-columns

35. Mode designation for an input/output parameter.
include
select
IN OUT
statement

36. Which collection type is bounded?
varray
cannot
dbms_output.put_line
IS

37. You (can / cannot) wrap trigger source code.
placeholders
nested
cannot
name

38. Command to delete a procedure.
compilation
drop procedure
not the same
a number := 10

39. The SET TRANSACTION statement affects only the ____________.
wrap
DBMS_SQL
FOR i IN REVERSE 1..10 LOOP
current transaction

40. You cannot bulk collect into an ARRAY OF RECORDS. You can into a ________________ (3 words).
RECORD OF ARRAYS
server
cannot
=>

41. Define a collection type - tV - which is a varray of 100 NUMBERs.
execute immediate
TYPE tV IS VARRAY(100) OF NUMBER
PLSQL_OPTIMIZE_LEVEL
COUNT

42. Cursors: A cursor FOR loop can use an explicit or an _______ cursor.
an autonomous routine
implicit
explicit
compilation

43. A FOR loop can be indexed by numbers or by a ______.
cursor
IN OUT
ALTER SESSION
stored

44. Assignment of PLSQL_CCFLAGS (cannot / can) be included in ALTER PROCEDURE ... COMPILE ...
RETURN
can
library
mandatory

45. Types: A ______ has the same valid operations as its base type.
optional
REF CURSOR
subtype
cursor

46. Nested tables can become sparse via ______.
deletions
create procedure
..
decimal

47. A GOTO statement can branch from an exception handler into...
5
object
never
an enclosing block

48. Declare a cursor c with no parameters or return type.
index
cursor c;
DECLARE - BEGIN - EXCEPTION - END
network

49. _________ exceptions can not be trapped with an error handler
definition
Declaration
1 million
invoker's

50. IDs: The two types of words that can - but should not - be used as user-defined identifiers.
Keywords and predefined names.
PRAGMA AUTONOMOUS_TRANSACTION;
elements - type
EXECUTE IMMEDIATE