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. Give the ANSI Date literal for December 25 - 2005.

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

2. Exceptions: Some internal exceptions have ________ names.
predefined
REUSE SETTINGS
1
can

3. Clause added to a cursor to use it with WHERE CURRENT OF.
current BEGIN-END block
in the database
is certain
for update of

4. IDs: What a quoted user-defined identifier is enclosed in.
Double quotes.
associative arrays
associative
DBMS_SQL

5. The FIRST method gets the first (element / index) of a collection.
for update of
function f (n number) return number result_cache relies_on (emps);
index
error

6. Triggers: A compound trigger can fire at more than one ______ point.
composite
current BEGIN-END block
SQLERRM
timing

7. TCL: Create a savepoint called ab
procedure - function
savepoint ab
PLS_INTEGER
INTO

8. A CASE expression ends with _____.
255
END
Wrap
definition

9. Conditional compilation is useful for compiling a program under different ______ of Oracle.
-20 -000
REF_CURSOR
versions
ALTER SESSION

10. In a collection - the internal components are called _______.
@
define
elements
constant

11. I/O: This DBMS_OUTPUT proc retrieves multiple lines from the buffer.
GET_LINES
lock
same
multi-row

12. Types: The PL/SQL type that is identical to PLS_INTEGER.
BINARY_INTEGER
constrained
package
VARRAY - Nested table

13. Declare an unconstrained subtype of NUMBER called NUMB.
machine code
SUBTYPE numb IS number;
DBMS_OUTPUT
information that changes infrequently

14. An incomplete type is a type created by a ______ type definition.
colon
forward
an AUTHID property
index

15. Dbms_sql: The integer returned by OPEN_CURSOR is a _____ _____.
DATE
cursor number
r tRec := tRec(9 - 'Jones');
buffer

16. Conversion: Just about everything will implicitly convert to _____ or _________.
ADT
CHAR - VARCHAR2
USING
cursor c;

17. Mode designation for an output parameter.
anonymous block
not a number
close C
OUT

18. Command to delete a procedure.
TYPE rec IS RECORD (num NUMBER - name VARCHAR2(10));
same
index
drop procedure

19. The SET TRANSACTION statement affects only the ____________.
EXCEPTION_INIT
-20 -000
current transaction
$IF

20. A GOTO cannot branch into an...
scalar
fields
currval and nextval
IF - CASE or LOOP

21. Cursors: The statement where you pass the parameters to a cursor.
bb:true
OPEN
SESSION_USER
DBMS_SESSION.RESET_PACKAGE

22. A null string and a BOOLEAN null are _______ (same/not the same).
deletions
not the same
SESSION_USER
timing

23. Define a record type REC with number num and varchar2(10) name.
suspended
TYPE rec IS RECORD (num NUMBER - name VARCHAR2(10));
bytecode
RESULT_CACHE

24. Advantage: PL/SQL programs are stored centrally - making them more ______.
manageable
colon
query
REF CURSOR

25. To run TCL or DDL statements - a trigger (must / must not) be autonomous .
exception
decimal
must
PVM

26. When an autonomous routine begins execution - the main transaction is ________.
suspended
<<>>
definer's
error code

27. PLS_INTEGER has its arithmetic implemented in ________ - so it is very fast.
hardware
LOOP - END LOOP
inquiry
deletions

28. A GOTO cannot branch into a...
SESSION_USER
cursor
lower sub-block
code

29. The method to add one or more elements to a nested table or VARRAY is ______.
EXTEND
IN - OUT - IN OUT
reference
PLSQL_CCFLAGS

30. NAN stands for _________.
not a number
aliases
view
implicit

31. A unit with AUTHID = CURRENT_USER is an ________ rights unit.

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

32. The first SQL statement in an autonomous routine begins a _______.
Oracle
LOOP - END LOOP
transaction
identifiers

33. For a collection - the NEXT method gets the next higher (element / index).
HTF
fine-grained auditing
OPEN_CURSOR
index

34. Cursors: The first two keywords of a basic fetch statement.
EXIT
constrained
FETCH - INTO
significant

35. Data dictionary view giving the AUTHID values on a user's objects.
%BULK_ROWCOUNT
USER_PROCEDURES
HTF
INTO

36. The EXCEPTION section is (optional/mandatory).
LOOP - END LOOP
optional
DBMS_SESSION
Wrap

37. Delimiters: The component indicator/selector.
single-line
create
.
a cursor

38. PL/SQL does not automatically create bind variables in ________ SQL.
DATE
dynamic
TOO_MANY_ROWS
cursor

39. Cursors: The value of SQL%ROWCOUNT after a SELECT INTO statement returns more than one row.
1
anonymous
$IF $THEN $ELSE $END
INSTEAD OF

40. Set flag bb true: ALTER SESSION SET PLSQL_CCFLAGS= '____'
open C(p)
exception handler
finishes
bb:true

41. How many PL/SQL collection types are there?
-20 -000
3
FETCH - BULK COLLECT INTO
virtual machine

42. A type of compiler directive - begins with 'e'.
error
commit - rollback
numeric and cursor
r t.%ROWTYPE;

43. Declare a cursor c with no parameters or return type.
cursor c;
view
p.v
is certain

44. Exceptions: The maximum length of an Oracle error message is ____ characters
2
512
fine-grained auditing
TYPE rec IS RECORD (num NUMBER - name VARCHAR2(10));

45. Value of PLSQL_OPTIMIZE_LEVEL that prevents optimization.
preprocessor
1
LOOP - END LOOP
L.V

46. The lowest index of a nested table is ___.
same
cannot
Web Toolkit
1

47. DynSQL: Native Dynamic SQL
NDS
1
INTO
TYPE t IS TABLE OF rPerson INDEX BY PLS_INTEGER;

48. An $ERROR directive ends with _____.
INTO
NESTED TABLE myColl STORE AS myCollTab
is certain
$END

49. By default - OUT and IN OUT parameters are passed by _____.
obfuscates
v2 IN NUMBER default 20
explicit
value

50. Subprograms are stored in __________ form.
executable
suspended
FGA
# - $ - _