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. Cursors: A cursor FOR loop can use an explicit or an _______ cursor.
anonymous block
END
implicit
simple
2. Delimiters: Single-line comment marker.
lock
CHAR - VARCHAR2
*/
-
3. Cursors: Give the statement to open cursor C.
after insert on emps
quoted
open C
v1 OUT number default 10
4. IDs: The 3 non-alphanumeric characters that can be in an ordinary user-defined identifier.
buffer
# - $ - _
1
REF CURSOR
5. To exit an active autonomous transaction without causing an exception - you must issue _____ or ______.
commit - rollback
do not
EXTEND
library
6. Fundamental: One of the 4 types of lexical units: c_____.
fail
comments
aggregate - analytical
%FOUND - %ISOPEN - %NOTFOUND - %ROWCOUNT
7. A CASE statement ends with ____ ____.
END CASE
can
PL/SQL
FETCH
8. 5 types of events that can have triggers: DML - DDL - INSTEAD OFs - database events - and ________ statements.
raise_application_error(-20 -100 - 'Bad');
error code
USER_PROCEDURES
suspended
9. With an sparse - integer-indexed associative array - you (can / cannot) use a regular FOR loop.
block
IF - CASE or LOOP
cannot
DBMS_SQL
10. Types: The storage size of a NUMBER value is based on the number of ______ digits.
for update of
significant
cannot
error code
11. Mode designation for an input/output parameter.
multi-row
compile
FGA
IN OUT
12. Fundamental: Labels furnish targets for GOTO and _____ statements.
anonymous
raise_application_error(-20 -100 - 'Bad');
EXIT
always
13. Types: ______ data types are those storing values with no internal components.
FORALL i IN MyList.FIRST..MyList.LAST
scalar
FOR UPDATE
compile
14. Types: ________ data types have no internal components.
scalar
3
an enclosing block
native dynamic
15. Cursors: The value of SQL%ISOPEN is always ______.
FALSE
fields
exception handler
cached
16. IDs: The two types of words that can - but should not - be used as user-defined identifiers.
%BULK_ROWCOUNT
anonymous block
Keywords and predefined names.
execute
17. A basic PL/SQL datatype that SQL does not have.
boolean
v2 IN NUMBER default 20
injection
lowest
18. Cursors: SYS_REFCURSOR is a predefined type based on _____ ______.
$END
REF CURSOR
elsif
inquiry
19. Cursors: The two keywords in a mere cursor declaration (one is optional).
multi-row
ex := tbl1 MULTISET EXCEPT tbl2
CURSOR - RETURN
1
20. Types: Which type of arithmetic does NUMBER use - library or hardware?
TYPE tV IS VARRAY(100) OF NUMBER
-
REF CURSOR
library
21. Which two collection types are unbounded?
DATE
CURSOR - RETURN
nested tables - associative arrays
32 -000
22. An anonymous block is a(n) ____ statement.
array
SQL
CURRENT OF
delimiters
23. Bytecode is _______ _______ code.
virtual machine
define
DBMS_OUTPUT
implicit cursor
24. User-defined compiler directives are defined in this system compile parameter.
PLSQL_CCFLAGS
decimal
CHAR - VARCHAR2
<> - != - ^=
25. Cursors: Give the statement to fetch data from cursor C into variable V.
PRAGMA EXCEPTION_INIT (E - -1);
%FOUND - %ISOPEN - %NOTFOUND - %ROWCOUNT
portable
fetch C into V
26. The _____ utility turns PL/SQL source code into unreadable text.
error code
Wrap
package
cursor variable
27. Bulk: The use of FORALL statements cuts down on ______ traffic.
network
create
1
scalar
28. Triggers: If two or more triggers are defined with the same timing point - then you can control the firing order using the ________ clause.
v2 IN NUMBER default 20
follows
finishes
'
29. Make a FOR loop that executes NULL 10 times counting in reverse - using index i.
FOR i IN REVERSE 1..10 - LOOP - NULL; END LOOP;
CURRENT_USER - DEFINER
collections
deletions
30. From a block nested inside a procedure P - reference variable V of the outer procedure.
return value
p.v
DML
after
31. Dbms_sql: The integer returned by OPEN_CURSOR is a _____ _____.
GET_LINES
currval and nextval
savepoint ab
cursor number
32. Cursors: An explicit cursor (can/cannot) accept parameters.
can
dense
names
DATE
33. A subprogram defined within another subprogram is a _______ subprogram.
SQLERRM
EVERE - PERFORMANCE - INFORMATIONAL
nested
virtual machine
34. The three possible values of a BOOLEAN literal.
:=
True - false or NULL.
hardware
32 -000
35. Define a collection type - tV - which is a varray of 100 NUMBERs.
query
TYPE tV IS VARRAY(100) OF NUMBER
LOOP - END LOOP
cannot
36. Subprograms are stored in __________ form.
view
Web Toolkit
Reserved words.
executable
37. Cursors: A cursor with a name is an _________ cursor.
EVERE - PERFORMANCE - INFORMATIONAL
explicit
invoker's
# - $ - _
38. Triggers: You create a trigger with the _______ ________ statement.
inquiry
CREATE TRIGGER
hardware
1
39. I/O: If the current (outermost) PL/SQL block ends with an unhandled exception - the output buffer will not be ___________.
COMMIT - ROLLBACK - SAVEPOINT - SET TRANSACTION
flushed
DBMS_DDL
EVERE - PERFORMANCE - INFORMATIONAL
40. Abbreviation for Abstract Data Type.
Ada
deletions
CREATE TYPE
ADT
41. Advantage: PL/SQL runs anywhere Oracle runs - so it is very ________.
dynamic
portable
after insert on emps
RECORDS
42. IDs: How an ordinary user-defined identifier must begin.
dynamic
CURRENT_USER
hardware
With a letter.
43. Conversion: If the specific value is suitable - ____ or _______ values can convert to almost any datatype
CHAR - VARCHAR2
With a letter.
package
L.V
44. The DECLARE keyword is only required in an _______ _______.
anonymous block
suspended
END LOOP
=
45. Exceptions: Write the call (2 args) to associate message 'Bad' with error code -20 -100.
Warning
: Invalid argument supplied for foreach() in
/var/www/html/basicversity.com/show_quiz.php
on line
183
46. Command used to execute dynamic SQL.
EXECUTE IMMEDIATE
%ROWTYPE
DBMS_SESSION
Gateway
47. The PL/SQL preprocessor passes ______ code to the compiler.
current transaction
%
block
source
48. Types: A data type family consists of a ______ type and its subtypes.
$$
base
nested tables - associative arrays
/*
49. I/O: The output from DBMS_OUTPUT will display (during/after) program execution.
after
close C
enabled
an autonomous routine
50. For a collection - the NEXT method returns ____ when there is no next index value.
Wrap
$END
CHAR - VARCHAR2
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