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. To recompile a procedure - use the _____ ______ command.
UTL_FILE
PLS_INTEGER
PLSQL_CCFLAGS
alter procedure
2. PLS_INTEGER has its arithmetic implemented in ________ - so it is very fast.
explicit
constant
hardware
oname
3. Value of a character literal with zero characters.
increment
exception handler
INSTEAD OF
4. This is a CASE (expression / statement): CASE num WHEN 1 THEN goto LABEL1 WHEN 2 THEN var := 2 END CASE;
associative arrays
statement
once
WHEN
5. Types: In addition to the SQL data types - PL/SQL has ___ more scalar data types.
WHEN
4
include
SIMPLE_INTEGER
6. Advantage: Performance: PL/SQL automatically creates ______ variables for variables in WHERE and VALUES clauses.
PL/SQL
unqualified
bind
definer's
7. Cursors: Give the statement to open cursor C.
associative
open C
30
SQL
8. Exceptions: An exception in the declarations section propagates to the enclosing _______.
placeholders
block
sequence pseudo-columns
ALTER SESSION
9. Exceptions: The three words that can be used to guarantee all exceptions will be handled.
1 million
an autonomous routine
WHEN OTHERS THEN
%FOUND - %ISOPEN - %NOTFOUND - %ROWCOUNT
10. Web: The gateway that allows a web browser to invoke a PL/SQL procedure through an HTTP listener.
OPEN
FETCH - INTO
Declaration
PL/SQL Gateway
11. Cursors: A cursor variable's type must be a ____ ______ type.
name-value
not a number
REF CURSOR
literals
12. A GOTO cannot branch into an...
fetch cv into myvar
PLSQL_CCFLAGS
IF - CASE or LOOP
WHERE CURRENT OF
13. The variable showing the user id that is automatically prepended to object names.
CURRENT_USER
PUT
FOR - IN
unconstrained
14. In a record - the internal components are called ______.
can
information that changes infrequently
implicit
fields
15. Abbreviation of invoker's rights
IR
DBMS_PREPROCESSOR
machine
before insert or update on emps
16. Exceptions: Associate exception E with error code -1.
$END
PRAGMA EXCEPTION_INIT (E - -1);
EXECUTE IMMEDIATE
invoker's
17. I/O: SQLPlus command for turning on buffered output.
library
set serveroutput on
compilation
API
18. The BEGIN section is (optional/mandatory)
Wrap
PRAGMA EXCEPTION_INIT (E - -1);
mandatory
CURSOR - RETURN
19. Two types of stored subprograms.
DML
RAISE
procedure - function
4
20. I/O: This package has hypertext functions that generate HTML tags
3
HTF
EXTEND
nested
21. Statement to set current schema to x: _____ _____ SET CURRENT_SCHEMA = 'x';
selection
function f (n number) return number result_cache relies_on (emps);
ALTER SESSION
anonymous block
22. Advantage: PL/SQL is tightly _______ with Oracle SQL.
finishes
is not
associative
integrated
23. To exit an active autonomous transaction without causing an exception - you must issue _____ or ______.
USING
commit - rollback
cursor variable
PL/SQL Gateway
24. _________ exceptions can not be trapped with an error handler
flushed
compile
Declaration
PLS_INTEGER
25. IDs: You can use a reserved word as a _______ user-defined identifier.
include
code
quoted
source code
26. Package for getting the postprocessed source of a program.
PUT
scalable
DBMS_PREPROCESSOR
1 million
27. Bulk: The use of FORALL statements cuts down on ______ traffic.
32 -000
comments
open cv for
network
28. To get the current value of CURRENT_SCHEMA - CURRENT_USER - or SESSION_USER - use the ____ function.
CASE_NOT_FOUND
SYS_CONTEXT
3
;
29. With dynamic typing - type checking is done at ______time.
run
RAISE
integer
always
30. If an initialized collection has no elements - FIRST and LAST return _____.
user-defined
CHARARR
type T is ref cursor
31. After the RESULT_CACHE clause - you can put a _________ clause to enable dependency-checking.
FALSE
$$
TYPE tV IS VARRAY(100) OF NUMBER
RELIES_ON
32. Delimiters: The remote access symbol.
definer's
@
SESSION_USER
DATE
33. IDs: What a quoted user-defined identifier is enclosed in.
for update of
Double quotes.
strong
procedure P AUTHID definer;
34. When a session starts - CURRENT_SCHEMA has the value of the schema owned by ___________.
DML
SESSION_USER
virtual machine
COMMIT - ROLLBACK - SAVEPOINT - SET TRANSACTION
35. The NOCOPY option on an OUT or IN OUT parameter - causes it to be passed by ______.
3
execute immediate
reference
DBMS_PREPROCESSOR
36. DBMS_DDL.WRAP returns a string containing wrapped _____ _____.
'
IN OUT
p.v
source code
37. Value of PLSQL_OPTIMIZE_LEVEL that prevents optimization.
after
-
1
REUSE SETTINGS
38. Declare an output NUMBER parameter - v1 - that defaults to 10.
does not
in the database
Oracle
v1 OUT number default 10
39. Triggers: The clause to make a trigger run before inserting or updating table EMPS.
TYPE tA IS TABLE OF NUMBER INDEX BY VARCHAR2(20)
TRUE - FALSE and NULL
object
before insert or update on emps
40. Subprograms are stored in __________ form.
NEW
p.v
executable
optional
41. The three possible values of a BOOLEAN literal.
currval and nextval
True - false or NULL.
EXIT WHEN
simple
42. I/O: The DBMS_OUTPUT function that writes output WITH a newline character.
p.v
identifiers
obfuscates
PUT_LINE
43. Cursors: What is the 'name' of the implicit cursor?
Declaration
reference
255
SQL
44. In short-circuit evaluation - IF-conditions are only evaluated up to where the outcome ___________.
SESSION_USER
is certain
REF_CURSOR
slower
45. Characters that end a multi-line comment.
*/
currval and nextval
VARRAYs
source code
46. A type of compiler directive - begins with 's'.
strong
does not
selection
pls_integer
47. You cannot bulk collect into an ARRAY OF RECORDS. You can into a ________________ (3 words).
slower
RECORD OF ARRAYS
composite
USER_PLSQL_OBJECT_SETTINGS
48. When a parameter is passed by reference - changes made to it inside the procedure cannot be undone. True/False.
slower
True
%ISOPEN.
must
49. Cursors: You give an explicit cursor a name and associate it with a _______.
query
bind
TIMESTAMP.
for update of
50. A type of compiler directive - begins with 'i'.
inquiry
SQLERRM
CURRENT_USER
static boolean
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