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. DynSQL: The standard package that does dynamic SQL.
cannot
database
DBMS_SQL
NESTED TABLE myColl STORE AS myCollTab
2. A CASE statement ends with ____ ____.
DML
Web Toolkit
END CASE
$IF $THEN $ELSE $END
3. With a result-cached function - it uses a cached value when the function is called again with the...
cannot
index
for each row
same arguments
4. The collection method that tells the number of elements in the collection.
COUNT
E Exception;
OPEN
quoted
5. Exceptions: A GOTO statement cannot branch into an _______ ________.
sequence pseudo-columns
NESTED TABLE myColl STORE AS myCollTab
exception handler
value
6. The allowed data types of user-defined conditional compilation directives are boolean and _______.
compilation
pls_integer
anonymous block
simple and compound symbols
7. If none of a CASE expression's conditions are TRUE - it returns _____.
CURSOR - RETURN - IS
PLS_INTEGER
LOOP - END LOOP
8. Types: One of the 4 PL/SQL things that have a data type (begins with 'v').
specification - body
non-editioning views
Double quotes.
variable
9. IDs: What a quoted user-defined identifier is enclosed in.
deletions
open cv for
Double quotes.
identifiers
10. Cursors: An implicit cursor is also called a/n ________ ________ -
SQL
constrained
SQL cursor
fetch C into V
11. (from inside a package) Declare a function f - that takes a number n - returns a number - and caches results - depending on table EMPS.
expression
function f (n number) return number result_cache relies_on (emps);
anonymous block
statement
12. DynSQL: EXECUTE IMMEDIATE does both dynamic SQL and dynamic _______.
Apache
elements
PL/SQL
32 -000
13. Triggers: To simulate having triggers on SELECT statements - you can try ___ (3-letter acronym).
Web Toolkit
FGA
**
integer
14. Triggers: Unlike a stored procedure - you can enable and _____ a trigger.
disable
non-editioning views
PLSQL_OPTIMIZE_LEVEL
production
15. A FOR loop can be indexed by numbers or by a ______.
cursor
NDS
1
concatenation
16. Cursors: The FOR UPDATE phrase goes at the (beginning/end) of the cursor definition.
cached
RECORD OF ARRAYS
cannot
end
17. Statement to exit a cursor loop on cursor cGo when there are no more records.
exit when cgo%NOTFOUND
production
DATE '2005-12-25'
1
18. Exceptions: Some internal exceptions have ________ names.
production
cursor variable
predefined
fetch C into V
19. A GOTO cannot branch into a...
**
5
lower sub-block
statically
20. The PL/SQL preprocessor passes ______ code to the compiler.
Gateway
source
machine code
FETCH - BULK COLLECT INTO
21. VARRAYs are (always / never) sparse.
increment
never
can
FGA
22. Default value of PLSQL_OPTIMIZE_LEVEL.
ex := tbl1 MULTISET EXCEPT tbl2
1
2
.
23. Cursors: The SQL%FOUND attribute has how many possible values?
create
1
explicit
3
24. A type of compiler directive - begins with 'i'.
procedure P AUTHID definer;
composite
inquiry
query
25. Advantage: PL/SQL is PORTABLE to any OS where ________ runs.
255
information that changes infrequently
Oracle
column
26. Types: A data type family consists of a ______ type and its subtypes.
TYPE rec IS RECORD (num NUMBER - name VARCHAR2(10));
base
cursor
DBMS_SESSION.RESET_PACKAGE
27. In a sparse collection - the indexes of defined elements (do / do not) run in consecutive order.
do not
information that changes infrequently
server
IR
28. With dynamic typing - type checking is done at ______time.
SQL
run
2
predefined
29. Collections are one of the two kinds of PL/SQL _______ data types.
nested
block
composite
object
30. Give the first line of the FOR loop with index i going from 1 to 10 in reverse.
4
expression
explicit
FOR i IN REVERSE 1..10 LOOP
31. Cursors: How many implicit cursors can you access?
1
<<
always
server
32. Fundamental: Which one of these is a simple symbol: a - = - !=
cannot
information that changes infrequently
=
# - $ - _
33. A subprogram created inside a block is a _________ subprogram.
machine
RAISE
can
nested
34. Exceptions: The ________ function returns the error message associated with an error code.
explicit
SQLERRM
CHAR - VARCHAR2
aggregate - analytical
35. I/O: The DBMS_OUTPUT buffer will not be flushed until it is full or until the current PL/SQL block _________.
DBMS_OUTPUT
null string
finishes
cursor c;
36. This is a CASE (expression / statement): myvar := CASE num WHEN 1 THEN 'good' WHEN 2 THEN 'bad' END;
INTO
specification - body
expression
DML
37. To insert or update on a table that has a collection column - you have to have _______ privilege on the collection type.
array
EXECUTE
after insert on emps
constrained
38. In 11g you can directly reference _____________ in PL/SQL.
numeric and cursor
sequence pseudo-columns
code
machine code
39. In the special IF syntax - is it ELSIF - or ELSEIF?
elsif
index
fetch C into V
bb:true
40. An INSTEAD OF trigger is used - e.g - when you want to insert into a complex _____.
view
anonymous block
VARCHAR2
DBMS_SESSION
41. For a collection - the NEXT method gets the next higher (element / index).
index
close C
END CASE
wrap
42. Characters that begin a single-line comment.
-
for each row
suspended
scalar
43. How many times are a FOR loop's index bounds evaluated?
an enclosing block
3
once
executable
44. Conversion: If the specific value is suitable - ____ or _______ values can convert to almost any datatype
error code
Ordinary - Quoted.
CHAR - VARCHAR2
ENABLE
45. Setting CURRENT_SCHEMA only changes what is prepended to __________ references.
UTL_SMTP
slower
procedure - function
unqualified
46. Cursors: The three keywords in a full cursor declaration/definition (before the SELECT).
cursor number
IN
CURSOR - RETURN - IS
column
47. I/O: This package sends text output to SQLPlus
EXIT
DBMS_OUTPUT
drop procedure
cannot
48. To use a TYPE declared in the database - a PL/SQL block has to have _______ privilege on the type.
anonymous
enabled
select
cannot
49. IDs: You (can/cannot) use keywords as ordinary user-defined identifiers.
EXECUTE
can
package
DBMS_SQL
50. The PL/SQL ________ evaluates compiler directives.
dbms_output.put_line
ROLLBACK
preprocessor
SYS_CONTEXT
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