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. Abbreviation of definer's rights
VARCHAR2
cursor c;
delimiters
DR

2. Records are one of the two kinds of PL/SQL _______ data types.
static boolean
server
composite
fine-grained auditing

3. Fundamental: Which one of these is a compound symbol: = - :=
True - false or NULL.
:=
scalable
r tRec := tRec(9 - 'Jones');

4. Conversion: If the specific value is suitable - ____ or _______ values can convert to almost any datatype
CHAR - VARCHAR2
boolean
%TYPE
predefined

5. $$PLSQL_LINE and $$PLSQL_UNIT are ______-ly defined inquiry directives.
invoker's
autonomous triggers
is not
implicit

6. A FOR loop can be indexed by numbers or by a ______.
dbms_output.put_line
cursor
*/
commit - rollback

7. Triggers: If two or more triggers are defined with the same timing point - then you can control the firing order using the ________ clause.
pls_integer
Gateway
CHAR - VARCHAR2
follows

8. An incomplete type is a type created by a ______ type definition.
nested
forward
numeric and cursor
constant

9. An incomplete type only has a ____.
anonymous block
same arguments
name
END

10. DynSQL: The colon-prefixed names used in EXECUTE IMMEDIATE are called ________.
%TYPE
names
API
placeholders

11. I/O: The PL/SQL I/O packages (can/cannot) accept input directly from the keyboard.
cannot
SESSION_USER
system global area
do not

12. A type of compiler directive - begins with 'i'.
cursor number
inquiry
USING
CLOSE

13. The lowest index of a VARRAY is ___.
1
network
1 million
index

14. Fundamental: One of the 4 types of lexical units: L_____
literals
DBMS_CRYPTO
%
RELIES_ON

15. The three types of compiler warnings.
dense
EVERE - PERFORMANCE - INFORMATIONAL
Abstract
commit - rollback

16. Package for getting the postprocessed source of a program.
Ada
selection
base
DBMS_PREPROCESSOR

17. Triggers: In a DML trigger - the phrase that makes the trigger run for every affected record.
-
CLOSE_CURSOR
for each row
IR

18. Types of blocks: Procedures and functions are _______ blocks.
lowest
stored
single-line
TRUE - FALSE - NULL

19. Language that PL/SQL is derived from.
vname CONSTANT VARCHAR2 := 'x';
Ada
PL/SQL
FORALL and BULK COLLECT

20. In a cursor loop - the clause added to an INSERT or UPDATE to point at the current record.
1
preprocessor
WHERE CURRENT OF
TYPE tV IS VARRAY(100) OF NUMBER

21. Command to assign to variables from a cursor.
=>
elements
FETCH
cursor

22. The inquiry directive that gives the current line number in the procedure.
optional
CREATE TYPE
$$PLSQL_LINE
execute immediate

23. Delimiters: Item separator.
cursor
integer

same

24. Dbms_sql: A cursor opened with OPEN_CURSOR (can/cannot) be reused for multiple queries without first closing it.
TRUE - FALSE and NULL
IR
currval and nextval
can

25. The DECLARE keyword is only required in an _______ _______.
TYPE t IS TABLE OF rPerson INDEX BY PLS_INTEGER;
elements
ENABLE
anonymous block

26. Advantage: Caching of programs and sharing among users lowers _______ requirements.
library
EXECUTE IMMEDIATE
HTP
memory

27. Exceptions: The maximum length of an Oracle error message is ____ characters
PUT_LINE
nested
512
SQL cursor

28. An ordinary character literal is composed of characters in the ________ character set.
anonymous
VARRAYs
database
constructor

29. You have to use _______ SQL to run DDL statements n PL/SQL.
dynamic
literals
NDS
SQL cursor

30. Are good for logging table DML operations.
p.v
EXECUTE IMMEDIATE
fetch C into V
autonomous triggers

31. Cursors: WHERE _______ ______ makes an UPDATE or DELETE apply to the current row of a cursor.
DBMS_DDL
database
CURRENT OF
IR

32. Triggers: On a non-editioning view - you can only define __________ triggers.
USER_PROCEDURES
DML
INSTEAD OF
explicit cursor

33. Triggers: By default - a trigger is created in the ______ state.
enabled
STANDARD
TYPE tN IS TABLE of NUMBER
CHAR - VARCHAR2

34. Give the statement to make a program autonomous.
plb
PRAGMA AUTONOMOUS_TRANSACTION;
composite
1

35. The BETWEEN operator is (inclusive / exclusive).
explicit cursor
PVM
API
inclusive

36. The method to add one or more elements to a nested table or VARRAY is ______.
FGA
elements - type
EXTEND
SESSION_USER

37. The variable showing the user id of the session owner.
<<
CURSOR - RETURN
stored
SESSION_USER

38. Types: The storage size of a NUMBER value is based on the number of ______ digits.
cannot
Oracle
parameter
significant

39. Cursors: You can just declare a cursor at first - then _______ it later.
RETURN
define
VARCHAR2
object

40. A ___________ behaves like a table column - but it is not stored in the table.
definer's
pseudocolumn
delimiters
can

41. Web: PL/SQL _____ _______ lets you to develop Web applications made of PL/SQL procedures.
RETURN
CURSOR - RETURN - IS
Web Toolkit
non-editioning views

42. Cursors: The statement where you pass the parameters to a cursor.
closed
4
:=
OPEN

43. A null string and a BOOLEAN null are _______ (same/not the same).
Ordinary - Quoted.
loop
*/
not the same

44. Dbms_sql: The return type DBMS_SQL.open_cursor.
UTL_FILE
EXIT WHEN
transaction
integer

45. Cursors: The keyword that makes a ref cursor type STRONG.
stored
reference
enabled
RETURN

46. Exceptions: Start of the range of error codes for RAISE_APPLICATION_ERROR.
PLS_INTEGER
vname CONSTANT VARCHAR2 := 'x';
parameter
-20 -000

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

48. Types: A ______ has the same valid operations as its base type.
API
Oracle
current BEGIN-END block
subtype

49. The PL/SQL virtual machine turns bytecode into system ______.
RETURN
return value
calls
identifiers

50. Setting CURRENT_SCHEMA only changes what is prepended to __________ references.
query
1 million
static
unqualified