Test your basic knowledge |

Oracle PL - SQL

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. A CASE statement ends with ____ ____.
DATE
placeholders
PL/SQL Gateway
END CASE

2. Records are one of the two kinds of PL/SQL _______ data types.
SQLCODE
TOO_MANY_ROWS
cannot
composite

3. PL/SQL does not automatically create bind variables in ________ SQL.
EVERE - PERFORMANCE - INFORMATIONAL
dynamic
With a letter.
REUSE SETTINGS

4. Delimiters: the attribute indicator.
IN
OTHERS
=
%

5. Assignment of PLSQL_CCFLAGS (cannot / can) be included in ALTER PROCEDURE ... COMPILE ...
1
DBMS_PREPROCESSOR
Gateway
can

6. In short-circuit evaluation - IF-conditions are only evaluated up to where the outcome ___________.
is certain
bytecode
pls_integer
enabled

7. The command used to populate PLSQL_CCFLAGS.
DECLARE - BEGIN - EXCEPTION - END
EXIT WHEN cv%NOTFOUND
RESULT_CACHE
ALTER SESSION

8. Triggers: The clause to make a trigger run after inserting into table EMPS.
statement
close C
after insert on emps
buffer

9. A PL/SQL block that is not stored.
PLS_INTEGER
collections - records
anonymous block
PLSQL_CCFLAGS

10. A type of compiler directive - begins with 'e'.
1
unqualified
error
1

11. Web: mod_plsql is an _______ module.
decimal
Apache
for each row
before insert or update on emps

12. Mode designation for an input parameter.
numeric and cursor
subtype
IN
TOO_MANY_ROWS

13. Exceptions: A GOTO statement cannot branch into an _______ ________.
exception handler
SESSION_USER
database
information that changes infrequently

14. Declare an unconstrained subtype of NUMBER called NUMB.
SUBTYPE numb IS number;
REUSE SETTINGS
finishes
server

15. Fundamental: What is the range operator?
..
HTF
END IF
USER_PLSQL_OBJECT_SETTINGS

16. Triggers: The code in a trigger is actually an ________ block.
name and datatype
OPEN
database
anonymous

17. A numeric FOR loop cannot _________ by other than 1?
increment
3
must
SESSION_USER

18. ______ SQL is a PL/SQL feature that allows SQL syntax directly in a PL/SQL statement.
UTL_HTTP
static
network
scalable

19. Advantage: PL/SQL is PORTABLE to any OS where ________ runs.
Web Toolkit
hardware
RETURN
Oracle

20. What do you FETCH from?
a cursor
timing
once
must

21. Declare an associative array type - t - whose elements are of type rPerson - and whose index is PLS_INTEGER.
anonymous
TYPE t IS TABLE OF rPerson INDEX BY PLS_INTEGER;
bytecode
EXIT WHEN

22. Cursors: The SQL%FOUND attribute has how many possible values?
exit when cgo%NOTFOUND
3
..
exception handler

23. Triggers: A compound trigger can fire at more than one ______ point.
CURRENT OF
RETURN
do not
timing

24. TCL: Undo changes back to savepoint ab.
r t.%ROWTYPE;
forward
rollback to ab
searched

25. Characters that begin a single-line comment.
-
can
machine
invoker's

26. CREATE TYPE cannot be used for _______ array types.
literal
3
associative
label

27. The BEGIN section is (optional/mandatory)
select
RETURN
constant
mandatory

28. The meaning of 'FGA'.
fine-grained auditing
EXECUTE IMMEDIATE
selection
FETCH

29. DynSQL: In EXECUTE IMMEDIATE - the statement string can use either placeholders - or string ________.
:=
concatenation
cursor
current transaction

30. Are good for logging table DML operations.
4
autonomous triggers
PRAGMA AUTONOMOUS_TRANSACTION;
exception

31. Triggers: If two or more triggers are defined with the same timing point - then you can control the firing order using the ________ clause.
index
follows
SQLPlus
CHAR - VARCHAR2

32. The FOR UPDATE OF clause references a (table / column).
column
query
1
..

33. DynSQL: Maximum string length to pass to EXECUTE IMMEDIATE.
32 -000
constrained
WHERE CURRENT OF
PL/SQL

34. Types: One of the scalar data types specific to PL/SQL: P________
DML
literals
view
PLS_INTEGER

35. The PL/SQL virtual machine turns bytecode into system ______.
INSTEAD OF
calls
@
multi-row

36. DBMS_DDL.CREATE_WRAPPED: wraps and _______ the source code passed to it.
CURRENT_USER - DEFINER
collections - records
invalid
compiles

37. Into nested table ex - put elements of tbl1 that are not in tbl2.
ex := tbl1 MULTISET EXCEPT tbl2
cannot
cursor c RETURN rC;
searched

38. Cursors: An implicit cursor is also called a/n ________ ________ -
finishes
raise_application_error
SQL cursor
END LOOP

39. Fundamental: Labels furnish targets for GOTO and _____ statements.
NEW
cursor
for update of
EXIT

40. The compiler directive governing conditional compilation.
finishes
$IF
Apache
exception handler

41. An $ERROR directive ends with _____.
$END
delimiters
does not
VARCHAR2

42. Default file extension of wrap's output file.
savepoint ab
PRAGMA AUTONOMOUS_TRANSACTION;
plb
32 -000

43. Value of a character literal with zero characters.
closed
an AUTHID property
DBMS_DDL

44. You (can / cannot) wrap trigger source code.
INSTEAD OF
cannot
HTF
constructor

45. Triggers: There are __ types of triggers.
5
DML
inclusive
loop

46. Abbreviation of definer's rights
value
PRAGMA EXCEPTION_INIT (E - -1);
same arguments
DR

47. Conversion: It is best to use (implicit / explicit) conversion.
SYS_REFCURSOR
v1 OUT number default 10
can
explicit

48. In the special IF syntax - is it ELSIF - or ELSEIF?
CHAR - VARCHAR2
bind
elsif
national

49. Exceptions: When an exception is raised inside a cursor FOR loop - the cursor is _______ implicitly.
FETCH
closed
a cursor
VARRAY - Nested table

50. Types: The only PL/SQL type for which you can specify a range constraint.
finishes
Oracle
FETCH - INTO
PLS_INTEGER

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

Test your basic knowledge |

Oracle PL - SQL

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

Certifications

IT Skills

Business Skills

Soft Skills

Vocabulary

Languages

Engineering

Health Sciences

English

Math

Other Major Subjects

Browse all subjects

Browse all tests

Most popular tests