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. How to reference a variable V declared in a block labelled L: ____.
EXTEND
L.V
ADT
virtual machine

2. Keyword for doing assignment to a variable with SELECT.
INTO
CURRENT_USER
alter procedure
FOR i IN REVERSE 1..10 LOOP

3. Cursors: Give the statement to close cursor C.
REF_CURSOR
HTF
CURSOR - RETURN - IS
close C

4. I/O: This package sends text output to SQLPlus
EXTEND
DBMS_OUTPUT
30
elements - type

5. A (simple / searched) CASE statement begins with CASE <expression>.
bytecode
for each row
simple
bind arguments

6. TCL: Create a savepoint called ab
savepoint ab
compile
rollback to ab
True

7. I/O: Max number of bytes DBMS_OUTPUT can handle in a session.
unconstrained
invoker's
1 million
FETCH - INTO

8. Triggers: INSTEAD OF triggers only run on ______ views.
non-editioning views
statement
implicit cursor
expression

9. Triggers: The code in a trigger is actually an ________ block.
deletions
anonymous
session cursor
composite

10. An INSTEAD OF trigger is used - e.g - when you want to insert into a complex _____.
PL/SQL Gateway
USING
view
end

11. Advantage: Performance: PL/SQL automatically creates ______ variables for variables in WHERE and VALUES clauses.
3
cannot
bind
FETCH - INTO

12. NAN stands for _________.
cursor variable
inclusive
boolean
not a number

13. Command to assign to variables from a cursor.
do not
FETCH
open C(p)
optional

14. Triggers: A compound trigger can fire at more than one ______ point.
FORALL i IN MyList.FIRST..MyList.LAST
timing
SQL
searched

15. The EXTEND method is not used with ______ _______.
can
BOOLEAN
associative arrays
Declaration

16. Advantage: Having procedures stored and executed on the server makes PL/SQL ________.
$IF
%TYPE
include
scalable

17. Wrapped code (is / is not) not backward compatible.
/*
fail
is not
SQL cursor

18. Unlike the CASE statement - the CASE expression does not have the...
*/
COMMIT - ROLLBACK - SAVEPOINT - SET TRANSACTION
implicit CASE_NOT_FOUND exception
raise_application_error(-20 -100 - 'Bad');

19. DynSQL: EXECUTE IMMEDIATE does both dynamic SQL and dynamic _______.
injection
scalable
simple and compound symbols
PL/SQL

20. Cursors: The keyword that makes a ref cursor type STRONG.
associative
**
RETURN
SQL

21. Cursors: The second keyword of a FETCH statement.
%ROWTYPE
PLSQL_OPTIMIZE_LEVEL
LOOP - END LOOP
INTO

22. The EXCEPTION section is (optional/mandatory).
optional
binding
cannot

23. Exceptions: You cannot GOTO from an exception handler back into the __________ block.
cached
cannot
current
FORALL i IN MyList.FIRST..MyList.LAST

24. The FOR UPDATE OF clause references a (table / column).
IF - CASE or LOOP
column
name and datatype
savepoint ab

25. Types: The PL/SQL type that is identical to PLS_INTEGER.
elements - type
constructor
BINARY_INTEGER
selection

26. Abbreviation of invoker's rights
IR
REUSE SETTINGS
Reserved words.
RETURN

27. When a parameter is passed by reference - changes made to it inside the procedure cannot be undone. True/False.
True
p.v
names
ex := tbl1 MULTISET EXCEPT tbl2

28. Web: Abbreviation of PL/SQL Server Page.
placeholders
PSP
COUNT
query

29. The lowest index of a VARRAY is ___.
is
1
exception
compilation

30. An INSTEAD OF trigger specifies what to do instead of a ___ statement.
source
VARRAY - Nested table
DML
cannot

31. Cursors: The SQL%BULK_ROWCOUNT attribute is an _________ -
create procedure
array
4K
enabled

32. Cursors: Give the statement for getting out of a FETCH loop for cursor CV.
do not
INTO
SQLCODE
EXIT WHEN cv%NOTFOUND

33. In interpreted mode - PL/SQL code is run in a _______ _______.
commit - rollback
FETCH
virtual machine
database

34. The BETWEEN operator is (inclusive / exclusive).
PLSQL_CCFLAGS
in the database
inclusive
RETURN

35. The values defined in PLSQL_CCFLAGS can be referenced as _____ directives.
inquiry
1
index
code

36. The names of Java objects in Oracle can be up to __ characters in length.
propagates
4K
implicit
DML

37. Types: In addition to the SQL data types - PL/SQL has ___ more scalar data types.
type T is ref cursor
4
INTO
cannot

38. A FOR loop can be indexed by numbers or by a ______.
expression
binding
cursor
'ENABLE:SEVERE' - 'ERROR:06002'

39. Declare an output NUMBER parameter - v1 - that defaults to 10.
ROLLBACK
include
cursor
v1 OUT number default 10

40. 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

41. The declaration section is (optional/mandatory).
PLS_INTEGER
cached
optional
OPEN_CURSOR

42. Triggers: There are __ types of triggers.
DR
5
user-defined
cannot

43. VARRAYs are (always / never) sparse.
never
placeholders
invoker's
variable

44. INSTEAD OF triggers are alternatives to ___ triggers
associative
RETURN
DML
before insert or update on emps

45. Types: The predefined subtype of PLS_INTEGER that has the NOT NULL constraint.
transaction
SIMPLE_INTEGER
END
1

46. Cursors: A session cursor that a PL/SQL user creates and manages.
flushed
explicit cursor
versions
WHEN OTHERS THEN

47. A type of compiler directive - begins with 's'.
virtual machine
$IF
selection
value

48. DynSQL: The main command for Native Dynamic SQL.
FALSE
OUT
WHEN OTHERS THEN
EXECUTE IMMEDIATE

49. Define a nested table type - tN - which is a table NUMBERs.
L.V
TYPE tN IS TABLE of NUMBER
database
fine-grained auditing

50. Into nested table ex - put elements of tbl1 that are not in tbl2.
bb:true
user-defined
ex := tbl1 MULTISET EXCEPT tbl2
%FOUND - %ISOPEN - %NOTFOUND - %ROWCOUNT

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