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. To recompile a procedure - use the _____ ______ command.
UTL_FILE
PLS_INTEGER
PLSQL_CCFLAGS
alter procedure

2. PLS_INTEGER has its arithmetic implemented in ________ - so it is very fast.
explicit
constant
hardware
oname

3. Value of a character literal with zero characters.
increment
exception handler
INSTEAD OF

4. This is a CASE (expression / statement): CASE num WHEN 1 THEN goto LABEL1 WHEN 2 THEN var := 2 END CASE;
associative arrays
statement
once
WHEN

5. Types: In addition to the SQL data types - PL/SQL has ___ more scalar data types.
WHEN
4
include
SIMPLE_INTEGER

6. Advantage: Performance: PL/SQL automatically creates ______ variables for variables in WHERE and VALUES clauses.
PL/SQL
unqualified
bind
definer's

7. Cursors: Give the statement to open cursor C.
associative
open C
30
SQL

8. Exceptions: An exception in the declarations section propagates to the enclosing _______.
placeholders
block
sequence pseudo-columns
ALTER SESSION

9. Exceptions: The three words that can be used to guarantee all exceptions will be handled.
1 million
an autonomous routine
WHEN OTHERS THEN
%FOUND - %ISOPEN - %NOTFOUND - %ROWCOUNT

10. Web: The gateway that allows a web browser to invoke a PL/SQL procedure through an HTTP listener.
OPEN
FETCH - INTO
Declaration
PL/SQL Gateway

11. Cursors: A cursor variable's type must be a ____ ______ type.
name-value
not a number
REF CURSOR
literals

12. A GOTO cannot branch into an...
fetch cv into myvar
PLSQL_CCFLAGS
IF - CASE or LOOP
WHERE CURRENT OF

13. The variable showing the user id that is automatically prepended to object names.
CURRENT_USER
PUT
FOR - IN
unconstrained

14. In a record - the internal components are called ______.
can
information that changes infrequently
implicit
fields

15. Abbreviation of invoker's rights
IR
DBMS_PREPROCESSOR
machine
before insert or update on emps

16. Exceptions: Associate exception E with error code -1.
$END
PRAGMA EXCEPTION_INIT (E - -1);
EXECUTE IMMEDIATE
invoker's

17. I/O: SQLPlus command for turning on buffered output.
library
set serveroutput on
compilation
API

18. The BEGIN section is (optional/mandatory)
Wrap
PRAGMA EXCEPTION_INIT (E - -1);
mandatory
CURSOR - RETURN

19. Two types of stored subprograms.
DML
RAISE
procedure - function
4

20. I/O: This package has hypertext functions that generate HTML tags
3
HTF
EXTEND
nested

21. Statement to set current schema to x: _____ _____ SET CURRENT_SCHEMA = 'x';
selection
function f (n number) return number result_cache relies_on (emps);
ALTER SESSION
anonymous block

22. Advantage: PL/SQL is tightly _______ with Oracle SQL.
finishes
is not
associative
integrated

23. To exit an active autonomous transaction without causing an exception - you must issue _____ or ______.
USING
commit - rollback
cursor variable
PL/SQL Gateway

24. _________ exceptions can not be trapped with an error handler
flushed
compile
Declaration
PLS_INTEGER

25. IDs: You can use a reserved word as a _______ user-defined identifier.
include
code
quoted
source code

26. Package for getting the postprocessed source of a program.
PUT
scalable
DBMS_PREPROCESSOR
1 million

27. Bulk: The use of FORALL statements cuts down on ______ traffic.
32 -000
comments
open cv for
network

28. To get the current value of CURRENT_SCHEMA - CURRENT_USER - or SESSION_USER - use the ____ function.
CASE_NOT_FOUND
SYS_CONTEXT
3
;

29. With dynamic typing - type checking is done at ______time.
run
RAISE
integer
always

30. If an initialized collection has no elements - FIRST and LAST return _____.
user-defined

CHARARR
type T is ref cursor

31. After the RESULT_CACHE clause - you can put a _________ clause to enable dependency-checking.
FALSE
$$
TYPE tV IS VARRAY(100) OF NUMBER
RELIES_ON

32. Delimiters: The remote access symbol.
definer's
@
SESSION_USER
DATE

33. IDs: What a quoted user-defined identifier is enclosed in.
for update of
Double quotes.
strong
procedure P AUTHID definer;

34. When a session starts - CURRENT_SCHEMA has the value of the schema owned by ___________.
DML
SESSION_USER
virtual machine
COMMIT - ROLLBACK - SAVEPOINT - SET TRANSACTION

35. The NOCOPY option on an OUT or IN OUT parameter - causes it to be passed by ______.
3
execute immediate
reference
DBMS_PREPROCESSOR

36. DBMS_DDL.WRAP returns a string containing wrapped _____ _____.
'
IN OUT
p.v
source code

37. Value of PLSQL_OPTIMIZE_LEVEL that prevents optimization.
after
-
1
REUSE SETTINGS

38. Declare an output NUMBER parameter - v1 - that defaults to 10.
does not
in the database
Oracle
v1 OUT number default 10

39. Triggers: The clause to make a trigger run before inserting or updating table EMPS.
TYPE tA IS TABLE OF NUMBER INDEX BY VARCHAR2(20)
TRUE - FALSE and NULL
object
before insert or update on emps

40. Subprograms are stored in __________ form.
NEW
p.v
executable
optional

41. The three possible values of a BOOLEAN literal.
currval and nextval
True - false or NULL.
EXIT WHEN
simple

42. I/O: The DBMS_OUTPUT function that writes output WITH a newline character.
p.v
identifiers
obfuscates
PUT_LINE

43. Cursors: What is the 'name' of the implicit cursor?
Declaration
reference
255
SQL

44. In short-circuit evaluation - IF-conditions are only evaluated up to where the outcome ___________.
SESSION_USER
is certain
REF_CURSOR
slower

45. Characters that end a multi-line comment.
*/
currval and nextval
VARRAYs
source code

46. A type of compiler directive - begins with 's'.
strong
does not
selection
pls_integer

47. You cannot bulk collect into an ARRAY OF RECORDS. You can into a ________________ (3 words).
slower
RECORD OF ARRAYS
composite
USER_PLSQL_OBJECT_SETTINGS

48. When a parameter is passed by reference - changes made to it inside the procedure cannot be undone. True/False.
slower
True
%ISOPEN.
must

49. Cursors: You give an explicit cursor a name and associate it with a _______.
query
bind
TIMESTAMP.
for update of

50. A type of compiler directive - begins with 'i'.
inquiry
SQLERRM
CURRENT_USER
static boolean

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