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. Fundamental: What are the 3 compound symbols for 'not equal to'?
<> - != - ^=
%FOUND - %ISOPEN - %NOTFOUND - %ROWCOUNT
system global area
RETURN

2. Give the ANSI Date literal for December 25 - 2005.

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

3. Command to assign to variables from a cursor.
FETCH
IF - CASE or LOOP
EXECUTE IMMEDIATE
package

4. Delimiters: The remote access symbol.
@
'ENABLE:SEVERE' - 'ERROR:06002'
production
PVM

5. The EXCEPTION section is (optional/mandatory).
literals
DML
optional
bind

6. Cursors: The FOR UPDATE phrase goes at the (beginning/end) of the cursor definition.
statement
ex := tbl1 MULTISET EXCEPT tbl2
DML
end

7. Are good for logging table DML operations.
autonomous triggers
reference
must
dynamic

8. Value of PLSQL_OPTIMIZE_LEVEL that prevents optimization.
IN OUT
FETCH
1
RESULT_CACHE

9. Triggers: By default - a trigger is created in the ______ state.
enabled
PL/SQL
mandatory
DBMS_SESSION

10. Web: mod_plsql is an implementation of the PL/SQL _________.
execute
explicit
Gateway
DATE '2005-12-25'

11. Cursors: An explicit cursor (can/cannot) accept parameters.
same arguments
can
strong
decimal

12. To run TCL or DDL statements - a trigger (must / must not) be autonomous .
FOR - IN
must
3
$IF

13. Exceptions: The ________ function returns the current error code.
SQLCODE
v3 IN OUT NUMBER
PUT
anonymous

14. A __________ can have an AUTHID property
scalable
an AUTHID property
package
cannot

15. I/O: This package sends text output to SQLPlus
3
once
$IF
DBMS_OUTPUT

16. The lowest index of a VARRAY is ___.
boolean
manageable
1
VARRAYs

17. DynSQL: The main command for Native Dynamic SQL.
Oracle
composite
NDS
EXECUTE IMMEDIATE

18. Triggers: If two or more triggers are defined with the same timing point - then you can control the firing order using the ________ clause.
invoker's
WHERE CURRENT OF
3
follows

19. In a sparse collection - the indexes of defined elements (do / do not) run in consecutive order.
do not
does not
TYPE tV IS VARRAY(100) OF NUMBER
block

20. The _______ package lets you wrap dynamically generated PL/SQL.
FGA
32 -000
DBMS_DDL
CHAR - VARCHAR2

21. Dbms_sql: The return type DBMS_SQL.open_cursor.
integer
query
buffer
*/

22. Simple CASE statement checks for different values of a single _________
LOOP
invoker's
EXIT WHEN cv%NOTFOUND
expression

23. A national character literal is composed of characters in the ________ character set.
'ENABLE:SEVERE' - 'ERROR:06002'
a number := 10
national
name and datatype

24. Cursors: A cursor FOR loop can use an explicit or an _______ cursor.
implicit
DR
select
scalable

25. Exceptions: A GOTO statement CAN branch from an exception handler into an ________ block.
composite
enclosing
NESTED TABLE myColl STORE AS myCollTab
slower

26. I/O: Max number of bytes DBMS_OUTPUT can handle in a session.
boolean
1 million
not a number
after

27. GOTO branches to a ________.
FORALL and BULK COLLECT
bytecode
$IF
label

28. The PL/SQL preprocessor passes ______ code to the compiler.
END LOOP
%FOUND - %ISOPEN - %NOTFOUND - %ROWCOUNT
source
associative

29. IDs: What a quoted user-defined identifier is enclosed in.
INTO
label
Double quotes.
constrained

30. Dbms_sql: The integer returned by OPEN_CURSOR is a _____ _____.
implicit CASE_NOT_FOUND exception
EXIT WHEN cv%NOTFOUND
cursor number
CURRENT_USER

31. Default file extension of wrap's input file.
for each row
significant
executable
sql

32. The values defined in PLSQL_CCFLAGS can be referenced as _____ directives.
REF CURSOR
inquiry
PVM
placeholders

33. Mode designation for an input/output parameter.
IN OUT
1
RAISE
EXIT WHEN cv%NOTFOUND

34. Cursors: The value of SQL%ROWCOUNT after a SELECT INTO statement returns more than one row.
SQL
@
1
after insert on emps

35. Exceptions: Pragma that links an exception to an Oracle error code.
1
EXCEPTION_INIT
array
cursor

36. Fundamental: One of the 4 types of lexical units: L_____
production
object
VARRAY - Nested table
literals

37. An INSTEAD OF trigger specifies what to do instead of a ___ statement.
DML
FOR UPDATE
5
p.v

38. A GOTO statement cannot branch from an exception handler back into the...
current BEGIN-END block
invoker's
fields
integrated

39. Cursors: The four cursor attributes - in alphabetical order.
error code
%FOUND - %ISOPEN - %NOTFOUND - %ROWCOUNT
Web Toolkit
DECLARE - BEGIN - EXCEPTION - END

40. The best candidates for result-caching are functions that are invoked frequently but depend on __________________ or never.
=>
information that changes infrequently
5
SESSION_USER

41. Fundamental: One of the 4 types of lexical units: d_____
%FOUND - %ISOPEN - %NOTFOUND - %ROWCOUNT
delimiters
EXCEPTION_INIT
scalar

42. Types: Which type of arithmetic does NUMBER use - library or hardware?
library
TRUE - FALSE and NULL
anonymous
SQLCODE

43. Delimiters: The left label delimiter.
-
enclosing
EXIT
<<

44. I/O: One of the 3 types of data stored in the DBMS_OUTPUT buffer.
Double quotes.
implicit
DATE
finishes

45. In a collection - the internal components always have the _____ data type.
same
anonymous block
%
CLOSE

46. Cursors: The keyword that makes a ref cursor type STRONG.
RETURN
function f (n number) return number result_cache relies_on (emps);
/*
upper - coalesce

47. Fundamental: Which one of these is a compound symbol: = - :=
same arguments
%BULK_ROWCOUNT
cursor
:=

48. Declare a package procedure P with no arguments - and give it definer's rights.
type T is ref cursor
procedure P AUTHID definer;
not a number
selection

49. Give the first line of the FOR loop with index i going from 1 to 10 in reverse.
FOR i IN REVERSE 1..10 LOOP
EXECUTE
open cv for
CURSOR - RETURN

50. The default value of the AUTHID property.
FOR i IN REVERSE 1..10 - LOOP - NULL; END LOOP;
DEFINER
slower
obfuscates