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. A CASE expression ends with _____.
HTF
FGA
END
NUMBER

2. Fundamental: identifiers (include/do not include) reserved words.
bytecode
WHEN OTHERS THEN
include
composite

3. Cursors: A cursor variable's type must be a ____ ______ type.
comments
REF CURSOR
%
error code

4. Web: PL/SQL ______ ______ (PSPs) let you develop web pages with dynamic content.
column
FORALL and BULK COLLECT
Server Pages
pls_integer

5. Cursors: Give the statement to open cursor C.
REUSE SETTINGS
NDS
open C
transaction

6. A kind of variable used as a placeholder.
PLS_INTEGER
Web Toolkit
bind
30

7. Two types of stored subprograms.
CHAR - VARCHAR2
implicit
procedure - function
FORALL i IN MyList.FIRST..MyList.LAST

8. The BETWEEN operator is (inclusive / exclusive).
inclusive
1
definer's
BOOLEAN

9. Cursors: The second keyword of a FETCH statement.
name-value
INTO
IF - CASE or LOOP
define

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

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

11. Keyword for doing assignment to a variable with SELECT.
procedure - function
BINARY_INTEGER
**
INTO

12. Triggers: In a DML trigger - the phrase that makes the trigger run for every affected record.
integrated
for each row
server
END CASE

13. A subprogram created inside a block is a _________ subprogram.
system global area
UTL_HTTP
nested
searched

14. Command to make a no-op (omit semicolon).
implicit CASE_NOT_FOUND exception

memory
exception

15. Conversion: Implicit conversion can be (faster / slower) than explicit conversion.
END
EXCEPTION_INIT
close C
slower

16. A PL/SQL block that is not stored.
RETURN
anonymous block
constrained
source

17. Exceptions: The maximum length of an Oracle error message is ____ characters
r t.%ROWTYPE;
specification - body
PUT
512

18. You (can/cannot) put a label before an END LOOP statement.
$IF
FETCH
USER_PROCEDURES
cannot

19. Types: One of the 4 PL/SQL things that have a data type (begins with 'r').
multi-row
fetch cv into myvar
DBMS_SESSION
return value

20. IDs: How an ordinary user-defined identifier must begin.
error code
index
DBMS_CRYPTO
With a letter.

21. To use a TYPE declared in the database - a PL/SQL block has to have _______ privilege on the type.
NDS
select
v2 IN NUMBER default 20
enabled

22. Cursors: A pointer to a cursor is called a ______ _______.
injection
cursor variable
SYS_CONTEXT
REF CURSOR

23. Cursors: The SQL%BULK_ROWCOUNT attribute is an _________ -
array
never
timing
for each row

24. The PL/SQL preprocessor passes ______ code to the compiler.
name and datatype
source
anonymous
RECORD OF ARRAYS

25. An autonomous program runs in its own __________.
Gateway
:=
transaction
OPEN_CURSOR

26. Types: One of the scalar data types specific to PL/SQL: R_________.
IS
inquiry
preprocessor
REF_CURSOR

27. Mode designation for an input/output parameter.
IN OUT
definition
compilation
NUMBER

28. The NOCOPY option on an OUT or IN OUT parameter - causes it to be passed by ______.
buffer
before insert or update on emps
VARCHAR2
reference

29. Nested tables can become sparse via ______.
DEFINER
array
ENABLE
deletions

30. DynSQL: The colon-prefixed names used in EXECUTE IMMEDIATE are called ________.
cannot
With a letter.
system global area
placeholders

31. Parameter that controls how much Oracle optimizes your PL/SQL code on compilation.
comments
IN - OUT - IN OUT
statement
PLSQL_OPTIMIZE_LEVEL

32. Triggers: In a trigger - you cannot issue a COMMIT or a ______.
ROLLBACK
EXECUTE IMMEDIATE
procedure P AUTHID definer;
increment

33. When an autonomous routine begins execution - the main transaction is ________.
REF_CURSOR
suspended
plb
varray

34. Advantage: Performance: Storing and runnng procedures on the server minimizes ______ traffic.
BINARY_INTEGER
PLSQL_CCFLAGS
network
..

35. The allowed data types of user-defined conditional compilation directives are boolean and _______.
pls_integer
bind
plb
memory

36. The DEFINITION of a cursor is the _____ that returns the records.
drop procedure
versions
query
PUT

37. Set flag bb true: ALTER SESSION SET PLSQL_CCFLAGS= '____'
current transaction
UTL_FILE
E Exception;
bb:true

38. Wrapping can be done with the ____ executable.
wrap
1 million
composite
SQL

39. The RESULT_CACHE clause has to be in both the declaration and in the ______ of the function.
anonymous
definition
package
static boolean

40. Cursors: A cursor FOR loop can use an explicit or an _______ cursor.
implicit
E Exception;
FALSE
versions

41. Advantage: Performance: PL/SQL automatically creates ______ variables for variables in WHERE and VALUES clauses.
non-editioning views
define
bind
OUT

42. Types: One of the 4 PL/SQL things that have a data type (begins with 'c').
constant
return value
query
RETURN

43. Exceptions: Declare an exception called E.
PL/SQL
suspended
E Exception;
DR

44. Default value of PLSQL_OPTIMIZE_LEVEL.
suspended
TRUE - FALSE - NULL
32 -000
2

45. The FOR UPDATE OF clause references a (table / column).
column
database
Abstract
do not

46. Triggers: The clause to make a trigger run once for every affected row.
not a number
ROLLBACK
rollback to ab
for each row

47. Cursors: Give the statement to open cursor C that takes parameter p.
executable
dynamic
name and datatype
open C(p)

48. Nested tables are multisets - meaning that there is no inherent _____ of their elements.
order
delimiters
implicit
UTL_SMTP

49. To get the current value of CURRENT_SCHEMA - CURRENT_USER - or SESSION_USER - use the ____ function.
SYS_CONTEXT
32 -000
NUMBER
constructor

50. Delimiters: Single-line comment marker.
create procedure
commit - rollback
-
3