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. Fundamental: One of the 4 types of lexical units: L_____
same
increment
numeric and cursor
literals

2. Cursors: You cannot use cursor attributes in _______ statements.
PL/SQL
cursor c RETURN rC;
SQL
r tRec := tRec(9 - 'Jones');

3. Command to assign to variables from a cursor.
compilation
production
<<
FETCH

4. Setting CURRENT_SCHEMA only changes what is prepended to __________ references.
hardware
unqualified
suspended
'

5. Kind of comment not to put in a PL/SQL block to be processed dynamically by an Oracle Precompiler program.
column
single-line
PUT
cursor

6. DynSQL: In EXECUTE IMMEDIATE - the statement string can use either placeholders - or string ________.
explicit
do not
concatenation
LOOP - END LOOP

7. I/O: The buffered output of dbms_output.put_line is retrieved by _______.
'
1
SQLPlus
definer's

8. Cursors: The four cursor attributes - in alphabetical order.
implicit
%FOUND - %ISOPEN - %NOTFOUND - %ROWCOUNT
cached
closed

9. Triggers: On a non-editioning view - you can only define __________ triggers.
INSTEAD OF
virtual machine
pls_integer
name

10. I/O: One of the 3 types of data that can be passed to the DBMS_OUTPUT buffer.
external subprogram
aliases
exception handler
VARCHAR2

11. The PL/SQL ________ evaluates compiler directives.
preprocessor
collections - records
3
composite

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

13. Types: In addition to the SQL data types - PL/SQL has ___ more scalar data types.
will not
4
BOOLEAN
autonomous triggers

14. Types: A ______ has the same valid operations as its base type.
subtype
for each row
label
3

15. A collection is an ordered group of ________ - all of the same ____
block
;
elements - type
cursor number

16. By default - an IN parameter is passed by ______.
Abstract
array
anonymous block
reference

17. _________ exceptions can not be trapped with an error handler
can
Declaration
FOR - IN
bind

18. I/O: This package does email.
SYS_CONTEXT
$END
UTL_SMTP
CURSOR - RETURN - IS

19. Bulk: The implicit cursor attribute that gives the number of rows affected by each DML statement in a FORALL statement.
CURRENT_USER
lock
collections
%BULK_ROWCOUNT

20. Web: PL/SQL ______ ______ (PSPs) let you develop web pages with dynamic content.
%
Server Pages
composite
inquiry

21. Data dictionary view that shows the compiler settings for each compiled object.
cannot
USER_PLSQL_OBJECT_SETTINGS
fine-grained auditing
error code

22. The 4 keywords in the $IF compiler directive.
SIMPLE_INTEGER
upper - coalesce
open C(p)
$IF $THEN $ELSE $END

23. Exceptions: An unhandled exception ________ to the enclosing block.
propagates
cursor
exit when cgo%NOTFOUND
parameter

24. Cursors: The index variable in a cursor FOR loop (does/does not) need to be declared.
does not
order
REUSE SETTINGS
compiles

25. %ROWTYPE gets the type of a table or _______.
WHERE CURRENT OF
do not
cursor
decimal

26. To exit an active autonomous transaction without causing an exception - you must issue _____ or ______.
3
commit - rollback
variable
information that changes infrequently

27. Define a record variable r - of type tRec - initialized with values 9 and 'Jones' in its two fields.

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

28. A PL/SQL block that is not stored.
DML
Gateway
savepoint ab
anonymous block

29. Advantage: PL/SQL runs anywhere Oracle runs - so it is very ________.
value
error code
fields
portable

30. The BEGIN section is (optional/mandatory)
non-editioning views
mandatory
...
<<>>

31. In interpreted mode - the PL/SQL VM interprets the _________.
for each row
autonomous triggers
bytecode
PLSQL_CCFLAGS

32. You can define PL/SQL collections using TYPEs defined in the _______.
definition
cursor
query
database

33. In interpreted mode - PL/SQL code is run in a _______ _______.
query
for each row
virtual machine
alter procedure

34. Delimiters: The assignment operator.
:=
END CASE
identifiers
VARRAYs

35. Bulk: The use of FORALL statements cuts down on ______ traffic.
network
VARCHAR2
'ENABLE:SEVERE' - 'ERROR:06002'
DATE

36. Types: One of the scalar data types specific to PL/SQL: B_______
literals
BINARY_INTEGER
raise_application_error(-20 -100 - 'Bad');
cached

37. I/O: This DBMS_OUTPUT proc retrieves one line from the buffer.
SQLERRM
STANDARD
lowest
GET_LINE

38. I/O: One of the 3 types of data stored in the DBMS_OUTPUT buffer.
open C
IN
integer
DATE

39. The _______ package lets you wrap dynamically generated PL/SQL.
DBMS_DDL
hardware
$IF
HTP

40. Cursors: If you use an EXIT statement to exit a cursor FOR loop prematurely - the cursor (is / is not) closed automatically.
currval and nextval
NEW
is
1

41. Which two of these built-in SQL functions can be used in procedural (PL/SQL) statements: DECODE - CORR - UPPER - SUM - COALESCE - DEREF.
hardware
upper - coalesce
3
exception handler

42. Types: The PL/SQL type that is identical to PLS_INTEGER.
VARRAYs
BINARY_INTEGER
nested tables - associative arrays
invalid

43. The exception raised when a SELECT INTO statement returns more than one row.
native dynamic
TOO_MANY_ROWS
cursor
name-value

44. For a collection - the NEXT method gets the next higher (element / index).
ex := tbl1 MULTISET EXCEPT tbl2
index
IN
Apache

45. $$PLSQL_LINE and $$PLSQL_UNIT are ______-ly defined inquiry directives.
implicit
*/
ADT
array

46. Delimiters: Item separator.
5
never

varray

47. Advantage: PL/SQL gives SCALABILITY because stored procedures are executed on the _______.
server
TRUE - FALSE - NULL
explicit
:=

48. Are good for logging table DML operations.
Server Pages
autonomous triggers
cursor c;
can

49. Triggers: INSTEAD OF triggers only run on ______ views.
TYPE rec IS RECORD (num NUMBER - name VARCHAR2(10));
after
non-editioning views
5

50. Cursors: Give the statement to fetch data from cursor C into variable V.
CREATE TRIGGER
fetch C into V
anonymous
an autonomous routine