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 values defined in PLSQL_CCFLAGS can be referenced as _____ directives.
DML
GET_LINES
%BULK_ROWCOUNT
inquiry

2. Types: One of the 4 PL/SQL things that have a data type (begins with 'r').
return value
composite
memory
With a letter.

3. I/O: This DBMS_OUTPUT proc retrieves multiple lines from the buffer.
GET_LINES
oname
TYPE tN IS TABLE of NUMBER
PRAGMA AUTONOMOUS_TRANSACTION;

4. Declare a variable r whose type is that of the records in table t.
after
r tRec := tRec(9 - 'Jones');
r t.%ROWTYPE;
WHERE CURRENT OF

5. Types: The only Oracle datetime type that doesn't begin with TIMESTAMP is ________.
DATE
CURSOR - RETURN
manageable
expression

6. I/O: Max number of bytes to pass in a call to DBMS_OUTPUT.PUT_LINE.
error code
255
implicit CASE_NOT_FOUND exception
Keywords and predefined names.

7. For a collection - the NEXT method gets the next higher (element / index).
searched
IR
index
current

8. In interpreted mode - the PL/SQL VM interprets the _________.
bytecode
nested
is
implicit CASE_NOT_FOUND exception

9. Conversion: Just about everything will implicitly convert to _____ or _________.
CHAR - VARCHAR2
static
SQL
PLSQL_OPTIMIZE_LEVEL

10. A type of compiler directive - begins with 'e'.
FETCH - INTO
error
4
pls_integer

11. I/O: This package sends text output to SQLPlus
obfuscates
virtual machine
EXIT
DBMS_OUTPUT

12. Abbreviation of invoker's rights
IR
variable
SQLCODE
lock

13. Triggers: In a per-row trigger - the ____ record shows you the original state of an affected row.
OLD
cached
/*
FETCH

14. Triggers: Programmers (as opposed to DBAs) mostly make use of _____ triggers.
subtype
expression
DML
**

15. Wrapped code (is / is not) not backward compatible.
elsif
is not
currval and nextval
view

16. Advantage: PL/SQL programs are stored centrally - making them more ______.
exit when cgo%NOTFOUND
manageable
machine code
DATE

17. Advantage: Having procedures stored and executed on the server makes PL/SQL ________.
a cursor
**
FALSE
scalable

18. Exceptions: The three words that can be used to guarantee all exceptions will be handled.
unhandled
current BEGIN-END block
RAISE
WHEN OTHERS THEN

19. The DEFINITION of a cursor is the _____ that returns the records.
order
CLOSE
query
TYPE tA IS TABLE OF NUMBER INDEX BY VARCHAR2(20)

20. The meaning of 'FGA'.
implicit
fine-grained auditing
FGA
TYPE tA IS TABLE OF NUMBER INDEX BY VARCHAR2(20)

21. I/O: dbms_output.put_line puts output into a _______.
NESTED TABLE myColl STORE AS myCollTab
buffer
order
SQL

22. Exceptions: If there is no handler for an exception - PL/SQL returns an ________ exception error to the invoker or host environment.
RAISE
unhandled
OTHERS
index

23. Pkgs: The _______ package gives access to such SQL things as ALTER SESSION.
DBMS_SESSION
definer's
constructor
procedure P AUTHID current_user;

24. The lowest index of a VARRAY is ___.
v1 OUT number default 10
same arguments
$$PLSQL_LINE
1

25. I/O: One of the 3 types of data stored in the DBMS_OUTPUT buffer.
:=
explicit
DATE
pseudocolumn

26. Exceptions: A GOTO statement CAN branch from an exception handler into an ________ block.
enclosing
compile
oname
select

27. The attribute used to get the type of a column or variable without knowing what it is.
once
%TYPE
manageable
IF - CASE or LOOP

28. Cursors: What implicit cursor attribute gives row counts for a FORALL statement?
calls
boolean
does not
%BULK_ROWCOUNT

29. Types of blocks: A pl/sql block that is not stored in the database.
session cursor
anonymous
SQLERRM
wrap

30. Into nested table ex - put elements of tbl1 that are not in tbl2.
ex := tbl1 MULTISET EXCEPT tbl2
EXECUTE IMMEDIATE
an AUTHID property
1

31. IDs: Predefined identifiers are declared in this package.
associative
STANDARD
colon

32. Default value of PLSQL_OPTIMIZE_LEVEL.
TYPE tN IS TABLE of NUMBER
will not
SIMPLE_INTEGER
2

33. How many types of compiler directives are there?
implicit
3
execute
current BEGIN-END block

34. Fundamental: What are the 3 compound symbols for 'not equal to'?
<> - != - ^=
Ada
cursor
create procedure

35. DynSQL: The colon-prefixed names used in EXECUTE IMMEDIATE are called ________.
scalar
does not
EXIT WHEN cv%NOTFOUND
placeholders

36. Web: PL/SQL _______ enables a Web browser to invoke a PL/SQL stored subprogram through an HTTP listener.
cursor variable
Gateway
scalar
:=

37. I/O: The DBMS_OUTPUT function that writes output WITH a newline character.
STANDARD
PUT_LINE
in the database
NUMBER

38. The three possible values of a BOOLEAN literal.
autonomous triggers
error code
True - false or NULL.
<<

39. Web: mod_plsql is an _______ module.
Apache
specification - body
EXIT WHEN cv%NOTFOUND
context

40. Triggers: On a non-editioning view - you can only define __________ triggers.
INSTEAD OF
v3 IN OUT NUMBER
FETCH - INTO
lowest

41. Conditional compilation is useful for compiling a program under different ______ of Oracle.
INTO
order
versions
fail

42. An anonymous block is a(n) ____ statement.
fail
collections - records
does not
SQL

43. Advantage: Performance: Stored subprograms are ______ in memory.
cached
propagates
FETCH
autonomous transaction

44. IDs: The two types of words that can - but should not - be used as user-defined identifiers.
significant
user-defined
Keywords and predefined names.
%FOUND - %ISOPEN - %NOTFOUND - %ROWCOUNT

45. An anonymous block always has _________ rights.

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

46. Define a record variable r - of type tRec - initialized with values 9 and 'Jones' in its two fields.

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

47. Types: One of the 4 PL/SQL things that have a data type (begins with 'p').
hardware
parameter
statically
invoker's

48. A PL/SQL extension to the WHERE clause of the SQL statements UPDATE and DELETE
RECORDS
exception handler
WHERE CURRENT OF
specification - body

49. 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

50. Mode designation for an output parameter.
TIMESTAMP.
can
OUT
increment