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. DBMS_DDL.CREATE_WRAPPED: wraps and _______ the source code passed to it.
create
compiles
Reserved words.
**
2. What is the exception that is implicitly raised in a CASE statement with no ELSE clause?
REF_CURSOR
1 million
STANDARD
CASE_NOT_FOUND
3. The Wrap utility ________ the source code.
include
inquiry
executable
obfuscates
4. Declare an input NUMBER parameter - v2 - that defaults to 20.
v2 IN NUMBER default 20
DR
same arguments
raise_application_error
5. I/O: The DBMS_OUTPUT procedure that sets the size of the output buffer.
RETURN
ENABLE
finishes
6. Cursors: Give the statement to open cursor C.
3
1
open C
%BULK_ROWCOUNT
7. Cursors: The first two keywords of a basic fetch statement.
FETCH - INTO
TOO_MANY_ROWS
must
SUBTYPE numb IS number;
8. The valid values of the AUTHID property.
SESSION_USER
cannot
aggregate - analytical
CURRENT_USER - DEFINER
9. The meaning of 'FGA'.
implicit CASE_NOT_FOUND exception
fine-grained auditing
512
bind arguments
10. 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
11. You (can / cannot) wrap trigger source code.
implicit CASE_NOT_FOUND exception
savepoint ab
cannot
for update of
12. Cursors: A Cursor FOR loop does not use a ______ statement.
FETCH
EXCEPTION_INIT
loop
explicit
13. I/O: This package does email.
@
UTL_SMTP
EDITION_NAME
# - $ - _
14. With a result-cached function - it uses a cached value when the function is called again with the...
raise_application_error(-20 -100 - 'Bad');
Server Pages
END IF
same arguments
15. In PL/SQL - what the variables in DML statements are turned into.
NDS
bind arguments
TYPE tA IS TABLE OF NUMBER INDEX BY VARCHAR2(20)
CURSOR - RETURN
16. Cursors: The value of SQL%ROWCOUNT after a SELECT INTO statement returns more than one row.
SQL
boolean
1
simple and compound symbols
17. The compiler directive governing conditional compilation.
RAISE
dbms_output.put_line
$IF
USER_PROCEDURES
18. IDs: The two types of words that can - but should not - be used as user-defined identifiers.
Keywords and predefined names.
...
numeric and cursor
implicit cursor
19. Fundamental: What are the 3 compound symbols for 'not equal to'?
CLOSE_CURSOR
<> - != - ^=
statement
scalar
20. Statement to exit a cursor loop on cursor cGo when there are no more records.
statement
exit when cgo%NOTFOUND
explicit
RELIES_ON
21. Cursors: The FOR UPDATE phrase goes at the (beginning/end) of the cursor definition.
subtype
not a number
end
machine code
22. Fundamental: Which one of these is a simple symbol: a - = - !=
WHERE CURRENT OF
block
=
after
23. Pkgs: This procedure de-instantiates/resets all packages in this session.
delimiters
Reserved words.
CURRENT OF
DBMS_SESSION.RESET_PACKAGE
24. PL/SQL does not automatically create bind variables in ________ SQL.
dynamic
INTO
unconstrained
null string
25. Types: One of the scalar data types specific to PL/SQL: b_____.
..
BOOLEAN
512
system global area
26. Cursors: The index variable in a cursor FOR loop (does/does not) need to be declared.
does not
Ada
scalar
index
27. The source for wrapping begins with the word ______.
statically
view
injection
create
28. Types: Which type of arithmetic does NUMBER use - library or hardware?
EVERE - PERFORMANCE - INFORMATIONAL
library
searched
DBMS_PREPROCESSOR
29. I/O: Max number of bytes DBMS_OUTPUT can handle in a session.
compile
CREATE TYPE
TYPE tN IS TABLE of NUMBER
1 million
30. How many types of compiler directives are there?
3
DBMS_SQL
255
STANDARD
31. The DECLARE keyword is only required in an _______ _______.
oname
REF_CURSOR
anonymous block
session cursor
32. Cursors: A cursor that lives in session memory until the session ends.
static boolean
session cursor
identifiers
PLS_INTEGER
33. Advantage: PL/SQL programs are stored centrally - making them more ______.
once
GET_LINES
vname CONSTANT VARCHAR2 := 'x';
manageable
34. In short-circuit evaluation - IF-conditions are only evaluated up to where the outcome ___________.
1
bind
FGA
is certain
35. Exceptions: The maximum length of an Oracle error message is ____ characters
procedure P AUTHID current_user;
fields
system global area
512
36. IDs: List the two types of user-defined identifiers.
Ordinary - Quoted.
r t.%ROWTYPE;
EXECUTE IMMEDIATE
network
37. You have to use _______ SQL to run DDL statements n PL/SQL.
dynamic
HTP
Apache
closed
38. You cannot bulk collect into an ARRAY OF ________.
RECORDS
32 -000
INTO
39. If none of a CASE expression's conditions are TRUE - it returns _____.
loop
open cv for
rollback to ab
40. A national character literal is composed of characters in the ________ character set.
portable
national
CHARARR
GET_LINES
41. Conversion: Implicit conversion can be (faster / slower) than explicit conversion.
DML
BOOLEAN
DR
slower
42. Cursors: The statement where you pass the parameters to a cursor.
OPEN
rollback to ab
associative arrays
concatenation
43. Cursors: A pointer to a cursor is called a ______ _______.
=
cursor variable
GET_LINE
v2 IN NUMBER default 20
44. Delimiters: the attribute indicator.
enabled
drop procedure
EXIT
%
45. Cursors: Give the statement for getting out of a FETCH loop for cursor CV.
ALTER SESSION
static
DBMS_CRYPTO
EXIT WHEN cv%NOTFOUND
46. Fundamental: One of the 4 types of lexical units: c_____.
comments
associative
implicit
NUMBER
47. The AUTHID property applies to PL/SQL objects that contain _____.
=
pseudocolumn
code
CURRENT_USER
48. FOR-Looping over a collection from FIRST to LAST only works if the collection is _______.
lowest
DML
dense
CLOSE_CURSOR
49. You can have many autonomous transactions in ___________.
OUT
an autonomous routine
statement
lower sub-block
50. To exit an active autonomous transaction without causing an exception - you must issue _____ or ______.
OTHERS
FORALL and BULK COLLECT
commit - rollback
DML
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