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. You can use the BULK COLLECT INTO clause in a SELECT or a ______.
varray
array
1
FETCH

2. FOR-Looping over a collection from FIRST to LAST only works if the collection is _______.
4K
aggregate - analytical
<<>>
dense

3. A PL/SQL extension to the WHERE clause of the SQL statements UPDATE and DELETE
3
session cursor
WHERE CURRENT OF
HTP

4. I/O: The most basic PL/SQL way to give output to the user.
dbms_output.put_line
composite
API
SUBTYPE n IS number not null;

5. To run DDL statements - a trigger must be autonomous and must use ______ ______ SQL.
native dynamic
CREATE TRIGGER
LOOP - END LOOP
for update of

6. Types: Which type of arithmetic does PLS_INTEGER use - library or hardware?
*/
hardware
END
USER_PLSQL_OBJECT_SETTINGS

7. You can put a label before any executable PL/SQL _________.
value
statement
searched
4K

8. A national character literal is composed of characters in the ________ character set.
national
FORALL and BULK COLLECT
SQL cursor
DATE

9. _____ arrays cannot be used as the type of an Oracle table column.
associative
IF - CASE or LOOP
information that changes infrequently
selection

10. Which two collection types are unbounded?
a cursor
CHARARR
nested tables - associative arrays
$$

11. The RESULT_CACHE clause comes (before / after) the RETURN clause.
EXECUTE
pseudocolumn
after
open cv for

12. Types: In addition to the SQL data types - PL/SQL has ___ more scalar data types.
UTL_HTTP
cannot
FOR i IN REVERSE 1..10 LOOP
4

13. Cursors: Give the statement to fetch data from cursor C into variable V.
r t.%ROWTYPE;
fetch C into V
decimal
information that changes infrequently

14. Kind of code created by the PL/SQL compiler.
machine
associative
cursor
bytecode

15. I/O: This DBMS_OUTPUT proc retrieves multiple lines from the buffer.
GET_LINES
pls_integer
aggregate - analytical
FALSE

16. PL/SQL is a ________ typed programming language.
an enclosing block
decimal
statically
invoker's

17. Cursors: If you use an EXIT statement to exit a cursor FOR loop prematurely - the cursor (is / is not) closed automatically.
is
close C
simple
deletions

18. Fundamental: Character used to escape a single quote inside a literal.

19. Package for getting the postprocessed source of a program.
close C
simple
CLOSE
DBMS_PREPROCESSOR

20. Advantage: Having procedures stored and executed on the server makes PL/SQL ________.
dbms_output.put_line
scalable
CURRENT_USER - DEFINER
...

21. The Wrap utility ________ the source code.
elements - type
3
CASE_NOT_FOUND
obfuscates

22. Assignment of PLSQL_CCFLAGS (cannot / can) be included in ALTER PROCEDURE ... COMPILE ...
bytecode
autonomous triggers
can
aliases

23. I/O: This package has hypertext functions that generate HTML tags
HTF
context
parameter
composite

24. To exit an active autonomous transaction without causing an exception - you must issue _____ or ______.
DBMS_OUTPUT
explicit
commit - rollback
r tRec := tRec(9 - 'Jones');

25. Declare a package procedure P with no arguments - and give it invoker's rights.
procedure P AUTHID current_user;
FETCH - BULK COLLECT INTO
ADT
close C

26. DynSQL: Native Dynamic SQL
BINARY_INTEGER
Double quotes.
literal
NDS

27. Types: Which type of arithmetic does NUMBER use - library or hardware?
cannot
CASE_NOT_FOUND
library
EXIT

28. Internally - the NUMBER type is stored as ______. Therefore - decimal numbers (such as prices) are stored exactly - with no rounding.
PLSQL_OPTIMIZE_LEVEL
a cursor
decimal
varray

29. For a collection - the NEXT method returns ____ when there is no next index value.

bytecode
1
slower

30. A large OUT or IN OUT parameter will waste a lot of space and CPU if it is passed by _____.
can
VARRAY - Nested table
BINARY_INTEGER
value

31. Dbms_sql: DBMS_SQL package is compiled with _______ rights.

32. Cursors: You give an explicit cursor a name and associate it with a _______.
PVM
query
FOR i IN REVERSE 1..10 LOOP
database

33. A __________ can have an AUTHID property
CLOSE_CURSOR
network
CHARARR
package

34. Give the ANSI Date literal for December 25 - 2005.

35. The PL/SQL preprocessor passes ______ code to the compiler.
increment
source
PRAGMA AUTONOMOUS_TRANSACTION;
suspended

36. Fundamental: Which one of these is a simple symbol: a - = - !=
RESULT_CACHE
SQLPlus
label
=

37. Fundamental: Delimiters are _____ and _____ symbols.
current
simple and compound symbols
names
error code

38. Advantage: PL/SQL runs anywhere Oracle runs - so it is very ________.
scalar
1
implicit CASE_NOT_FOUND exception
portable

39. I/O: This package lets PL/SQL programs read and write OS files.
UTL_FILE
value
native dynamic
finishes

40. Cursors: A Cursor FOR loop does not use a ______ statement.
open C(p)
FETCH
$$PLSQL_LINE
cursor variable

41. An autonomous program runs in its own __________.
unqualified
transaction
Web Toolkit
SQLCODE

42. A type of compiler directive - begins with 's'.
invoker's
selection
SUBTYPE numb IS number;
can

43. A record is a group of related data items stored in fields - each with its own...

name and datatype
memory
forward

44. Triggers: On a non-editioning view - you can only define __________ triggers.
raise_application_error
INSTEAD OF
WHERE CURRENT OF
compilation

45. An ordinary character literal is composed of characters in the ________ character set.
database
current transaction
colon
single-line

46. The lowest index of a VARRAY is ___.
PL/SQL
lower sub-block
STANDARD
1

47. Cursors: A pointer to a cursor is called a ______ _______.
raise_application_error(-20 -100 - 'Bad');
obfuscates
finishes
cursor variable

48. For a collection - the NEXT method gets the next higher (element / index).
scalar
SYS_REFCURSOR
index
cannot

49. Delimiters: The component indicator/selector.
collections
CHAR - VARCHAR2
.
cannot

50. How many times are a FOR loop's index bounds evaluated?
name
5
do not
once