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. Pkgs: This procedure de-instantiates/resets all packages in this session.
selection
3
DBMS_SESSION.RESET_PACKAGE
literal
2. In the special IF syntax - is it ELSIF - or ELSEIF?
versions
elsif
FETCH - INTO
:=
3. Conversion: Implicit conversion is not always predictable; it is _______-sensitive. And its rules might change.
cannot
context
RECORDS
same
4. I/O: This package has hypertext functions that generate HTML tags
IN - OUT - IN OUT
block
order
HTF
5. _____ arrays cannot be used as the type of an Oracle table column.
bind arguments
cached
associative
..
6. Language that PL/SQL is derived from.
OTHERS
API
Ada
associative
7. GOTO branches to a ________.
ALTER SESSION
$$PLSQL_LINE
Gateway
label
8. Declare a package procedure P with no arguments - and give it definer's rights.
procedure P AUTHID definer;
decimal
DML
v1 OUT number default 10
9. A CASE statement ends with ____ ____.
FALSE
END CASE
NESTED TABLE myColl STORE AS myCollTab
subtype
10. Triggers: INSTEAD OF triggers only run on ______ views.
non-editioning views
name and datatype
SQLERRM
never
11. Advantage: PL/SQL programs are stored centrally - making them more ______.
'ENABLE:SEVERE' - 'ERROR:06002'
virtual machine
REF_CURSOR
manageable
12. A subprogram defined within another subprogram is a _______ subprogram.
nested
propagates
CURSOR - RETURN - IS
DBMS_OUTPUT
13. Types: One of the 4 PL/SQL things that have a data type (begins with 'p').
parameter
bind
Abstract
execute immediate
14. Cursors: Only a _____ _____ cursor can appear in the CURRENT OF clause of an UPDATE or DELETE statement.
FOR UPDATE
3
Gateway
%
15. Types: The only PL/SQL type for which you can specify a range constraint.
anonymous
EXIT WHEN cv%NOTFOUND
OPEN
PLS_INTEGER
16. Delimiters: the attribute indicator.
SUBTYPE n IS number not null;
%
raise_application_error(-20 -100 - 'Bad');
cursor number
17. VARRAYs are (always / never) sparse.
implicit
column
never
...
18. Default value of PLSQL_OPTIMIZE_LEVEL.
error code
collections
compilation
2
19. An anonymous block always has _________ rights.
Warning
: Invalid argument supplied for foreach() in
/var/www/html/basicversity.com/show_quiz.php
on line
183
20. A CASE statement (can / cannot) execute more than one group of statements.
value
cannot
IR
colon
21. I/O: Max number of bytes DBMS_OUTPUT can handle in a session.
Ada
executable
context
1 million
22. DynSQL: EXECUTE IMMEDIATE does both dynamic SQL and dynamic _______.
disable
is not
DATE
PL/SQL
23. A (simple / searched) CASE statement begins with CASE WHEN <boolean expression>.
searched
EXECUTE IMMEDIATE
specification - body
definer's
24. Exceptions: Type ______ to re-raise the current exception.
statement
RAISE
bytecode
compile
25. In a sparse collection - the indexes of defined elements (do / do not) run in consecutive order.
network
do not
expression
FETCH - BULK COLLECT INTO
26. Cursors: A Cursor FOR loop does not use a ______ statement.
SQLCODE
FETCH
definer's
cannot
27. User-defined compiler directives are defined in this system compile parameter.
PLS_INTEGER
cursor c;
PLSQL_CCFLAGS
bytecode
28. What is the simplest statement for conditionally getting out of simple loop?
object
disable
collections - records
EXIT WHEN
29. What are the 3 values of the BOOLEAN data type?
1
create
TRUE - FALSE and NULL
associative
30. If you are in a procedure inside a package - the compilation unit is the _______.
fine-grained auditing
DEFINER
package
native dynamic
31. Bulk: The two features that comprise Bulk SQL are:
EDITION_NAME
FORALL and BULK COLLECT
1
savepoint ab
32. Types: The predefined subtype of PLS_INTEGER that has the NOT NULL constraint.
1
implicit CASE_NOT_FOUND exception
SIMPLE_INTEGER
VARRAY - Nested table
33. Exceptions: If there is no handler for an exception - PL/SQL returns an ________ exception error to the invoker or host environment.
unhandled
DBMS_PREPROCESSOR
error code
<<>>
34. IDs: How an ordinary user-defined identifier must begin.
With a letter.
explicit
source
colon
35. For a collection - the NEXT method gets the next higher (element / index).
unconstrained
USER_PROCEDURES
index
SQLPlus
36. TCL: Undo changes back to savepoint ab.
hardware
IN
ex := tbl1 MULTISET EXCEPT tbl2
rollback to ab
37. Triggers: The clause to make a trigger run after inserting into table EMPS.
bb:true
USER_PLSQL_OBJECT_SETTINGS
after insert on emps
value
38. An incomplete type only has a ____.
aliases
name
EXECUTE
wrap
39. In 11g you can directly reference _____________ in PL/SQL.
USER_PLSQL_OBJECT_SETTINGS
CLOSE
E Exception;
sequence pseudo-columns
40. Advantage: Performance: Stored subprograms are ______ in memory.
cached
BINARY_INTEGER
UTL_SMTP
unqualified
41. A nested table has to be initialized using a ________ - named the same as the type.
package
constructor
native dynamic
manageable
42. %ROWTYPE gets the type of a table or _______.
Declaration
Ada
cursor
package
43. The statement that is used to execute most (native) dynamic SQL.
constructor
name
procedure - function
execute immediate
44. Pkgs: RESET_PACKAGE only takes effect after the outermost PL/SQL proc that called it ________.
simple
a cursor
production
finishes
45. A FOR loop can be indexed by numbers or by a ______.
static boolean
RESULT_CACHE
cursor
multi-row
46. Cursors: A cursor variable's type must be a ____ ______ type.
REF CURSOR
concatenation
FOR i IN REVERSE 1..10 - LOOP - NULL; END LOOP;
same arguments
47. The FOR UPDATE OF clause references a (table / column).
cannot
column
selection
does not
48. Define a collection type - tA - which is an associative array of NUMBERS - indexed with varchar2(20) values.
TYPE tA IS TABLE OF NUMBER INDEX BY VARCHAR2(20)
vname CONSTANT VARCHAR2 := 'x';
OUT
aggregate - analytical
49. Loops: What is the index range operator in a FOR loop?
cannot
injection
END CASE
..
50. Cursors: The index variable in a cursor FOR loop (does/does not) need to be declared.
SQLPlus
optional
wrap
does not
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