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. You (can/cannot) put a label before an END LOOP statement.
SQL
Apache
PUT_LINE
cannot
2. Cursors: The value of SQL%ISOPEN is always ______.
FALSE
timing
Declaration
%BULK_ROWCOUNT
3. PL/SQL does not automatically create bind variables in ________ SQL.
specification - body
dynamic
PRAGMA AUTONOMOUS_TRANSACTION;
define
4. Cursors: If an exception is raised inside a cursor loop - the cursor (is / is not) also closed automatically.
for each row
is
cursor variable
FORALL and BULK COLLECT
5. What is the simplest statement for getting out of simple loop?
.
EXIT
..
UTL_FILE
6. Triggers: An INSTEAD OF trigger is (always/never) a row-level trigger.
PLS_INTEGER
USER_PROCEDURES
can
always
7. $$PLSQL_LINE and $$PLSQL_UNIT are ______-ly defined inquiry directives.
open cv for
..
invoker's
implicit
8. IDs: You can use a reserved word as a _______ user-defined identifier.
include
quoted
autonomous triggers
DML
9. Which collection type is bounded?
1
anonymous block
varray
virtual machine
10. Triggers: The code in a trigger is actually an ________ block.
anonymous
not the same
Ada
-20 -000
11. The BEGIN section is (optional/mandatory)
mandatory
timing
integer
block
12. Cursors: Give the statement for getting out of a FETCH loop for cursor CV.
dynamic
fetch C into V
r t.%ROWTYPE;
EXIT WHEN cv%NOTFOUND
13. Triggers: On a non-editioning view - you can only define __________ triggers.
INSTEAD OF
cursor c;
CREATE TRIGGER
cannot
14. Abbreviation of definer's rights
selection
invalid
EXCEPTION_INIT
DR
15. Native compilation turns bytecode into ________ code.
machine
can
package
E Exception;
16. Cursors: You cannot use cursor attributes in _______ statements.
SQL
inquiry
DBMS_DDL
will not
17. The 2 characters that begin all inquiry directives.
exception
GET_LINES
name
$$
18. You cannot bulk collect into an ARRAY OF RECORDS. You can into a ________________ (3 words).
DBMS_SQL
FOR - IN
RECORD OF ARRAYS
bytecode
19. The RESULT_CACHE clause comes (before / after) the RETURN clause.
after
EXIT WHEN
TOO_MANY_ROWS
define
20. A PL/SQL extension to the WHERE clause of the SQL statements UPDATE and DELETE
cursor c;
virtual machine
WHERE CURRENT OF
%
21. Delimiters: The component indicator/selector.
CURRENT_USER - DEFINER
END CASE
CHAR - VARCHAR2
.
22. GOTO branches to a ________.
label
transaction
$IF
RECORDS
23. Delimiters: Host variable indicator.
...
cursor
hardware
elsif
24. IDs: You cannot use reserved words as ______ user-defined identifiers.
fail
ordinary
CLOSE
PL/SQL Gateway
25. _________ exceptions can not be trapped with an error handler
dynamic
Declaration
SESSION_USER
searched
26. Exceptions: A GOTO statement cannot branch into an _______ ________.
exception handler
PLS_INTEGER
do not
GET_LINE
27. Cursors: If you use an EXIT statement to exit a cursor FOR loop prematurely - the cursor (is / is not) closed automatically.
REF CURSOR
is
HTP
CHARARR
28. I/O: The DBMS_OUTPUT function that writes output without a newline character.
PUT
WHERE CURRENT OF
FETCH - INTO
index
29. In a collection - the internal components are called _______.
oname
Apache
elements
can
30. Fundamental: Character used to escape a single quote inside a literal.
Warning
: Invalid argument supplied for foreach() in
/var/www/html/basicversity.com/show_quiz.php
on line
183
31. Cursors: A session cursor that is automatically created and managed by PL/SQL.
PUT_LINE
inquiry
implicit cursor
cannot
32. Triggers: If two or more triggers are defined with the same timing point - then you can control the firing order using the ________ clause.
USING
follows
current BEGIN-END block
upper - coalesce
33. I/O: The DBMS_OUTPUT function that writes output WITH a newline character.
cursor c RETURN rC;
obfuscates
PUT_LINE
%BULK_ROWCOUNT
34. Triggers: In a per-row trigger - the ____ record shows you the changed state of an affected row.
DBMS_OUTPUT
NEW
FETCH - INTO
base
35. Conversion: Implicit conversion can be (faster / slower) than explicit conversion.
explicit
WHEN OTHERS THEN
EVERE - PERFORMANCE - INFORMATIONAL
slower
36. Delimiters: Item separator.
NUMBER
FETCH
cannot
37. I/O: The PL/SQL I/O packages (can/cannot) accept input directly from the keyboard.
WHERE CURRENT OF
versions
cursor
cannot
38. NAN stands for _________.
not a number
;
IN - OUT - IN OUT
plb
39. An anonymous block is a(n) ____ statement.
SQL
sequence pseudo-columns
explicit
optional
40. Bulk: The two features that comprise Bulk SQL are:
SQL
executable
propagates
FORALL and BULK COLLECT
41. DynSQL: The colon-prefixed names used in EXECUTE IMMEDIATE are called ________.
an AUTHID property
after insert on emps
bind
placeholders
42. Exceptions: Type ______ to re-raise the current exception.
E Exception;
END
RAISE
-
43. Exceptions: The keyword that begins an exception handler.
same
v2 IN NUMBER default 20
Abstract
WHEN
44. (from inside a package) Declare a function f - that takes a number n - returns a number - and caches results - depending on table EMPS.
Ordinary - Quoted.
do not
integer
function f (n number) return number result_cache relies_on (emps);
45. Pkgs: RESET_PACKAGE only takes effect after the outermost PL/SQL proc that called it ________.
finishes
TRUE - FALSE - NULL
DBMS_OUTPUT
definition
46. Web: Abbreviation of PL/SQL Server Page.
PSP
label
cannot
unqualified
47. Cursors: What are the 3 possible values of SQL%FOUND and SQL%NOTFOUND?
UTL_HTTP
collections - records
VARCHAR2
TRUE - FALSE - NULL
48. The three types of compiler warnings.
cursor c;
an AUTHID property
v1 OUT number default 10
EVERE - PERFORMANCE - INFORMATIONAL
49. Advantage: Having procedures stored and executed on the server makes PL/SQL ________.
specification - body
scalable
executable
SQLCODE
50. How many PL/SQL collection types are there?
commit - rollback
3
autonomous transaction
REF CURSOR