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. IDs: The two types of words that can - but should not - be used as user-defined identifiers.
anonymous
invalid
VARRAYs
Keywords and predefined names.

2. Which two of these built-in SQL functions can be used in procedural (PL/SQL) statements: DECODE - CORR - UPPER - SUM - COALESCE - DEREF.
comments
order
raise_application_error(-20 -100 - 'Bad');
upper - coalesce

3. The allowed data types of user-defined conditional compilation directives are boolean and _______.
pls_integer
exception
selection
buffer

4. I/O: This package handles HTTP.
stored
UTL_HTTP
EXIT WHEN
transaction

5. IDs: The type of words that cannot be user-defined identifiers.
procedure P AUTHID definer;
Reserved words.
DBMS_DDL
INTO

6. Nested tables are multisets - meaning that there is no inherent _____ of their elements.
is
DEFINER
order
1

7. Wrapped code (is / is not) not backward compatible.
quoted
UTL_SMTP
is not
Reserved words.

8. A kind of variable used as a placeholder.
multi-row
DML
bind
With a letter.

9. Delimiters: The left label delimiter.
associative
<<
obfuscates
do not

10. Exceptions: A GOTO statement CAN branch from an exception handler into an ________ block.
DML
nested tables - associative arrays
after
enclosing

11. Declare an associative array type - t - whose elements are of type rPerson - and whose index is PLS_INTEGER.
# - $ - _
TYPE t IS TABLE OF rPerson INDEX BY PLS_INTEGER;
currval and nextval
user-defined

12. Default file extension of wrap's output file.
PLS_INTEGER
anonymous
%ISOPEN.
plb

13. Cursors: WHERE _______ ______ makes an UPDATE or DELETE apply to the current row of a cursor.
cannot
external subprogram
CURRENT OF
stored

14. You have to use _______ SQL to run DDL statements n PL/SQL.
%FOUND - %ISOPEN - %NOTFOUND - %ROWCOUNT
loop
dynamic
cannot

15. An $ERROR directive ends with _____.
expression
SQL
constrained
$END

16. Clause added to a cursor to use it with WHERE CURRENT OF.
EXECUTE IMMEDIATE
for update of
..
TYPE t IS TABLE OF rPerson INDEX BY PLS_INTEGER;

17. The NOCOPY option on an OUT or IN OUT parameter - causes it to be passed by ______.
reference
source
elsif
session cursor

18. 5 types of events that can have triggers: DML - DDL - INSTEAD OFs - database events - and ________ statements.
subtype
after
suspended
DBMS_CRYPTO

19. INSTEAD OF triggers are alternatives to ___ triggers
fail
name-value
DML
DECLARE - BEGIN - EXCEPTION - END

20. Cursors: You cannot use cursor attributes in _______ statements.
significant
SQL
raise_application_error
searched

21. Statement to exit a cursor loop on cursor cGo when there are no more records.
exit when cgo%NOTFOUND
single-line
procedure P AUTHID definer;
NESTED TABLE myColl STORE AS myCollTab

22. I/O: The DBMS_OUTPUT function that writes output WITH a newline character.
varray
obfuscates
lower sub-block
PUT_LINE

23. IDs: How an ordinary user-defined identifier must begin.
DML
composite
With a letter.
/*

24. Cursors: You can just declare a cursor at first - then _______ it later.
define
numeric and cursor
CURRENT_USER
unhandled

25. With a result-cached function - it uses a cached value when the function is called again with the...
iname
Gateway
OLD
same arguments

26. Web: PL/SQL _______ enables a Web browser to invoke a PL/SQL stored subprogram through an HTTP listener.
DBMS_PREPROCESSOR
Gateway
TRUE - FALSE - NULL
RELIES_ON

27. Exceptions: Pragma that links an exception to an Oracle error code.
EXCEPTION_INIT
%BULK_ROWCOUNT
FETCH
explicit cursor

28. Wrapping can be done with the ____ executable.
wrap
cannot
RETURN
searched

29. The BETWEEN operator is (inclusive / exclusive).
EXIT
ROLLBACK
FOR i IN REVERSE 1..10 - LOOP - NULL; END LOOP;
inclusive

30. Cursors: A Cursor FOR loop does not use a ______ statement.
Keywords and predefined names.
FETCH
OTHERS
dynamic

31. Fundamental: Maximum string length of a PL/SQL variable.
32 -000
BOOLEAN
session cursor
loop

32. Cursors: A cursor FOR loop can use an explicit or an _______ cursor.
SESSION_USER
implicit
enclosing
significant

33. I/O: The PL/SQL I/O packages (can/cannot) accept input directly from the keyboard.
currval and nextval
cannot
1 million
strong

34. Fundamental: One of the 4 types of lexical units: L_____
executable
executable
RESULT_CACHE
literals

35. Triggers: The clause to make a trigger run after inserting into table EMPS.
anonymous block
DBMS_DDL
query
after insert on emps

36. Cursors: A session cursor that is automatically created and managed by PL/SQL.
implicit cursor
WHERE CURRENT OF
FETCH
UTL_FILE

37. Bulk: The use of FORALL statements cuts down on ______ traffic.
network
can
a number := 10
FORALL i IN MyList.FIRST..MyList.LAST

38. Cursors: The first two keywords in a Cursor FOR loop.
base
%ISOPEN.
EXECUTE
FOR - IN

39. Cursors: The three keywords in a full cursor declaration/definition (before the SELECT).
package
CURSOR - RETURN - IS
exit when cgo%NOTFOUND
binding

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. Statement to set current schema to x: _____ _____ SET CURRENT_SCHEMA = 'x';
wrap
concatenation
finishes
ALTER SESSION

42. Triggers and views always have _________ rights.

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

43. Fundamental: Delimiters are _____ and _____ symbols.
concatenation
simple and compound symbols
current
32 -000

44. Records are one of the two kinds of PL/SQL _______ data types.
does not
external subprogram
must
composite

45. Cursors: The Oracle predefined REF CURSOR type.
run
scalar
SYS_REFCURSOR
value

46. Abbreviation of definer's rights
flushed
EXTEND
network
DR

47. What are two categories of SQL functions that cannot be used in procedural statements?
boolean
EDITION_NAME
USING
aggregate - analytical

48. Fundamental: One of the 4 types of lexical units: d_____
define
delimiters
current BEGIN-END block
4K

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

50. Types: ________ data types have no internal components.
r t.%ROWTYPE;
scalar
STANDARD
CURRENT_USER - DEFINER