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. Declare an unconstrained subtype of NUMBER called NUMB.
DATE '2005-12-25'
SUBTYPE numb IS number;
pseudocolumn
bind arguments

2. Cursors: You give an explicit cursor a name and associate it with a _______.
-
query
SUBTYPE numb IS number;
-20 -000

3. Exceptions: PL/SQL exceptions are of two types: internal and _________.
upper - coalesce
elsif
user-defined
cannot

4. IDs: You can use a reserved word as a _______ user-defined identifier.
national
1
view
quoted

5. I/O: This package lets PL/SQL programs read and write OS files.
does not
name-value
UTL_FILE
TIMESTAMP.

6. Cursors: The first two keywords in a Cursor FOR loop.
FOR - IN
IN - OUT - IN OUT
FORALL i IN MyList.FIRST..MyList.LAST
after insert on emps

7. Fundamental: Which one of these is a simple symbol: a - = - !=
can
procedure P AUTHID current_user;
=
definer's

8. Triggers: In a trigger - you cannot issue a COMMIT or a ______.
TYPE tA IS TABLE OF NUMBER INDEX BY VARCHAR2(20)
GET_LINE
ROLLBACK
SQL

9. Exceptions: Each internal exception has an Oracle ______ _______.
RAISE
type T is ref cursor
PUT_LINE
error code

10. Exceptions: User-defined exceptions must have _______.
BINARY_INTEGER
GET_LINE
names
TRUE - FALSE - NULL

11. Wrapped code (is / is not) not backward compatible.
fine-grained auditing
bind
is not
anonymous block

12. A result-cached function caches its results in the _____ _____ ____ (SGA)
system global area
..
for update of
run

13. Clause added to a cursor to use it with WHERE CURRENT OF.
does not
SUBTYPE n IS number not null;
for update of
IN

14. The compiler directive governing conditional compilation.
PRAGMA EXCEPTION_INIT (E - -1);
DBMS_SQL
FETCH
$IF

15. The attribute used to get the type of a row without knowing what it is.
Wrap
not the same
$IF
%ROWTYPE

16. A nested table has to be initialized using a ________ - named the same as the type.
DML
explicit cursor
Gateway
constructor

17. Web: PL/SQL ______ ______ (PSPs) let you develop web pages with dynamic content.
Server Pages
DML
boolean
scalable

18. Cursors: The statement that closes a cursor.
CLOSE
fields
GET_LINES
OTHERS

19. You have to use _______ SQL to run DDL statements n PL/SQL.
PLSQL_OPTIMIZE_LEVEL
name and datatype
autonomous transaction
dynamic

20. Which two collection types are unbounded?
Reserved words.
nested tables - associative arrays
virtual machine
1

21. Triggers and views always have _________ rights.

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

22. I/O: The output from DBMS_OUTPUT will display (during/after) program execution.
associative
*/
3
after

23. Triggers: The clause to make a trigger run after inserting into table EMPS.
value
bind
elsif
after insert on emps

24. Triggers: An INSTEAD OF trigger (can/cannot) be conditional.
With a letter.
sequence pseudo-columns
fine-grained auditing
cannot

25. Cursors: The four cursor attributes - in alphabetical order.
%FOUND - %ISOPEN - %NOTFOUND - %ROWCOUNT
cannot
SQL cursor
Declaration

26. Exceptions: Pragma that links an exception to an Oracle error code.
-
ROLLBACK
$$
EXCEPTION_INIT

27. Exceptions: The ________ function returns the current error code.
SQLCODE
**
FETCH
for update of

28. Types: The PL/SQL type that is identical to PLS_INTEGER.
PRAGMA AUTONOMOUS_TRANSACTION;
BINARY_INTEGER
VARCHAR2
unhandled

29. Setting CURRENT_SCHEMA only changes what is prepended to __________ references.
source
unqualified
cannot
value

30. Cursors: An explicit cursor (can/cannot) accept parameters.
%ROWTYPE
SQLCODE
can
OTHERS

31. Delimiters: The remote access symbol.
quoted
a cursor
Declaration
@

32. Advantage: PL/SQL programs are stored centrally - making them more ______.
...
IN - OUT - IN OUT
FORALL and BULK COLLECT
manageable

33. To create a collection type - use the TYPE command in PL/SQL and the ______ _____ command in SQL.
CREATE TYPE
CURRENT OF
current BEGIN-END block
PUT

34. DynSQL: The three modes of arguments in the USING clause of EXECUTE IMMEDIATE.
invoker's
drop procedure
IN - OUT - IN OUT
OPEN_CURSOR

35. ______ SQL is a PL/SQL feature that allows SQL syntax directly in a PL/SQL statement.
suspended
static
1
label

36. VARRAYs are (always / never) sparse.
never
STANDARD
RETURN
variable

37. What is the simplest statement for conditionally getting out of simple loop?
EXIT WHEN
SQL
RAISE
unqualified

38. Wrap ______=xxxx oname=zzzzz
collections - records
statement
iname
name

39. Where an external subprogram is stored.
FETCH - INTO
Abstract
in the database
cursor c;

40. Triggers: You (can/cannot) explicitly invoke a trigger.
cannot
error
create
invoker's

41. The DEFINITION of a cursor is the part after the keyword __.
optional
DBMS_PIPE
IS
DBMS_SESSION

42. For a collection - the NEXT method gets the next higher (element / index).
server
CREATE TRIGGER
Double quotes.
index

43. Cursors: The value of SQL%ISOPEN is always ______.
FALSE
DECLARE - BEGIN - EXCEPTION - END
fail
select

44. Conversion: Implicit conversion is not always predictable; it is _______-sensitive. And its rules might change.
%BULK_ROWCOUNT
context
CHAR - VARCHAR2
5

45. Characters that begin a multi-line comment.
anonymous block
before insert or update on emps
/*
collections - records

46. Give the statement to make a program autonomous.
EXIT
end
PRAGMA AUTONOMOUS_TRANSACTION;
Abstract

47. I/O: This package lets two or more sessions in the same instance communicate.
DBMS_PIPE
TYPE tA IS TABLE OF NUMBER INDEX BY VARCHAR2(20)
forward
never

48. I/O: The DBMS_OUTPUT buffer will not be flushed until it is full or until the current PL/SQL block _________.
30
finishes
$$
bind

49. Fundamental: One of the 4 types of lexical units: d_____
PRAGMA AUTONOMOUS_TRANSACTION;
delimiters
unconstrained
CURSOR - RETURN - IS

50. The EXCEPTION section is (optional/mandatory).
optional
procedure P AUTHID definer;
PUT
pseudocolumn