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. Types: ________ data types have no internal components.
USER_PLSQL_OBJECT_SETTINGS
constant
cursor number
scalar

2. Abbreviation for Abstract Data Type.
cursor
ADT
DBMS_SESSION
UTL_HTTP

3. Records are one of the two kinds of PL/SQL _______ data types.
composite
DBMS_SQL
current
optional

4. Cursors: What is the 'name' of the implicit cursor?
SQL
VARCHAR2
EXECUTE IMMEDIATE
1

5. PLSQL_CCFLAGS hold a comma-separated list of ______ pairs (hyphenated).
name-value
2
EXIT WHEN
p.v

6. In Native Mode - PL/SQL code is compiled into ______ ______.
machine code
cannot
IN
2

7. Cursors: Give the first 3 words to open a cursor variable called cv.
open cv for
SQLPlus
OPEN
DBMS_OUTPUT

8. Fundamental: Labels furnish targets for GOTO and _____ statements.
EXIT
same
database
FETCH

9. Triggers: In a per-row trigger - the ____ record shows you the original state of an affected row.
TYPE t IS TABLE OF rPerson INDEX BY PLS_INTEGER;
OLD
ROLLBACK
select

10. Advantage: PL/SQL supports ______-oriented programming.
object
elsif
select
Apache

11. Exceptions: An exception in the declarations section propagates to the enclosing _______.
$IF
block
v1 OUT number default 10
database

12. The Wrap utility (does / does not) encrypt source code.
does not
machine code
END IF
closed

13. Triggers: In a DML trigger - the phrase that makes the trigger run for every affected record.
delimiters
2
flushed
for each row

14. Types: One of the 4 PL/SQL things that have a data type (begins with 'c').
buffer
constant
manageable
FOR i IN REVERSE 1..10 - LOOP - NULL; END LOOP;

15. Dbms_sql: The return type DBMS_SQL.open_cursor.
ENABLE
CHAR - VARCHAR2
integer
create procedure

16. Triggers: An INSTEAD OF trigger (can/cannot) be conditional.
Double quotes.
cannot
integer
package

17. Command used to execute dynamic SQL.
API
is certain
lower sub-block
EXECUTE IMMEDIATE

18. An INSTEAD OF trigger specifies what to do instead of a ___ statement.
DML
array
finishes
composite

19. Exceptions: Start of the range of error codes for RAISE_APPLICATION_ERROR.
SQLCODE
-20 -000
RETURN
an AUTHID property

20. Cursors: Opening keyword of a cursor FETCH loop.
LOOP
alter procedure
is
network

21. Cursors: Give the statement for getting out of a FETCH loop for cursor CV.
EXIT WHEN cv%NOTFOUND
index
currval and nextval
statement

22. A CASE expression ends with _____.
before insert or update on emps
BINARY_INTEGER
END
BOOLEAN

23. Advantage: Performance: PL/SQL automatically creates ______ variables for variables in WHERE and VALUES clauses.
elements
Abstract
bind
LOOP

24. _________ exceptions can not be trapped with an error handler
procedure - function
disable
Declaration
COUNT

25. Pkgs: The _______ package gives access to such SQL things as ALTER SESSION.
NDS
VARRAY - Nested table
procedure - function
DBMS_SESSION

26. If you are in a procedure inside a package - the compilation unit is the _______.
explicit
package
USER_PLSQL_OBJECT_SETTINGS
index

27. Type: An ________ subtype has all the values of its base type.
nested
unconstrained
DATE
exception

28. Nested tables can become sparse via ______.
FALSE
RAISE
Declaration
deletions

29. A result-cached function caches its results in the _____ _____ ____ (SGA)
static
system global area
REUSE SETTINGS
value

30. A PL/SQL extension to the WHERE clause of the SQL statements UPDATE and DELETE
loop
WHERE CURRENT OF
SQLERRM
define

31. How many times are a FOR loop's index bounds evaluated?
flushed
injection
once
=>

32. Delimiters: The component indicator/selector.
3
production
.
LOOP

33. I/O: The most basic PL/SQL way to give output to the user.
@
an autonomous routine
dbms_output.put_line
view

34. Types: The PL/SQL type that is identical to PLS_INTEGER.
current BEGIN-END block
BINARY_INTEGER
explicit
identifiers

35. Triggers: When using the NEW or OLD pseudo-records in the body of the trigger - they must be prefixed with a _______.
colon
must
..
array

36. The DECLARE keyword is only required in an _______ _______.
concatenation
anonymous block
bytecode
%BULK_ROWCOUNT

37. Delimiters: The assignment operator.
follows
:=
execute
CLOSE_CURSOR

38. Advantage: Performance: Stored subprograms are ______ in memory.
bind
cached
'
create

39. In a collection - the internal components always have the _____ data type.
same
block
name and datatype
SESSION_USER

40. A (simple / searched) CASE statement begins with CASE WHEN <boolean expression>.
buffer
searched
exit when cgo%NOTFOUND
identifiers

41. I/O: This package sends text output to SQLPlus
DBMS_OUTPUT
INTO
TRUE - FALSE - NULL
hardware

42. Associative arrays (do / do not) have to be initialized with a constructor.
cursor variable
EXIT
statically
do not

43. Exceptions: The package that defines pre-defined exceptions.
STANDARD
define
boolean
SIMPLE_INTEGER

44. DynSQL: The clause that receives single-row query output from EXECUTE IMMEDIATE.
INTO
same
4K
will not

45. Define a record type REC with number num and varchar2(10) name.
TYPE rec IS RECORD (num NUMBER - name VARCHAR2(10));
v3 IN OUT NUMBER
RECORD OF ARRAYS
constrained

46. The FIRST method gets the first (element / index) of a collection.
index
machine code
deletions
FALSE

47. Exceptions: If there is no handler for an exception - PL/SQL returns an ________ exception error to the invoker or host environment.
execute immediate
a cursor
unhandled
SYS_CONTEXT

48. Cursors: The two keywords in a mere cursor declaration (one is optional).
index
production
$$
CURSOR - RETURN

49. Data dictionary view that shows the compiler settings for each compiled object.
information that changes infrequently
TYPE rec IS RECORD (num NUMBER - name VARCHAR2(10));
Apache
USER_PLSQL_OBJECT_SETTINGS

50. A CASE statement (can / cannot) execute more than one group of statements.
lock
numeric and cursor
<<>>
cannot