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. Types: A data type family consists of a ______ type and its subtypes.
bind arguments
anonymous
base
EXIT

2. Cursors: A Cursor FOR loop does not use a ______ statement.
FETCH
Double quotes.
CURRENT OF
placeholders

3. The inquiry directive that gives the current line number in the procedure.
system global area
CURRENT_USER - DEFINER
$$PLSQL_LINE
anonymous block

4. The variable showing the user id that is automatically prepended to object names.
DBMS_PIPE
CASE_NOT_FOUND
inclusive
CURRENT_USER

5. Delimiters: The component indicator/selector.
TIMESTAMP.
unqualified
scalar
.

6. Dbms_sql: The DBMS_SQL procedure that closes a cursor.
fetch C into V
native dynamic
is certain
CLOSE_CURSOR

7. Exceptions: Associate exception E with error code -1.
PRAGMA EXCEPTION_INIT (E - -1);
bind arguments
..
Gateway

8. When an autonomous routine begins execution - the main transaction is ________.
procedure P AUTHID current_user;
1
memory
suspended

9. Types: A ______ has the same valid operations as its base type.
is not
inquiry
external subprogram
subtype

10. Give the first line of the FOR loop with index i going from 1 to 10 in reverse.
cursor c RETURN rC;
FOR i IN REVERSE 1..10 LOOP
for update of
integrated

11. Triggers: You (can/cannot) explicitly invoke a trigger.
..
WHEN
before insert or update on emps
cannot

12. IDs: The type of words that cannot be user-defined identifiers.
EXCEPTION_INIT
Reserved words.
comments
currval and nextval

13. The declaration section is (optional/mandatory).
EXECUTE IMMEDIATE
NESTED TABLE myColl STORE AS myCollTab
optional
FOR - IN

14. Exceptions: An unhandled exception ________ to the enclosing block.
3
USER_PROCEDURES
view
propagates

15. The statement that is used to execute most (native) dynamic SQL.
execute immediate
static
SQLPlus
FETCH

16. A collection is an ordered group of ________ - all of the same ____
-20 -000
elements - type
machine code
explicit

17. Exceptions: The _________ package defines the PL/SQL environment.
RETURN
code
slower
STANDARD

18. Cursors: The two keywords in a mere cursor declaration (one is optional).
CURSOR - RETURN
hardware
query
finishes

19. Loops: What is the index range operator in a FOR loop?
return value
..
SIMPLE_INTEGER
'

20. Exceptions: You cannot GOTO from an exception handler back into the __________ block.
current
follows
same arguments
DATE

21. The PL/SQL ________ evaluates compiler directives.
finishes
preprocessor
FETCH
can

22. Cursors: If you use an EXIT statement to exit a cursor FOR loop prematurely - the cursor (is / is not) closed automatically.
END
aggregate - analytical
is
open C

23. Java - C or other program called directly in PL/SQL.
external subprogram
network
ADT
bind arguments

24. DynSQL: Native Dynamic SQL
NDS
USER_PROCEDURES
PUT_LINE
DML

25. Declare an unconstrained subtype of NUMBER called NUMB.
SUBTYPE numb IS number;
COMMIT - ROLLBACK - SAVEPOINT - SET TRANSACTION
after
IR

26. Exceptions: The built-in procedure for raising an application-defined error.
STANDARD
raise_application_error
slower
same arguments

27. Fundamental: One of the 4 types of lexical units: L_____
cursor variable
include
literals
With a letter.

28. I/O: SQLPlus command for turning on buffered output.
raise_application_error(-20 -100 - 'Bad');
set serveroutput on
finishes
comments

29. I/O: dbms_output.put_line puts output into a _______.
buffer
execute
TYPE tN IS TABLE of NUMBER
CURRENT OF

30. I/O: This package handles HTTP.
can
cursor
iname
UTL_HTTP

31. The two kinds of CASE statements are simple and ________.
source
native dynamic
searched
array

32. Cursors: Opening keyword of a cursor FETCH loop.
3
Gateway
PRAGMA EXCEPTION_INIT (E - -1);
LOOP

33. Command to assign to variables from a cursor.
raise_application_error
single-line
.
FETCH

34. Triggers: In a DML trigger - the phrase that makes the trigger run for every affected record.
255
OPEN_CURSOR
will not
for each row

35. The values defined in PLSQL_CCFLAGS can be referenced as _____ directives.
inquiry
IS
server
CLOSE_CURSOR

36. The first SQL statement in an autonomous routine begins a _______.
WHERE CURRENT OF
transaction
national
DR

37. Define a collection type - tV - which is a varray of 100 NUMBERs.
for update of
TYPE tV IS VARRAY(100) OF NUMBER
COMMIT - ROLLBACK - SAVEPOINT - SET TRANSACTION
return value

38. %ROWTYPE gets the type of a table or _______.
literal
SUBTYPE numb IS number;
cursor
bind

39. An incomplete type only has a ____.
implicit cursor
API
exception handler
name

40. Type: A __________ subtype has only a subset of the values of its base type.
constrained
concatenation
PLSQL_OPTIMIZE_LEVEL
TOO_MANY_ROWS

41. Declare a number variable - A - initialized to 10.
literal
a number := 10
not the same
searched

42. The SET TRANSACTION statement affects only the ____________.
current transaction
cannot
E Exception;
does not

43. Cursors: Give the statement to close cursor C.
end
definer's
INTO
close C

44. Types: PL/SQL has all the _____ data types.
never
order
can
SQL

45. Declare a cursor c with no parameters or return type.
block
%ISOPEN.
DBMS_OUTPUT
cursor c;

46. Characters that begin a multi-line comment.
EVERE - PERFORMANCE - INFORMATIONAL
3
RELIES_ON
/*

47. Exceptions: User-defined exceptions must have _______.
RAISE
names
NDS
will not

48. Cursors: What implicit cursor attribute gives row counts for a FORALL statement?
cursor
constructor
procedure P AUTHID current_user;
%BULK_ROWCOUNT

49. 5 types of events that can have triggers: DML - DDL - INSTEAD OFs - database events - and ________ statements.
specification - body
suspended
PL/SQL Gateway
never

50. Setting CURRENT_SCHEMA only changes what is prepended to __________ references.
explicit cursor
unqualified
associative
IN OUT

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