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. Conversion: Implicit conversion is not always predictable; it is _______-sensitive. And its rules might change.
CURRENT_USER - DEFINER
context
CURRENT OF
stored
2. I/O: Max number of bytes DBMS_OUTPUT can handle in a session.
rollback to ab
package
cannot
1 million
3. Pkgs: This procedure de-instantiates/resets all packages in this session.
:=
static
Keywords and predefined names.
DBMS_SESSION.RESET_PACKAGE
4. Cursors: WHERE _______ ______ makes an UPDATE or DELETE apply to the current row of a cursor.
exit when cgo%NOTFOUND
CURRENT OF
p.v
statement
5. With Edition-based Redefinition enabled - the unique specification of an object requires OWNER - OBJECT_NAME and ___________.
HTF
EDITION_NAME
bind
CLOSE_CURSOR
6. Exceptions: An exception raised inside an _______ _______ propagates immediately to the enclosing block
constructor
INTO
exception handler
collections - records
7. A national character literal is composed of characters in the ________ character set.
transaction
identifiers
literals
national
8. Cursors: The value of SQL%ROWCOUNT after a SELECT INTO statement returns more than one row.
OLD
will not
an AUTHID property
1
9. Fundamental: What is the exponentiation operator?
constrained
WHEN OTHERS THEN
invoker's
**
10. The three sorts of date/time types are DATE - INTERVAL and _________.
TIMESTAMP.
scalar
CHAR - VARCHAR2
network
11. In interpreted mode - the PL/SQL VM interprets the _________.
predefined
bytecode
SUBTYPE n IS number not null;
1
12. Triggers: In a per-row trigger - the ____ record shows you the original state of an affected row.
EXECUTE IMMEDIATE
OLD
OPEN_CURSOR
dynamic
13. For a collection - the NEXT method returns ____ when there is no next index value.
slower
anonymous block
virtual machine
14. How to reference a variable V declared in a block labelled L: ____.
L.V
DBMS_SESSION.RESET_PACKAGE
DR
scalar
15. Data dictionary view that shows the compiler settings for each compiled object.
@
enabled
UTL_FILE
USER_PLSQL_OBJECT_SETTINGS
16. Advantage: Performance: PL/SQL automatically creates ______ variables for variables in WHERE and VALUES clauses.
INSTEAD OF
GET_LINES
DBMS_SQL
bind
17. Cursors: If you use an EXIT statement to exit a cursor FOR loop prematurely - the cursor (is / is not) closed automatically.
is
autonomous triggers
LOOP
DML
18. IDs: How an ordinary user-defined identifier must begin.
With a letter.
after
EXTEND
cursor
19. Cursors: The four cursor attributes - in alphabetical order.
VARRAYs
%FOUND - %ISOPEN - %NOTFOUND - %ROWCOUNT
specification - body
statically
20. This is a CASE (expression / statement): myvar := CASE num WHEN 1 THEN 'good' WHEN 2 THEN 'bad' END;
a cursor
REF CURSOR
statement
expression
21. I/O: The DBMS_OUTPUT procedure that sets the size of the output buffer.
FGA
CLOSE
elements
ENABLE
22. The Wrap utility ________ the source code.
obfuscates
CHARARR
unconstrained
cursor
23. A CASE statement ends with ____ ____.
anonymous block
searched
3
END CASE
24. _________ exceptions can not be trapped with an error handler
after
Declaration
null string
strong
25. Cursors: How many DML statements can a FORALL statement contain?
1
Keywords and predefined names.
OPEN
aliases
26. The PL/SQL ________ evaluates compiler directives.
preprocessor
cursor c;
define
Apache
27. Set flag bb true: ALTER SESSION SET PLSQL_CCFLAGS= '____'
pseudocolumn
lock
bb:true
open C
28. Collections are one of the two kinds of PL/SQL _______ data types.
collections
composite
portable
name and datatype
29. Triggers: In a trigger - you cannot issue a COMMIT or a ______.
1
ROLLBACK
associative
v1 OUT number default 10
30. What is the simplest statement for getting out of simple loop?
closed
EXIT
$IF $THEN $ELSE $END
cannot
31. Declare a number variable - A - initialized to 10.
a number := 10
loop
SUBTYPE numb IS number;
SQL
32. Cursors: Give the statement to fetch data from cursor variable CV into MyVar.
query
fetch cv into myvar
error code
identifiers
33. Fundamental: Delimiters are _____ and _____ symbols.
optional
transaction
timing
simple and compound symbols
34. Cursors: Give the statement to close cursor C.
return value
SUBTYPE numb IS number;
close C
disable
35. Advantage: PL/SQL runs anywhere Oracle runs - so it is very ________.
VARRAY - Nested table
CLOSE_CURSOR
portable
Abstract
36. Exceptions: The maximum length of an Oracle error message is ____ characters
512
TRUE - FALSE and NULL
ordinary
selection
37. Cursors: The first two keywords in a Cursor FOR loop.
NESTED TABLE myColl STORE AS myCollTab
oname
FOR - IN
upper - coalesce
38. Cursors: A cursor FOR loop can use an explicit or an _______ cursor.
execute
TRUE - FALSE - NULL
CREATE TYPE
implicit
39. A large OUT or IN OUT parameter will waste a lot of space and CPU if it is passed by _____.
scalar
SQL
value
OPEN_CURSOR
40. Cursors: The two keywords in a mere cursor declaration (one is optional).
follows
Ordinary - Quoted.
CURSOR - RETURN
cursor c;
41. Mode designation for an input/output parameter.
statement
integer
can
IN OUT
42. Types: The only Oracle datetime type that doesn't begin with TIMESTAMP is ________.
DATE
comments
RETURN
drop procedure
43. DynSQL: Native Dynamic SQL
exception handler
SYS_CONTEXT
static boolean
NDS
44. DynSQL: The colon-prefixed names used in EXECUTE IMMEDIATE are called ________.
null string
placeholders
non-editioning views
3
45. I/O: The output from DBMS_OUTPUT will display (during/after) program execution.
names
collections
after
cannot
46. A GOTO statement can branch from an exception handler into...
DBMS_DDL
.
dynamic
an enclosing block
47. Define a nested table type - tN - which is a table NUMBERs.
TYPE tN IS TABLE of NUMBER
transaction
memory
FOR i IN REVERSE 1..10 LOOP
48. A kind of variable used as a placeholder.
suspended
DBMS_SESSION
procedure - function
bind
49. Bulk: The two features that comprise Bulk SQL are:
TYPE tA IS TABLE OF NUMBER INDEX BY VARCHAR2(20)
enabled
FORALL and BULK COLLECT
session cursor
50. Types: The only PL/SQL type for which you can specify a range constraint.
before insert or update on emps
DATE '2005-12-25'
static boolean
PLS_INTEGER
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