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. Default file extension of wrap's output file.
SUBTYPE n IS number not null;
plb
expression
IF - CASE or LOOP

2. A user-defined TYPE can have...
GET_LINES
cannot
do not
an AUTHID property

3. Simple CASE statement checks for different values of a single _________
expression
pls_integer
invoker's
With a letter.

4. Cursors: An explicit cursor (can/cannot) accept parameters.
end
expression
can
must

5. Static typing is also called _____ typing.
L.V
DML
strong
ADT

6. Types: ______ data types are those storing values with no internal components.
unhandled
DATE '2005-12-25'
scalar
SUBTYPE n IS number not null;

7. Advantage: Performance: PL/SQL automatically creates ______ variables for variables in WHERE and VALUES clauses.
invoker's
bind
RETURN
%

8. This is a CASE (expression / statement): CASE num WHEN 1 THEN goto LABEL1 WHEN 2 THEN var := 2 END CASE;
decimal
lock
DBMS_SQL
statement

9. DynSQL: Maximum string length to pass to EXECUTE IMMEDIATE.
OPEN
calls
32 -000
DBMS_SESSION.RESET_PACKAGE

10. $$PLSQL_LINE and $$PLSQL_UNIT are ______-ly defined inquiry directives.
anonymous block
**
implicit
non-editioning views

11. I/O: This package has hypertext procedures that generate HTML tags
HTP
for each row
boolean
UTL_SMTP

12. The Wrap utility ________ the source code.
obfuscates
can
portable
index

13. Cursors: The index variable in a cursor FOR loop (does/does not) need to be declared.
suspended
%TYPE
does not
32 -000

14. Cursors: The value of SQL%ROWCOUNT after a SELECT INTO statement returns more than one row.
1
L.V
WHEN OTHERS THEN
boolean

15. DBMS_DDL.CREATE_WRAPPED: wraps and _______ the source code passed to it.
name and datatype
system global area
compiles
query

16. Dbms_sql: The integer returned by OPEN_CURSOR is a _____ _____.
return value
cursor number
is certain
ALTER SESSION

17. Declare a package procedure P with no arguments - and give it invoker's rights.
procedure P AUTHID current_user;
cannot
invoker's
FOR UPDATE

18. _______ arrays can be sparse or dense - depending on how you fill them.
associative
255
=
name and datatype

19. Statement to set current schema to x: _____ _____ SET CURRENT_SCHEMA = 'x';
END IF
WHEN
source
ALTER SESSION

20. The 2 characters that begin all inquiry directives.
production
DBMS_OUTPUT
cursor c;
$$

21. A subprogram defined within another subprogram is a _______ subprogram.
VARRAYs
commit - rollback
nested
SQLCODE

22. The _____ utility turns PL/SQL source code into unreadable text.
package
can
Wrap
raise_application_error(-20 -100 - 'Bad');

23. The values defined in PLSQL_CCFLAGS can be referenced as _____ directives.
server
inquiry
a number := 10
END

24. PLS_INTEGER has its arithmetic implemented in ________ - so it is very fast.
SQL
always
hardware
manageable

25. _________ exceptions can not be trapped with an error handler
Declaration
object
boolean
CLOSE

26. A CASE expression ends with _____.
END
v2 IN NUMBER default 20
source
explicit

27. The PL/SQL ________ evaluates compiler directives.
preprocessor
EDITION_NAME
static boolean
query

28. ______ SQL is a PL/SQL feature that allows SQL syntax directly in a PL/SQL statement.
anonymous
cannot
static
optional

29. Fundamental: Which one of these is a compound symbol: = - :=
composite
exception
:=
for each row

30. Cursors: What implicit cursor attribute gives row counts for a FORALL statement?
never
EVERE - PERFORMANCE - INFORMATIONAL
%BULK_ROWCOUNT
autonomous triggers

31. Cursors: Give the statement to open cursor C.
open C
literal
$END
null string

32. With dynamic typing - type checking is done at ______time.
run
identifiers
ADT
not a number

33. Cursors: How many DML statements can a FORALL statement contain?
database
buffer
1
mandatory

34. A large OUT or IN OUT parameter will waste a lot of space and CPU if it is passed by _____.
same arguments
calls
order
value

35. Delimiters: Single-line comment marker.
information that changes infrequently
composite
-
national

36. The FIRST method gets the first (element / index) of a collection.
index
Apache
/*
%BULK_ROWCOUNT

37. Types: One of the 4 PL/SQL things that have a data type (begins with 'v').
for update of
%BULK_ROWCOUNT
variable
cursor

38. 5 types of events that can have triggers: DML - DDL - INSTEAD OFs - database events - and ________ statements.
SQL
suspended
must
cannot

39. The $IF must evaluate a ______ _______ expression.
FETCH - INTO
DR
static boolean
INTO

40. An editioning view is like an ____ for a table.
raise_application_error(-20 -100 - 'Bad');
-
exception handler
API

41. Subprograms are stored in __________ form.
LOOP
autonomous transaction
DBMS_PIPE
executable

42. Cursors: If you use an EXIT statement to exit a cursor FOR loop prematurely - the cursor (is / is not) closed automatically.
information that changes infrequently
forward
is
implicit

43. Exceptions: The keyword that begins an exception handler.
PLSQL_OPTIMIZE_LEVEL
EXECUTE IMMEDIATE
same arguments
WHEN

44. Which two of these built-in SQL functions can be used in procedural (PL/SQL) statements: DECODE - CORR - UPPER - SUM - COALESCE - DEREF.
USING
upper - coalesce
aliases
SYS_REFCURSOR

45. You can use the BULK COLLECT INTO clause in a SELECT or a ______.
FETCH
RETURN
SQLERRM
1

46. Bulk: The implicit cursor attribute that gives the number of rows affected by each DML statement in a FORALL statement.
%BULK_ROWCOUNT
COMMIT - ROLLBACK - SAVEPOINT - SET TRANSACTION
cursor variable
E Exception;

47. Types: Which type of arithmetic does PLS_INTEGER use - library or hardware?
statement
hardware
IN OUT
integer

48. Kind of datatypes that support object-oriented programming in PL/SQL.
HTP
NESTED TABLE myColl STORE AS myCollTab
Abstract
enclosing

49. Native compilation turns bytecode into ________ code.
32 -000
DML
machine
SQL

50. Wrap iname=xxxx _____=zzzzz
oname
aliases
PUT_LINE
delimiters

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

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