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. Types: PL/SQL has all the _____ data types.
SQL
BINARY_INTEGER
...
ex := tbl1 MULTISET EXCEPT tbl2

2. IDs: List the two types of user-defined identifiers.
lowest
STANDARD
1 million
Ordinary - Quoted.

3. Wrap ______=xxxx oname=zzzzz
never
iname
cannot
lower sub-block

4. Declare an unconstrained subtype of NUMBER called NUMB.
SUBTYPE numb IS number;
end
BOOLEAN
composite

5. The exception raised when a SELECT INTO statement returns more than one row.
do not
DBMS_DDL
boolean
TOO_MANY_ROWS

6. The command used to populate PLSQL_CCFLAGS.
cannot
dbms_output.put_line
OUT
ALTER SESSION

7. INSTEAD OF triggers are alternatives to ___ triggers
column
do not
%BULK_ROWCOUNT
DML

8. PL/SQL does not automatically create bind variables in ________ SQL.
dynamic
selection
multi-row
package

9. The three types of compiler warnings.
EVERE - PERFORMANCE - INFORMATIONAL
definer's
return value
NEW

10. I/O: The most basic PL/SQL way to give output to the user.
dbms_output.put_line
TRUE - FALSE - NULL
placeholders
run

11. You have to use _______ SQL to run DDL statements n PL/SQL.
VARRAYs
dynamic
subtype
%TYPE

12. The variable showing the user id of the session owner.
explicit
True - false or NULL.
SESSION_USER
nested

13. Triggers: There are __ types of triggers.
boolean
5
searched
RELIES_ON

14. Fundamental: Maximum string length of a PL/SQL variable.
ADT
1
32 -000
injection

15. Exceptions: The ________ function returns the current error code.
ordinary
bind arguments
SQLCODE
cursor c;

16. Cursors: What is the 'name' of the implicit cursor?
RETURN
%BULK_ROWCOUNT
SQL
CLOSE_CURSOR

17. Which two of these built-in SQL functions can be used in procedural (PL/SQL) statements: DECODE - CORR - UPPER - SUM - COALESCE - DEREF.
quoted
upper - coalesce
must
:=

18. Simple CASE statement checks for different values of a single _________
placeholders
significant
simple and compound symbols
expression

19. Associative arrays (do / do not) have to be initialized with a constructor.
portable
do not
query
not the same

20. Command used to execute dynamic SQL.
specification - body
EXECUTE IMMEDIATE
disable
SYS_CONTEXT

21. The 2 characters that begin all inquiry directives.
$$
4K
versions
:=

22. Triggers: To simulate having triggers on SELECT statements - you can try ___ (3-letter acronym).
%
integrated
With a letter.
FGA

23. Mode designation for an input/output parameter.
%ISOPEN.
IN OUT
boolean
CURRENT_USER - DEFINER

24. When an autonomous routine begins execution - the main transaction is ________.
suspended
TYPE tN IS TABLE of NUMBER
national
PUT

25. Types: In addition to the SQL data types - PL/SQL has ___ more scalar data types.
transaction
512
bind
4

26. A PL/SQL block that is not stored.
anonymous block
FETCH
IF - CASE or LOOP
compile

27. Give the value list in the PLSQL_WARNINGS parameter to turn on SEVERE compiler warnings and make compiler warning 06002 be an error.

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

28. Where an external subprogram is stored.
cannot
in the database
<<>>
exception handler

29. Cursors: What are the 3 possible values of SQL%FOUND and SQL%NOTFOUND?
UTL_HTTP
v2 IN NUMBER default 20
dynamic
TRUE - FALSE - NULL

30. The default value of the AUTHID property.
STANDARD
flushed
return value
DEFINER

31. Cursors: You give an explicit cursor a name and associate it with a _______.
query
BINARY_INTEGER
bytecode
session cursor

32. A ___________ behaves like a table column - but it is not stored in the table.
RETURN
suspended
for each row
pseudocolumn

33. Pkgs: The _______ package gives access to such SQL things as ALTER SESSION.
fetch cv into myvar
definition
DBMS_SESSION
delimiters

34. Wrap iname=xxxx _____=zzzzz
oname
expression
rollback to ab
CLOSE

35. A PL/SQL extension to the WHERE clause of the SQL statements UPDATE and DELETE
1
after
WHERE CURRENT OF
for each row

36. Cursors: The SQL%FOUND attribute has how many possible values?
machine
EXTEND
$IF
3

37. Default file extension of wrap's input file.
END IF
concatenation
return value
sql

38. The values defined in PLSQL_CCFLAGS can be referenced as _____ directives.
inquiry
parameter
quoted
identifiers

39. _______ arrays can be sparse or dense - depending on how you fill them.
Double quotes.
associative
same
EXECUTE IMMEDIATE

40. Kind of comment not to put in a PL/SQL block to be processed dynamically by an Oracle Precompiler program.
2
varray
single-line
function f (n number) return number result_cache relies_on (emps);

41. The PL/SQL ________ evaluates compiler directives.
bb:true
current
SQL
preprocessor

42. A CASE expression ends with _____.
cursor
END
ALTER SESSION
COMMIT - ROLLBACK - SAVEPOINT - SET TRANSACTION

43. IDs: You can use a reserved word as a _______ user-defined identifier.
EXIT WHEN cv%NOTFOUND
quoted
:=
function f (n number) return number result_cache relies_on (emps);

44. Cursors: Give the statement to close cursor C.
close C
context
SYS_CONTEXT
raise_application_error(-20 -100 - 'Bad');

45. Cursors: The value of SQL%ISOPEN is always ______.
injection
v1 OUT number default 10
FALSE
wrap

46. DynSQL: EXECUTE IMMEDIATE does both dynamic SQL and dynamic _______.
EXIT WHEN cv%NOTFOUND
PL/SQL
fine-grained auditing
finishes

47. Command to make a no-op (omit semicolon).
$IF
an AUTHID property

drop procedure

48. Fundamental: What is the range operator?
index
optional
EDITION_NAME
..

49. Delimiters: the attribute indicator.
%
$$
Ada
mandatory

50. A unit with AUTHID = CURRENT_USER is an ________ rights unit.

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