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. In short-circuit evaluation - IF-conditions are only evaluated up to where the outcome ___________.
rollback to ab
TYPE t IS TABLE OF rPerson INDEX BY PLS_INTEGER;
is certain
associative

2. Triggers: The clause to make a trigger run before inserting or updating table EMPS.
fetch cv into myvar
Gateway
is
before insert or update on emps

3. Declare an output NUMBER parameter - v1 - that defaults to 10.
ordinary
L.V
FOR i IN REVERSE 1..10 LOOP
v1 OUT number default 10

4. Web: PL/SQL _____ _______ lets you to develop Web applications made of PL/SQL procedures.
Web Toolkit
sequence pseudo-columns
forward
=>

5. The compiler directive governing conditional compilation.
EXTEND
$IF
native dynamic
4

6. Labels for blocks and statements are enclosed in '__' brackets.
<<>>
is certain
base
after

7. When a session starts - CURRENT_SCHEMA has the value of the schema owned by ___________.
TYPE t IS TABLE OF rPerson INDEX BY PLS_INTEGER;
SESSION_USER
reference
REF CURSOR

8. Default file extension of wrap's input file.
sql
COMMIT - ROLLBACK - SAVEPOINT - SET TRANSACTION
integer
name-value

9. I/O: This DBMS_OUTPUT proc retrieves one line from the buffer.
DEFINER
.
GET_LINE
4

10. With Edition-based Redefinition enabled - the unique specification of an object requires OWNER - OBJECT_NAME and ___________.
NDS
executable
EDITION_NAME
obfuscates

11. Exceptions: The maximum length of an Oracle error message is ____ characters
cursor variable
unqualified
timing
512

12. Web: The gateway that allows a web browser to invoke a PL/SQL procedure through an HTTP listener.
single-line
PL/SQL Gateway
scalar
WHERE CURRENT OF

13. In PL/SQL - what the variables in DML statements are turned into.
bind arguments
constrained
1
'ENABLE:SEVERE' - 'ERROR:06002'

14. Command to delete a procedure.
drop procedure
END LOOP
DBMS_OUTPUT
must

15. A PL/SQL block that is not stored.
anonymous block
Ordinary - Quoted.
cursor variable
OPEN

16. You (can/cannot) put a label before an END LOOP statement.
@
cannot
%
unqualified

17. The command used to populate PLSQL_CCFLAGS.
INTO
EXIT
=>
ALTER SESSION

18. A numeric FOR loop cannot _________ by other than 1?
increment
order
v2 IN NUMBER default 20
SQL

19. The four keywords that define a PL/SQL block.
DECLARE - BEGIN - EXCEPTION - END
$IF
...
autonomous triggers

20. Delimiters: Item separator.

IF - CASE or LOOP
nested
for each row

21. How to reference a variable V declared in a block labelled L: ____.
;
reference
IN - OUT - IN OUT
L.V

22. Triggers: There are __ types of triggers.
5
optional
closed
ENABLE

23. A null string and a BOOLEAN null are _______ (same/not the same).
compilation
ROLLBACK
ALTER SESSION
not the same

24. I/O: Max number of bytes DBMS_OUTPUT can handle in a session.
system global area
1 million
nested
OPEN_CURSOR

25. The PL/SQL preprocessor passes ______ code to the compiler.
NESTED TABLE myColl STORE AS myCollTab
current BEGIN-END block
variable
source

26. A (simple / searched) CASE statement begins with CASE <expression>.
Web Toolkit
WHEN OTHERS THEN
simple
can

27. The Wrap utility (does / does not) encrypt source code.
does not
value
function f (n number) return number result_cache relies_on (emps);
EXIT WHEN

28. Advantage: Having procedures stored and executed on the server makes PL/SQL ________.
hardware
scalable
selection
define

29. To use a TYPE declared in the database - a PL/SQL block has to have _______ privilege on the type.
USING
predefined
select
anonymous block

30. A SELECT statement with the FOR UPDATE clause puts a ______ on the selected rows.
lock
%ROWTYPE
anonymous
DBMS_OUTPUT

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

32. Fundamental: A label can be used to name an ______ block.
TRUE - FALSE - NULL
FETCH
anonymous
network

33. DynSQL: The three modes of arguments in the USING clause of EXECUTE IMMEDIATE.
finishes
IN - OUT - IN OUT
numeric and cursor
DBMS_PIPE

34. Packaged constants can synchronize programs through use in _______ directives.
selection
suspended
CLOSE_CURSOR
IF - CASE or LOOP

35. I/O: The string table type in DBMS_OUTPUT for holding lines of text.
STANDARD
aggregate - analytical
DBMS_SQL
CHARARR

36. DynSQL: The colon-prefixed names used in EXECUTE IMMEDIATE are called ________.
placeholders
bind
package
not the same

37. Exceptions: Start of the range of error codes for RAISE_APPLICATION_ERROR.
never
$IF
=
-20 -000

38. Cursors: The first two keywords of a basic fetch statement.
cursor number
CLOSE
FETCH - INTO
memory

39. Parameter that controls how much Oracle optimizes your PL/SQL code on compilation.
PLSQL_OPTIMIZE_LEVEL
preprocessor
STANDARD
DML

40. Abbreviation of definer's rights
True - false or NULL.
pls_integer
32 -000
DR

41. Dbms_sql: The integer returned by OPEN_CURSOR is a _____ _____.
placeholders
NUMBER
cursor number
5

42. In the IF syntax - is if ENDIF or END IF?
END IF
;
pls_integer
FOR UPDATE

43. The RESULT_CACHE clause has to be in both the declaration and in the ______ of the function.
cached
definition
lower sub-block
alter procedure

44. Dbms_sql: A cursor opened with OPEN_CURSOR (can/cannot) be reused for multiple queries without first closing it.
IN - OUT - IN OUT
can
%FOUND - %ISOPEN - %NOTFOUND - %ROWCOUNT
unqualified

45. The EXCEPTION section is (optional/mandatory).
optional
SESSION_USER
WHEN OTHERS THEN
invoker's

46. The attribute used to get the type of a column or variable without knowing what it is.
DBMS_SQL
DBMS_SESSION.RESET_PACKAGE
collections
%TYPE

47. Triggers: The clause to make a trigger run once for every affected row.
server
object
index
for each row

48. Triggers: In a per-row trigger - the ____ record shows you the changed state of an affected row.
NDS
SYS_CONTEXT
NEW
IN

49. If a result-cached function's data source (based on the RELIES_ON clause) is updated - any cached results become _______.
OUT
composite
invalid
...

50. Cursors: A cursor that lives in session memory until the session ends.
cursor
Declaration
session cursor
upper - coalesce