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. Are good for logging table DML operations.
PLSQL_OPTIMIZE_LEVEL
INTO
pls_integer
autonomous triggers

2. Cursors: Only a _____ _____ cursor can appear in the CURRENT OF clause of an UPDATE or DELETE statement.
SQL cursor
VARCHAR2
FOR UPDATE
# - $ - _

3. Triggers: You create a trigger with the _______ ________ statement.
CREATE TRIGGER
significant
'
explicit cursor

4. Types: One of the scalar data types specific to PL/SQL: B_______
network
%ISOPEN.
BINARY_INTEGER
finishes

5. DynSQL: The three modes of arguments in the USING clause of EXECUTE IMMEDIATE.
explicit
statically
IN - OUT - IN OUT
error code

6. Web: PL/SQL _______ enables a Web browser to invoke a PL/SQL stored subprogram through an HTTP listener.
SIMPLE_INTEGER
flushed
never
Gateway

7. I/O: One of the 3 types of data stored in the DBMS_OUTPUT buffer.
1 million
query
error code
DATE

8. List the transaction control statements.
bind
COMMIT - ROLLBACK - SAVEPOINT - SET TRANSACTION
rollback to ab
1

9. Exceptions: The _________ package defines the PL/SQL environment.
STANDARD
ENABLE
CURRENT OF
UTL_SMTP

10. A type of compiler directive - begins with 's'.
FGA
name
selection
..

11. A SELECT statement with the FOR UPDATE clause puts a ______ on the selected rows.
collections - records
explicit
lock
EXECUTE IMMEDIATE

12. The exception raised when a SELECT INTO statement returns more than one row.
RELIES_ON
predefined
TOO_MANY_ROWS
EXCEPTION_INIT

13. The RESULT_CACHE clause comes (before / after) the RETURN clause.
explicit
after
VARRAY - Nested table
FGA

14. Data dictionary view giving the AUTHID values on a user's objects.
USER_PROCEDURES
Gateway
:=
do not

15. I/O: To make sure the DBMS_OUTPUT buffer will be flushed - put a WHEN ______ clause in the EXCEPTION section of your outer block.
select
OTHERS
production
elements

16. Give the value list in the PLSQL_WARNINGS parameter to turn on SEVERE compiler warnings and make compiler warning 06002 be an error.

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

17. I/O: The DBMS_OUTPUT procedure that sets the size of the output buffer.
1
.
unhandled
ENABLE

18. To insert or update on a table that has a collection column - you have to have _______ privilege on the collection type.
name
an AUTHID property
EXECUTE
USER_PLSQL_OBJECT_SETTINGS

19. I/O: The buffered output of dbms_output.put_line is retrieved by _______.
searched
SQLPlus
E Exception;
CURSOR - RETURN

20. Cursors: An explicit cursor (can/cannot) accept parameters.
OUT
can
raise_application_error
SQLCODE

21. Cursors: The SQL%FOUND attribute has how many possible values?
non-editioning views
COUNT
3
EXTEND

22. Triggers: If two or more triggers are defined with the same timing point - then you can control the firing order using the ________ clause.
follows
comments
SIMPLE_INTEGER
DECLARE - BEGIN - EXCEPTION - END

23. Java - C or other program called directly in PL/SQL.
FETCH
a number := 10
external subprogram
v1 OUT number default 10

24. DynSQL: EXECUTE IMMEDIATE can be used for any SQL statement or PL/SQL block - except for ________ queries.
=
label
multi-row
ROLLBACK

25. Conversion: It is best to use (implicit / explicit) conversion.
elements - type
explicit
nested tables - associative arrays
Reserved words.

26. Triggers: The clause to make a trigger run before inserting or updating table EMPS.
lowest
machine
before insert or update on emps
cursor c RETURN rC;

27. Dbms_sql: DBMS_SQL package is compiled with _______ rights.

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

28. Triggers: INSTEAD OF triggers only run on ______ views.
BINARY_INTEGER
user-defined
TYPE t IS TABLE OF rPerson INDEX BY PLS_INTEGER;
non-editioning views

29. This is a CASE (expression / statement): CASE num WHEN 1 THEN goto LABEL1 WHEN 2 THEN var := 2 END CASE;
statement
PUT
propagates
searched

30. Cursors: The index variable in a cursor FOR loop (does/does not) need to be declared.
does not
aliases
sql
constant

31. In the IF syntax - is if ENDIF or END IF?
END IF
cannot
HTP
associative

32. Cursors: An implicit cursor is also called a/n ________ ________ -
define
SQL cursor
not the same
implicit

33. FOR-Looping over a collection from FIRST to LAST only works if the collection is _______.
DBMS_DDL
Server Pages
dense
4K

34. Nested tables are multisets - meaning that there is no inherent _____ of their elements.
UTL_HTTP
varray
DECLARE - BEGIN - EXCEPTION - END
order

35. Cursors: What is the 'name' of the implicit cursor?
hardware
anonymous
SQL
DBMS_SESSION.RESET_PACKAGE

36. Dbms_sql: The DBMS_SQL procedure that will execute a DDL or DML statement.
END IF
scalable
TYPE rec IS RECORD (num NUMBER - name VARCHAR2(10));
execute

37. Triggers and views always have _________ rights.

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

38. The default value of the AUTHID property.
DEFINER
definition
%
cursor

39. Exceptions: A GOTO statement cannot branch into an _______ ________.
names
exception handler
procedure - function
value

40. Declare an output NUMBER parameter - v1 - that defaults to 10.
cannot
variable
v1 OUT number default 10
1 million

41. Delimiters: The left label delimiter.
<<
delimiters
an AUTHID property
SQL

42. Types: One of the scalar data types specific to PL/SQL: b_____.
PRAGMA AUTONOMOUS_TRANSACTION;
BOOLEAN
can
%

43. With static typing - type checking is done at ______ time.
compile
STANDARD
static boolean
will not

44. Bulk: The implicit cursor attribute that gives the number of rows affected by each DML statement in a FORALL statement.
is
invoker's
boolean
%BULK_ROWCOUNT

45. The FOR UPDATE OF clause references a (table / column).
PLS_INTEGER
column
information that changes infrequently
buffer

46. When a session starts - CURRENT_SCHEMA has the value of the schema owned by ___________.
SESSION_USER
RECORDS
FORALL i IN MyList.FIRST..MyList.LAST
compilation

47. Cursors: The first two keywords in a Cursor FOR loop.
an enclosing block
value
implicit CASE_NOT_FOUND exception
FOR - IN

48. How many types of compiler directives are there?
%BULK_ROWCOUNT
after insert on emps
3
$IF

49. Define a collection type - tV - which is a varray of 100 NUMBERs.
DML
INTO
TYPE tV IS VARRAY(100) OF NUMBER
INTO

50. With conditional compilation you can avoid compiling debug code in the _______ environment.
EXIT WHEN cv%NOTFOUND
v3 IN OUT NUMBER
anonymous
production