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. Exceptions: An exception in the declarations section does not go to the __________ section.
return value
exception
UTL_FILE
EDITION_NAME
2. When a parameter is passed by reference - changes made to it inside the procedure cannot be undone. True/False.
CURRENT_USER - DEFINER
implicit
True
'ENABLE:SEVERE' - 'ERROR:06002'
3. You can put a label before any executable PL/SQL _________.
statement
name-value
SYS_REFCURSOR
EDITION_NAME
4. A type of compiler directive - begins with 's'.
versions
v2 IN NUMBER default 20
can
selection
5. What are the starting and ending keywords of a simple loop?
LOOP - END LOOP
Wrap
32 -000
simple
6. Conversion: It is best to use (implicit / explicit) conversion.
same
inquiry
explicit
NUMBER
7. Delimiters: Single-line comment marker.
ROLLBACK
-
memory
cannot
8. Dbms_sql: A cursor opened with OPEN_CURSOR (can/cannot) be reused for multiple queries without first closing it.
can
mandatory
name and datatype
RETURN
9. To enable result-caching for a function - use the _____________ clause.
statement
WHEN
can
RESULT_CACHE
10. Kind of code created by the PL/SQL compiler.
associative
$IF $THEN $ELSE $END
external subprogram
bytecode
11. The PL/SQL preprocessor passes ______ code to the compiler.
colon
aliases
explicit
source
12. Mode designation for an input/output parameter.
collections
FOR - IN
IN OUT
$$
13. What clause makes a compilation default to the PLSQL_CCFLAGS settings from the last compilation?
REUSE SETTINGS
associative arrays
executable
an enclosing block
14. Two types of stored subprograms.
Declaration
procedure - function
multi-row
database
15. The EXCEPTION section is (optional/mandatory).
for each row
optional
CASE_NOT_FOUND
do not
16. A CASE expression ends with _____.
Abstract
END
null string
integer
17. Cursors: The SQL%BULK_ROWCOUNT attribute is an _________ -
array
names
cursor number
$END
18. The lowest index of a VARRAY is ___.
1
NESTED TABLE myColl STORE AS myCollTab
:=
array
19. Bulk: The use of FORALL statements cuts down on ______ traffic.
increment
colon
network
information that changes infrequently
20. _________ exceptions can not be trapped with an error handler
Declaration
composite
API
TOO_MANY_ROWS
21. Assigning values to PL/SQL variables that appear in SQL statements is called _______.
collections
server
binding
not a number
22. Types: One of the 4 PL/SQL things that have a data type (begins with 'v').
memory
DR
is
variable
23. FOR-Looping over a collection from FIRST to LAST only works if the collection is _______.
CLOSE_CURSOR
FALSE
cannot
dense
24. Characters that end a multi-line comment.
CLOSE_CURSOR
quoted
FOR i IN REVERSE 1..10 LOOP
*/
25. Mode designation for an input parameter.
searched
IN
RESULT_CACHE
disable
26. Exceptions: User-defined exceptions must have _______.
HTF
names
RESULT_CACHE
SQL cursor
27. Types of blocks: A pl/sql block that is not stored in the database.
DATE '2005-12-25'
literal
RAISE
anonymous
28. A PL/SQL block that is not stored.
RECORD OF ARRAYS
decimal
unqualified
anonymous block
29. Cursors: Which cursor attribute is not meaningful for an implicit cursor?
%ISOPEN.
32 -000
suspended
3
30. What is the simplest statement for conditionally getting out of simple loop?
portable
lowest
EXIT WHEN
wrap
31. Advantage: PL/SQL runs anywhere Oracle runs - so it is very ________.
portable
WHERE CURRENT OF
FOR - IN
inclusive
32. PLSQL_CCFLAGS hold a comma-separated list of ______ pairs (hyphenated).
name-value
scalar
DATE '2005-12-25'
cannot
33. How many times are a FOR loop's index bounds evaluated?
once
EXECUTE IMMEDIATE
Declaration
STANDARD
34. Triggers: When using the NEW or OLD pseudo-records in the body of the trigger - they must be prefixed with a _______.
E Exception;
end
colon
raise_application_error(-20 -100 - 'Bad');
35. What do you FETCH from?
%BULK_ROWCOUNT
a cursor
transaction
%TYPE
36. A GOTO statement cannot branch from an exception handler back into the...
set serveroutput on
same
transaction
current BEGIN-END block
37. The first SQL statement in an autonomous routine begins a _______.
transaction
production
REF CURSOR
RESULT_CACHE
38. Cursors: A cursor variable's type must be a ____ ______ type.
select
cursor
loop
REF CURSOR
39. A SELECT statement with the FOR UPDATE clause puts a ______ on the selected rows.
$IF
lock
USER_PROCEDURES
END CASE
40. Clause added to a cursor to use it with WHERE CURRENT OF.
for update of
VARRAY - Nested table
DEFINER
HTP
41. Abbreviation of definer's rights
can
DR
FETCH
DML
42. A national character literal is composed of characters in the ________ character set.
cannot
national
%ISOPEN.
fetch C into V
43. Web: mod_plsql is an _______ module.
does not
block
Apache
statement
44. An INSTEAD OF trigger is used - e.g - when you want to insert into a complex _____.
select
a number := 10
view
USING
45. Where an external subprogram is stored.
in the database
WHERE CURRENT OF
can
Keywords and predefined names.
46. I/O: One of the 3 types of data that can be passed to the DBMS_OUTPUT buffer.
code
VARCHAR2
definer's
always
47. If a procedure fails - an OUT parameter passed to it by value (will / will not) be passed back with changes.
will not
REUSE SETTINGS
do not
type T is ref cursor
48. DBMS_DDL.CREATE_WRAPPED: wraps and _______ the source code passed to it.
INTO
compiles
4
a cursor
49. Advantage: Caching of programs and sharing among users lowers _______ requirements.
memory
anonymous block
EDITION_NAME
fine-grained auditing
50. The PL/SQL virtual machine turns bytecode into system ______.
external subprogram
calls
open C
compilation