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. The PL/SQL ________ evaluates compiler directives.
preprocessor
define
WHERE CURRENT OF
inquiry

2. I/O: The string table type in DBMS_OUTPUT for holding lines of text.
FETCH
integer
CHARARR
cannot

3. Exceptions: The _________ package defines the PL/SQL environment.
STANDARD
associative arrays
1
=>

4. Advantage: PL/SQL gives SCALABILITY because stored procedures are executed on the _______.
PRAGMA EXCEPTION_INIT (E - -1);
bind arguments
server
upper - coalesce

5. Conversion: Just about everything will implicitly convert to _____ or _________.
library
decimal
SIMPLE_INTEGER
CHAR - VARCHAR2

6. DynSQL: Maximum string length to pass to EXECUTE IMMEDIATE.
PSP
index
order
32 -000

7. Types: One of the scalar data types specific to PL/SQL: P________
preprocessor
PLS_INTEGER
loop
specification - body

8. To insert or update on a table that has a collection column - you have to have _______ privilege on the collection type.
Declaration
iname
EXECUTE
$IF

9. _____ arrays cannot be used as the type of an Oracle table column.
cannot
implicit
associative
compilation

10. The declaration section is (optional/mandatory).
optional
single-line
does not
REF_CURSOR

11. Cursors: You can just declare a cursor at first - then _______ it later.
define
fine-grained auditing
Double quotes.
exit when cgo%NOTFOUND

12. Type: An ________ subtype has all the values of its base type.
execute immediate
dbms_output.put_line
unconstrained
32 -000

13. How many PL/SQL collection types are there?
enclosing
IN OUT
3
PUT

14. Triggers: In a DML trigger - the phrase that makes the trigger run for every affected record.
for each row
UTL_SMTP
STANDARD
VARRAYs

15. Delimiters: The component indicator/selector.
flushed
.
after
SQL

16. Records are one of the two kinds of PL/SQL _______ data types.
composite
currval and nextval
specification - body
expression

17. Pkgs: This procedure de-instantiates/resets all packages in this session.
DML
%BULK_ROWCOUNT
DBMS_SESSION.RESET_PACKAGE
4K

18. Cursors: The Oracle predefined REF CURSOR type.
IF - CASE or LOOP
numeric and cursor
SYS_REFCURSOR
DBMS_DDL

19. Triggers: To simulate having triggers on SELECT statements - you can try ___ (3-letter acronym).
FGA
base
4K
network

20. Delimiters: Host variable indicator.
...
a cursor
current transaction
bytecode

21. IDs: The type of words that cannot be user-defined identifiers.
value
open C(p)
Reserved words.
DEFINER

22. In the special IF syntax - is it ELSIF - or ELSEIF?
cannot
elsif
label
BOOLEAN

23. TCL: Undo changes back to savepoint ab.
rollback to ab
predefined
DBMS_PIPE
ALTER SESSION

24. From a block nested inside a procedure P - reference variable V of the outer procedure.
cursor
anonymous
parameter
p.v

25. An ordinary character literal is composed of characters in the ________ character set.
dense
FETCH - BULK COLLECT INTO
an AUTHID property
database

26. The lowest index of a nested table is ___.
:=
$END
bind
1

27. Triggers: An INSTEAD OF trigger (can/cannot) be conditional.
HTF
library
cannot
a number := 10

28. You can have many autonomous transactions in ___________.
network
Gateway
INTO
an autonomous routine

29. An incomplete type only has a ____.
reference
RAISE
context
name

30. Conversion: It is best to use (implicit / explicit) conversion.
explicit
sequence pseudo-columns
comments
TYPE t IS TABLE OF rPerson INDEX BY PLS_INTEGER;

31. The allowed data types of user-defined conditional compilation directives are boolean and _______.
pls_integer
CURSOR - RETURN
STANDARD
FOR i IN REVERSE 1..10 - LOOP - NULL; END LOOP;

32. You (can/cannot) put a label before an END LOOP statement.
FETCH - INTO
expression
cannot
constructor

33. I/O: Max number of bytes to pass in a call to DBMS_OUTPUT.PUT_LINE.
dynamic
bind arguments
255
$$

34. Exceptions: User-defined exceptions must have _______.
%FOUND - %ISOPEN - %NOTFOUND - %ROWCOUNT
EXTEND
:=
names

35. The LIMIT method is only meaningful for _______.
query
VARRAYs
INSTEAD OF
current BEGIN-END block

36. If none of a CASE expression's conditions are TRUE - it returns _____.
OPEN_CURSOR
constant
RESULT_CACHE

37. Language that PL/SQL is derived from.
Ada
DBMS_OUTPUT
explicit
not the same

38. After the RESULT_CACHE clause - you can put a _________ clause to enable dependency-checking.
r tRec := tRec(9 - 'Jones');
TYPE tV IS VARRAY(100) OF NUMBER
RELIES_ON
anonymous

39. A nested table has to be initialized using a ________ - named the same as the type.
expression
vname CONSTANT VARCHAR2 := 'x';
type T is ref cursor
constructor

40. Types: One of the scalar data types specific to PL/SQL: B_______
DATE
invalid
Ordinary - Quoted.
BINARY_INTEGER

41. Cursors: An implicit cursor is also called a/n ________ ________ -
run
SQL cursor
GET_LINE
DBMS_SESSION

42. Which two collection types are unbounded?
after
nested tables - associative arrays
RECORDS
EXCEPTION_INIT

43. Cursors: A session cursor that is automatically created and managed by PL/SQL.
implicit cursor
WHERE CURRENT OF
current
RETURN

44. The FORALL statement to loop over a collection MyList using index i.
deletions
FORALL i IN MyList.FIRST..MyList.LAST
procedure P AUTHID definer;
1

45. Exceptions: The ________ function returns the error message associated with an error code.
4K
SQLERRM
current
definer's

46. Characters that begin a multi-line comment.
/*
anonymous block
do not
CLOSE_CURSOR

47. The collection method that tells the number of elements in the collection.
calls
BINARY_INTEGER
COUNT
run

48. To exit an active autonomous transaction without causing an exception - you must issue _____ or ______.
commit - rollback
procedure P AUTHID definer;
STANDARD
for update of

49. With conditional compilation you can avoid compiling debug code in the _______ environment.
column
'ENABLE:SEVERE' - 'ERROR:06002'
production
static boolean

50. Characters that begin a single-line comment.
-
DBMS_PIPE
explicit
savepoint ab

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