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. The command used to populate PLSQL_CCFLAGS.
%BULK_ROWCOUNT
ALTER SESSION
dynamic
END CASE

2. Static typing is also called _____ typing.
compilation
255
Gateway
strong

3. For a collection - the NEXT method gets the next higher (element / index).
always
index
composite
IF - CASE or LOOP

4. The BEGIN section is (optional/mandatory)
database
mandatory
collections - records
=>

5. Fundamental: One of the 4 types of lexical units: d_____
delimiters
decimal
bind
END IF

6. Cursors: What is the 'name' of the implicit cursor?
concatenation
decimal
cursor
SQL

7. Type: An ________ subtype has all the values of its base type.
executable
unconstrained
DEFINER
increment

8. Kind of code created by the PL/SQL compiler.
production
bytecode
5
PUT_LINE

9. Exceptions: The ________ handler must always be the last handler.
PUT
OTHERS
CASE_NOT_FOUND
object

10. TCL: Undo changes back to savepoint ab.
1 million
IN OUT
rollback to ab
Declaration

11. Command to create a procedure.
index
Web Toolkit
create procedure
IF - CASE or LOOP

12. To exit an active autonomous transaction without causing an exception - you must issue _____ or ______.
4K
portable
commit - rollback
lock

13. IDs: Predefined identifiers are declared in this package.
UTL_HTTP
STANDARD
placeholders
current

14. Cursors: The second keyword of a FETCH statement.
INTO
specification - body
3
statement

15. A unit with AUTHID = DEFINER is a ________ rights unit.

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

16. For a collection - the NEXT method returns ____ when there is no next index value.
OLD

autonomous triggers
1

17. I/O: To make sure the DBMS_OUTPUT buffer will be flushed - put a WHEN ______ clause in the EXCEPTION section of your outer block.
USER_PLSQL_OBJECT_SETTINGS
run
PLSQL_OPTIMIZE_LEVEL
OTHERS

18. ______ SQL is a PL/SQL feature that allows SQL syntax directly in a PL/SQL statement.
delimiters
static
OPEN
32 -000

19. Bulk: The two features that comprise Bulk SQL are:
@
not the same
FORALL and BULK COLLECT
$IF $THEN $ELSE $END

20. IDs: How an ordinary user-defined identifier must begin.
With a letter.
%BULK_ROWCOUNT
PLS_INTEGER
PLSQL_OPTIMIZE_LEVEL

21. I/O: The output from DBMS_OUTPUT will display (during/after) program execution.
dbms_output.put_line
delimiters
after
enclosing

22. The Wrap utility ________ the source code.
obfuscates
alter procedure
statement
..

23. The DEFINITION of a cursor is the _____ that returns the records.
unconstrained
comments
FETCH
query

24. Advantage: Performance: Stored subprograms are ______ in memory.
cached
TIMESTAMP.
FETCH
query

25. Default file extension of wrap's output file.
EXIT WHEN
plb
CLOSE_CURSOR
FETCH

26. DynSQL: The three modes of arguments in the USING clause of EXECUTE IMMEDIATE.
UTL_HTTP
associative
IN - OUT - IN OUT
scalable

27. A type of compiler directive - begins with 'i'.
inquiry
boolean
EXIT WHEN
EXIT

28. In short-circuit evaluation - IF-conditions are only evaluated up to where the outcome ___________.
procedure - function
FOR - IN
is certain
expression

29. Declare an unconstrained subtype of NUMBER called NUMB.
RETURN
delimiters
parameter
SUBTYPE numb IS number;

30. Conversion: It is best to use (implicit / explicit) conversion.
virtual machine
OLD
explicit
source code

31. What is the exception that is implicitly raised in a CASE statement with no ELSE clause?
v1 OUT number default 10
REUSE SETTINGS
CASE_NOT_FOUND
DATE

32. PLS_INTEGER has its arithmetic implemented in ________ - so it is very fast.
delimiters
hardware
scalable
execute

33. Cursors: Give the statement to open cursor C that takes parameter p.
disable
an AUTHID property
32 -000
open C(p)

34. In a sparse collection - the indexes of defined elements (do / do not) run in consecutive order.
r t.%ROWTYPE;
exit when cgo%NOTFOUND
do not
explicit

35. A null string and a BOOLEAN null are _______ (same/not the same).
specification - body
4K
Ordinary - Quoted.
not the same

36. Cursors: The value of SQL%ROWCOUNT after a SELECT INTO statement returns more than one row.
PLS_INTEGER
1
DBMS_SESSION
OPEN

37. The EXTEND method is not used with ______ _______.
constrained
$IF
associative arrays
is

38. A CASE statement (can / cannot) execute more than one group of statements.
identifiers
@
cannot
executable

39. The NOCOPY option on an OUT or IN OUT parameter - causes it to be passed by ______.
reference
/*
cursor c;
SQL

40. A result-cached function caches its results in the _____ _____ ____ (SGA)
forward
system global area
fields
context

41. The EXCEPTION section is (optional/mandatory).
optional
$IF $THEN $ELSE $END
DATE
same

42. Command to assign to variables from a cursor.
after insert on emps
error code
FETCH
lock

43. Cursors: The first two keywords in a Cursor FOR loop.
raise_application_error(-20 -100 - 'Bad');
FOR - IN
RECORD OF ARRAYS
null string

44. In PL/SQL - what the variables in DML statements are turned into.
base
after insert on emps
=>
bind arguments

45. The three possible values of a BOOLEAN literal.
1
associative
True - false or NULL.
implicit

46. Exceptions: An unhandled exception ________ to the enclosing block.
names
can
propagates
PUT

47. Triggers: An INSTEAD OF trigger (can/cannot) be conditional.
v3 IN OUT NUMBER
timing
cannot
$IF $THEN $ELSE $END

48. An autonomous program runs in its own __________.
transaction
TIMESTAMP.
user-defined
subtype

49. Define a collection type - tV - which is a varray of 100 NUMBERs.
TYPE tV IS VARRAY(100) OF NUMBER
procedure P AUTHID current_user;
deletions
optional

50. Fundamental: A label can only go directly before an _______ statement.
executable
32 -000
plb
information that changes infrequently