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. Cursors: The SQL%BULK_ROWCOUNT attribute is an _________ -
can
array
COMMIT - ROLLBACK - SAVEPOINT - SET TRANSACTION
does not

2. With dynamic typing - type checking is done at ______time.
hardware
DBMS_OUTPUT
run
BINARY_INTEGER

3. Declare a variable r whose type is that of the records in table t.
SYS_REFCURSOR
production
index
r t.%ROWTYPE;

4. Labels for blocks and statements are enclosed in '__' brackets.
<<>>
DML
PRAGMA EXCEPTION_INIT (E - -1);
include

5. In a FORALL loop - you (can / cannot) use the index variable for purposes other than indexing into the collection.
FORALL and BULK COLLECT
multi-row
network
cannot

6. Set flag bb true: ALTER SESSION SET PLSQL_CCFLAGS= '____'
bb:true
..
NUMBER
open C(p)

7. ______ SQL is a PL/SQL feature that allows SQL syntax directly in a PL/SQL statement.
True
INTO
ALTER SESSION
static

8. The source for wrapping begins with the word ______.
create
enabled
1
$$PLSQL_LINE

9. Records are one of the two kinds of PL/SQL _______ data types.
composite
variable
OPEN_CURSOR
ROLLBACK

10. A unit with AUTHID = DEFINER is a ________ rights unit.

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

11. When a session starts - CURRENT_SCHEMA has the value of the schema owned by ___________.
WHERE CURRENT OF
after
database
SESSION_USER

12. Cursors: Give the statement to fetch data from cursor variable CV into MyVar.
fetch cv into myvar
expression
INTO
NEW

13. IDs: How an ordinary user-defined identifier must begin.
$$PLSQL_LINE
an autonomous routine
With a letter.
name

14. Dbms_sql: The return type DBMS_SQL.open_cursor.
EXIT WHEN cv%NOTFOUND
v2 IN NUMBER default 20
integer
error code

15. Wrap iname=xxxx _____=zzzzz
oname
TRUE - FALSE - NULL
CLOSE
executable

16. Triggers: Unlike a stored procedure - you can enable and _____ a trigger.
production
disable
hardware
PLSQL_OPTIMIZE_LEVEL

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

18. Native compilation turns bytecode into ________ code.
USER_PROCEDURES
3
lower sub-block
machine

19. Web: Abbreviation of PL/SQL Server Page.
explicit
PSP
cursor variable
HTF

20. Define a nested table type - tN - which is a table NUMBERs.
TYPE tN IS TABLE of NUMBER
LOOP
RETURN
user-defined

21. The command used to populate PLSQL_CCFLAGS.
EXIT WHEN
current
PLS_INTEGER
ALTER SESSION

22. A type of compiler directive - begins with 'e'.
IN - OUT - IN OUT
iname
error
for update of

23. Cursors: A Cursor FOR loop does not use a ______ statement.
RECORD OF ARRAYS
SQL
after
FETCH

24. 5 types of events that can have triggers: DML - DDL - INSTEAD OFs - database events - and ________ statements.
enabled
fetch cv into myvar
suspended
session cursor

25. How to reference a variable V declared in a block labelled L: ____.
OUT
portable
L.V
TYPE rec IS RECORD (num NUMBER - name VARCHAR2(10));

26. The allowed data types of user-defined conditional compilation directives are boolean and _______.
FETCH - INTO
exception handler
ordinary
pls_integer

27. Delimiters: The remote access symbol.
dynamic
@
INTO
upper - coalesce

28. Parameter that controls how much Oracle optimizes your PL/SQL code on compilation.
CHAR - VARCHAR2
error code
DR
PLSQL_OPTIMIZE_LEVEL

29. Advantage: PL/SQL supports ______-oriented programming.
current
execute immediate
SYS_REFCURSOR
object

30. The FIRST method gets the first (element / index) of a collection.
network
set serveroutput on
index
PUT

31. Exceptions: An exception in the declarations section propagates to the enclosing _______.
ALTER SESSION
block
injection
*/

32. Types: One of the scalar data types specific to PL/SQL: R_________.
REF CURSOR
code
REF_CURSOR
CREATE TYPE

33. Cursors: The keyword that makes a ref cursor type STRONG.
RETURN
WHEN
colon
GET_LINES

34. Advantage: PL/SQL is tightly _______ with Oracle SQL.
cursor
not the same
integrated
transaction

35. Exceptions: When an exception is raised inside a cursor FOR loop - the cursor is _______ implicitly.
upper - coalesce
cursor variable
closed
PRAGMA EXCEPTION_INIT (E - -1);

36. Types: A ______ has the same valid operations as its base type.
EXIT WHEN
p.v
/*
subtype

37. What is the simplest statement for conditionally getting out of simple loop?
EXIT WHEN
:=
lock
implicit CASE_NOT_FOUND exception

38. You cannot bulk collect into an ARRAY OF ________.
=>
simple and compound symbols
RECORDS
L.V

39. I/O: The DBMS_OUTPUT function that writes output WITH a newline character.
FGA
PUT_LINE
constant
%ISOPEN.

40. Cursors: A pointer to a cursor is called a ______ _______.
hardware
cannot
cursor variable
enabled

41. Triggers: If two or more triggers are defined with the same timing point - then you can control the firing order using the ________ clause.
invalid
nested
flushed
follows

42. Abbreviation of definer's rights
injection
DR
INTO
cannot

43. Triggers: When using the NEW or OLD pseudo-records in the body of the trigger - they must be prefixed with a _______.
IF - CASE or LOOP
colon
GET_LINE
value

44. A null string and a BOOLEAN null are _______ (same/not the same).
not the same
RECORDS
machine
before insert or update on emps

45. A (simple / searched) CASE statement begins with CASE <expression>.
COUNT
implicit cursor
INTO
simple

46. IDs: What a quoted user-defined identifier is enclosed in.
explicit cursor
machine code
Double quotes.
index

47. Cursors: Which cursor attribute is not meaningful for an implicit cursor?
always
CHAR - VARCHAR2
%ISOPEN.
collections - records

48. Characters that begin a multi-line comment.
/*
concatenation
Gateway
associative

49. Types: One of the scalar data types specific to PL/SQL: b_____.
BOOLEAN
label
PRAGMA AUTONOMOUS_TRANSACTION;
CHAR - VARCHAR2

50. Exceptions: An exception in the declarations section does not go to the __________ section.
32 -000
True - false or NULL.
associative
exception