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. Cursors: A cursor FOR loop can use an explicit or an _______ cursor.
anonymous block
END
implicit
simple

2. Delimiters: Single-line comment marker.
lock
CHAR - VARCHAR2
*/
-

3. Cursors: Give the statement to open cursor C.
after insert on emps
quoted
open C
v1 OUT number default 10

4. IDs: The 3 non-alphanumeric characters that can be in an ordinary user-defined identifier.
buffer
# - $ - _
1
REF CURSOR

5. To exit an active autonomous transaction without causing an exception - you must issue _____ or ______.
commit - rollback
do not
EXTEND
library

6. Fundamental: One of the 4 types of lexical units: c_____.
fail
comments
aggregate - analytical
%FOUND - %ISOPEN - %NOTFOUND - %ROWCOUNT

7. A CASE statement ends with ____ ____.
END CASE
can
PL/SQL
FETCH

8. 5 types of events that can have triggers: DML - DDL - INSTEAD OFs - database events - and ________ statements.
raise_application_error(-20 -100 - 'Bad');
error code
USER_PROCEDURES
suspended

9. With an sparse - integer-indexed associative array - you (can / cannot) use a regular FOR loop.
block
IF - CASE or LOOP
cannot
DBMS_SQL

10. Types: The storage size of a NUMBER value is based on the number of ______ digits.
for update of
significant
cannot
error code

11. Mode designation for an input/output parameter.
multi-row
compile
FGA
IN OUT

12. Fundamental: Labels furnish targets for GOTO and _____ statements.
anonymous
raise_application_error(-20 -100 - 'Bad');
EXIT
always

13. Types: ______ data types are those storing values with no internal components.
FORALL i IN MyList.FIRST..MyList.LAST
scalar
FOR UPDATE
compile

14. Types: ________ data types have no internal components.
scalar
3
an enclosing block
native dynamic

15. Cursors: The value of SQL%ISOPEN is always ______.
FALSE
fields
exception handler
cached

16. IDs: The two types of words that can - but should not - be used as user-defined identifiers.
%BULK_ROWCOUNT
anonymous block
Keywords and predefined names.
execute

17. A basic PL/SQL datatype that SQL does not have.
boolean
v2 IN NUMBER default 20
injection
lowest

18. Cursors: SYS_REFCURSOR is a predefined type based on _____ ______.
$END
REF CURSOR
elsif
inquiry

19. Cursors: The two keywords in a mere cursor declaration (one is optional).
multi-row
ex := tbl1 MULTISET EXCEPT tbl2
CURSOR - RETURN
1

20. Types: Which type of arithmetic does NUMBER use - library or hardware?
TYPE tV IS VARRAY(100) OF NUMBER
-
REF CURSOR
library

21. Which two collection types are unbounded?
DATE
CURSOR - RETURN
nested tables - associative arrays
32 -000

22. An anonymous block is a(n) ____ statement.
array
SQL
CURRENT OF
delimiters

23. Bytecode is _______ _______ code.
virtual machine
define
DBMS_OUTPUT
implicit cursor

24. User-defined compiler directives are defined in this system compile parameter.
PLSQL_CCFLAGS
decimal
CHAR - VARCHAR2
<> - != - ^=

25. Cursors: Give the statement to fetch data from cursor C into variable V.
PRAGMA EXCEPTION_INIT (E - -1);
%FOUND - %ISOPEN - %NOTFOUND - %ROWCOUNT
portable
fetch C into V

26. The _____ utility turns PL/SQL source code into unreadable text.
error code
Wrap
package
cursor variable

27. Bulk: The use of FORALL statements cuts down on ______ traffic.
network
create
1
scalar

28. Triggers: If two or more triggers are defined with the same timing point - then you can control the firing order using the ________ clause.
v2 IN NUMBER default 20
follows
finishes
'

29. Make a FOR loop that executes NULL 10 times counting in reverse - using index i.
FOR i IN REVERSE 1..10 - LOOP - NULL; END LOOP;
CURRENT_USER - DEFINER
collections
deletions

30. From a block nested inside a procedure P - reference variable V of the outer procedure.
return value
p.v
DML
after

31. Dbms_sql: The integer returned by OPEN_CURSOR is a _____ _____.
GET_LINES
currval and nextval
savepoint ab
cursor number

32. Cursors: An explicit cursor (can/cannot) accept parameters.
can
dense
names
DATE

33. A subprogram defined within another subprogram is a _______ subprogram.
SQLERRM
EVERE - PERFORMANCE - INFORMATIONAL
nested
virtual machine

34. The three possible values of a BOOLEAN literal.
:=
True - false or NULL.
hardware
32 -000

35. Define a collection type - tV - which is a varray of 100 NUMBERs.
query
TYPE tV IS VARRAY(100) OF NUMBER
LOOP - END LOOP
cannot

36. Subprograms are stored in __________ form.
view
Web Toolkit
Reserved words.
executable

37. Cursors: A cursor with a name is an _________ cursor.
EVERE - PERFORMANCE - INFORMATIONAL
explicit
invoker's
# - $ - _

38. Triggers: You create a trigger with the _______ ________ statement.
inquiry
CREATE TRIGGER
hardware
1

39. I/O: If the current (outermost) PL/SQL block ends with an unhandled exception - the output buffer will not be ___________.
COMMIT - ROLLBACK - SAVEPOINT - SET TRANSACTION
flushed
DBMS_DDL
EVERE - PERFORMANCE - INFORMATIONAL

40. Abbreviation for Abstract Data Type.
Ada
deletions
CREATE TYPE
ADT

41. Advantage: PL/SQL runs anywhere Oracle runs - so it is very ________.
dynamic
portable
after insert on emps
RECORDS

42. IDs: How an ordinary user-defined identifier must begin.
dynamic
CURRENT_USER
hardware
With a letter.

43. Conversion: If the specific value is suitable - ____ or _______ values can convert to almost any datatype
CHAR - VARCHAR2
With a letter.
package
L.V

44. The DECLARE keyword is only required in an _______ _______.
anonymous block
suspended
END LOOP
=

45. Exceptions: Write the call (2 args) to associate message 'Bad' with error code -20 -100.

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

46. Command used to execute dynamic SQL.
EXECUTE IMMEDIATE
%ROWTYPE
DBMS_SESSION
Gateway

47. The PL/SQL preprocessor passes ______ code to the compiler.
current transaction
%
block
source

48. Types: A data type family consists of a ______ type and its subtypes.
$$
base
nested tables - associative arrays
/*

49. I/O: The output from DBMS_OUTPUT will display (during/after) program execution.
after
close C
enabled
an autonomous routine

50. For a collection - the NEXT method returns ____ when there is no next index value.
Wrap
$END

CHAR - VARCHAR2

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