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. Conversion: It is best to use (implicit / explicit) conversion.
error
$IF
explicit
can
2. The best candidates for result-caching are functions that are invoked frequently but depend on __________________ or never.
buffer
information that changes infrequently
UTL_SMTP
optional
3. Assignment of PLSQL_CCFLAGS (cannot / can) be included in ALTER PROCEDURE ... COMPILE ...
cannot
can
Double quotes.
LOOP
4. I/O: This package sends text output to SQLPlus
DBMS_OUTPUT
national
not the same
is
5. An anonymous block is a(n) ____ statement.
delimiters
SQL
significant
finishes
6. Triggers: An INSTEAD OF trigger (can/cannot) be conditional.
commit - rollback
DATE '2005-12-25'
cannot
r t.%ROWTYPE;
7. The FOR UPDATE OF clause references a (table / column).
loop
user-defined
column
%BULK_ROWCOUNT
8. Types: ________ data types have no internal components.
dense
<> - != - ^=
scalar
definer's
9. Nested tables are multisets - meaning that there is no inherent _____ of their elements.
create
order
..
COUNT
10. Advantage: PL/SQL is tightly _______ with Oracle SQL.
VARRAY - Nested table
v1 OUT number default 10
upper - coalesce
integrated
11. Cursors: SYS_REFCURSOR is a predefined type based on _____ ______.
REF CURSOR
literal
is not
EXECUTE
12. Web: mod_plsql is an _______ module.
EXIT WHEN
Apache
2
drop procedure
13. FOR-Looping over a collection from FIRST to LAST only works if the collection is _______.
dense
optional
r t.%ROWTYPE;
BINARY_INTEGER
14. In a cursor loop - the clause added to an INSERT or UPDATE to point at the current record.
WHERE CURRENT OF
RELIES_ON
close C
EXIT WHEN
15. Abbreviation of invoker's rights
$IF
=
IR
implicit
16. Cursors: The values plugged into the DML in a FORALL must come from existing - populated _________.
collections
cannot
exception
sql
17. After the RESULT_CACHE clause - you can put a _________ clause to enable dependency-checking.
RELIES_ON
finishes
RETURN
FOR i IN REVERSE 1..10 LOOP
18. An anonymous block always has _________ rights.
Warning
: Invalid argument supplied for foreach() in
/var/www/html/basicversity.com/show_quiz.php
on line
183
19. I/O: The DBMS_OUTPUT procedure that sets the size of the output buffer.
DBMS_SESSION.RESET_PACKAGE
ENABLE
Wrap
an enclosing block
20. Cursors: The SQL%FOUND attribute has how many possible values?
3
user-defined
Declaration
RELIES_ON
21. DynSQL: In EXECUTE IMMEDIATE - the statement string can use either placeholders - or string ________.
30
lowest
concatenation
strong
22. Assigning values to PL/SQL variables that appear in SQL statements is called _______.
binding
statement
IR
RETURN
23. Delimiters: The component indicator/selector.
commit - rollback
an autonomous routine
SYS_CONTEXT
.
24. The source for wrapping begins with the word ______.
library
statically
create
stored
25. Cursors: A session cursor that a PL/SQL user creates and manages.
procedure P AUTHID current_user;
explicit cursor
SUBTYPE numb IS number;
run
26. A FOR loop can be indexed by numbers or by a ______.
FORALL i IN MyList.FIRST..MyList.LAST
static boolean
cannot
cursor
27. A type of compiler directive - begins with 's'.
:=
cannot
optional
selection
28. The _______ package lets you wrap dynamically generated PL/SQL.
DBMS_DDL
INTO
associative
after insert on emps
29. Declare a number variable - A - initialized to 10.
PLS_INTEGER
a number := 10
Gateway
GET_LINE
30. Native compilation turns bytecode into ________ code.
HTP
DBMS_OUTPUT
machine
SESSION_USER
31. To enable result-caching for a function - use the _____________ clause.
RESULT_CACHE
network
can
an autonomous routine
32. In a FORALL loop - you (can / cannot) use the index variable for purposes other than indexing into the collection.
cannot
IN
TYPE tA IS TABLE OF NUMBER INDEX BY VARCHAR2(20)
boolean
33. In short-circuit evaluation - IF-conditions are only evaluated up to where the outcome ___________.
is certain
names
IN
PL/SQL Gateway
34. Mode designation for an input parameter.
IN
INTO
cursor c;
is
35. The BEGIN section is (optional/mandatory)
mandatory
OTHERS
anonymous block
ROLLBACK
36. I/O: One of the 3 types of data stored in the DBMS_OUTPUT buffer.
NUMBER
%ISOPEN.
SUBTYPE numb IS number;
currval and nextval
37. Advantage: PL/SQL is PORTABLE to any OS where ________ runs.
associative
Web Toolkit
Oracle
elements - type
38. Advantage: Performance: PL/SQL automatically creates ______ variables for variables in WHERE and VALUES clauses.
anonymous
WHERE CURRENT OF
$IF
bind
39. The LIMIT method is only meaningful for _______.
do not
VARRAYs
procedure P AUTHID current_user;
disable
40. The three types of compiler warnings.
oname
user-defined
EVERE - PERFORMANCE - INFORMATIONAL
DR
41. The names of Java objects in Oracle can be up to __ characters in length.
4K
FORALL i IN MyList.FIRST..MyList.LAST
vname CONSTANT VARCHAR2 := 'x';
cannot
42. IDs: What a quoted user-defined identifier is enclosed in.
exception handler
TRUE - FALSE and NULL
BINARY_INTEGER
Double quotes.
43. In the IF syntax - is if ENDIF or END IF?
network
cursor c RETURN rC;
END IF
$$
44. Exceptions: Some internal exceptions have ________ names.
:=
predefined
1
RELIES_ON
45. If a result-cached function's data source (based on the RELIES_ON clause) is updated - any cached results become _______.
invalid
definition
virtual machine
drop procedure
46. Exceptions: You can pass an ______ ________ to SQLERRM.
column
selection
SQL
error code
47. Types: One of the 4 PL/SQL things that have a data type (begins with 'p').
parameter
PRAGMA EXCEPTION_INIT (E - -1);
expression
before insert or update on emps
48. I/O: This package does email.
COMMIT - ROLLBACK - SAVEPOINT - SET TRANSACTION
UTL_SMTP
execute immediate
PRAGMA AUTONOMOUS_TRANSACTION;
49. CREATE TYPE cannot be used for _______ array types.
sequence pseudo-columns
associative
executable
COMMIT - ROLLBACK - SAVEPOINT - SET TRANSACTION
50. A result-cached function caches its results in the _____ _____ ____ (SGA)
API
OTHERS
after
system global area