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. (from inside a package) Declare a function f - that takes a number n - returns a number - and caches results - depending on table EMPS.
inclusive
30
database
function f (n number) return number result_cache relies_on (emps);

2. I/O: The PL/SQL I/O packages (can/cannot) accept input directly from the keyboard.
E Exception;
cannot
implicit
transaction

3. Exceptions: The built-in procedure for raising an application-defined error.
$$
order
raise_application_error
transaction

4. 5 types of events that can have triggers: DML - DDL - INSTEAD OFs - database events - and ________ statements.
32 -000
COMMIT - ROLLBACK - SAVEPOINT - SET TRANSACTION
suspended
procedure - function

5. The FIRST method gets the first (element / index) of a collection.
@
index
hardware
composite

6. What is the simplest statement for conditionally getting out of simple loop?
hardware
EXIT WHEN
literal
Wrap

7. I/O: One of the 3 types of data that can be passed to the DBMS_OUTPUT buffer.
library
VARCHAR2
error code
placeholders

8. You have to use _______ SQL to run DDL statements n PL/SQL.
REF_CURSOR
dynamic
implicit
increment

9. SIMPLE_INTEGER is like PLS_INTEGER - but it does not allow ____ values - and it does not raise overflow exceptions.
statement

searched
literals

10. Types: One of the scalar data types specific to PL/SQL: P________
PLS_INTEGER
...
hardware
EXCEPTION_INIT

11. In interpreted mode - PL/SQL code is run in a _______ _______.
EDITION_NAME
virtual machine
TYPE tA IS TABLE OF NUMBER INDEX BY VARCHAR2(20)
network

12. The _____ utility turns PL/SQL source code into unreadable text.
FETCH
Wrap
after
VARCHAR2

13. Wrapping can be done with the ____ executable.
BINARY_INTEGER
open C
exit when cgo%NOTFOUND
wrap

14. You can define PL/SQL collections using TYPEs defined in the _______.
Server Pages
database
1
INTO

15. A user-defined TYPE can have...
package
EXECUTE
an AUTHID property
never

16. The _______ package lets you wrap dynamically generated PL/SQL.
*/
DBMS_OUTPUT
searched
DBMS_DDL

17. For an associative array - the FIRST method gets the (lowest / first-created) index.
DML
lowest
currval and nextval
True - false or NULL.

18. Assignment of PLSQL_CCFLAGS (cannot / can) be included in ALTER PROCEDURE ... COMPILE ...
UTL_HTTP
is not
can
/*

19. $$PLSQL_LINE and $$PLSQL_UNIT are ______-ly defined inquiry directives.
always
-
execute
implicit

20. What do you FETCH from?
injection
same
inquiry
a cursor

21. Static typing is also called _____ typing.
strong
variable
cursor
concatenation

22. Cursors: What implicit cursor attribute gives row counts for a FORALL statement?
%BULK_ROWCOUNT
create procedure
name and datatype
VARRAYs

23. IDs: The type of words that cannot be user-defined identifiers.
255
Reserved words.
wrap
EXECUTE IMMEDIATE

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

25. To run a PIPE ROW statement in your autonomous routine - you must close any _____________.
autonomous transaction
DML
loop
1

26. The BETWEEN operator is (inclusive / exclusive).
is
cached
inclusive
SQL

27. The three sorts of date/time types are DATE - INTERVAL and _________.
DBMS_OUTPUT
TIMESTAMP.
PUT_LINE
cannot

28. Exceptions: The ________ handler must always be the last handler.
OTHERS
Server Pages
3
pls_integer

29. Term for a character literal with zero characters.
REF CURSOR
bind
exit when cgo%NOTFOUND
null string

30. An editioning view can only select a subset of the columns from the base table and provide ________ for them
aliases
30
UTL_HTTP
composite

31. Value of a character literal with zero characters.
machine

dynamic
obfuscates

32. Give the clause you add to a CREATE TABLE statement - when there is a collection column myColl - that you want to be stored in a table called myCollTab.
set serveroutput on
for update of
NESTED TABLE myColl STORE AS myCollTab
1

33. A CASE expression ends with _____.
IF - CASE or LOOP
mandatory
END
PL/SQL

34. Conditional compilation is useful for compiling a program under different ______ of Oracle.
versions
API
OPEN
single-line

35. Cursors: The keyword that makes a ref cursor type STRONG.
IN OUT
RETURN
EXECUTE
anonymous

36. Triggers: In a trigger - you cannot issue a COMMIT or a ______.
ROLLBACK
iname
return value
512

37. Wrapped code (is / is not) not backward compatible.
is not
versions
user-defined
vname CONSTANT VARCHAR2 := 'x';

38. A null string and a BOOLEAN null are _______ (same/not the same).
label
not the same
IS
wrap

39. In Native Mode - PL/SQL code is compiled into ______ ______.
WHEN
UTL_HTTP
machine code
current transaction

40. TCL: Undo changes back to savepoint ab.
rollback to ab
IR
run
information that changes infrequently

41. Declare an unconstrained subtype of NUMBER called NUMB.
statically
SUBTYPE numb IS number;
package
array

42. A GOTO statement cannot branch from an exception handler back into the...
statement
FORALL i IN MyList.FIRST..MyList.LAST
sequence pseudo-columns
current BEGIN-END block

43. Cursors: The four cursor attributes - in alphabetical order.
package
same arguments
E Exception;
%FOUND - %ISOPEN - %NOTFOUND - %ROWCOUNT

44. Cursors: The type definition of a WEAK ref cursor type has no _______ clause.
RETURN
query
True - false or NULL.
cannot

45. Are good for logging table DML operations.
autonomous triggers
:=
follows
IF - CASE or LOOP

46. Triggers: In a DML trigger - the phrase that makes the trigger run for every affected record.
for each row
variable
v1 OUT number default 10
hardware

47. Keyword for doing assignment to a variable with SELECT.
raise_application_error(-20 -100 - 'Bad');
statement
Abstract
INTO

48. The first SQL statement in an autonomous routine begins a _______.
Gateway
collections - records
LOOP - END LOOP
transaction

49. Cursors: The FOR UPDATE phrase goes at the (beginning/end) of the cursor definition.
end
anonymous block
open C(p)
associative

50. List the transaction control statements.
Server Pages
execute
COMMIT - ROLLBACK - SAVEPOINT - SET TRANSACTION
1 million