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: If there is no handler for an exception - PL/SQL returns an ________ exception error to the invoker or host environment.
type T is ref cursor
fetch C into V
unhandled
collections
2. An anonymous block always has _________ rights.
Warning
: Invalid argument supplied for foreach() in
/var/www/html/basicversity.com/show_quiz.php
on line
183
3. I/O: This package handles HTTP.
is certain
reference
ALTER SESSION
UTL_HTTP
4. INSTEAD OF triggers are alternatives to ___ triggers
transaction
DML
FETCH
constant
5. FOR-Looping over a collection from FIRST to LAST only works if the collection is _______.
<<
statically
dense
'
6. Cursors: You can just declare a cursor at first - then _______ it later.
manageable
associative
define
machine
7. Cursors: SYS_REFCURSOR is a predefined type based on _____ ______.
SYS_REFCURSOR
REF CURSOR
selection
same
8. Triggers: In a per-row trigger - the ____ record shows you the original state of an affected row.
CLOSE_CURSOR
OLD
disable
invoker's
9. The two kinds of CASE statements are simple and ________.
national
searched
30
scalar
10. I/O: SQLPlus command for turning on buffered output.
timing
BOOLEAN
set serveroutput on
%ISOPEN.
11. Exceptions: Some internal exceptions have ________ names.
predefined
SQLCODE
implicit
reference
12. VARRAYs are (always / never) sparse.
create procedure
never
STANDARD
UTL_FILE
13. PLSQL_CCFLAGS hold a comma-separated list of ______ pairs (hyphenated).
EXECUTE IMMEDIATE
strong
composite
name-value
14. Advantage: PL/SQL supports ______-oriented programming.
object
for each row
integrated
create procedure
15. Cursors: A session cursor that is automatically created and managed by PL/SQL.
deletions
implicit cursor
block
array
16. A subprogram defined within another subprogram is a _______ subprogram.
fail
v1 OUT number default 10
PUT
nested
17. Wrapping can be done with the ____ executable.
EXIT
wrap
L.V
compiles
18. An editioning view can only select a subset of the columns from the base table and provide ________ for them
loop
reference
aliases
composite
19. Declare a cursor c with no parameters or return type.
package
manageable
cursor c;
INTO
20. I/O: To make sure the DBMS_OUTPUT buffer will be flushed - put a WHEN ______ clause in the EXCEPTION section of your outer block.
%TYPE
BINARY_INTEGER
select
OTHERS
21. The RESULT_CACHE clause comes (before / after) the RETURN clause.
after
UTL_HTTP
255
optional
22. Web: PL/SQL _____ _______ lets you to develop Web applications made of PL/SQL procedures.
Web Toolkit
select
after insert on emps
..
23. The Wrap utility ________ the source code.
national
5
cannot
obfuscates
24. What is the simplest statement for conditionally getting out of simple loop?
error code
cursor
r tRec := tRec(9 - 'Jones');
EXIT WHEN
25. Characters that end a multi-line comment.
exception
*/
Ada
cursor
26. Characters that begin a multi-line comment.
/*
dense
OPEN_CURSOR
oname
27. The PL/SQL virtual machine turns bytecode into system ______.
SESSION_USER
calls
FETCH - BULK COLLECT INTO
EXCEPTION_INIT
28. Exceptions: Associate exception E with error code -1.
oname
context
PRAGMA EXCEPTION_INIT (E - -1);
literals
29. A __________ can have an AUTHID property
package
%BULK_ROWCOUNT
is
<<
30. Type: An ________ subtype has all the values of its base type.
32 -000
session cursor
unconstrained
SQL
31. Triggers: The code in a trigger is actually an ________ block.
PLS_INTEGER
PL/SQL
loop
anonymous
32. Cursors: Give the statement to fetch data from cursor C into variable V.
does not
bytecode
fetch C into V
non-editioning views
33. With conditional compilation you can avoid compiling debug code in the _______ environment.
OLD
DML
bind
production
34. What are two categories of SQL functions that cannot be used in procedural statements?
aggregate - analytical
calls
fetch cv into myvar
TYPE tN IS TABLE of NUMBER
35. Types: PL/SQL has all the _____ data types.
aggregate - analytical
external subprogram
dynamic
SQL
36. Characters that begin a single-line comment.
-
implicit cursor
error
fields
37. Cursors: A cursor FOR loop can use an explicit or an _______ cursor.
implicit
CURRENT_USER
cursor number
ALTER SESSION
38. Web: The gateway that allows a web browser to invoke a PL/SQL procedure through an HTTP listener.
SUBTYPE numb IS number;
**
PL/SQL Gateway
deletions
39. Triggers: An INSTEAD OF trigger (can/cannot) be conditional.
column
non-editioning views
exception
cannot
40. Official acronym for PL/SQL's runtime engine.
package
FETCH
PVM
IN OUT
41. Exceptions: The three words that can be used to guarantee all exceptions will be handled.
null string
after
WHEN OTHERS THEN
cursor c RETURN rC;
42. Cursors: Define a ref cursor type called T.
sql
type T is ref cursor
elements - type
512
43. I/O: This DBMS_OUTPUT proc retrieves multiple lines from the buffer.
hardware
INTO
GET_LINES
aggregate - analytical
44. Kind of comment not to put in a PL/SQL block to be processed dynamically by an Oracle Precompiler program.
single-line
database
reference
WHERE CURRENT OF
45. Cursors: A cursor FOR loop cannot use a _______ variable.
cursor
not the same
RELIES_ON
STANDARD
46. Associative array types (can / cannot) be defined in the database.
lock
cannot
selection
unhandled
47. In the special IF syntax - is it ELSIF - or ELSEIF?
wrap
Declaration
bytecode
elsif
48. Give the clause you add to a CREATE TABLE statement - when there is a collection column myColl - that you want to be stored in a table called myCollTab.
Abstract
varray
NESTED TABLE myColl STORE AS myCollTab
UTL_SMTP
49. Triggers: The clause to make a trigger run before inserting or updating table EMPS.
exception handler
before insert or update on emps
not a number
$IF
50. A FOR-loop counter is defined only within the _____.
VARRAYs
loop
run
-
Sorry!:) No result found.
Can you answer 50 questions in 15 minutes?
Let me suggest you:
Browse all subjects
Browse all tests
Most popular tests
Major Subjects
Tests & Exams
AP
CLEP
DSST
GRE
SAT
GMAT
Certifications
CISSP go to https://www.isc2.org/
PMP
ITIL
RHCE
MCTS
More...
IT Skills
Android Programming
Data Modeling
Objective C Programming
Basic Python Programming
Adobe Illustrator
More...
Business Skills
Advertising Techniques
Business Accounting Basics
Business Strategy
Human Resource Management
Marketing Basics
More...
Soft Skills
Body Language
People Skills
Public Speaking
Persuasion
Job Hunting And Resumes
More...
Vocabulary
GRE Vocab
SAT Vocab
TOEFL Essential Vocab
Basic English Words For All
Global Words You Should Know
Business English
More...
Languages
AP German Vocab
AP Latin Vocab
SAT Subject Test: French
Italian Survival
Norwegian Survival
More...
Engineering
Audio Engineering
Computer Science Engineering
Aerospace Engineering
Chemical Engineering
Structural Engineering
More...
Health Sciences
Basic Nursing Skills
Health Science Language Fundamentals
Veterinary Technology Medical Language
Cardiology
Clinical Surgery
More...
English
Grammar Fundamentals
Literary And Rhetorical Vocab
Elements Of Style Vocab
Introduction To English Major
Complete Advanced Sentences
Literature
Homonyms
More...
Math
Algebra Formulas
Basic Arithmetic: Measurements
Metric Conversions
Geometric Properties
Important Math Facts
Number Sense Vocab
Business Math
More...
Other Major Subjects
Science
Economics
History
Law
Performing-arts
Cooking
Logic & Reasoning
Trivia
Browse all subjects
Browse all tests
Most popular tests