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. Exceptions: The three words that can be used to guarantee all exceptions will be handled.
WHEN OTHERS THEN
suspended
quoted
upper - coalesce

2. Conditional ______ allows backward compability with older database versions.
compilation
1 million
INSTEAD OF
must

3. Associative arrays (do / do not) have to be initialized with a constructor.
do not
cursor c RETURN rC;
r tRec := tRec(9 - 'Jones');
anonymous block

4. Bulk: The implicit cursor attribute that gives the number of rows affected by each DML statement in a FORALL statement.
%BULK_ROWCOUNT
lowest
END LOOP
pls_integer

5. Declare an input/output NUMBER parameter - v3.
HTP
v3 IN OUT NUMBER
DBMS_PREPROCESSOR
not the same

6. Types: The only PL/SQL type for which you can specify a range constraint.
OTHERS
PLS_INTEGER
RECORDS
REF CURSOR

7. To enable result-caching for a function - use the _____________ clause.
associative
RESULT_CACHE
invoker's
upper - coalesce

8. Command to create a procedure.
FETCH - BULK COLLECT INTO
create procedure
end
..

9. What clause makes a compilation default to the PLSQL_CCFLAGS settings from the last compilation?
constant
specification - body
REUSE SETTINGS
EXECUTE

10. A collection is an ordered group of ________ - all of the same ____
elements - type
REF CURSOR
True - false or NULL.
currval and nextval

11. The valid values of the AUTHID property.
..
numeric and cursor
before insert or update on emps
CURRENT_USER - DEFINER

12. Exceptions: When an exception is raised inside a cursor FOR loop - the cursor is _______ implicitly.
savepoint ab
inquiry
closed
exception handler

13. To use a TYPE declared in the database - a PL/SQL block has to have _______ privilege on the type.
END LOOP
is
numeric and cursor
select

14. NAN stands for _________.
not a number
Server Pages
include
optional

15. Web: PL/SQL ______ ______ (PSPs) let you develop web pages with dynamic content.
EXIT
Server Pages
EXECUTE IMMEDIATE
dynamic

16. Cursors: You give an explicit cursor a name and associate it with a _______.
integrated
query
names
FETCH

17. What is the exception that is implicitly raised in a CASE statement with no ELSE clause?
FOR UPDATE
CASE_NOT_FOUND
numeric and cursor
RESULT_CACHE

18. You (can/cannot) put a label before an END LOOP statement.
v1 OUT number default 10
Ordinary - Quoted.
EVERE - PERFORMANCE - INFORMATIONAL
cannot

19. Cursors: The FOR UPDATE phrase goes at the (beginning/end) of the cursor definition.
DR
cannot
is not
end

20. How many times are a FOR loop's index bounds evaluated?
once
DML
optional
cursor

21. The three types of compiler warnings.
machine
1 million
EVERE - PERFORMANCE - INFORMATIONAL
FOR i IN REVERSE 1..10 - LOOP - NULL; END LOOP;

22. I/O: One of the 3 types of data stored in the DBMS_OUTPUT buffer.
virtual machine
%TYPE
DATE
IS

23. True encryption is done with package __________.
order
EXIT WHEN
%BULK_ROWCOUNT
DBMS_CRYPTO

24. Wrapped code (is / is not) not backward compatible.
virtual machine
$$PLSQL_LINE
cursor
is not

25. Mode designation for an input/output parameter.
3
value
unqualified
IN OUT

26. Fundamental: Maximum string length of a PL/SQL variable.
nested
32 -000
exception
binding

27. Cursors: The SQL%BULK_ROWCOUNT attribute is an _________ -
in the database
array
versions
deletions

28. Cursors: WHERE _______ ______ makes an UPDATE or DELETE apply to the current row of a cursor.
WHERE CURRENT OF
rollback to ab
1
CURRENT OF

29. DynSQL: Native Dynamic SQL
NDS
cursor number
autonomous triggers
IN OUT

30. To recompile a procedure - use the _____ ______ command.
ROLLBACK
include
alter procedure
$$PLSQL_LINE

31. The variable showing the user id of the session owner.
for update of
aggregate - analytical
SESSION_USER
return value

32. A PL/SQL block that is not stored.
anonymous block
cannot
nested tables - associative arrays
SYS_CONTEXT

33. Cursors: Give the statement to open cursor C that takes parameter p.
machine
mandatory
;
open C(p)

34. The RESULT_CACHE clause comes (before / after) the RETURN clause.
implicit
GET_LINE
after
scalar

35. A subprogram defined within another subprogram is a _______ subprogram.
nested
collections - records
Wrap
disable

36. Cursors: Give the statement to open cursor C.
elements
FOR UPDATE
DR
open C

37. Give the ANSI Date literal for December 25 - 2005.

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

38. You can have many autonomous transactions in ___________.
executable
compiles
EXIT WHEN cv%NOTFOUND
an autonomous routine

39. The default value of the AUTHID property.
statement
DEFINER
multi-row
DATE

40. Exceptions: You cannot GOTO from an exception handler back into the __________ block.
expression
TRUE - FALSE and NULL
an AUTHID property
current

41. Pkgs: The _______ package gives access to such SQL things as ALTER SESSION.
DBMS_SESSION
Web Toolkit
scalar
/*

42. I/O: The DBMS_OUTPUT procedure that sets the size of the output buffer.
Double quotes.
EXTEND
ENABLE
LOOP

43. What are the starting and ending keywords of a simple loop?
literals
static
is certain
LOOP - END LOOP

44. DynSQL: The main command for Native Dynamic SQL.
an AUTHID property
drop procedure
cannot
EXECUTE IMMEDIATE

45. You (can / cannot) wrap trigger source code.
cannot
PLSQL_CCFLAGS
elements - type
associative

46. Data dictionary view that shows the compiler settings for each compiled object.
RETURN
USER_PLSQL_OBJECT_SETTINGS
DBMS_SESSION.RESET_PACKAGE
manageable

47. The $ERROR directive is used to make compilation ____.
fail
finishes
UTL_SMTP
compilation

48. Fundamental: Which one of these is a simple symbol: a - = - !=
REUSE SETTINGS
=
Keywords and predefined names.
DBMS_SESSION

49. DBMS_DDL.WRAP returns a string containing wrapped _____ _____.
column
PLSQL_CCFLAGS
source code
decimal

50. Advantage: Performance: Stored subprograms are ______ in memory.
cached
RETURN
DML
function f (n number) return number result_cache relies_on (emps);

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