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. Package for getting the postprocessed source of a program.
same
DBMS_PREPROCESSOR
dynamic
5

2. The four keywords that define a PL/SQL block.
network
do not
$$PLSQL_LINE
DECLARE - BEGIN - EXCEPTION - END

3. PL/SQL lets you define two kinds of composite data types: _______ and _______
name
collections - records
Abstract
PL/SQL

4. Default file extension of wrap's output file.
plb
portable
open C(p)
rollback to ab

5. Cursors: You give an explicit cursor a name and associate it with a _______.
dynamic
IF - CASE or LOOP
IN OUT
query

6. A kind of variable used as a placeholder.
virtual machine
collections - records
once
bind

7. To get the current value of CURRENT_SCHEMA - CURRENT_USER - or SESSION_USER - use the ____ function.
PRAGMA AUTONOMOUS_TRANSACTION;
SYS_CONTEXT
CHAR - VARCHAR2
value

8. I/O: This package has hypertext procedures that generate HTML tags
vname CONSTANT VARCHAR2 := 'x';
is certain
HTP
suspended

9. Data dictionary view giving the AUTHID values on a user's objects.
USER_PROCEDURES
'
manageable
1

10. Delimiters: The association operator.
database
EXIT WHEN
=>
compiles

11. List the transaction control statements.
TIMESTAMP.
dbms_output.put_line
COMMIT - ROLLBACK - SAVEPOINT - SET TRANSACTION
transaction

12. Triggers and views always have _________ rights.

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

13. Delimiters: Item separator.
invoker's
p.v
CURSOR - RETURN

14. A large OUT or IN OUT parameter will waste a lot of space and CPU if it is passed by _____.
invoker's
obfuscates
value
PLSQL_OPTIMIZE_LEVEL

15. Triggers: In a per-row trigger - the ____ record shows you the changed state of an affected row.
NEW
unconstrained
USING
CHAR - VARCHAR2

16. A numeric FOR loop cannot _________ by other than 1?
concatenation

increment
SESSION_USER

17. IDs: Maximum number of bytes in a user-defined identifier.
after
NDS
30
aggregate - analytical

18. I/O: To make sure the DBMS_OUTPUT buffer will be flushed - put a WHEN ______ clause in the EXCEPTION section of your outer block.
CURRENT_USER
name and datatype
4K
OTHERS

19. IDs: What a quoted user-defined identifier is enclosed in.
can
cannot
never
Double quotes.

20. Kind of datatypes that support object-oriented programming in PL/SQL.
machine
Web Toolkit
Abstract
INTO

21. Cursors: The second keyword of a FETCH statement.
compilation
HTF
INTO
4

22. Types: One of the scalar data types specific to PL/SQL: R_________.
OPEN_CURSOR
invoker's
constant
REF_CURSOR

23. The attribute used to get the type of a row without knowing what it is.
block
dynamic
%ROWTYPE
RETURN

24. Abbreviation for Abstract Data Type.
ADT
base
cursor
comments

25. Mode designation for an input/output parameter.
information that changes infrequently
commit - rollback
EDITION_NAME
IN OUT

26. Conversion: It is best to use (implicit / explicit) conversion.
Web Toolkit
TYPE tV IS VARRAY(100) OF NUMBER
vname CONSTANT VARCHAR2 := 'x';
explicit

27. The BETWEEN operator is (inclusive / exclusive).
OUT
collections - records
SQL cursor
inclusive

28. How many types of compiler directives are there?
TYPE tV IS VARRAY(100) OF NUMBER
commit - rollback
3
IS

29. Nested tables can become sparse via ______.
deletions
savepoint ab
simple and compound symbols
currval and nextval

30. Command to assign to variables from a cursor.
BINARY_INTEGER
timing
FETCH
v3 IN OUT NUMBER

31. PLS_INTEGER has its arithmetic implemented in ________ - so it is very fast.
PVM
execute immediate
hardware
preprocessor

32. I/O: The buffered output of dbms_output.put_line is retrieved by _______.
SQLPlus
pseudocolumn
aggregate - analytical
EXIT WHEN cv%NOTFOUND

33. A FOR-loop counter is defined only within the _____.
anonymous block
loop
statement
exit when cgo%NOTFOUND

34. A CASE statement (can / cannot) execute more than one group of statements.
virtual machine
cannot
server
Keywords and predefined names.

35. Dbms_sql: DBMS_SQL package is compiled with _______ rights.

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

36. You can have many autonomous transactions in ___________.
SQLERRM
IS
Server Pages
an autonomous routine

37. A nested table has to be initialized using a ________ - named the same as the type.
32 -000
unconstrained
source
constructor

38. If a result-cached function's data source (based on the RELIES_ON clause) is updated - any cached results become _______.
invalid
OLD
DBMS_SESSION
cursor variable

39. The attribute used to get the type of a column or variable without knowing what it is.
%TYPE
pseudocolumn
selection
INSTEAD OF

40. Which two collection types are unbounded?
cursor variable
4K
integrated
nested tables - associative arrays

41. What are the two sequence pseudo-columns?
comments
nested
finishes
currval and nextval

42. The variable showing the user id that is automatically prepended to object names.
<<>>
bind
CURRENT_USER
network

43. Types: ______ data types are those storing values with no internal components.
scalar
SQLCODE
SQLPlus
production

44. The DEFINITION of a cursor is the _____ that returns the records.
TRUE - FALSE and NULL
query
PLSQL_OPTIMIZE_LEVEL
OPEN_CURSOR

45. Cursors: A cursor with a name is an _________ cursor.
%ROWTYPE
explicit
an AUTHID property
IS

46. DynSQL: The main command for Native Dynamic SQL.
EXIT WHEN
VARRAYs
EXECUTE IMMEDIATE
NEW

47. I/O: The DBMS_OUTPUT function that writes output without a newline character.
executable
PUT
composite
buffer

48. An $ERROR directive ends with _____.
$END
4
statement
placeholders

49. Delimiters: the attribute indicator.
index
1
SESSION_USER
%

50. Fundamental: One of the 4 types of lexical units: d_____
CURSOR - RETURN
STANDARD
delimiters
loop