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. I/O: The string table type in DBMS_OUTPUT for holding lines of text.
REF CURSOR
E Exception;
CHARARR
<> - != - ^=

2. A value that is neither represented by an identifier nor calculated from other values.
TYPE tN IS TABLE of NUMBER
literal
searched
a number := 10

3. Types: One of the scalar data types specific to PL/SQL: R_________.
REF_CURSOR
end
explicit cursor
EVERE - PERFORMANCE - INFORMATIONAL

4. PLSQL_CCFLAGS hold a comma-separated list of ______ pairs (hyphenated).
name-value
collections
execute immediate
name

5. Declare a cursor c with no parameters - and return type rC.
associative
cached
RECORD OF ARRAYS
cursor c RETURN rC;

6. Types: One of the 4 PL/SQL things that have a data type (begins with 'c').
virtual machine
constant
quoted
cannot

7. Conversion: Implicit conversion is not always predictable; it is _______-sensitive. And its rules might change.
context
lowest
Gateway
implicit cursor

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

9. Data dictionary view giving the AUTHID values on a user's objects.
Double quotes.
close C
USER_PROCEDURES
lock

10. Exceptions: You can pass an ______ ________ to SQLERRM.
stored
SQL cursor
virtual machine
error code

11. IDs: The two types of words that can - but should not - be used as user-defined identifiers.
Keywords and predefined names.
current BEGIN-END block
selection
numeric and cursor

12. I/O: This package has hypertext functions that generate HTML tags
drop procedure
TRUE - FALSE and NULL
RECORDS
HTF

13. PL/SQL lets you define two kinds of composite data types: _______ and _______
collections - records
# - $ - _
Web Toolkit
invoker's

14. Advantage: Performance: Storing and runnng procedures on the server minimizes ______ traffic.
anonymous
network
FORALL and BULK COLLECT
API

15. Web: mod_plsql is an implementation of the PL/SQL _________.
SQLERRM
UTL_HTTP
Gateway
TYPE tA IS TABLE OF NUMBER INDEX BY VARCHAR2(20)

16. To run TCL or DDL statements - a trigger (must / must not) be autonomous .
must
DATE
bind arguments
CURSOR - RETURN

17. Web: PL/SQL ______ ______ (PSPs) let you develop web pages with dynamic content.
wrap
NEW
same
Server Pages

18. Bulk: The use of FORALL statements cuts down on ______ traffic.
CHAR - VARCHAR2
network
object
cannot

19. I/O: Max number of bytes DBMS_OUTPUT can handle in a session.
Reserved words.
procedure P AUTHID current_user;
FORALL i IN MyList.FIRST..MyList.LAST
1 million

20. Kind of comment not to put in a PL/SQL block to be processed dynamically by an Oracle Precompiler program.
alter procedure
single-line
3
cannot

21. Cursors: A cursor FOR loop cannot use a _______ variable.
..
cursor
Ordinary - Quoted.
exit when cgo%NOTFOUND

22. In short-circuit evaluation - IF-conditions are only evaluated up to where the outcome ___________.
is certain
do not
does not
return value

23. CREATE TYPE cannot be used for _______ array types.
associative
EXIT WHEN
SQL
null string

24. Command to make a no-op (omit semicolon).

finishes
RETURN
DBMS_OUTPUT

25. I/O: Max number of bytes to pass in a call to DBMS_OUTPUT.PUT_LINE.
once
name
;
255

26. Exceptions: Each internal exception has an Oracle ______ _______.
error code
exception handler
VARRAYs
CURSOR - RETURN

27. I/O: The output from DBMS_OUTPUT will display (during/after) program execution.
SQL
FALSE
block
after

28. Statement to set current schema to x: _____ _____ SET CURRENT_SCHEMA = 'x';
inclusive
3
implicit
ALTER SESSION

29. Cursors: You can just declare a cursor at first - then _______ it later.
rollback to ab
cursor
BOOLEAN
define

30. Static typing is also called _____ typing.
%BULK_ROWCOUNT
simple
True
strong

31. A PL/SQL extension to the WHERE clause of the SQL statements UPDATE and DELETE
WHERE CURRENT OF
never

SESSION_USER

32. Exceptions: The three words that can be used to guarantee all exceptions will be handled.
DML
WHEN OTHERS THEN
PLS_INTEGER
SQL cursor

33. With an sparse - integer-indexed associative array - you (can / cannot) use a regular FOR loop.
cannot
**
PLS_INTEGER
query

34. IDs: You cannot use reserved words as ______ user-defined identifiers.
DEFINER
BOOLEAN
p.v
ordinary

35. Term for a character literal with zero characters.
composite
=>
iname
null string

36. Cursors: A cursor FOR loop can use an explicit or an _______ cursor.
invalid
2
EXCEPTION_INIT
implicit

37. Cursors: You cannot use cursor attributes in _______ statements.
DML
SQL
Declaration
simple and compound symbols

38. Advantage: PL/SQL supports ______-oriented programming.
object
EXIT WHEN
**
statically

39. Cursors: The first two keywords in a Cursor FOR loop.
FOR - IN
transaction
API
open cv for

40. The allowed data types of user-defined conditional compilation directives are boolean and _______.
USER_PLSQL_OBJECT_SETTINGS
pls_integer
savepoint ab
Oracle

41. DynSQL: The clause that receives single-row query output from EXECUTE IMMEDIATE.
FETCH
ROLLBACK
autonomous transaction
INTO

42. ______ SQL is a PL/SQL feature that allows SQL syntax directly in a PL/SQL statement.
associative
static
collections - records
Ordinary - Quoted.

43. Cursors: The keyword that makes a ref cursor type STRONG.
PRAGMA EXCEPTION_INIT (E - -1);
RETURN
EXECUTE IMMEDIATE
integer

44. You can put a label before any executable PL/SQL _________.
4
Gateway
same
statement

45. Exceptions: Some internal exceptions have ________ names.
variable
colon
predefined
bind

46. Command used to execute dynamic SQL.
EXECUTE IMMEDIATE
FOR UPDATE
is certain
DML

47. Searchable CASE statement: Each WHEN has its own _______ condition.
%BULK_ROWCOUNT
integrated
boolean
library

48. What word is in a function header but not in a procedure header?
LOOP
CREATE TYPE
delimiters
RETURN

49. Delimiters: The association operator.
E Exception;
DATE
WHEN OTHERS THEN
=>

50. Dbms_sql: The integer returned by OPEN_CURSOR is a _____ _____.
scalable
reference
OUT
cursor number