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. Types: A data type family consists of a ______ type and its subtypes.
bind arguments
anonymous
base
EXIT
2. Cursors: A Cursor FOR loop does not use a ______ statement.
FETCH
Double quotes.
CURRENT OF
placeholders
3. The inquiry directive that gives the current line number in the procedure.
system global area
CURRENT_USER - DEFINER
$$PLSQL_LINE
anonymous block
4. The variable showing the user id that is automatically prepended to object names.
DBMS_PIPE
CASE_NOT_FOUND
inclusive
CURRENT_USER
5. Delimiters: The component indicator/selector.
TIMESTAMP.
unqualified
scalar
.
6. Dbms_sql: The DBMS_SQL procedure that closes a cursor.
fetch C into V
native dynamic
is certain
CLOSE_CURSOR
7. Exceptions: Associate exception E with error code -1.
PRAGMA EXCEPTION_INIT (E - -1);
bind arguments
..
Gateway
8. When an autonomous routine begins execution - the main transaction is ________.
procedure P AUTHID current_user;
1
memory
suspended
9. Types: A ______ has the same valid operations as its base type.
is not
inquiry
external subprogram
subtype
10. Give the first line of the FOR loop with index i going from 1 to 10 in reverse.
cursor c RETURN rC;
FOR i IN REVERSE 1..10 LOOP
for update of
integrated
11. Triggers: You (can/cannot) explicitly invoke a trigger.
..
WHEN
before insert or update on emps
cannot
12. IDs: The type of words that cannot be user-defined identifiers.
EXCEPTION_INIT
Reserved words.
comments
currval and nextval
13. The declaration section is (optional/mandatory).
EXECUTE IMMEDIATE
NESTED TABLE myColl STORE AS myCollTab
optional
FOR - IN
14. Exceptions: An unhandled exception ________ to the enclosing block.
3
USER_PROCEDURES
view
propagates
15. The statement that is used to execute most (native) dynamic SQL.
execute immediate
static
SQLPlus
FETCH
16. A collection is an ordered group of ________ - all of the same ____
-20 -000
elements - type
machine code
explicit
17. Exceptions: The _________ package defines the PL/SQL environment.
RETURN
code
slower
STANDARD
18. Cursors: The two keywords in a mere cursor declaration (one is optional).
CURSOR - RETURN
hardware
query
finishes
19. Loops: What is the index range operator in a FOR loop?
return value
..
SIMPLE_INTEGER
'
20. Exceptions: You cannot GOTO from an exception handler back into the __________ block.
current
follows
same arguments
DATE
21. The PL/SQL ________ evaluates compiler directives.
finishes
preprocessor
FETCH
can
22. Cursors: If you use an EXIT statement to exit a cursor FOR loop prematurely - the cursor (is / is not) closed automatically.
END
aggregate - analytical
is
open C
23. Java - C or other program called directly in PL/SQL.
external subprogram
network
ADT
bind arguments
24. DynSQL: Native Dynamic SQL
NDS
USER_PROCEDURES
PUT_LINE
DML
25. Declare an unconstrained subtype of NUMBER called NUMB.
SUBTYPE numb IS number;
COMMIT - ROLLBACK - SAVEPOINT - SET TRANSACTION
after
IR
26. Exceptions: The built-in procedure for raising an application-defined error.
STANDARD
raise_application_error
slower
same arguments
27. Fundamental: One of the 4 types of lexical units: L_____
cursor variable
include
literals
With a letter.
28. I/O: SQLPlus command for turning on buffered output.
raise_application_error(-20 -100 - 'Bad');
set serveroutput on
finishes
comments
29. I/O: dbms_output.put_line puts output into a _______.
buffer
execute
TYPE tN IS TABLE of NUMBER
CURRENT OF
30. I/O: This package handles HTTP.
can
cursor
iname
UTL_HTTP
31. The two kinds of CASE statements are simple and ________.
source
native dynamic
searched
array
32. Cursors: Opening keyword of a cursor FETCH loop.
3
Gateway
PRAGMA EXCEPTION_INIT (E - -1);
LOOP
33. Command to assign to variables from a cursor.
raise_application_error
single-line
.
FETCH
34. Triggers: In a DML trigger - the phrase that makes the trigger run for every affected record.
255
OPEN_CURSOR
will not
for each row
35. The values defined in PLSQL_CCFLAGS can be referenced as _____ directives.
inquiry
IS
server
CLOSE_CURSOR
36. The first SQL statement in an autonomous routine begins a _______.
WHERE CURRENT OF
transaction
national
DR
37. Define a collection type - tV - which is a varray of 100 NUMBERs.
for update of
TYPE tV IS VARRAY(100) OF NUMBER
COMMIT - ROLLBACK - SAVEPOINT - SET TRANSACTION
return value
38. %ROWTYPE gets the type of a table or _______.
literal
SUBTYPE numb IS number;
cursor
bind
39. An incomplete type only has a ____.
implicit cursor
API
exception handler
name
40. Type: A __________ subtype has only a subset of the values of its base type.
constrained
concatenation
PLSQL_OPTIMIZE_LEVEL
TOO_MANY_ROWS
41. Declare a number variable - A - initialized to 10.
literal
a number := 10
not the same
searched
42. The SET TRANSACTION statement affects only the ____________.
current transaction
cannot
E Exception;
does not
43. Cursors: Give the statement to close cursor C.
end
definer's
INTO
close C
44. Types: PL/SQL has all the _____ data types.
never
order
can
SQL
45. Declare a cursor c with no parameters or return type.
block
%ISOPEN.
DBMS_OUTPUT
cursor c;
46. Characters that begin a multi-line comment.
EVERE - PERFORMANCE - INFORMATIONAL
3
RELIES_ON
/*
47. Exceptions: User-defined exceptions must have _______.
RAISE
names
NDS
will not
48. Cursors: What implicit cursor attribute gives row counts for a FORALL statement?
cursor
constructor
procedure P AUTHID current_user;
%BULK_ROWCOUNT
49. 5 types of events that can have triggers: DML - DDL - INSTEAD OFs - database events - and ________ statements.
specification - body
suspended
PL/SQL Gateway
never
50. Setting CURRENT_SCHEMA only changes what is prepended to __________ references.
explicit cursor
unqualified
associative
IN OUT
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