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 package has hypertext functions that generate HTML tags
before insert or update on emps
1
HTF
Gateway

2. Value of a character literal with zero characters.
FORALL i IN MyList.FIRST..MyList.LAST

view
RETURN

3. A numeric FOR loop cannot _________ by other than 1?
definer's
explicit
SIMPLE_INTEGER
increment

4. DynSQL: Native Dynamic SQL
exception
variable
NDS
$$PLSQL_LINE

5. To insert or update on a table that has a collection column - you have to have _______ privilege on the collection type.
EXECUTE
elsif
DBMS_SQL
ROLLBACK

6. Cursors: The Oracle predefined REF CURSOR type.
simple and compound symbols
variable
TRUE - FALSE - NULL
SYS_REFCURSOR

7. ______ SQL is a PL/SQL feature that allows SQL syntax directly in a PL/SQL statement.
composite
HTP
static
*/

8. A basic PL/SQL datatype that SQL does not have.
virtual machine
boolean
network
value

9. IDs: Maximum number of bytes in a user-defined identifier.
fine-grained auditing
$IF
30
UTL_FILE

10. Kind of comment not to put in a PL/SQL block to be processed dynamically by an Oracle Precompiler program.
L.V
finishes
single-line
strong

11. Cursors: A session cursor that is automatically created and managed by PL/SQL.
selection
%ISOPEN.
selection
implicit cursor

12. Cursors: An implicit cursor is also called a/n ________ ________ -
$END
OPEN_CURSOR
do not
SQL cursor

13. Types: One of the 4 PL/SQL things that have a data type (begins with 'p').
cannot
parameter
SQL
value

14. DynSQL: Maximum string length to pass to EXECUTE IMMEDIATE.
32 -000
OLD
drop procedure
END CASE

15. Types: Which type of arithmetic does PLS_INTEGER use - library or hardware?
EXECUTE
30
loop
hardware

16. Cursors: The keyword that makes a ref cursor type STRONG.
pls_integer
/*
suspended
RETURN

17. The DEFINITION of a cursor is the part after the keyword __.
IS
nested
collections
procedure P AUTHID definer;

18. The 4 keywords in the $IF compiler directive.
transaction
4K
$IF $THEN $ELSE $END
elements

19. IDs: You cannot use reserved words as ______ user-defined identifiers.
for update of
ordinary
FETCH
WHEN OTHERS THEN

20. To exit an active autonomous transaction without causing an exception - you must issue _____ or ______.
commit - rollback
WHEN OTHERS THEN
not a number
ex := tbl1 MULTISET EXCEPT tbl2

21. Types: PL/SQL has all the _____ data types.
context
SQL
code
cursor c;

22. I/O: This DBMS_OUTPUT proc retrieves multiple lines from the buffer.
identifiers
lowest
plb
GET_LINES

23. The Wrap utility (does / does not) encrypt source code.
boolean
propagates
EXIT
does not

24. Types: One of the scalar data types specific to PL/SQL: P________
drop procedure
explicit
PLS_INTEGER
TIMESTAMP.

25. Triggers: The clause to make a trigger run before inserting or updating table EMPS.
before insert or update on emps
cannot
cannot
OUT

26. Types: One of the scalar data types specific to PL/SQL: B_______
RETURN
set serveroutput on
BINARY_INTEGER
Ada

27. I/O: Max number of bytes DBMS_OUTPUT can handle in a session.
1 million
$END
unqualified
session cursor

28. A PL/SQL block that is not stored.
INTO
varray
anonymous block
sql

29. Clause added to a cursor to use it with WHERE CURRENT OF.
names
composite
WHEN OTHERS THEN
for update of

30. You cannot bulk collect into an ARRAY OF ________.
RECORDS
True
current
DBMS_CRYPTO

31. The lowest index of a VARRAY is ___.
savepoint ab
Apache
DBMS_DDL
1

32. The variable showing the user id that is automatically prepended to object names.
anonymous
END CASE
invoker's
CURRENT_USER

33. I/O: One of the 3 types of data stored in the DBMS_OUTPUT buffer.
comments
cursor
DATE
predefined

34. Into nested table ex - put elements of tbl1 that are not in tbl2.
RECORDS
ex := tbl1 MULTISET EXCEPT tbl2
transaction
PLSQL_OPTIMIZE_LEVEL

35. Set flag bb true: ALTER SESSION SET PLSQL_CCFLAGS= '____'
%ISOPEN.
bb:true
database
decimal

36. With conditional compilation you can avoid compiling debug code in the _______ environment.
production
bind arguments
information that changes infrequently
can

37. In a record - the internal components are called ______.
%ROWTYPE
CURSOR - RETURN - IS
wrap
fields

38. Types of blocks: A pl/sql block that is not stored in the database.
definer's
anonymous
query
for each row

39. Cursors: What is the 'name' of the implicit cursor?
$END
simple
VARRAY - Nested table
SQL

40. Triggers: Unlike a stored procedure - you can enable and _____ a trigger.
create
disable
open C
database

41. Declare a cursor c with no parameters or return type.
cursor c;
*/
TYPE tA IS TABLE OF NUMBER INDEX BY VARCHAR2(20)
30

42. The DEFINITION of a cursor is the _____ that returns the records.
simple and compound symbols
WHEN
query
transaction

43. IDs: The type of words that cannot be user-defined identifiers.
Reserved words.
FGA
GET_LINES
RELIES_ON

44. The BETWEEN operator is (inclusive / exclusive).
inclusive
FORALL i IN MyList.FIRST..MyList.LAST
for update of
RECORD OF ARRAYS

45. Assigning values to PL/SQL variables that appear in SQL statements is called _______.
vname CONSTANT VARCHAR2 := 'x';
PL/SQL
for each row
binding

46. Triggers and views always have _________ rights.

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

47. Exceptions: When an exception is raised inside a cursor FOR loop - the cursor is _______ implicitly.
implicit
closed
run
cursor

48. Declare an unconstrained subtype of NUMBER called NUMB.
SUBTYPE numb IS number;
close C
commit - rollback
REUSE SETTINGS

49. Conversion: It is best to use (implicit / explicit) conversion.
portable
explicit
E Exception;
subtype

50. With an sparse - integer-indexed associative array - you (can / cannot) use a regular FOR loop.
INSTEAD OF
is not
cannot
exception handler