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. The PL/SQL preprocessor passes ______ code to the compiler.
=>
END LOOP
source
array

2. Declare a cursor c with no parameters or return type.
lock
cursor c;
cannot
SYS_REFCURSOR

3. Exceptions: An exception raised inside an _______ _______ propagates immediately to the enclosing block
1
exception handler
WHERE CURRENT OF
4

4. Keyword for doing assignment to a variable with SELECT.
INTO
255
Abstract
Apache

5. Exceptions: The keyword that begins an exception handler.
WHEN
does not
unhandled
STANDARD

6. The two main parts of a package are the ____ and the _____.
label
FGA
specification - body
HTP

7. The allowed data types of user-defined conditional compilation directives are boolean and _______.
selection
SUBTYPE n IS number not null;
v3 IN OUT NUMBER
pls_integer

8. Cursors: The FOR UPDATE phrase goes at the (beginning/end) of the cursor definition.
PUT_LINE
PRAGMA EXCEPTION_INIT (E - -1);
FOR i IN REVERSE 1..10 LOOP
end

9. Declaration of a varchar2 constant - called vname - with value 'x'.

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

10. To exit an active autonomous transaction without causing an exception - you must issue _____ or ______.
definition
buffer
array
commit - rollback

11. Cursors: Give the statement to open cursor C.
SESSION_USER
CURRENT OF
view
open C

12. The _____ and ____ _____ collection types can be used in database table columns.
bind arguments
EXIT
VARRAY - Nested table
calls

13. Abbreviation of definer's rights
ALTER SESSION
cannot
1 million
DR

14. The 2 characters that begin all inquiry directives.
buffer
CURRENT_USER
for each row
$$

15. Conversion: Implicit conversion can be (faster / slower) than explicit conversion.
cannot
slower
system global area
IS

16. A GOTO cannot branch into an...
r t.%ROWTYPE;
IF - CASE or LOOP
1
EXIT

17. Delimiters: Host variable indicator.
DML
...
oname
binding

18. What is the exception that is implicitly raised in a CASE statement with no ELSE clause?
CASE_NOT_FOUND
cannot
FALSE
open cv for

19. DynSQL: EXECUTE IMMEDIATE does both dynamic SQL and dynamic _______.
$IF $THEN $ELSE $END
END
PL/SQL
decimal

20. Triggers and views always have _________ rights.

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

21. Declare a constrained subtype of NUMBER called N that is not null.
SUBTYPE n IS number not null;
decimal
PL/SQL
:=

22. Exceptions: If there is no handler for an exception - PL/SQL returns an ________ exception error to the invoker or host environment.
CHAR - VARCHAR2
unhandled
collections
statement

23. A (simple / searched) CASE statement begins with CASE <expression>.
error code
invalid
simple
USER_PROCEDURES

24. I/O: The PL/SQL I/O packages (can/cannot) accept input directly from the keyboard.
fine-grained auditing
cannot
CASE_NOT_FOUND
UTL_HTTP

25. Web: PL/SQL _______ enables a Web browser to invoke a PL/SQL stored subprogram through an HTTP listener.
INSTEAD OF
executable
Gateway
binding

26. A FOR loop can be indexed by numbers or by a ______.
cursor
'ENABLE:SEVERE' - 'ERROR:06002'
executable
PL/SQL

27. IDs: The 3 non-alphanumeric characters that can be in an ordinary user-defined identifier.
propagates
timing
# - $ - _
dynamic

28. By default - OUT and IN OUT parameters are passed by _____.
national
exit when cgo%NOTFOUND
SESSION_USER
value

29. Types of blocks: A pl/sql block that is not stored in the database.
ADT
anonymous
INTO
open C(p)

30. In short-circuit evaluation - IF-conditions are only evaluated up to where the outcome ___________.
EXIT
is certain
is
Wrap

31. Types: One of the scalar data types specific to PL/SQL: P________
EXIT WHEN
COMMIT - ROLLBACK - SAVEPOINT - SET TRANSACTION
VARRAY - Nested table
PLS_INTEGER

32. Delimiters: Statement terminator.
;
error code
RECORDS
is

33. Triggers: By default - a trigger is created in the ______ state.
enabled

TRUE - FALSE - NULL
open C(p)

34. Cursors: WHERE _______ ______ makes an UPDATE or DELETE apply to the current row of a cursor.
value
CURRENT OF
finishes
..

35. Statement to exit a cursor loop on cursor cGo when there are no more records.
EDITION_NAME
simple
exit when cgo%NOTFOUND
statement

36. To use a TYPE declared in the database - a PL/SQL block has to have _______ privilege on the type.
TRUE - FALSE - NULL
execute immediate
select
system global area

37. Triggers: Unlike a stored procedure - you can enable and _____ a trigger.
open C
<<>>
disable
USER_PLSQL_OBJECT_SETTINGS

38. Type: An ________ subtype has all the values of its base type.
transaction
forward
fields
unconstrained

39. Cursors: Give the statement to close cursor C.
SQL
RETURN
close C
package

40. GOTO branches to a ________.
forward
label
Keywords and predefined names.
bb:true

41. Declare a number variable - A - initialized to 10.
<> - != - ^=
inclusive
a number := 10
memory

42. True encryption is done with package __________.
constrained
name-value
3
DBMS_CRYPTO

43. Cursors: If no SELECT or DML statement has run - the value of SQL%ROWCOUNT is what?
DBMS_PIPE
end

CURSOR - RETURN

44. Types: A ______ has the same valid operations as its base type.
raise_application_error
PRAGMA AUTONOMOUS_TRANSACTION;
expression
subtype

45. The command used to populate PLSQL_CCFLAGS.
:=
INTO
collections - records
ALTER SESSION

46. The $IF must evaluate a ______ _______ expression.
DBMS_SQL
REF_CURSOR
virtual machine
static boolean

47. Delimiters: The remote access symbol.
code
@
multi-row
comments

48. CREATE TYPE cannot be used for _______ array types.
STANDARD
vname CONSTANT VARCHAR2 := 'x';
associative
compile

49. Cursors: A cursor FOR loop can use an explicit or an _______ cursor.
ROLLBACK
implicit
boolean
Server Pages

50. By default - an IN parameter is passed by ______.
fetch cv into myvar
reference
create procedure
return value