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. An editioning view can only select a subset of the columns from the base table and provide ________ for them
SIMPLE_INTEGER
aliases
TYPE rec IS RECORD (num NUMBER - name VARCHAR2(10));
dense

2. The Wrap utility ________ the source code.
obfuscates
index
varray
FGA

3. Cursors: SYS_REFCURSOR is a predefined type based on _____ ______.
buffer
REF CURSOR
UTL_SMTP
execute

4. Advantage: Having procedures stored and executed on the server makes PL/SQL ________.
invalid
scalable
ENABLE
cannot

5. You can put a label before any executable PL/SQL _________.
literals
statement
TOO_MANY_ROWS
REF_CURSOR

6. Bulk: The use of FORALL statements cuts down on ______ traffic.
static boolean
drop procedure
network
library

7. In a FORALL loop - you (can / cannot) use the index variable for purposes other than indexing into the collection.
closed
boolean
constructor
cannot

8. A result-cached function caches its results in the _____ _____ ____ (SGA)
system global area
calls
simple and compound symbols
v2 IN NUMBER default 20

9. Cursors: The first two keywords in a Cursor FOR loop.
**
for each row
invoker's
FOR - IN

10. DynSQL: The colon-prefixed names used in EXECUTE IMMEDIATE are called ________.
placeholders
FETCH
DBMS_PREPROCESSOR
END LOOP

11. You have to use _______ SQL to run DDL statements n PL/SQL.
UTL_FILE
inclusive
after insert on emps
dynamic

12. The Wrap utility (does / does not) encrypt source code.
END
LOOP - END LOOP
does not
before insert or update on emps

13. You cannot bulk collect into an ARRAY OF ________.
specification - body
RECORDS
1
$IF

14. Triggers: In a per-row trigger - the ____ record shows you the changed state of an affected row.
explicit cursor
NEW
...
selection

15. The command used to populate PLSQL_CCFLAGS.
autonomous triggers
HTP
ALTER SESSION
network

16. Types: PL/SQL has all the _____ data types.
SQL
loop
elements - type
4

17. With a result-cached function - it uses a cached value when the function is called again with the...
composite
invoker's
same arguments
external subprogram

18. Types: One of the 4 PL/SQL things that have a data type (begins with 'r').
TIMESTAMP.
return value
decimal
PRAGMA AUTONOMOUS_TRANSACTION;

19. Declare an input NUMBER parameter - v2 - that defaults to 20.
for update of
cursor variable
=>
v2 IN NUMBER default 20

20. I/O: Max number of bytes to pass in a call to DBMS_OUTPUT.PUT_LINE.
expression
255
OPEN_CURSOR
dense

21. Advantage: Performance: Stored subprograms are ______ in memory.
BINARY_INTEGER
TYPE tN IS TABLE of NUMBER
%
cached

22. Cursors: How many implicit cursors can you access?
512
RETURN
1
label

23. In Native Mode - PL/SQL code is compiled into ______ ______.
machine code
VARRAY - Nested table
32 -000
nested

24. IDs: Predefined identifiers are declared in this package.
preprocessor
cursor number
implicit CASE_NOT_FOUND exception
STANDARD

25. Cursors: Give the statement to close cursor C.
close C
INTO
%BULK_ROWCOUNT
lower sub-block

26. Dbms_sql: The integer returned by OPEN_CURSOR is a _____ _____.
aliases
cursor number
preprocessor
index

27. DynSQL: EXECUTE IMMEDIATE does both dynamic SQL and dynamic _______.
PL/SQL
after
implicit
preprocessor

28. Which two collection types are unbounded?
USER_PROCEDURES
END IF
cached
nested tables - associative arrays

29. DynSQL: The standard package that does dynamic SQL.
PVM
UTL_FILE
index
DBMS_SQL

30. Fundamental: What are the 3 compound symbols for 'not equal to'?
is
<> - != - ^=
predefined
SQL

31. Cursors: If you use an EXIT statement to exit a cursor FOR loop prematurely - the cursor (is / is not) closed automatically.
OTHERS
is
END IF
package

32. Exceptions: An unhandled exception ________ to the enclosing block.
PL/SQL Gateway
selection
propagates
can

33. Web: PL/SQL ______ ______ (PSPs) let you develop web pages with dynamic content.
Server Pages
base
anonymous
USING

34. Triggers: The clause to make a trigger run after inserting into table EMPS.
simple and compound symbols
propagates
after insert on emps
PL/SQL Gateway

35. Cursors: An explicit cursor (can/cannot) accept parameters.
can
nested
Gateway
query

36. Exceptions: Write the call (2 args) to associate message 'Bad' with error code -20 -100.

Warning: Invalid argument supplied for foreach() in /var/www/html/basicversity.com/show_quiz.php on line 183

37. What are the two sequence pseudo-columns?
currval and nextval
TYPE tV IS VARRAY(100) OF NUMBER
TYPE tN IS TABLE of NUMBER
array

38. Cursors: You give an explicit cursor a name and associate it with a _______.
memory
national
cursor number
query

39. In short-circuit evaluation - IF-conditions are only evaluated up to where the outcome ___________.
IR
is certain
pls_integer
define

40. Cursors: The values plugged into the DML in a FORALL must come from existing - populated _________.
collections
autonomous triggers
FETCH
include

41. You (can / cannot) wrap trigger source code.
Double quotes.
cannot
comments
pls_integer

42. The AUTHID property applies to PL/SQL objects that contain _____.
CURRENT_USER - DEFINER
slower
code
RETURN

43. Cursors: Give the statement to fetch data from cursor C into variable V.
1
fetch C into V
after insert on emps
finishes

44. The valid values of the AUTHID property.
COUNT
PL/SQL
API
CURRENT_USER - DEFINER

45. Cursors: A Cursor FOR loop does not use a ______ statement.
optional
FETCH
SQL cursor
v2 IN NUMBER default 20

46. The DEFINITION of a cursor is the _____ that returns the records.
plb
USING
query
OPEN

47. Exceptions: Declare an exception called E.
E Exception;
HTF
fail
information that changes infrequently

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

Warning: Invalid argument supplied for foreach() in /var/www/html/basicversity.com/show_quiz.php on line 183

49. Type: An ________ subtype has all the values of its base type.
SYS_CONTEXT
stored
unconstrained
WHEN OTHERS THEN

50. The DECLARE keyword is only required in an _______ _______.
DATE '2005-12-25'
anonymous block
set serveroutput on
same