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. Cursors: Which cursor attribute is not meaningful for an implicit cursor?
PLS_INTEGER
order
%ISOPEN.
close C

2. The three possible values of a BOOLEAN literal.
anonymous
transaction
single-line
True - false or NULL.

3. To insert or update on a table that has a collection column - you have to have _______ privilege on the collection type.
..
CURRENT_USER
base
EXECUTE

4. Cursors: The four cursor attributes - in alphabetical order.
v3 IN OUT NUMBER
cannot
%FOUND - %ISOPEN - %NOTFOUND - %ROWCOUNT
inquiry

5. Types: The storage size of a NUMBER value is based on the number of ______ digits.
anonymous
significant
REF_CURSOR
comments

6. Bulk: The keywords of a bulk collect FETCH statement.
32 -000
4
is certain
FETCH - BULK COLLECT INTO

7. What is the exception that is implicitly raised in a CASE statement with no ELSE clause?
CASE_NOT_FOUND
nested
null string
selection

8. List the transaction control statements.
static
injection
COMMIT - ROLLBACK - SAVEPOINT - SET TRANSACTION
WHEN OTHERS THEN

9. A kind of variable used as a placeholder.
cursor
bind
inquiry
network

10. To enable result-caching for a function - use the _____________ clause.
RESULT_CACHE
can
bytecode
%BULK_ROWCOUNT

11. IDs: You (can/cannot) use keywords as ordinary user-defined identifiers.
flushed
significant
can
..

12. I/O: To make sure the DBMS_OUTPUT buffer will be flushed - put a WHEN ______ clause in the EXCEPTION section of your outer block.
FETCH
RECORD OF ARRAYS
decimal
OTHERS

13. I/O: Max number of bytes DBMS_OUTPUT can handle in a session.
predefined
TYPE tA IS TABLE OF NUMBER INDEX BY VARCHAR2(20)
1 million
object

14. IDs: How an ordinary user-defined identifier must begin.
SESSION_USER
DATE
With a letter.
DBMS_CRYPTO

15. Value of PLSQL_OPTIMIZE_LEVEL that prevents optimization.
1
national
RELIES_ON
error code

16. Delimiters: Item separator.
type T is ref cursor

Abstract
NDS

17. A nested table has to be initialized using a ________ - named the same as the type.
constructor
FOR - IN
source
*/

18. Pkgs: RESET_PACKAGE only takes effect after the outermost PL/SQL proc that called it ________.
finishes
session cursor
END
implicit CASE_NOT_FOUND exception

19. I/O: This package has hypertext functions that generate HTML tags
HTF
cursor c RETURN rC;
nested tables - associative arrays
COUNT

20. Delimiters: The left label delimiter.
executable
<<
1
BINARY_INTEGER

21. The compiler directive used to select which code to compile.
EXECUTE IMMEDIATE
$IF
=
DATE '2005-12-25'

22. The attribute used to get the type of a row without knowing what it is.
Ada
do not
%ROWTYPE
SESSION_USER

23. Declare an output NUMBER parameter - v1 - that defaults to 10.
EDITION_NAME
block
elements - type
v1 OUT number default 10

24. Parameter that controls how much Oracle optimizes your PL/SQL code on compilation.
PLSQL_OPTIMIZE_LEVEL
value
REF CURSOR
'

25. Give the first line of the FOR loop with index i going from 1 to 10 in reverse.
not the same
FOR i IN REVERSE 1..10 LOOP
fine-grained auditing
for each row

26. Web: mod_plsql is an _______ module.
cannot
Apache
placeholders
FOR i IN REVERSE 1..10 - LOOP - NULL; END LOOP;

27. Cursors: The SQL%BULK_ROWCOUNT attribute is an _________ -
array
in the database
cursor
simple and compound symbols

28. Types: The predefined subtype of PLS_INTEGER that has the NOT NULL constraint.
ordinary
SIMPLE_INTEGER
cannot
PRAGMA AUTONOMOUS_TRANSACTION;

29. Fundamental: Maximum string length of a PL/SQL variable.
suspended
error
32 -000
value

30. To run TCL or DDL statements - a trigger (must / must not) be autonomous .
$IF
must
database
hardware

31. In a record - the internal components are called ______.
elsif
$IF
network
fields

32. You cannot bulk collect into an ARRAY OF ________.
RECORDS
EXECUTE
FGA
'

33. Declare a variable r whose type is that of the records in table t.
r t.%ROWTYPE;
statically
bind
:=

34. The FIRST method gets the first (element / index) of a collection.
index
UTL_FILE
name and datatype
an autonomous routine

35. If an initialized collection has no elements - FIRST and LAST return _____.
bytecode
query
GET_LINES

36. Types: One of the scalar data types specific to PL/SQL: B_______
BINARY_INTEGER
Web Toolkit
USER_PROCEDURES
SUBTYPE n IS number not null;

37. Triggers: In a DML trigger - the phrase that makes the trigger run for every affected record.
TRUE - FALSE and NULL
for each row
execute
<> - != - ^=

38. Cursors: What implicit cursor attribute gives row counts for a FORALL statement?
CREATE TRIGGER
collections - records
nested
%BULK_ROWCOUNT

39. Bulk: The use of FORALL statements cuts down on ______ traffic.
transaction
cannot
network
PLSQL_CCFLAGS

40. Declare a package procedure P with no arguments - and give it invoker's rights.
procedure P AUTHID current_user;
raise_application_error
invoker's
for update of

41. Fundamental: Delimiters are _____ and _____ symbols.
boolean
UTL_SMTP
Gateway
simple and compound symbols

42. Types: Which type of arithmetic does PLS_INTEGER use - library or hardware?
open cv for
NDS
hardware
exception handler

43. A PL/SQL extension to the WHERE clause of the SQL statements UPDATE and DELETE
HTF
explicit cursor
bind arguments
WHERE CURRENT OF

44. A GOTO statement can branch from an exception handler into...
must
an enclosing block
colon
USER_PROCEDURES

45. Conditional ______ allows backward compability with older database versions.
compilation
collections - records
constant
after

46. Which two collection types are unbounded?
reference
implicit CASE_NOT_FOUND exception
enabled
nested tables - associative arrays

47. Types: A ______ has the same valid operations as its base type.
executable
an AUTHID property
concatenation
subtype

48. Dbms_sql: This DBMS_SQL function opens a new cursor.
OPEN_CURSOR
ordinary
inquiry
server

49. Advantage: PL/SQL is PORTABLE to any OS where ________ runs.
aggregate - analytical
SQLERRM
FOR i IN REVERSE 1..10 LOOP
Oracle

50. An editioning view can only select a subset of the columns from the base table and provide ________ for them
information that changes infrequently
session cursor
aliases
lowest