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. I/O: This DBMS_OUTPUT proc retrieves one line from the buffer.
GET_LINE
procedure P AUTHID definer;
statement
RAISE

2. Wrapped code (is / is not) not backward compatible.
IN OUT
CLOSE_CURSOR
RELIES_ON
is not

3. Associative arrays (do / do not) have to be initialized with a constructor.
do not
anonymous
optional
PL/SQL

4. Mode designation for an input parameter.
PLS_INTEGER
IN
loop
PRAGMA EXCEPTION_INIT (E - -1);

5. Are good for logging table DML operations.
FETCH - INTO
autonomous triggers
ENABLE
suspended

6. Cursors: An implicit cursor is also called a/n ________ ________ -

is certain
SQL cursor
OPEN_CURSOR

7. What are two categories of SQL functions that cannot be used in procedural statements?
wrap
FORALL and BULK COLLECT
aggregate - analytical
BINARY_INTEGER

8. Cursors: Which cursor attribute is not meaningful for an implicit cursor?
network
associative arrays
%ISOPEN.
TIMESTAMP.

9. What clause makes a compilation default to the PLSQL_CCFLAGS settings from the last compilation?
FOR i IN REVERSE 1..10 LOOP
CURSOR - RETURN
composite
REUSE SETTINGS

10. Triggers: In a per-row trigger - the ____ record shows you the original state of an affected row.
$IF
FETCH - BULK COLLECT INTO
OLD
BOOLEAN

11. Characters that begin a multi-line comment.
..
user-defined
/*
manageable

12. In PL/SQL - what the variables in DML statements are turned into.
TYPE tA IS TABLE OF NUMBER INDEX BY VARCHAR2(20)
bind arguments
database
EXECUTE IMMEDIATE

13. Types: A data type family consists of a ______ type and its subtypes.
base
;
explicit
Server Pages

14. Web: PL/SQL _______ enables a Web browser to invoke a PL/SQL stored subprogram through an HTTP listener.
FOR i IN REVERSE 1..10 - LOOP - NULL; END LOOP;
Gateway
machine code
bind arguments

15. Cursors: Give the statement to close cursor C.
wrap
255
BOOLEAN
close C

16. Types: ________ data types have no internal components.
scalar
dynamic
cannot
for each row

17. In a FORALL loop - you (can / cannot) use the index variable for purposes other than indexing into the collection.
1 million
cannot
current transaction
stored

18. Cursors: WHERE _______ ______ makes an UPDATE or DELETE apply to the current row of a cursor.
$END
CURRENT OF
invoker's
%

19. Triggers: You create a trigger with the _______ ________ statement.
CREATE TRIGGER
.
WHERE CURRENT OF
...

20. A user-defined TYPE can have...
an AUTHID property
follows
cannot
inquiry

21. Types: PL/SQL has all the _____ data types.
$$PLSQL_LINE
SQL
expression
index

22. Command to delete a procedure.
set serveroutput on
drop procedure
associative
-20 -000

23. Dbms_sql: A cursor opened with OPEN_CURSOR (can/cannot) be reused for multiple queries without first closing it.
CURSOR - RETURN - IS
composite
does not
can

24. I/O: This package sends text output to SQLPlus
DBMS_OUTPUT
do not
1
Declaration

25. Bulk: The two features that comprise Bulk SQL are:
FORALL and BULK COLLECT
do not
order
information that changes infrequently

26. Cursors: Statement to end a loop when MyCur is used up: _____ ______ MyCur%NOTFOUND.
EXIT WHEN
sequence pseudo-columns
RECORDS
inquiry

27. The source for wrapping begins with the word ______.
forward
..
create
collections - records

28. I/O: dbms_output.put_line puts output into a _______.
parameter
buffer
subtype
is

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

30. Types: One of the scalar data types specific to PL/SQL: P________
DML
cursor
increment
PLS_INTEGER

31. Types: ______ data types are those storing values with no internal components.
scalar
bind
inclusive
is

32. Fundamental: One of the 4 types of lexical units: L_____
literals
CHAR - VARCHAR2
Web Toolkit
not a number

33. Conversion: Implicit conversion can be (faster / slower) than explicit conversion.
statement
selection
slower
DECLARE - BEGIN - EXCEPTION - END

34. Which collection type is bounded?
EXECUTE IMMEDIATE
mandatory
varray
subtype

35. Cursors: The second keyword of a FETCH statement.
system global area
IN - OUT - IN OUT
-
INTO

36. TCL: Create a savepoint called ab
scalar
4K
savepoint ab
HTP

37. Cursors: The keyword that makes a ref cursor type STRONG.
RETURN
static boolean
FOR i IN REVERSE 1..10 LOOP
does not

38. Give the statement to make a program autonomous.
PRAGMA AUTONOMOUS_TRANSACTION;
boolean
cannot
user-defined

39. Fundamental: A label can be used to name an ______ block.
anonymous
EXIT WHEN
INTO
EXTEND

40. The _____ utility turns PL/SQL source code into unreadable text.
scalable
placeholders
RETURN
Wrap

41. Exceptions: The keyword that begins an exception handler.
colon
RETURN
cursor
WHEN

42. For a collection - the NEXT method returns ____ when there is no next index value.
compiles
virtual machine

v3 IN OUT NUMBER

43. Declare a constrained subtype of NUMBER called N that is not null.
exit when cgo%NOTFOUND
SUBTYPE n IS number not null;
Gateway
code

44. Delimiters: Host variable indicator.
anonymous block
cannot
...
names

45. _______ arrays can be sparse or dense - depending on how you fill them.
associative
binding
optional
searched

46. The command used to populate PLSQL_CCFLAGS.
closed
4
%FOUND - %ISOPEN - %NOTFOUND - %ROWCOUNT
ALTER SESSION

47. In Native Mode - PL/SQL code is compiled into ______ ______.
binding
does not
machine code
transaction

48. Triggers and views always have _________ rights.

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

49. IDs: How an ordinary user-defined identifier must begin.
With a letter.
TOO_MANY_ROWS
bind
ALTER SESSION

50. By default - OUT and IN OUT parameters are passed by _____.
multi-row
PUT_LINE
anonymous
value