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. Exceptions: The package that defines pre-defined exceptions.
non-editioning views
cannot
STANDARD
BOOLEAN

2. Give the first line of the FOR loop with index i going from 1 to 10 in reverse.
hardware
cursor number
FOR i IN REVERSE 1..10 LOOP
memory

3. Data dictionary view that shows the compiler settings for each compiled object.
slower
manageable
simple
USER_PLSQL_OBJECT_SETTINGS

4. Web: mod_plsql is an implementation of the PL/SQL _________.
Gateway
parameter
4
bind

5. Triggers: On a non-editioning view - you can only define __________ triggers.
EXIT WHEN
INSTEAD OF
flushed
session cursor

6. Cursors: The keyword that makes a ref cursor type STRONG.
INTO
return value
DML
RETURN

7. If you are in a procedure inside a package - the compilation unit is the _______.
CURRENT OF
can
cannot
package

8. IDs: Maximum number of bytes in a user-defined identifier.
alter procedure
TYPE tA IS TABLE OF NUMBER INDEX BY VARCHAR2(20)
30
source code

9. Mode designation for an input/output parameter.
finishes
OLD
IN OUT
FGA

10. Advantage: PL/SQL gives SCALABILITY because stored procedures are executed on the _______.
bind
server
bind arguments
CASE_NOT_FOUND

11. A value that is neither represented by an identifier nor calculated from other values.
literal
boolean
%FOUND - %ISOPEN - %NOTFOUND - %ROWCOUNT
name-value

12. I/O: This DBMS_OUTPUT proc retrieves one line from the buffer.
GET_LINE
OTHERS
DBMS_PREPROCESSOR
package

13. Cursors: A cursor FOR loop can use an explicit or an _______ cursor.
source
implicit
predefined
FETCH - BULK COLLECT INTO

14. From a block nested inside a procedure P - reference variable V of the outer procedure.
1
NESTED TABLE myColl STORE AS myCollTab
p.v
nested

15. An INSTEAD OF trigger specifies what to do instead of a ___ statement.
exit when cgo%NOTFOUND
executable
context
DML

16. With static typing - type checking is done at ______ time.
can
procedure P AUTHID current_user;
CURSOR - RETURN
compile

17. Native compilation turns bytecode into ________ code.
end
must
machine
optional

18. Cursors: The value of SQL%ROWCOUNT after a SELECT INTO statement returns more than one row.
FGA
1
EXIT
current BEGIN-END block

19. Delimiters: The assignment operator.
database
RECORD OF ARRAYS
:=
STANDARD

20. Cursors: The SQL%FOUND attribute has how many possible values?
255
1
create
3

21. Command used to execute dynamic SQL.
RAISE
CURRENT OF
cursor c;
EXECUTE IMMEDIATE

22. Exceptions: Declare an exception called E.
UTL_HTTP
never
a number := 10
E Exception;

23. Types: One of the 4 PL/SQL things that have a data type (begins with 'r').
loop
return value
create procedure
anonymous

24. Cursors: The three keywords in a full cursor declaration/definition (before the SELECT).
raise_application_error
4
CURSOR - RETURN - IS
PLS_INTEGER

25. Fundamental: Maximum string length of a PL/SQL variable.
elements
selection
32 -000
REF CURSOR

26. Delimiters: Single-line comment marker.
:=
-
varray
executable

27. What clause makes a compilation default to the PLSQL_CCFLAGS settings from the last compilation?
REUSE SETTINGS
NUMBER
EXIT WHEN cv%NOTFOUND
calls

28. Define a record variable r - of type tRec - initialized with values 9 and 'Jones' in its two fields.

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

29. 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

30. I/O: Max number of bytes to pass in a call to DBMS_OUTPUT.PUT_LINE.
hardware
255
pseudocolumn
constrained

31. The collection method that tells the number of elements in the collection.
4K
COUNT
'ENABLE:SEVERE' - 'ERROR:06002'
open C(p)

32. NAN stands for _________.
lock
create procedure
OTHERS
not a number

33. An $ERROR directive ends with _____.
exit when cgo%NOTFOUND
$END
suspended
%TYPE

34. Advantage: PL/SQL is PORTABLE to any OS where ________ runs.
Oracle
associative
manageable
open cv for

35. Types: A ______ has the same valid operations as its base type.
subtype
database
vname CONSTANT VARCHAR2 := 'x';
constant

36. Default file extension of wrap's input file.
sql
after
cannot
explicit cursor

37. In 11g you can directly reference _____________ in PL/SQL.
GET_LINES
sequence pseudo-columns
=>
pls_integer

38. I/O: One of the 3 types of data stored in the DBMS_OUTPUT buffer.
decimal
DATE
is
OTHERS

39. Advantage: PL/SQL runs anywhere Oracle runs - so it is very ________.
fail
portable
%
NUMBER

40. One good use of bind variables is to guard against SQL _______.
SESSION_USER
injection
index
EXIT WHEN

41. In interpreted mode - PL/SQL code is run in a _______ _______.
virtual machine
EXECUTE IMMEDIATE
define
follows

42. Wrapping can be done with the ____ executable.
wrap
$$PLSQL_LINE
RETURN
:=

43. The attribute used to get the type of a column or variable without knowing what it is.
%TYPE
IN OUT
forward
varray

44. Associative arrays (do / do not) have to be initialized with a constructor.
associative arrays
aggregate - analytical
do not
32 -000

45. A CASE expression ends with _____.
significant
anonymous
FETCH
END

46. The default value of the AUTHID property.
reference
OUT
DEFINER
HTF

47. Static typing is also called _____ typing.
inclusive
strong
512
composite

48. DynSQL: Maximum string length to pass to EXECUTE IMMEDIATE.
# - $ - _
fields
32 -000
PL/SQL Gateway

49. Dbms_sql: The DBMS_SQL procedure that closes a cursor.
is
EXECUTE IMMEDIATE
session cursor
CLOSE_CURSOR

50. An anonymous block always has _________ rights.

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