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. Type: A __________ subtype has only a subset of the values of its base type.
constrained
execute
open cv for
EVERE - PERFORMANCE - INFORMATIONAL

2. Define a record type REC with number num and varchar2(10) name.
PL/SQL
TOO_MANY_ROWS
deletions
TYPE rec IS RECORD (num NUMBER - name VARCHAR2(10));

3. Cursors: The SQL%FOUND attribute has how many possible values?
an enclosing block
3
:=
associative

4. For an associative array - the FIRST method gets the (lowest / first-created) index.
DBMS_PIPE
binding
scalable
lowest

5. I/O: This package has hypertext functions that generate HTML tags
EXECUTE
LOOP
network
HTF

6. The compiler directive governing conditional compilation.
current BEGIN-END block
DBMS_PREPROCESSOR
$IF
network

7. Fundamental: identifiers (include/do not include) reserved words.
associative
CLOSE
include
VARCHAR2

8. This is a CASE (expression / statement): myvar := CASE num WHEN 1 THEN 'good' WHEN 2 THEN 'bad' END;
DATE
p.v
expression
dense

9. Conversion: Just about everything will implicitly convert to _____ or _________.
BINARY_INTEGER
invalid
CHAR - VARCHAR2
invoker's

10. I/O: Max number of bytes to pass in a call to DBMS_OUTPUT.PUT_LINE.
255
CLOSE
expression
RETURN

11. Two types of stored subprograms.
procedure - function
collections
TOO_MANY_ROWS
binding

12. Cursors: Opening keyword of a cursor FETCH loop.
aggregate - analytical
include
$IF
LOOP

13. Cursors: Give the statement to open cursor C that takes parameter p.
CURSOR - RETURN - IS
buffer
open C(p)
network

14. Triggers: An INSTEAD OF trigger is (always/never) a row-level trigger.
network
'ENABLE:SEVERE' - 'ERROR:06002'
always
significant

15. Triggers: In a per-row trigger - the ____ record shows you the changed state of an affected row.
cursor
anonymous
NEW
colon

16. A CASE statement (can / cannot) execute more than one group of statements.
RECORDS
cannot
compile
colon

17. For a collection - the NEXT method returns ____ when there is no next index value.
SQL
enclosing

SQL

18. Cursors: The keyword that makes a ref cursor type STRONG.
identifiers
RETURN
BOOLEAN
bind

19. Declare a variable r whose type is that of the records in table t.
OUT
r t.%ROWTYPE;
FGA
static

20. Bulk: The use of FORALL statements cuts down on ______ traffic.
significant
network
L.V
Gateway

21. Cursors: A cursor variable's type must be a ____ ______ type.
static boolean
..
REF CURSOR
explicit cursor

22. Collections are one of the two kinds of PL/SQL _______ data types.
Abstract
significant
composite
decimal

23. Fundamental: What is the exponentiation operator?
finishes
suspended
**
run

24. _________ exceptions can not be trapped with an error handler
object
collections
Declaration
PL/SQL Gateway

25. DynSQL: The standard package that does dynamic SQL.
implicit
slower
DBMS_SQL
enclosing

26. Exceptions: The built-in procedure for raising an application-defined error.
SQL
Oracle
v3 IN OUT NUMBER
raise_application_error

27. DynSQL: Native Dynamic SQL
array
dynamic
NDS
transaction

28. What is the simplest statement for conditionally getting out of simple loop?
IN - OUT - IN OUT
OTHERS
SYS_CONTEXT
EXIT WHEN

29. Delimiters: Item separator.

statement
executable
disable

30. I/O: The output from DBMS_OUTPUT will display (during/after) program execution.
after
Server Pages
associative
finishes

31. IDs: Maximum number of bytes in a user-defined identifier.
implicit CASE_NOT_FOUND exception
cursor
30
cursor variable

32. Exceptions: Start of the range of error codes for RAISE_APPLICATION_ERROR.
-20 -000
BOOLEAN
inquiry
RAISE

33. Declare a cursor c with no parameters - and return type rC.
5
3
injection
cursor c RETURN rC;

34. Set flag bb true: ALTER SESSION SET PLSQL_CCFLAGS= '____'
finishes
bb:true
mandatory
IF - CASE or LOOP

35. A type of compiler directive - begins with 'e'.
SYS_CONTEXT
is
error
selection

36. Fundamental: Character used to escape a single quote inside a literal.

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

37. A (simple / searched) CASE statement begins with CASE <expression>.
definer's
simple and compound symbols
simple
exception

38. Characters that begin a single-line comment.
-
in the database
implicit cursor
comments

39. Declare an unconstrained subtype of NUMBER called NUMB.
USER_PROCEDURES
Ada
label
SUBTYPE numb IS number;

40. Cursors: The FOR UPDATE phrase goes at the (beginning/end) of the cursor definition.
end
follows
enabled
aggregate - analytical

41. List the transaction control statements.
CLOSE
cannot
r t.%ROWTYPE;
COMMIT - ROLLBACK - SAVEPOINT - SET TRANSACTION

42. Types of blocks: Procedures and functions are _______ blocks.
is
ordinary
injection
stored

43. A GOTO cannot branch into a...
is
lower sub-block
buffer
@

44. Declare an associative array type - t - whose elements are of type rPerson - and whose index is PLS_INTEGER.
TYPE t IS TABLE OF rPerson INDEX BY PLS_INTEGER;
compilation
Oracle
dynamic

45. In a FORALL loop - you (can / cannot) use the index variable for purposes other than indexing into the collection.
PLS_INTEGER
GET_LINE
OLD
cannot

46. Cursors: The type definition of a WEAK ref cursor type has no _______ clause.
Reserved words.
must
END LOOP
RETURN

47. One good use of bind variables is to guard against SQL _______.
-20 -000
fetch C into V
injection
SQLCODE

48. Exceptions: Some internal exceptions have ________ names.
-
predefined
explicit cursor
comments

49. Delimiters: Host variable indicator.
# - $ - _
statement
after
...

50. Triggers: The code in a trigger is actually an ________ block.
anonymous
bb:true
strong
Gateway