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 _____ utility turns PL/SQL source code into unreadable text.
Wrap
fields
<> - != - ^=
DATE '2005-12-25'

2. Web: mod_plsql is an _______ module.
cannot
RELIES_ON
Apache
FETCH

3. List the transaction control statements.
EXECUTE IMMEDIATE
fetch cv into myvar
COMMIT - ROLLBACK - SAVEPOINT - SET TRANSACTION
3

4. FOR-Looping over a collection from FIRST to LAST only works if the collection is _______.
dense
native dynamic
DBMS_PIPE
collections - records

5. Triggers: The clause to make a trigger run once for every affected row.
for each row
=
raise_application_error
select

6. Advantage: PL/SQL programs are stored centrally - making them more ______.
significant
FETCH
anonymous
manageable

7. How many types of compiler directives are there?
invoker's
EXIT WHEN
3
v3 IN OUT NUMBER

8. Cursors: You cannot use cursor attributes in _______ statements.
SQL
OTHERS
@
VARRAYs

9. A large OUT or IN OUT parameter will waste a lot of space and CPU if it is passed by _____.
index
OPEN_CURSOR
CASE_NOT_FOUND
value

10. Wrapped code (is / is not) not backward compatible.
is not
concatenation
open C(p)
OTHERS

11. One good use of bind variables is to guard against SQL _______.
fields
injection
open cv for
<<

12. The declaration section is (optional/mandatory).
PLS_INTEGER
optional
USER_PLSQL_OBJECT_SETTINGS
FGA

13. True encryption is done with package __________.
DBMS_CRYPTO
DBMS_SESSION.RESET_PACKAGE
value
scalable

14. Types: ______ data types are those storing values with no internal components.
255
OUT
scalar
sql

15. Cursors: Give the statement to fetch data from cursor variable CV into MyVar.
placeholders
fetch cv into myvar
COUNT
FORALL and BULK COLLECT

16. The source for wrapping begins with the word ______.
EXCEPTION_INIT
view
session cursor
create

17. IDs: You (can/cannot) use keywords as ordinary user-defined identifiers.
executable
searched
fine-grained auditing
can

18. Exceptions: The ________ handler must always be the last handler.
FOR i IN REVERSE 1..10 LOOP
FETCH - BULK COLLECT INTO
OTHERS
anonymous

19. A pointer to a private SQL area that stores information about processing a specific SELECT or DML statement.
flushed
cursor
query
compilation

20. A GOTO statement cannot branch from an exception handler back into the...
reference
current BEGIN-END block
elements
FOR i IN REVERSE 1..10 - LOOP - NULL; END LOOP;

21. A basic PL/SQL datatype that SQL does not have.
statement
composite
30
boolean

22. Types: One of the 4 PL/SQL things that have a data type (begins with 'v').
variable
DBMS_PIPE
forward
COUNT

23. Packaged constants can synchronize programs through use in _______ directives.
COUNT
selection
CHARARR
CREATE TYPE

24. Triggers: You create a trigger with the _______ ________ statement.
concatenation
'
CREATE TRIGGER
SQL

25. The inquiry directive that gives the current line number in the procedure.
$$PLSQL_LINE
national
END LOOP
%ISOPEN.

26. Characters that end a multi-line comment.
*/
current transaction
constructor
SQL

27. Exceptions: An exception raised inside an _______ _______ propagates immediately to the enclosing block
selection
FETCH - BULK COLLECT INTO
exception handler
ex := tbl1 MULTISET EXCEPT tbl2

28. The DEFINITION of a cursor is the _____ that returns the records.
run
query
1
ALTER SESSION

29. INSTEAD OF triggers are alternatives to ___ triggers
DML
inclusive
selection
cursor variable

30. An autonomous program runs in its own __________.
transaction
end
enclosing
r tRec := tRec(9 - 'Jones');

31. If a result-cached function's data source (based on the RELIES_ON clause) is updated - any cached results become _______.
VARRAY - Nested table
r tRec := tRec(9 - 'Jones');
.
invalid

32. Delimiters: the attribute indicator.
Double quotes.
PRAGMA AUTONOMOUS_TRANSACTION;
%
forward

33. PLSQL_CCFLAGS hold a comma-separated list of ______ pairs (hyphenated).
$$
OUT
name-value
cursor c RETURN rC;

34. The variable showing the user id of the session owner.
SESSION_USER
placeholders
is certain
composite

35. Advantage: Having procedures stored and executed on the server makes PL/SQL ________.
run
HTF
scalable
CLOSE

36. A CASE statement ends with ____ ____.
cannot
BINARY_INTEGER
32 -000
END CASE

37. Types of blocks: A pl/sql block that is not stored in the database.
TYPE rec IS RECORD (num NUMBER - name VARCHAR2(10));
anonymous
SQL
quoted

38. Exceptions: If there is no handler for an exception - PL/SQL returns an ________ exception error to the invoker or host environment.
L.V
Server Pages
unhandled
bb:true

39. What are the two sequence pseudo-columns?
currval and nextval
server
Keywords and predefined names.
implicit

40. The names of Java objects in Oracle can be up to __ characters in length.
integer
4K
suspended
lowest

41. Two types of stored subprograms.
CHAR - VARCHAR2
procedure - function
DATE
WHEN

42. A PL/SQL extension to the WHERE clause of the SQL statements UPDATE and DELETE
SQL
PRAGMA AUTONOMOUS_TRANSACTION;
stored
WHERE CURRENT OF

43. What is the simplest statement for getting out of simple loop?
VARCHAR2
EXIT
server
preprocessor

44. Exceptions: An exception in the declarations section propagates to the enclosing _______.
block

network
INTO

45. DynSQL: The three modes of arguments in the USING clause of EXECUTE IMMEDIATE.
CHAR - VARCHAR2
nested
library
IN - OUT - IN OUT

46. The $IF must evaluate a ______ _______ expression.
PUT
enclosing
name-value
static boolean

47. This is a CASE (expression / statement): CASE num WHEN 1 THEN goto LABEL1 WHEN 2 THEN var := 2 END CASE;
unqualified
anonymous
integrated
statement

48. DynSQL: The standard package that does dynamic SQL.
for each row
DBMS_SQL
collections
EVERE - PERFORMANCE - INFORMATIONAL

49. Cursors: WHERE _______ ______ makes an UPDATE or DELETE apply to the current row of a cursor.
bytecode
code
WHEN
CURRENT OF

50. An anonymous block is a(n) ____ statement.
production
SQL
FOR i IN REVERSE 1..10 LOOP
searched

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