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. DBMS_DDL.CREATE_WRAPPED: wraps and _______ the source code passed to it.
CURRENT OF
compiles
FOR i IN REVERSE 1..10 LOOP
1

2. What is the simplest statement for conditionally getting out of simple loop?
does not
v3 IN OUT NUMBER
EXIT WHEN
GET_LINES

3. Triggers: You create a trigger with the _______ ________ statement.
UTL_FILE
CREATE TRIGGER
do not
after insert on emps

4. 5 types of events that can have triggers: DML - DDL - INSTEAD OFs - database events - and ________ statements.
slower
END LOOP
searched
suspended

5. In short-circuit evaluation - IF-conditions are only evaluated up to where the outcome ___________.
API
1
is certain
anonymous block

6. How to reference a variable V declared in a block labelled L: ____.
PLS_INTEGER
L.V
dbms_output.put_line
hardware

7. PL/SQL is a ________ typed programming language.
never
boolean
FOR - IN
statically

8. Types: One of the 4 PL/SQL things that have a data type (begins with 'c').
exception handler
2
constant
current BEGIN-END block

9. Cursors: Give the first 3 words to open a cursor variable called cv.
open cv for
Double quotes.
RECORD OF ARRAYS
FETCH - INTO

10. Fundamental: What is the exponentiation operator?
elsif
**
static boolean
set serveroutput on

11. DynSQL: In EXECUTE IMMEDIATE - the statement string can use either placeholders - or string ________.
concatenation
RETURN
versions
composite

12. Internally - the NUMBER type is stored as ______. Therefore - decimal numbers (such as prices) are stored exactly - with no rounding.
error code
NESTED TABLE myColl STORE AS myCollTab
decimal
virtual machine

13. The command used to populate PLSQL_CCFLAGS.
multi-row
ALTER SESSION
calls
explicit cursor

14. Dbms_sql: This DBMS_SQL function opens a new cursor.
will not
OPEN_CURSOR
bytecode
Gateway

15. The 4 keywords in the $IF compiler directive.
$IF $THEN $ELSE $END
PUT_LINE
a cursor
%ROWTYPE

16. Dbms_sql: The DBMS_SQL procedure that closes a cursor.
run
CLOSE_CURSOR
Server Pages
national

17. Bulk: The two features that comprise Bulk SQL are:
HTF
FORALL and BULK COLLECT
FGA
bind arguments

18. Cursors: If no SELECT or DML statement has run - the value of SQL%ROWCOUNT is what?
WHERE CURRENT OF

sequence pseudo-columns
selection

19. Cursors: Give the statement to open cursor C that takes parameter p.
rollback to ab
open C(p)
dense
null string

20. To use a TYPE declared in the database - a PL/SQL block has to have _______ privilege on the type.
select
can
OLD
SESSION_USER

21. I/O: This package handles HTTP.
WHERE CURRENT OF
UTL_HTTP
ROLLBACK
EXIT

22. Exceptions: Associate exception E with error code -1.
'
RAISE
DBMS_DDL
PRAGMA EXCEPTION_INIT (E - -1);

23. Cursors: The SQL%BULK_ROWCOUNT attribute is an _________ -
%
selection
array
NUMBER

24. Exceptions: When an exception is raised inside a cursor FOR loop - the cursor is _______ implicitly.
varray
closed
is certain
30

25. The AUTHID property applies to PL/SQL objects that contain _____.
SESSION_USER
error
USER_PROCEDURES
code

26. Web: PL/SQL _____ _______ lets you to develop Web applications made of PL/SQL procedures.
transaction
Web Toolkit
server
same

27. Advantage: PL/SQL is PORTABLE to any OS where ________ runs.
Oracle
OTHERS
definer's
SQLPlus

28. Abbreviation of invoker's rights
IR
GET_LINE
scalar
fine-grained auditing

29. Triggers: A compound trigger can fire at more than one ______ point.
timing
/*
WHEN
cannot

30. Command to assign to variables from a cursor.
disable
LOOP
FETCH
native dynamic

31. Advantage: Having procedures stored and executed on the server makes PL/SQL ________.
current BEGIN-END block
savepoint ab
scalable
view

32. The default value of the AUTHID property.
:=
do not
can
DEFINER

33. Exceptions: A GOTO statement CAN branch from an exception handler into an ________ block.
anonymous
current BEGIN-END block
enclosing
boolean

34. Cursors: A cursor FOR loop can use an explicit or an _______ cursor.
subtype
implicit
source code
implicit cursor

35. Setting CURRENT_SCHEMA only changes what is prepended to __________ references.
numeric and cursor
SYS_REFCURSOR
WHERE CURRENT OF
unqualified

36. To insert or update on a table that has a collection column - you have to have _______ privilege on the collection type.
EXECUTE
<> - != - ^=
*/
national

37. Cursors: The type definition of a WEAK ref cursor type has no _______ clause.
RETURN
SQL
timing
32 -000

38. Cursors: A session cursor that is automatically created and managed by PL/SQL.
query
implicit cursor
an AUTHID property
SQL

39. Advantage: PL/SQL runs anywhere Oracle runs - so it is very ________.
aggregate - analytical
portable
SQL cursor
compile

40. This is a CASE (expression / statement): CASE num WHEN 1 THEN goto LABEL1 WHEN 2 THEN var := 2 END CASE;
TYPE tV IS VARRAY(100) OF NUMBER
OTHERS
STANDARD
statement

41. IDs: Predefined identifiers are declared in this package.
propagates
STANDARD
open C(p)
associative

42. The two kinds of CASE statements are simple and ________.
PLSQL_OPTIMIZE_LEVEL
searched
cursor
memory

43. Triggers: There are __ types of triggers.
END IF
5
unconstrained
portable

44. Exceptions: The three words that can be used to guarantee all exceptions will be handled.
WHEN OTHERS THEN
scalable
bind
varray

45. The SET TRANSACTION statement affects only the ____________.
hardware
cannot
current transaction
DBMS_PIPE

46. What are two categories of SQL functions that cannot be used in procedural statements?
BINARY_INTEGER
aggregate - analytical
enclosing
boolean

47. The _____ utility turns PL/SQL source code into unreadable text.
Wrap
SQL
ADT
DECLARE - BEGIN - EXCEPTION - END

48. Cursors: A pointer to a cursor is called a ______ _______.
STANDARD
WHERE CURRENT OF
CHARARR
cursor variable

49. Types of blocks: Procedures and functions are _______ blocks.
END
procedure P AUTHID definer;
USER_PROCEDURES
stored

50. I/O: This package has hypertext procedures that generate HTML tags
network
HTP
EXIT
OUT