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. Types: One of the scalar data types specific to PL/SQL: P________
elements - type
PLS_INTEGER
fine-grained auditing
package

2. The meaning of 'FGA'.
fine-grained auditing
fetch cv into myvar
1
query

3. Assigning values to PL/SQL variables that appear in SQL statements is called _______.
TYPE tN IS TABLE of NUMBER
array
define
binding

4. Dbms_sql: A cursor opened with OPEN_CURSOR (can/cannot) be reused for multiple queries without first closing it.
composite
can
IN - OUT - IN OUT
=

5. Types: ________ data types have no internal components.
OTHERS
scalar
elements - type
UTL_SMTP

6. Cursors: A session cursor that a PL/SQL user creates and manages.
Double quotes.
open cv for
SQL
explicit cursor

7. Cursors: What implicit cursor attribute gives row counts for a FORALL statement?
selection
%BULK_ROWCOUNT
CHAR - VARCHAR2
execute immediate

8. Cursors: A cursor variable's type must be a ____ ______ type.
Double quotes.
inclusive
SQL
REF CURSOR

9. IDs: You (can/cannot) use keywords as ordinary user-defined identifiers.
follows
base
can
raise_application_error

10. In a collection - the internal components are called _______.
execute immediate
4K
simple and compound symbols
elements

11. A FOR loop can be indexed by numbers or by a ______.
EXCEPTION_INIT
cursor
procedure P AUTHID current_user;
.

12. Triggers: On a non-editioning view - you can only define __________ triggers.
INSTEAD OF
boolean
error code
EXIT WHEN

13. Cursors: Give the statement to open cursor C.
ex := tbl1 MULTISET EXCEPT tbl2
database
open C
FGA

14. Cursors: The statement that closes a cursor.
CLOSE
DBMS_SESSION.RESET_PACKAGE
CURRENT_USER
OTHERS

15. Internally - the NUMBER type is stored as ______. Therefore - decimal numbers (such as prices) are stored exactly - with no rounding.
identifiers
decimal
raise_application_error(-20 -100 - 'Bad');
definer's

16. Fundamental: What is the exponentiation operator?
before insert or update on emps
exception handler
**
associative

17. The 4 keywords in the $IF compiler directive.
current transaction
$IF $THEN $ELSE $END
SQLCODE
run

18. You can put a label before any executable PL/SQL _________.
cannot
..
r t.%ROWTYPE;
statement

19. Triggers: INSTEAD OF triggers only run on ______ views.
=
currval and nextval
index
non-editioning views

20. CREATE TYPE cannot be used for _______ array types.
FOR i IN REVERSE 1..10 LOOP
associative
portable
for update of

21. Delimiters: Statement terminator.
SIMPLE_INTEGER
With a letter.
VARCHAR2
;

22. Triggers: By default - a trigger is created in the ______ state.
cannot
cannot
enabled
session cursor

23. SIMPLE_INTEGER is like PLS_INTEGER - but it does not allow ____ values - and it does not raise overflow exceptions.
anonymous

/*
network

24. Cursors: The four cursor attributes - in alphabetical order.
NEW
1
%FOUND - %ISOPEN - %NOTFOUND - %ROWCOUNT
cursor

25. Mode designation for an input parameter.
/*
IN
raise_application_error(-20 -100 - 'Bad');
parameter

26. I/O: This package has hypertext functions that generate HTML tags
HTF
END LOOP
searched
INTO

27. Types: One of the scalar data types specific to PL/SQL: B_______
before insert or update on emps
enabled
True - false or NULL.
BINARY_INTEGER

28. An autonomous program runs in its own __________.
%
transaction
never
calls

29. Advantage: PL/SQL gives SCALABILITY because stored procedures are executed on the _______.
PRAGMA AUTONOMOUS_TRANSACTION;
DBMS_SESSION
server
IN

30. Advantage: PL/SQL is PORTABLE to any OS where ________ runs.
for each row
Oracle
SQLERRM
cannot

31. Conditional ______ allows backward compability with older database versions.
optional
autonomous transaction
compilation
Reserved words.

32. I/O: dbms_output.put_line puts output into a _______.
bind arguments
buffer
FORALL i IN MyList.FIRST..MyList.LAST
NEW

33. Cursors: The values plugged into the DML in a FORALL must come from existing - populated _________.
fetch C into V
END LOOP
collections
execute

34. I/O: The string table type in DBMS_OUTPUT for holding lines of text.
boolean
LOOP - END LOOP
bb:true
CHARARR

35. Fundamental: One of the 4 types of lexical units: L_____
literals
exception handler
DECLARE - BEGIN - EXCEPTION - END
GET_LINE

36. Declare an unconstrained subtype of NUMBER called NUMB.
SUBTYPE numb IS number;
unconstrained
DML
30

37. Types: The only PL/SQL type for which you can specify a range constraint.
PLS_INTEGER
Gateway

boolean

38. The PL/SQL ________ evaluates compiler directives.
Declaration
exception handler
multi-row
preprocessor

39. The EXCEPTION section is (optional/mandatory).
cached
does not
drop procedure
optional

40. Bulk: The implicit cursor attribute that gives the number of rows affected by each DML statement in a FORALL statement.
RETURN
simple and compound symbols
%BULK_ROWCOUNT
32 -000

41. Nested tables can become sparse via ______.
increment
bind
deletions
TYPE rec IS RECORD (num NUMBER - name VARCHAR2(10));

42. The LIMIT method is only meaningful for _______.
VARRAYs
type T is ref cursor
index
set serveroutput on

43. DynSQL: In EXECUTE IMMEDIATE - the statement string can use either placeholders - or string ________.
True
execute
follows
concatenation

44. DynSQL: Maximum string length to pass to EXECUTE IMMEDIATE.
1
cursor variable
definer's
32 -000

45. An anonymous block always has _________ rights.

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

46. Command to make a no-op (omit semicolon).
NUMBER
implicit cursor

non-editioning views

47. Fundamental: What are the 3 compound symbols for 'not equal to'?
lock
<> - != - ^=
integrated
column

48. Declare a constrained subtype of NUMBER called N that is not null.
BINARY_INTEGER
associative
SUBTYPE n IS number not null;
$IF $THEN $ELSE $END

49. Package for getting the postprocessed source of a program.
DBMS_PREPROCESSOR
$IF $THEN $ELSE $END
a number := 10
PLS_INTEGER

50. Static typing is also called _____ typing.
strong
error code
UTL_FILE
v1 OUT number default 10