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. Conversion: Implicit conversion is not always predictable; it is _______-sensitive. And its rules might change.
CURRENT_USER - DEFINER
context
CURRENT OF
stored

2. I/O: Max number of bytes DBMS_OUTPUT can handle in a session.
rollback to ab
package
cannot
1 million

3. Pkgs: This procedure de-instantiates/resets all packages in this session.
:=
static
Keywords and predefined names.
DBMS_SESSION.RESET_PACKAGE

4. Cursors: WHERE _______ ______ makes an UPDATE or DELETE apply to the current row of a cursor.
exit when cgo%NOTFOUND
CURRENT OF
p.v
statement

5. With Edition-based Redefinition enabled - the unique specification of an object requires OWNER - OBJECT_NAME and ___________.
HTF
EDITION_NAME
bind
CLOSE_CURSOR

6. Exceptions: An exception raised inside an _______ _______ propagates immediately to the enclosing block
constructor
INTO
exception handler
collections - records

7. A national character literal is composed of characters in the ________ character set.
transaction
identifiers
literals
national

8. Cursors: The value of SQL%ROWCOUNT after a SELECT INTO statement returns more than one row.
OLD
will not
an AUTHID property
1

9. Fundamental: What is the exponentiation operator?
constrained
WHEN OTHERS THEN
invoker's
**

10. The three sorts of date/time types are DATE - INTERVAL and _________.
TIMESTAMP.
scalar
CHAR - VARCHAR2
network

11. In interpreted mode - the PL/SQL VM interprets the _________.
predefined
bytecode
SUBTYPE n IS number not null;
1

12. Triggers: In a per-row trigger - the ____ record shows you the original state of an affected row.
EXECUTE IMMEDIATE
OLD
OPEN_CURSOR
dynamic

13. For a collection - the NEXT method returns ____ when there is no next index value.

slower
anonymous block
virtual machine

14. How to reference a variable V declared in a block labelled L: ____.
L.V
DBMS_SESSION.RESET_PACKAGE
DR
scalar

15. Data dictionary view that shows the compiler settings for each compiled object.
@
enabled
UTL_FILE
USER_PLSQL_OBJECT_SETTINGS

16. Advantage: Performance: PL/SQL automatically creates ______ variables for variables in WHERE and VALUES clauses.
INSTEAD OF
GET_LINES
DBMS_SQL
bind

17. Cursors: If you use an EXIT statement to exit a cursor FOR loop prematurely - the cursor (is / is not) closed automatically.
is
autonomous triggers
LOOP
DML

18. IDs: How an ordinary user-defined identifier must begin.
With a letter.
after
EXTEND
cursor

19. Cursors: The four cursor attributes - in alphabetical order.
VARRAYs
%FOUND - %ISOPEN - %NOTFOUND - %ROWCOUNT
specification - body
statically

20. This is a CASE (expression / statement): myvar := CASE num WHEN 1 THEN 'good' WHEN 2 THEN 'bad' END;
a cursor
REF CURSOR
statement
expression

21. I/O: The DBMS_OUTPUT procedure that sets the size of the output buffer.
FGA
CLOSE
elements
ENABLE

22. The Wrap utility ________ the source code.
obfuscates
CHARARR
unconstrained
cursor

23. A CASE statement ends with ____ ____.
anonymous block
searched
3
END CASE

24. _________ exceptions can not be trapped with an error handler
after
Declaration
null string
strong

25. Cursors: How many DML statements can a FORALL statement contain?
1
Keywords and predefined names.
OPEN
aliases

26. The PL/SQL ________ evaluates compiler directives.
preprocessor
cursor c;
define
Apache

27. Set flag bb true: ALTER SESSION SET PLSQL_CCFLAGS= '____'
pseudocolumn
lock
bb:true
open C

28. Collections are one of the two kinds of PL/SQL _______ data types.
collections
composite
portable
name and datatype

29. Triggers: In a trigger - you cannot issue a COMMIT or a ______.
1
ROLLBACK
associative
v1 OUT number default 10

30. What is the simplest statement for getting out of simple loop?
closed
EXIT
$IF $THEN $ELSE $END
cannot

31. Declare a number variable - A - initialized to 10.
a number := 10
loop
SUBTYPE numb IS number;
SQL

32. Cursors: Give the statement to fetch data from cursor variable CV into MyVar.
query
fetch cv into myvar
error code
identifiers

33. Fundamental: Delimiters are _____ and _____ symbols.
optional
transaction
timing
simple and compound symbols

34. Cursors: Give the statement to close cursor C.
return value
SUBTYPE numb IS number;
close C
disable

35. Advantage: PL/SQL runs anywhere Oracle runs - so it is very ________.
VARRAY - Nested table
CLOSE_CURSOR
portable
Abstract

36. Exceptions: The maximum length of an Oracle error message is ____ characters
512
TRUE - FALSE and NULL
ordinary
selection

37. Cursors: The first two keywords in a Cursor FOR loop.
NESTED TABLE myColl STORE AS myCollTab
oname
FOR - IN
upper - coalesce

38. Cursors: A cursor FOR loop can use an explicit or an _______ cursor.
execute
TRUE - FALSE - NULL
CREATE TYPE
implicit

39. A large OUT or IN OUT parameter will waste a lot of space and CPU if it is passed by _____.
scalar
SQL
value
OPEN_CURSOR

40. Cursors: The two keywords in a mere cursor declaration (one is optional).
follows
Ordinary - Quoted.
CURSOR - RETURN
cursor c;

41. Mode designation for an input/output parameter.
statement
integer
can
IN OUT

42. Types: The only Oracle datetime type that doesn't begin with TIMESTAMP is ________.
DATE
comments
RETURN
drop procedure

43. DynSQL: Native Dynamic SQL
exception handler
SYS_CONTEXT
static boolean
NDS

44. DynSQL: The colon-prefixed names used in EXECUTE IMMEDIATE are called ________.
null string
placeholders
non-editioning views
3

45. I/O: The output from DBMS_OUTPUT will display (during/after) program execution.
names
collections
after
cannot

46. A GOTO statement can branch from an exception handler into...
DBMS_DDL
.
dynamic
an enclosing block

47. Define a nested table type - tN - which is a table NUMBERs.
TYPE tN IS TABLE of NUMBER
transaction
memory
FOR i IN REVERSE 1..10 LOOP

48. A kind of variable used as a placeholder.
suspended
DBMS_SESSION
procedure - function
bind

49. Bulk: The two features that comprise Bulk SQL are:
TYPE tA IS TABLE OF NUMBER INDEX BY VARCHAR2(20)
enabled
FORALL and BULK COLLECT
session cursor

50. Types: The only PL/SQL type for which you can specify a range constraint.
before insert or update on emps
DATE '2005-12-25'
static boolean
PLS_INTEGER

Sorry!:) No result found.

Can you answer 50 questions in 15 minutes?

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