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: Max number of bytes to pass in a call to DBMS_OUTPUT.PUT_LINE.
composite
ALTER SESSION
255
HTF

2. The statement that is used to execute most (native) dynamic SQL.
RECORD OF ARRAYS
execute immediate
implicit
FALSE

3. Cursors: The SQL%BULK_ROWCOUNT attribute is an _________ -
array
OLD
GET_LINE
information that changes infrequently

4. DBMS_DDL.WRAP returns a string containing wrapped _____ _____.
source code
production
reference
obfuscates

5. The three possible values of a BOOLEAN literal.
REUSE SETTINGS
nested tables - associative arrays
True - false or NULL.
Server Pages

6. A ___________ behaves like a table column - but it is not stored in the table.
procedure P AUTHID current_user;
not the same
pseudocolumn
index

7. Default file extension of wrap's output file.
drop procedure
plb
database
%FOUND - %ISOPEN - %NOTFOUND - %ROWCOUNT

8. Conversion: Implicit conversion can be (faster / slower) than explicit conversion.
column
order
1
slower

9. Cursors: What are the 3 possible values of SQL%FOUND and SQL%NOTFOUND?
TRUE - FALSE - NULL
invalid
RETURN
always

10. DynSQL: EXECUTE IMMEDIATE can be used for any SQL statement or PL/SQL block - except for ________ queries.
multi-row
Abstract
is certain
name-value

11. Fundamental: Maximum string length of a PL/SQL variable.
REF_CURSOR
inquiry
32 -000
FETCH

12. A type of compiler directive - begins with 's'.
FGA
bytecode
integrated
selection

13. Abbreviation of definer's rights
binding
DR
FORALL i IN MyList.FIRST..MyList.LAST
PVM

14. I/O: The output from DBMS_OUTPUT will display (during/after) program execution.
after
PRAGMA EXCEPTION_INIT (E - -1);
obfuscates
EXECUTE

15. DynSQL: The clause that receives single-row query output from EXECUTE IMMEDIATE.
1 million
literals
obfuscates
INTO

16. DynSQL: The three modes of arguments in the USING clause of EXECUTE IMMEDIATE.
1
block
IN - OUT - IN OUT
EXIT WHEN

17. A national character literal is composed of characters in the ________ character set.
package
national
define
plb

18. The compiler directive governing conditional compilation.
memory
definer's
$IF
Apache

19. Nested tables are multisets - meaning that there is no inherent _____ of their elements.
associative
cannot
is certain
order

20. Clause added to a cursor to use it with WHERE CURRENT OF.
%
for update of
USING
dynamic

21. Types: In addition to the SQL data types - PL/SQL has ___ more scalar data types.
do not
PSP
$$
4

22. Declare a cursor c with no parameters - and return type rC.
cursor c RETURN rC;
p.v
<<
exit when cgo%NOTFOUND

23. PLSQL_CCFLAGS hold a comma-separated list of ______ pairs (hyphenated).
name-value
3
colon
savepoint ab

24. Fundamental: What is the exponentiation operator?
numeric and cursor
30
**
/*

25. The PL/SQL virtual machine turns bytecode into system ______.
memory
calls
do not
EXIT

26. You can put a label before any executable PL/SQL _________.
v2 IN NUMBER default 20
function f (n number) return number result_cache relies_on (emps);
statement
closed

27. Dbms_sql: This DBMS_SQL function opens a new cursor.
TOO_MANY_ROWS
always
statement
OPEN_CURSOR

28. Declare an input NUMBER parameter - v2 - that defaults to 20.
block
implicit
for each row
v2 IN NUMBER default 20

29. IDs: You cannot use reserved words as ______ user-defined identifiers.
SIMPLE_INTEGER
ordinary
BOOLEAN
Server Pages

30. Command used to execute dynamic SQL.
specification - body
reference
HTF
EXECUTE IMMEDIATE

31. Triggers: The clause to make a trigger run once for every affected row.
for each row
exception
an enclosing block
searched

32. A GOTO cannot branch into a...
4K
lower sub-block
FOR i IN REVERSE 1..10 - LOOP - NULL; END LOOP;
END IF

33. Cursors: If you use an EXIT statement to exit a cursor FOR loop prematurely - the cursor (is / is not) closed automatically.
loop
is certain
is
always

34. The variable showing the user id that is automatically prepended to object names.
DECLARE - BEGIN - EXCEPTION - END
=
CURRENT_USER
a cursor

35. Give the first line of the FOR loop with index i going from 1 to 10 in reverse.
FOR i IN REVERSE 1..10 LOOP
API
constrained
END LOOP

36. Exceptions: Type ______ to re-raise the current exception.
SYS_REFCURSOR
PSP
RAISE
INSTEAD OF

37. An anonymous block always has _________ rights.

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

38. Statement to set current schema to x: _____ _____ SET CURRENT_SCHEMA = 'x';
ALTER SESSION
dynamic
COUNT
finishes

39. You can define PL/SQL collections using TYPEs defined in the _______.
FOR i IN REVERSE 1..10 - LOOP - NULL; END LOOP;
database
USER_PROCEDURES
EXIT WHEN cv%NOTFOUND

40. Make a FOR loop that executes NULL 10 times counting in reverse - using index i.
anonymous block
never
deletions
FOR i IN REVERSE 1..10 - LOOP - NULL; END LOOP;

41. The method to add one or more elements to a nested table or VARRAY is ______.
literal
OUT
cursor c RETURN rC;
EXTEND

42. Types: One of the 4 PL/SQL things that have a data type (begins with 'r').
searched
ROLLBACK
compilation
return value

43. Language that PL/SQL is derived from.
value
SQLCODE
statement
Ada

44. Triggers: By default - a trigger is created in the ______ state.
set serveroutput on
enabled
3
DATE

45. Exceptions: An unhandled exception ________ to the enclosing block.
propagates
raise_application_error(-20 -100 - 'Bad');
IN OUT
cursor

46. DynSQL: Native Dynamic SQL
sequence pseudo-columns
%FOUND - %ISOPEN - %NOTFOUND - %ROWCOUNT
NDS
%BULK_ROWCOUNT

47. Declaration of a varchar2 constant - called vname - with value 'x'.

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

48. You can have many autonomous transactions in ___________.
UTL_HTTP
WHERE CURRENT OF
an autonomous routine
invoker's

49. What clause makes a compilation default to the PLSQL_CCFLAGS settings from the last compilation?
L.V
PSP
name
REUSE SETTINGS

50. Fundamental: Character used to escape a single quote inside a literal.

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