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 FOR-loop counter is defined only within the _____.
type T is ref cursor
loop
does not
nested

2. Command to create a procedure.
enabled
-20 -000
create procedure
optional

3. I/O: If the current (outermost) PL/SQL block ends with an unhandled exception - the output buffer will not be ___________.
order
1
flushed
suspended

4. Web: PL/SQL _______ enables a Web browser to invoke a PL/SQL stored subprogram through an HTTP listener.
IR
SYS_CONTEXT
-20 -000
Gateway

5. A type of compiler directive - begins with 's'.
Abstract
selection
include
once

6. IDs: How an ordinary user-defined identifier must begin.
With a letter.
composite
invoker's
an autonomous routine

7. Nested tables can become sparse via ______.
autonomous transaction
deletions
native dynamic
SQL

8. Cursors: The type definition of a WEAK ref cursor type has no _______ clause.
CURSOR - RETURN - IS
DATE
FETCH - INTO
RETURN

9. The names of Java objects in Oracle can be up to __ characters in length.
4K
CHAR - VARCHAR2
label
SQLCODE

10. DBMS_DDL.CREATE_WRAPPED: wraps and _______ the source code passed to it.
COMMIT - ROLLBACK - SAVEPOINT - SET TRANSACTION
'ENABLE:SEVERE' - 'ERROR:06002'
compiles
Keywords and predefined names.

11. Advantage: PL/SQL runs anywhere Oracle runs - so it is very ________.
OPEN_CURSOR
is certain
lock
portable

12. I/O: This package has hypertext procedures that generate HTML tags
..
HTP
EXECUTE
flushed

13. DynSQL: The standard package that does dynamic SQL.
selection
aliases
scalable
DBMS_SQL

14. DynSQL: The colon-prefixed names used in EXECUTE IMMEDIATE are called ________.
static
placeholders
literals
always

15. Wrap iname=xxxx _____=zzzzz
32 -000
<<>>
oname
DR

16. IDs: List the two types of user-defined identifiers.
Ordinary - Quoted.
:=
SQL
DBMS_DDL

17. The RESULT_CACHE clause has to be in both the declaration and in the ______ of the function.
DATE '2005-12-25'
RETURN
NDS
definition

18. The command used to populate PLSQL_CCFLAGS.
ALTER SESSION
$END
run
END IF

19. _______ arrays can be sparse or dense - depending on how you fill them.
ALTER SESSION
associative
Web Toolkit
wrap

20. Labels for blocks and statements are enclosed in '__' brackets.
in the database
<<>>
compiles
include

21. The Wrap utility ________ the source code.
CURRENT_USER - DEFINER
compile
exception handler
obfuscates

22. Advantage: PL/SQL is PORTABLE to any OS where ________ runs.
Oracle
cannot
Server Pages
1

23. An INSTEAD OF trigger is used - e.g - when you want to insert into a complex _____.
view
upper - coalesce
autonomous transaction
SQL

24. VARRAYs are (always / never) sparse.
code
EXIT WHEN
nested tables - associative arrays
never

25. TCL: Create a savepoint called ab
lower sub-block
statement
INTO
savepoint ab

26. Wrapping can be done with the ____ executable.
wrap
cursor
EXCEPTION_INIT
ALTER SESSION

27. Loops: What is the index range operator in a FOR loop?
..
can
FGA
%BULK_ROWCOUNT

28. What is the simplest statement for conditionally getting out of simple loop?
network
FOR i IN REVERSE 1..10 LOOP
EXIT WHEN
can

29. DBMS_DDL.WRAP returns a string containing wrapped _____ _____.
UTL_SMTP
OTHERS
Gateway
source code

30. Triggers: If two or more triggers are defined with the same timing point - then you can control the firing order using the ________ clause.
FETCH
IF - CASE or LOOP
follows
%TYPE

31. INSTEAD OF triggers are alternatives to ___ triggers
enclosing
DML
SQL
associative

32. What do you FETCH from?
a cursor
CREATE TRIGGER
create
integer

33. Fundamental: Maximum string length of a PL/SQL variable.
/*
quoted
32 -000
PRAGMA AUTONOMOUS_TRANSACTION;

34. In 11g you can directly reference _____________ in PL/SQL.
With a letter.
parameter
procedure P AUTHID definer;
sequence pseudo-columns

35. When a session starts - CURRENT_SCHEMA has the value of the schema owned by ___________.
inclusive
SESSION_USER
Web Toolkit
cannot

36. Web: Abbreviation of PL/SQL Server Page.
RAISE
PSP
end
autonomous transaction

37. Types: A ______ has the same valid operations as its base type.
:=
subtype
DBMS_SESSION
Wrap

38. I/O: One of the 3 types of data stored in the DBMS_OUTPUT buffer.
NUMBER
fail
API
associative

39. The FOR UPDATE OF clause references a (table / column).
column
statement
create procedure
binding

40. IDs: You cannot use reserved words as ______ user-defined identifiers.
procedure P AUTHID definer;
%BULK_ROWCOUNT
Server Pages
ordinary

41. In a FORALL loop - you (can / cannot) use the index variable for purposes other than indexing into the collection.
scalable
cannot
procedure - function
open cv for

42. Default file extension of wrap's input file.
current
execute
binding
sql

43. What are the starting and ending keywords of a simple loop?
bind
LOOP - END LOOP
PRAGMA AUTONOMOUS_TRANSACTION;
hardware

44. Triggers: Programmers (as opposed to DBAs) mostly make use of _____ triggers.
DML
unconstrained
30
error code

45. Abbreviation of invoker's rights
1
IR
..
REUSE SETTINGS

46. Default value of PLSQL_OPTIMIZE_LEVEL.
2
literal
can
create

47. IDs: Maximum number of bytes in a user-defined identifier.
SQL
<<
preprocessor
30

48. When an autonomous routine begins execution - the main transaction is ________.
With a letter.
3
FETCH
suspended

49. Triggers: INSTEAD OF triggers only run on ______ views.
system global area
lowest
non-editioning views
index

50. Triggers: In a per-row trigger - the ____ record shows you the changed state of an affected row.
concatenation
True
NEW
cursor c;

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