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. Exceptions: A GOTO statement CAN branch from an exception handler into an ________ block.
enclosing
associative arrays
name
cursor number

2. Delimiters: The assignment operator.
CLOSE
:=
vname CONSTANT VARCHAR2 := 'x';
array

3. An editioning view can only select a subset of the columns from the base table and provide ________ for them
aliases
nested tables - associative arrays
nested
return value

4. I/O: This package lets PL/SQL programs read and write OS files.
explicit
UTL_FILE
same arguments
composite

5. Cursors: A cursor with a name is an _________ cursor.
IN - OUT - IN OUT
error
explicit
OTHERS

6. Web: mod_plsql is an _______ module.
selection
Apache
database
bytecode

7. The NOCOPY option on an OUT or IN OUT parameter - causes it to be passed by ______.
%
cannot
anonymous
reference

8. Cursors: If no SELECT or DML statement has run - the value of SQL%ROWCOUNT is what?
RETURN

STANDARD
base

9. TCL: Undo changes back to savepoint ab.
CURRENT OF
FALSE
SQL
rollback to ab

10. Cursors: The value of SQL%ROWCOUNT after a SELECT INTO statement returns more than one row.
$END
1
procedure - function
COUNT

11. From a block nested inside a procedure P - reference variable V of the outer procedure.
-
multi-row
p.v
cursor

12. Abbreviation for Abstract Data Type.
ADT
cursor variable
disable
IF - CASE or LOOP

13. How many PL/SQL collection types are there?
OLD
USER_PROCEDURES
3
GET_LINES

14. The best candidates for result-caching are functions that are invoked frequently but depend on __________________ or never.
anonymous
information that changes infrequently
OTHERS
unconstrained

15. Cursors: What is the 'name' of the implicit cursor?
statically
EXIT
SQL
cannot

16. Advantage: PL/SQL runs anywhere Oracle runs - so it is very ________.
TOO_MANY_ROWS
portable
anonymous
DBMS_PREPROCESSOR

17. Command used to execute dynamic SQL.
SUBTYPE numb IS number;
static
EXECUTE IMMEDIATE
parameter

18. Conversion: If the specific value is suitable - ____ or _______ values can convert to almost any datatype
stored
CHAR - VARCHAR2
REUSE SETTINGS
<<>>

19. Types: ________ data types have no internal components.
set serveroutput on
name and datatype
invoker's
scalar

20. Package for getting the postprocessed source of a program.
DBMS_PREPROCESSOR
=>
CREATE TYPE
Apache

21. Declare an associative array type - t - whose elements are of type rPerson - and whose index is PLS_INTEGER.
3
TYPE t IS TABLE OF rPerson INDEX BY PLS_INTEGER;
VARRAYs
SUBTYPE n IS number not null;

22. The two main parts of a package are the ____ and the _____.
specification - body
production
END CASE
exception handler

23. PLS_INTEGER has its arithmetic implemented in ________ - so it is very fast.
pseudocolumn
significant
fetch cv into myvar
hardware

24. Cursors: You cannot use cursor attributes in _______ statements.
SQL
# - $ - _
delimiters
multi-row

25. PL/SQL does not automatically create bind variables in ________ SQL.
executable
FGA
associative arrays
dynamic

26. Delimiters: The left label delimiter.
colon
<<
fields
error

27. Cursors: The second keyword of a FETCH statement.
invalid
can
close C
INTO

28. Advantage: Performance: Stored subprograms are ______ in memory.
cached
4K
definer's
nested

29. A numeric FOR loop cannot _________ by other than 1?
GET_LINES
define
current BEGIN-END block
increment

30. Advantage: Having procedures stored and executed on the server makes PL/SQL ________.
NDS
IR
collections - records
scalable

31. I/O: This package sends text output to SQLPlus
function f (n number) return number result_cache relies_on (emps);
DBMS_OUTPUT
cannot
bb:true

32. Web: PL/SQL _______ enables a Web browser to invoke a PL/SQL stored subprogram through an HTTP listener.
Gateway
collections - records
CASE_NOT_FOUND
With a letter.

33. Triggers: The clause to make a trigger run after inserting into table EMPS.
cannot
compiles
after insert on emps
.

34. I/O: This DBMS_OUTPUT proc retrieves multiple lines from the buffer.
DATE '2005-12-25'
database
OLD
GET_LINES

35. When an autonomous routine begins execution - the main transaction is ________.
PL/SQL
open C
EXECUTE
suspended

36. 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

37. The LIMIT method is only meaningful for _______.
RAISE
VARRAYs
HTP
cannot

38. I/O: The DBMS_OUTPUT function that writes output without a newline character.
PUT
flushed
NEW
alter procedure

39. Exceptions: Each internal exception has an Oracle ______ _______.
:=
CLOSE
error code
DBMS_DDL

40. I/O: To make sure the DBMS_OUTPUT buffer will be flushed - put a WHEN ______ clause in the EXCEPTION section of your outer block.
OTHERS
set serveroutput on
cannot
does not

41. Assigning values to PL/SQL variables that appear in SQL statements is called _______.
comments
E Exception;
binding
implicit CASE_NOT_FOUND exception

42. Web: PL/SQL ______ ______ (PSPs) let you develop web pages with dynamic content.
Server Pages
p.v
optional
sql

43. Bulk: The keywords of a bulk collect FETCH statement.
inquiry
FETCH - BULK COLLECT INTO
COUNT
cannot

44. Triggers: In a per-row trigger - the ____ record shows you the changed state of an affected row.
NEW
after
dbms_output.put_line
p.v

45. Bulk: The use of FORALL statements cuts down on ______ traffic.
statement
network
bind arguments
execute

46. Declare a constrained subtype of NUMBER called N that is not null.
DATE
HTP
explicit
SUBTYPE n IS number not null;

47. Types: One of the 4 PL/SQL things that have a data type (begins with 'c').
cursor
REUSE SETTINGS
REF CURSOR
constant

48. Web: Abbreviation of PL/SQL Server Page.
unhandled
PSP
%ISOPEN.
null string

49. The four keywords that define a PL/SQL block.
DECLARE - BEGIN - EXCEPTION - END
value
TOO_MANY_ROWS
lowest

50. Exceptions: If there is no handler for an exception - PL/SQL returns an ________ exception error to the invoker or host environment.
unhandled
autonomous triggers
machine
..