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. Exceptions: Type ______ to re-raise the current exception.
can
HTP
RAISE
EXCEPTION_INIT

2. The FORALL statement to loop over a collection MyList using index i.
FORALL i IN MyList.FIRST..MyList.LAST
before insert or update on emps
fetch cv into myvar
pseudocolumn

3. The three types of compiler warnings.
EVERE - PERFORMANCE - INFORMATIONAL
DBMS_SESSION.RESET_PACKAGE
NUMBER
exception handler

4. Exceptions: An exception in the declarations section does not go to the __________ section.
follows
lower sub-block
Abstract
exception

5. Dbms_sql: The DBMS_SQL procedure that will execute a DDL or DML statement.
SUBTYPE n IS number not null;
execute
FETCH
Reserved words.

6. Cursors: A session cursor that a PL/SQL user creates and manages.
FETCH
network
include
explicit cursor

7. An incomplete type only has a ____.
name-value
name
IN - OUT - IN OUT
cannot

8. Delimiters: The association operator.
error code
SQLPlus
not a number
=>

9. The EXCEPTION section is (optional/mandatory).
optional
memory
CURRENT_USER
SYS_CONTEXT

10. Triggers: An INSTEAD OF trigger (can/cannot) be conditional.
<<
cannot
2
IN

11. Exceptions: An exception in the declarations section propagates to the enclosing _______.
EXIT WHEN
hardware
v1 OUT number default 10
block

12. Exceptions: The maximum length of an Oracle error message is ____ characters
WHEN OTHERS THEN
open C
512
WHERE CURRENT OF

13. Cursors: The two keywords in a mere cursor declaration (one is optional).
rollback to ab
array
CURSOR - RETURN
index

14. I/O: This package does email.
UTL_SMTP
nested tables - associative arrays
can
RAISE

15. Characters that begin a multi-line comment.
SIMPLE_INTEGER
/*
disable
identifiers

16. Cursors: A cursor FOR loop cannot use a _______ variable.
cursor
-20 -000
versions
null string

17. With static typing - type checking is done at ______ time.
bind arguments
simple and compound symbols
compile
unconstrained

18. Cursors: You can just declare a cursor at first - then _______ it later.
after
define
selection
DBMS_CRYPTO

19. Subprograms are stored in __________ form.
DBMS_SQL
does not
executable
Declaration

20. Exceptions: The keyword that begins an exception handler.
END LOOP
flushed
boolean
WHEN

21. Types of blocks: Procedures and functions are _______ blocks.
r t.%ROWTYPE;
pls_integer
Gateway
stored

22. Bulk: The two features that comprise Bulk SQL are:
define
SUBTYPE numb IS number;
FORALL and BULK COLLECT
index

23. A type of compiler directive - begins with 'i'.
name and datatype
inquiry
VARCHAR2
True

24. Cursors: What is the 'name' of the implicit cursor?
comments
255
context
SQL

25. Define a record variable r - of type tRec - initialized with values 9 and 'Jones' in its two fields.

Warning: Invalid argument supplied for foreach() in /var/www/html/basicversity.com/show_quiz.php on line 183

26. Dbms_sql: The integer returned by OPEN_CURSOR is a _____ _____.
associative
for update of
cursor number
oname

27. Types: One of the scalar data types specific to PL/SQL: P________
PLS_INTEGER
concatenation
IN
USER_PROCEDURES

28. Two types of stored subprograms.
context
system global area
cursor variable
procedure - function

29. Static typing is also called _____ typing.
ADT
executable
DBMS_SESSION
strong

30. Give the statement to make a program autonomous.
PRAGMA AUTONOMOUS_TRANSACTION;
significant
unhandled
object

31. The attribute used to get the type of a row without knowing what it is.
TOO_MANY_ROWS
variable
CURRENT_USER
%ROWTYPE

32. I/O: This package lets PL/SQL programs read and write OS files.
UTL_FILE
INSTEAD OF
WHEN
SQL

33. Triggers: By default - a trigger is created in the ______ state.
enabled
=
execute
*/

34. DynSQL: The standard package that does dynamic SQL.
FETCH
DBMS_SQL
in the database
parameter

35. Packaged constants can synchronize programs through use in _______ directives.
object
cannot
CASE_NOT_FOUND
selection

36. I/O: Max number of bytes DBMS_OUTPUT can handle in a session.
1 million
user-defined
EXIT
invoker's

37. IDs: What a quoted user-defined identifier is enclosed in.
current BEGIN-END block
does not
flushed
Double quotes.

38. Characters that begin a single-line comment.
select
column
-
NESTED TABLE myColl STORE AS myCollTab

39. Conversion: Just about everything will implicitly convert to _____ or _________.
CHAR - VARCHAR2
deletions
open C(p)
255

40. The declaration section is (optional/mandatory).
reference
end
predefined
optional

41. If an initialized collection has no elements - FIRST and LAST return _____.

REUSE SETTINGS
%BULK_ROWCOUNT
invoker's

42. The inquiry directive that gives the current line number in the procedure.
package
close C
$$PLSQL_LINE
SQL

43. Assigning values to PL/SQL variables that appear in SQL statements is called _______.
unconstrained
anonymous block
binding
EXECUTE IMMEDIATE

44. Cursors: A cursor with a name is an _________ cursor.
CURRENT_USER - DEFINER
explicit
HTP
can

45. Simple CASE statement checks for different values of a single _________
expression
anonymous block
With a letter.
v3 IN OUT NUMBER

46. With conditional compilation you can avoid compiling debug code in the _______ environment.
production
IR
reference
FOR - IN

47. VARRAYs are (always / never) sparse.
never
placeholders
implicit
can

48. Cursors: An explicit cursor (can/cannot) accept parameters.
can
expression
PVM
set serveroutput on

49. The 2 characters that begin all inquiry directives.
fine-grained auditing
%FOUND - %ISOPEN - %NOTFOUND - %ROWCOUNT
$$
a cursor

50. Conditional ______ allows backward compability with older database versions.
compilation
/*
inclusive
source code

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