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. Value of PLSQL_OPTIMIZE_LEVEL that prevents optimization.
cannot
1
expression
SUBTYPE n IS number not null;

2. Fundamental: A label can only go directly before an _______ statement.
select
executable
query
aggregate - analytical

3. Name the two types of FOR loop.
versions
LOOP
numeric and cursor
cannot

4. The command used to populate PLSQL_CCFLAGS.
ALTER SESSION
do not
anonymous block
cached

5. Cursors: The type definition of a WEAK ref cursor type has no _______ clause.
Reserved words.
# - $ - _
RETURN
flushed

6. Exceptions: A GOTO statement CAN branch from an exception handler into an ________ block.
simple
enclosing
UTL_SMTP
OPEN

7. Types: ________ data types have internal components.
portable
GET_LINES
DATE
composite

8. I/O: SQLPlus command for turning on buffered output.
set serveroutput on
OPEN
DATE
collections - records

9. Exceptions: Some internal exceptions have ________ names.
alter procedure
Reserved words.
FGA
predefined

10. The RESULT_CACHE clause has to be in both the declaration and in the ______ of the function.
SUBTYPE numb IS number;
definition
-20 -000
True - false or NULL.

11. Kind of comment not to put in a PL/SQL block to be processed dynamically by an Oracle Precompiler program.
DEFINER
lock
single-line
index

12. Cursors: A session cursor that a PL/SQL user creates and manages.
order
DBMS_PIPE
END
explicit cursor

13. Types: Which type of arithmetic does NUMBER use - library or hardware?
COUNT
library
block
for update of

14. In PL/SQL - what the variables in DML statements are turned into.
bind arguments
CHAR - VARCHAR2
OTHERS
TOO_MANY_ROWS

15. A nested table has to be initialized using a ________ - named the same as the type.
order
constructor
cannot
EXIT WHEN cv%NOTFOUND

16. Wrapped code (is / is not) not backward compatible.
dense
cannot
same arguments
is not

17. The Wrap utility ________ the source code.
obfuscates
label
loop
RETURN

18. DynSQL: The colon-prefixed names used in EXECUTE IMMEDIATE are called ________.
once
placeholders
1 million
WHEN

19. The three types of compiler warnings.
EVERE - PERFORMANCE - INFORMATIONAL
SQLERRM
NEW
do not

20. A (simple / searched) CASE statement begins with CASE WHEN <boolean expression>.
stored
order
searched
PSP

21. Give the statement to make a program autonomous.
VARRAYs
PRAGMA AUTONOMOUS_TRANSACTION;
FETCH
composite

22. Simple CASE statement checks for different values of a single _________
session cursor
expression
alter procedure
FETCH - INTO

23. What are the two sequence pseudo-columns?
dense
currval and nextval
literals
DECLARE - BEGIN - EXCEPTION - END

24. Cursors: You give an explicit cursor a name and associate it with a _______.
v2 IN NUMBER default 20
is certain
query
dense

25. What is the exception that is implicitly raised in a CASE statement with no ELSE clause?
:=
=
CASE_NOT_FOUND
an autonomous routine

26. Exceptions: An unhandled exception ________ to the enclosing block.
propagates
EXTEND
collections - records
DEFINER

27. Types: One of the scalar data types specific to PL/SQL: P________
PLS_INTEGER
VARCHAR2
static boolean
DML

28. Cursors: Statement to end a loop when MyCur is used up: _____ ______ MyCur%NOTFOUND.
portable
EXIT WHEN
associative
CLOSE_CURSOR

29. Dbms_sql: This DBMS_SQL function opens a new cursor.
OPEN_CURSOR
nested tables - associative arrays
function f (n number) return number result_cache relies_on (emps);
=>

30. What do you FETCH from?
a cursor
procedure P AUTHID current_user;
INSTEAD OF
FOR - IN

31. DBMS_DDL.WRAP returns a string containing wrapped _____ _____.
context
source code
LOOP - END LOOP
definer's

32. A GOTO cannot branch into an...
native dynamic
SQL
IF - CASE or LOOP
name-value

33. Conditional compilation is useful for compiling a program under different ______ of Oracle.
literals
calls
versions
placeholders

34. I/O: This package sends text output to SQLPlus
UTL_SMTP
array
slower
DBMS_OUTPUT

35. FOR-Looping over a collection from FIRST to LAST only works if the collection is _______.
DML
1
cannot
dense

36. I/O: To make sure the DBMS_OUTPUT buffer will be flushed - put a WHEN ______ clause in the EXCEPTION section of your outer block.
associative
OTHERS
package
dynamic

37. Bulk: The implicit cursor attribute that gives the number of rows affected by each DML statement in a FORALL statement.
r tRec := tRec(9 - 'Jones');
r t.%ROWTYPE;
Abstract
%BULK_ROWCOUNT

38. Collections are one of the two kinds of PL/SQL _______ data types.
composite
multi-row
DML
REUSE SETTINGS

39. Types: One of the 4 PL/SQL things that have a data type (begins with 'p').
SQL
obfuscates
/*
parameter

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

41. Exceptions: The built-in procedure for raising an application-defined error.
value
raise_application_error
hardware
EXTEND

42. Types: One of the scalar data types specific to PL/SQL: B_______
package
BINARY_INTEGER
network
not the same

43. In the special IF syntax - is it ELSIF - or ELSEIF?
r t.%ROWTYPE;
%ROWTYPE
elsif
do not

44. Delimiters: Statement terminator.
CHARARR
specification - body
1 million
;

45. Advantage: PL/SQL is PORTABLE to any OS where ________ runs.
network
5
object
Oracle

46. DynSQL: Native Dynamic SQL
DBMS_OUTPUT
network
<<>>
NDS

47. The allowed data types of user-defined conditional compilation directives are boolean and _______.
bind arguments
constructor
<<>>
pls_integer

48. _______ arrays can be sparse or dense - depending on how you fill them.
constant
associative
TRUE - FALSE - NULL
expression

49. A numeric FOR loop cannot _________ by other than 1?
INTO
.
inquiry
increment

50. Cursors: A cursor FOR loop can use an explicit or an _______ cursor.
implicit
network
composite
pls_integer