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_sql: The DBMS_SQL procedure that closes a cursor.
STANDARD
CLOSE_CURSOR
=>
cursor number

2. The Wrap utility ________ the source code.
array
obfuscates
/*
error code

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

4. The DEFINITION of a cursor is the _____ that returns the records.
512
DBMS_OUTPUT
32 -000
query

5. In a FORALL loop - you (can / cannot) use the index variable for purposes other than indexing into the collection.
cannot
RELIES_ON
definer's
machine code

6. Set flag bb true: ALTER SESSION SET PLSQL_CCFLAGS= '____'
native dynamic
definer's
Double quotes.
bb:true

7. Triggers: On a non-editioning view - you can only define __________ triggers.
SQL
propagates
TYPE tN IS TABLE of NUMBER
INSTEAD OF

8. Dbms_sql: This DBMS_SQL function opens a new cursor.
OPEN_CURSOR
CURSOR - RETURN - IS
Wrap
EXECUTE IMMEDIATE

9. Conditional compilation is useful for compiling a program under different ______ of Oracle.
versions
lock
IR
not a number

10. IDs: You (can/cannot) use keywords as ordinary user-defined identifiers.
invoker's
PLS_INTEGER
can
HTP

11. Statement to exit a cursor loop on cursor cGo when there are no more records.
raise_application_error(-20 -100 - 'Bad');
..
inquiry
exit when cgo%NOTFOUND

12. Cursors: The value of SQL%ISOPEN is always ______.
name-value
FALSE
lock
True - false or NULL.

13. Advantage: Performance: Stored subprograms are ______ in memory.
PUT
512
explicit cursor
cached

14. Native compilation turns bytecode into ________ code.
EVERE - PERFORMANCE - INFORMATIONAL
machine
FETCH - INTO
STANDARD

15. Cursors: The SQL%BULK_ROWCOUNT attribute is an _________ -
invoker's
cannot
array
implicit

16. Exceptions: You cannot GOTO from an exception handler back into the __________ block.
<<
current
CREATE TYPE
raise_application_error

17. Simple CASE statement checks for different values of a single _________
expression
CHAR - VARCHAR2
wrap
source code

18. Exceptions: The package that defines pre-defined exceptions.
unhandled
DBMS_OUTPUT
integer
STANDARD

19. A result-cached function caches its results in the _____ _____ ____ (SGA)
PRAGMA AUTONOMOUS_TRANSACTION;
system global area
alter procedure
set serveroutput on

20. Cursors: Give the statement to fetch data from cursor variable CV into MyVar.
autonomous triggers
255
fetch cv into myvar
server

21. Declare a constrained subtype of NUMBER called N that is not null.
FETCH
SUBTYPE n IS number not null;
slower
plb

22. Cursors: The four cursor attributes - in alphabetical order.
bytecode
%
names
%FOUND - %ISOPEN - %NOTFOUND - %ROWCOUNT

23. Triggers: An INSTEAD OF trigger is (always/never) a row-level trigger.
SQL
savepoint ab
CLOSE
always

24. Delimiters: The component indicator/selector.
.
autonomous triggers
varray
EXECUTE IMMEDIATE

25. Web: PL/SQL _____ _______ lets you to develop Web applications made of PL/SQL procedures.
Web Toolkit
ex := tbl1 MULTISET EXCEPT tbl2
query
FETCH

26. Dbms_sql: A cursor opened with OPEN_CURSOR (can/cannot) be reused for multiple queries without first closing it.
PVM
can
scalar
=

27. Web: The gateway that allows a web browser to invoke a PL/SQL procedure through an HTTP listener.
name-value
cannot
exception handler
PL/SQL Gateway

28. In a sparse collection - the indexes of defined elements (do / do not) run in consecutive order.
$$
cursor
do not
significant

29. Cursors: A cursor FOR loop cannot use a _______ variable.
255
DBMS_OUTPUT
package
cursor

30. Exceptions: Associate exception E with error code -1.
name and datatype
static boolean
PRAGMA EXCEPTION_INIT (E - -1);
an AUTHID property

31. You can have many autonomous transactions in ___________.
compiles
an autonomous routine
SQL
PL/SQL

32. Keyword for doing assignment to a variable with SELECT.
OTHERS
INTO
OPEN
invalid

33. When a session starts - CURRENT_SCHEMA has the value of the schema owned by ___________.
current
SESSION_USER
wrap
exception handler

34. Advantage: Performance: Storing and runnng procedures on the server minimizes ______ traffic.
unconstrained
4K
CURRENT_USER - DEFINER
network

35. Nested tables are multisets - meaning that there is no inherent _____ of their elements.
national
p.v
order
True

36. Exceptions: The ________ function returns the error message associated with an error code.
@
not a number
SQLERRM
base

37. Command to assign to variables from a cursor.
STANDARD
WHEN OTHERS THEN
REF_CURSOR
FETCH

38. An INSTEAD OF trigger specifies what to do instead of a ___ statement.
RETURN
DML
@
associative

39. Types: One of the scalar data types specific to PL/SQL: B_______
query
value
null string
BINARY_INTEGER

40. Delimiters: Statement terminator.
reference
;
procedure - function
in the database

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

42. I/O: This package lets PL/SQL programs read and write OS files.
Gateway
PUT_LINE
REF CURSOR
UTL_FILE

43. Exceptions: An exception in the declarations section propagates to the enclosing _______.
drop procedure
block
fail
do not

44. Triggers: INSTEAD OF triggers only run on ______ views.
END
PLS_INTEGER
non-editioning views
bind

45. The EXTEND method is not used with ______ _______.
associative arrays
open C
/*
optional

46. Declaration of a varchar2 constant - called vname - with value 'x'.

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

47. Cursors: How many DML statements can a FORALL statement contain?
EVERE - PERFORMANCE - INFORMATIONAL
injection
upper - coalesce
1

48. Are good for logging table DML operations.
selection
CURRENT_USER - DEFINER
exit when cgo%NOTFOUND
autonomous triggers

49. Types: The storage size of a NUMBER value is based on the number of ______ digits.
inclusive
fetch cv into myvar
system global area
significant

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