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. For a collection - the NEXT method gets the next higher (element / index).
index
value
LOOP
v1 OUT number default 10

2. A numeric FOR loop cannot _________ by other than 1?
%ROWTYPE
return value
<> - != - ^=
increment

3. The DECLARE keyword is only required in an _______ _______.
function f (n number) return number result_cache relies_on (emps);
anonymous block
EDITION_NAME
open C(p)

4. The _____ utility turns PL/SQL source code into unreadable text.
TYPE tN IS TABLE of NUMBER
associative
Wrap
open cv for

5. A record is a group of related data items stored in fields - each with its own...
parameter
name and datatype
$IF
boolean

6. Cursors: The four cursor attributes - in alphabetical order.
WHERE CURRENT OF
.
virtual machine
%FOUND - %ISOPEN - %NOTFOUND - %ROWCOUNT

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

8. Simple CASE statement checks for different values of a single _________
bind arguments
expression
raise_application_error
WHEN OTHERS THEN

9. Fundamental: What is the range operator?
..
raise_application_error
null string
SYS_CONTEXT

10. Which collection type is bounded?
current
does not
varray
FETCH

11. Triggers: You create a trigger with the _______ ________ statement.
FETCH
CREATE TRIGGER
elsif
set serveroutput on

12. A result-cached function caches its results in the _____ _____ ____ (SGA)
cannot
is certain
system global area
procedure P AUTHID current_user;

13. Value of a character literal with zero characters.
32 -000
invoker's
predefined

14. Fundamental: A label can only go directly before an _______ statement.
executable
definer's
OLD
anonymous

15. DynSQL: The main command for Native Dynamic SQL.
EXECUTE IMMEDIATE
bind
CHARARR
TRUE - FALSE - NULL

16. The first SQL statement in an autonomous routine begins a _______.
transaction
suspended
LOOP - END LOOP
constrained

17. What is the simplest statement for conditionally getting out of simple loop?
anonymous block
ALTER SESSION
EXIT WHEN
...

18. The EXTEND method is not used with ______ _______.
associative arrays
suspended
select
inclusive

19. Types: ______ data types are those storing values with no internal components.
scalar
fields
enabled
IN OUT

20. Dbms_sql: DBMS_SQL package is compiled with _______ rights.

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

21. Cursors: The first two keywords in a Cursor FOR loop.
is
lock
placeholders
FOR - IN

22. A PL/SQL block that is not stored.
fail
manageable
anonymous block
associative

23. Are good for logging table DML operations.
.
autonomous triggers
an enclosing block
True

24. I/O: The DBMS_OUTPUT function that writes output WITH a newline character.
static
wrap
PUT_LINE
always

25. Web: PL/SQL ______ ______ (PSPs) let you develop web pages with dynamic content.
EDITION_NAME
after insert on emps
multi-row
Server Pages

26. Give the ANSI Date literal for December 25 - 2005.

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

27. The command used to populate PLSQL_CCFLAGS.
view
ALTER SESSION
5
LOOP - END LOOP

28. I/O: One of the 3 types of data that can be passed to the DBMS_OUTPUT buffer.
FETCH
DBMS_DDL
VARCHAR2
currval and nextval

29. Advantage: PL/SQL is PORTABLE to any OS where ________ runs.
lower sub-block
Oracle
SQL
v3 IN OUT NUMBER

30. Cursors: The SQL%BULK_ROWCOUNT attribute is an _________ -
query
definer's
UTL_FILE
array

31. The BETWEEN operator is (inclusive / exclusive).
block
BOOLEAN
32 -000
inclusive

32. Assignment of PLSQL_CCFLAGS (cannot / can) be included in ALTER PROCEDURE ... COMPILE ...
TYPE tN IS TABLE of NUMBER
can
inclusive
STANDARD

33. Type: An ________ subtype has all the values of its base type.
unconstrained
TRUE - FALSE and NULL
memory
statement

34. How many times are a FOR loop's index bounds evaluated?

SYS_REFCURSOR
Ordinary - Quoted.
once

35. IDs: The type of words that cannot be user-defined identifiers.
DML
Reserved words.
comments
parameter

36. Types of blocks: A pl/sql block that is not stored in the database.
anonymous
OLD
fetch C into V
INSTEAD OF

37. Subprograms are stored in __________ form.
executable
v3 IN OUT NUMBER
anonymous
bytecode

38. What is the exception that is implicitly raised in a CASE statement with no ELSE clause?
statically
%TYPE
FALSE
CASE_NOT_FOUND

39. The PL/SQL ________ evaluates compiler directives.
exception handler
same
preprocessor
run

40. Cursors: What implicit cursor attribute gives row counts for a FORALL statement?
is
%BULK_ROWCOUNT
TYPE t IS TABLE OF rPerson INDEX BY PLS_INTEGER;
1

41. Fundamental: Maximum string length of a PL/SQL variable.
statement
lock
32 -000
open C

42. Types: A ______ has the same valid operations as its base type.
increment
an autonomous routine
subtype
=

43. Cursors: A pointer to a cursor is called a ______ _______.
cursor variable
anonymous
SIMPLE_INTEGER
1

44. Fundamental: What are the 3 compound symbols for 'not equal to'?
<> - != - ^=
exception
DEFINER
open C(p)

45. Conversion: Implicit conversion can be (faster / slower) than explicit conversion.
slower
compilation
BINARY_INTEGER
national

46. The RESULT_CACHE clause has to be in both the declaration and in the ______ of the function.
definition
WHERE CURRENT OF
Abstract
FETCH

47. Packaged constants can synchronize programs through use in _______ directives.
3
name
selection
EXIT WHEN

48. Delimiters: The assignment operator.
flushed
:=
SUBTYPE n IS number not null;
cannot

49. Cursors: A cursor FOR loop can use an explicit or an _______ cursor.
DBMS_DDL
implicit
Declaration
elements

50. Types: Which type of arithmetic does NUMBER use - library or hardware?
-
library
an enclosing block
anonymous