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. The _____ utility turns PL/SQL source code into unreadable text.
Wrap
fields
<> - != - ^=
DATE '2005-12-25'
2. Web: mod_plsql is an _______ module.
cannot
RELIES_ON
Apache
FETCH
3. List the transaction control statements.
EXECUTE IMMEDIATE
fetch cv into myvar
COMMIT - ROLLBACK - SAVEPOINT - SET TRANSACTION
3
4. FOR-Looping over a collection from FIRST to LAST only works if the collection is _______.
dense
native dynamic
DBMS_PIPE
collections - records
5. Triggers: The clause to make a trigger run once for every affected row.
for each row
=
raise_application_error
select
6. Advantage: PL/SQL programs are stored centrally - making them more ______.
significant
FETCH
anonymous
manageable
7. How many types of compiler directives are there?
invoker's
EXIT WHEN
3
v3 IN OUT NUMBER
8. Cursors: You cannot use cursor attributes in _______ statements.
SQL
OTHERS
@
VARRAYs
9. A large OUT or IN OUT parameter will waste a lot of space and CPU if it is passed by _____.
index
OPEN_CURSOR
CASE_NOT_FOUND
value
10. Wrapped code (is / is not) not backward compatible.
is not
concatenation
open C(p)
OTHERS
11. One good use of bind variables is to guard against SQL _______.
fields
injection
open cv for
<<
12. The declaration section is (optional/mandatory).
PLS_INTEGER
optional
USER_PLSQL_OBJECT_SETTINGS
FGA
13. True encryption is done with package __________.
DBMS_CRYPTO
DBMS_SESSION.RESET_PACKAGE
value
scalable
14. Types: ______ data types are those storing values with no internal components.
255
OUT
scalar
sql
15. Cursors: Give the statement to fetch data from cursor variable CV into MyVar.
placeholders
fetch cv into myvar
COUNT
FORALL and BULK COLLECT
16. The source for wrapping begins with the word ______.
EXCEPTION_INIT
view
session cursor
create
17. IDs: You (can/cannot) use keywords as ordinary user-defined identifiers.
executable
searched
fine-grained auditing
can
18. Exceptions: The ________ handler must always be the last handler.
FOR i IN REVERSE 1..10 LOOP
FETCH - BULK COLLECT INTO
OTHERS
anonymous
19. A pointer to a private SQL area that stores information about processing a specific SELECT or DML statement.
flushed
cursor
query
compilation
20. A GOTO statement cannot branch from an exception handler back into the...
reference
current BEGIN-END block
elements
FOR i IN REVERSE 1..10 - LOOP - NULL; END LOOP;
21. A basic PL/SQL datatype that SQL does not have.
statement
composite
30
boolean
22. Types: One of the 4 PL/SQL things that have a data type (begins with 'v').
variable
DBMS_PIPE
forward
COUNT
23. Packaged constants can synchronize programs through use in _______ directives.
COUNT
selection
CHARARR
CREATE TYPE
24. Triggers: You create a trigger with the _______ ________ statement.
concatenation
'
CREATE TRIGGER
SQL
25. The inquiry directive that gives the current line number in the procedure.
$$PLSQL_LINE
national
END LOOP
%ISOPEN.
26. Characters that end a multi-line comment.
*/
current transaction
constructor
SQL
27. Exceptions: An exception raised inside an _______ _______ propagates immediately to the enclosing block
selection
FETCH - BULK COLLECT INTO
exception handler
ex := tbl1 MULTISET EXCEPT tbl2
28. The DEFINITION of a cursor is the _____ that returns the records.
run
query
1
ALTER SESSION
29. INSTEAD OF triggers are alternatives to ___ triggers
DML
inclusive
selection
cursor variable
30. An autonomous program runs in its own __________.
transaction
end
enclosing
r tRec := tRec(9 - 'Jones');
31. If a result-cached function's data source (based on the RELIES_ON clause) is updated - any cached results become _______.
VARRAY - Nested table
r tRec := tRec(9 - 'Jones');
.
invalid
32. Delimiters: the attribute indicator.
Double quotes.
PRAGMA AUTONOMOUS_TRANSACTION;
%
forward
33. PLSQL_CCFLAGS hold a comma-separated list of ______ pairs (hyphenated).
$$
OUT
name-value
cursor c RETURN rC;
34. The variable showing the user id of the session owner.
SESSION_USER
placeholders
is certain
composite
35. Advantage: Having procedures stored and executed on the server makes PL/SQL ________.
run
HTF
scalable
CLOSE
36. A CASE statement ends with ____ ____.
cannot
BINARY_INTEGER
32 -000
END CASE
37. Types of blocks: A pl/sql block that is not stored in the database.
TYPE rec IS RECORD (num NUMBER - name VARCHAR2(10));
anonymous
SQL
quoted
38. Exceptions: If there is no handler for an exception - PL/SQL returns an ________ exception error to the invoker or host environment.
L.V
Server Pages
unhandled
bb:true
39. What are the two sequence pseudo-columns?
currval and nextval
server
Keywords and predefined names.
implicit
40. The names of Java objects in Oracle can be up to __ characters in length.
integer
4K
suspended
lowest
41. Two types of stored subprograms.
CHAR - VARCHAR2
procedure - function
DATE
WHEN
42. A PL/SQL extension to the WHERE clause of the SQL statements UPDATE and DELETE
SQL
PRAGMA AUTONOMOUS_TRANSACTION;
stored
WHERE CURRENT OF
43. What is the simplest statement for getting out of simple loop?
VARCHAR2
EXIT
server
preprocessor
44. Exceptions: An exception in the declarations section propagates to the enclosing _______.
block
network
INTO
45. DynSQL: The three modes of arguments in the USING clause of EXECUTE IMMEDIATE.
CHAR - VARCHAR2
nested
library
IN - OUT - IN OUT
46. The $IF must evaluate a ______ _______ expression.
PUT
enclosing
name-value
static boolean
47. This is a CASE (expression / statement): CASE num WHEN 1 THEN goto LABEL1 WHEN 2 THEN var := 2 END CASE;
unqualified
anonymous
integrated
statement
48. DynSQL: The standard package that does dynamic SQL.
for each row
DBMS_SQL
collections
EVERE - PERFORMANCE - INFORMATIONAL
49. Cursors: WHERE _______ ______ makes an UPDATE or DELETE apply to the current row of a cursor.
bytecode
code
WHEN
CURRENT OF
50. An anonymous block is a(n) ____ statement.
production
SQL
FOR i IN REVERSE 1..10 LOOP
searched
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