SUBJECTS
|
BROWSE
|
CAREER CENTER
|
POPULAR
|
JOIN
|
LOGIN
Business Skills
|
Soft Skills
|
Basic Literacy
|
Certifications
About
|
Help
|
Privacy
|
Terms
|
Email
Search
Test your basic knowledge |
Oracle PL - SQL
Start Test
Study First
Subjects
:
oracle
,
it-skills
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. I/O: This package handles HTTP.
DBMS_SQL
deletions
UTL_HTTP
r t.%ROWTYPE;
2. Statement to exit a cursor loop on cursor cGo when there are no more records.
exit when cgo%NOTFOUND
UTL_HTTP
closed
constructor
3. Exceptions: The _________ package defines the PL/SQL environment.
STANDARD
invoker's
unqualified
END IF
4. After the RESULT_CACHE clause - you can put a _________ clause to enable dependency-checking.
END LOOP
EXIT
RELIES_ON
FORALL i IN MyList.FIRST..MyList.LAST
5. Exceptions: An exception raised inside an _______ _______ propagates immediately to the enclosing block
exception handler
PUT_LINE
package
enabled
6. The FORALL statement to loop over a collection MyList using index i.
%ISOPEN.
FORALL i IN MyList.FIRST..MyList.LAST
not a number
HTP
7. Conditional ______ allows backward compability with older database versions.
FETCH - INTO
ex := tbl1 MULTISET EXCEPT tbl2
comments
compilation
8. A pointer to a private SQL area that stores information about processing a specific SELECT or DML statement.
cursor
%FOUND - %ISOPEN - %NOTFOUND - %ROWCOUNT
machine code
9. Cursors: The first two keywords of a basic fetch statement.
FETCH - INTO
currval and nextval
virtual machine
an autonomous routine
10. I/O: Max number of bytes to pass in a call to DBMS_OUTPUT.PUT_LINE.
PUT
literal
definer's
255
11. Declare a package procedure P with no arguments - and give it invoker's rights.
NUMBER
RAISE
procedure P AUTHID current_user;
exception handler
12. Fundamental: What are the 3 compound symbols for 'not equal to'?
optional
RETURN
<> - != - ^=
PUT
13. Cursors: A cursor variable's type must be a ____ ______ type.
REF CURSOR
machine
RETURN
WHERE CURRENT OF
14. In short-circuit evaluation - IF-conditions are only evaluated up to where the outcome ___________.
dynamic
is certain
TIMESTAMP.
decimal
15. Fundamental: Maximum string length of a PL/SQL variable.
index
comments
32 -000
WHEN
16. DynSQL: The three modes of arguments in the USING clause of EXECUTE IMMEDIATE.
Keywords and predefined names.
NESTED TABLE myColl STORE AS myCollTab
IN - OUT - IN OUT
WHEN
17. DynSQL: EXECUTE IMMEDIATE does both dynamic SQL and dynamic _______.
open cv for
names
PL/SQL
'
18. Term for a character literal with zero characters.
FGA
CHAR - VARCHAR2
bind
null string
19. Cursors: The four cursor attributes - in alphabetical order.
implicit cursor
%FOUND - %ISOPEN - %NOTFOUND - %ROWCOUNT
open cv for
Declaration
20. Triggers: A compound trigger can fire at more than one ______ point.
a number := 10
INTO
an autonomous routine
timing
21. Cursors: The Oracle predefined REF CURSOR type.
STANDARD
SYS_REFCURSOR
finishes
EXIT
22. Cursors: A cursor FOR loop cannot use a _______ variable.
cursor
constructor
LOOP
collections
23. In Native Mode - PL/SQL code is compiled into ______ ______.
bb:true
DEFINER
machine code
FOR - IN
24. Cursors: The second keyword of a FETCH statement.
value
mandatory
index
INTO
25. Pkgs: The _______ package gives access to such SQL things as ALTER SESSION.
statement
$IF
manageable
DBMS_SESSION
26. To enable result-caching for a function - use the _____________ clause.
statement
nested
NUMBER
RESULT_CACHE
27. Give the first line of the FOR loop with index i going from 1 to 10 in reverse.
ordinary
PL/SQL Gateway
FOR i IN REVERSE 1..10 LOOP
disable
28. The valid values of the AUTHID property.
an enclosing block
finishes
always
CURRENT_USER - DEFINER
29. Mode designation for an input parameter.
can
IN
statically
Declaration
30. I/O: One of the 3 types of data stored in the DBMS_OUTPUT buffer.
autonomous triggers
%
DATE
cannot
31. Advantage: Performance: PL/SQL automatically creates ______ variables for variables in WHERE and VALUES clauses.
finishes
bind
compiles
autonomous triggers
32. PLSQL_CCFLAGS hold a comma-separated list of ______ pairs (hyphenated).
name-value
implicit
SYS_REFCURSOR
name and datatype
33. Exceptions: Type ______ to re-raise the current exception.
RAISE
procedure - function
memory
external subprogram
34. Loops: What is the index range operator in a FOR loop?
DML
..
PRAGMA EXCEPTION_INIT (E - -1);
finishes
35. This is a CASE (expression / statement): CASE num WHEN 1 THEN goto LABEL1 WHEN 2 THEN var := 2 END CASE;
statement
plb
STANDARD
optional
36. DynSQL: In EXECUTE IMMEDIATE - the statement string can use either placeholders - or string ________.
SQLCODE
concatenation
associative
code
37. Default file extension of wrap's input file.
sql
cursor
user-defined
commit - rollback
38. With an sparse - integer-indexed associative array - you (can / cannot) use a regular FOR loop.
name and datatype
cannot
-
simple and compound symbols
39. Fundamental: A label can be used to name an ______ block.
alter procedure
commit - rollback
4
anonymous
40. _________ exceptions can not be trapped with an error handler
SUBTYPE numb IS number;
DBMS_OUTPUT
is
Declaration
41. Default file extension of wrap's output file.
array
Ada
after
plb
42. Abbreviation of definer's rights
ENABLE
EXTEND
Gateway
DR
43. In the special IF syntax - is it ELSIF - or ELSEIF?
suspended
elsif
system global area
CLOSE_CURSOR
44. Cursors: If an exception is raised inside a cursor loop - the cursor (is / is not) also closed automatically.
cannot
is
/*
SQLPlus
45. Wrapping can be done with the ____ executable.
1
fields
wrap
BINARY_INTEGER
46. What do you FETCH from?
a cursor
external subprogram
SQL
ALTER SESSION
47. Assigning values to PL/SQL variables that appear in SQL statements is called _______.
FORALL i IN MyList.FIRST..MyList.LAST
EVERE - PERFORMANCE - INFORMATIONAL
index
binding
48. Declare a number variable - A - initialized to 10.
a number := 10
DECLARE - BEGIN - EXCEPTION - END
v3 IN OUT NUMBER
single-line
49. PLS_INTEGER has its arithmetic implemented in ________ - so it is very fast.
hardware
slower
transaction
select
50. Triggers: You create a trigger with the _______ ________ statement.
EVERE - PERFORMANCE - INFORMATIONAL
cursor
RAISE
CREATE TRIGGER