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 $ERROR directive is used to make compilation ____.
parameter
fail
LOOP - END LOOP
SQL

2. With static typing - type checking is done at ______ time.
compile
type T is ref cursor
FETCH
cannot

3. Exceptions: A GOTO statement cannot branch into an _______ ________.
exception handler
=>
unhandled
SQL cursor

4. A GOTO cannot branch into a...
OUT
:=
lower sub-block
SQL

5. GOTO branches to a ________.
SYS_CONTEXT
delimiters
composite
label

6. A (simple / searched) CASE statement begins with CASE WHEN <boolean expression>.
Ordinary - Quoted.
ALTER SESSION
aliases
searched

7. Abbreviation for Abstract Data Type.
fields
ADT
1 million
TYPE t IS TABLE OF rPerson INDEX BY PLS_INTEGER;

8. Fundamental: What is the exponentiation operator?
REUSE SETTINGS
COUNT
**
server

9. Exceptions: Declare an exception called E.
an AUTHID property
FORALL i IN MyList.FIRST..MyList.LAST
E Exception;
name

10. SIMPLE_INTEGER is like PLS_INTEGER - but it does not allow ____ values - and it does not raise overflow exceptions.
NESTED TABLE myColl STORE AS myCollTab
aliases
SQLPlus

11. The three possible values of a BOOLEAN literal.
FETCH - BULK COLLECT INTO
native dynamic
True - false or NULL.
calls

12. Wrap iname=xxxx _____=zzzzz
oname
for each row
cursor
RAISE

13. How many PL/SQL collection types are there?
3
nested
Declaration
1

14. DynSQL: In EXECUTE IMMEDIATE - the statement string can use either placeholders - or string ________.
$IF $THEN $ELSE $END
USING
concatenation
package

15. I/O: The DBMS_OUTPUT buffer will not be flushed until it is full or until the current PL/SQL block _________.
statically
CHAR - VARCHAR2
finishes
explicit cursor

16. Cursors: The value of SQL%ISOPEN is always ______.
CREATE TYPE
implicit
FALSE
-

17. Triggers: On a non-editioning view - you can only define __________ triggers.
EXECUTE IMMEDIATE
INSTEAD OF
/*
not a number

18. After the RESULT_CACHE clause - you can put a _________ clause to enable dependency-checking.
RELIES_ON
PLSQL_OPTIMIZE_LEVEL
WHERE CURRENT OF
can

19. I/O: This package sends text output to SQLPlus
COMMIT - ROLLBACK - SAVEPOINT - SET TRANSACTION
simple
DBMS_OUTPUT
collections

20. The _____ and ____ _____ collection types can be used in database table columns.
*/
1 million
error
VARRAY - Nested table

21. This is a CASE (expression / statement): myvar := CASE num WHEN 1 THEN 'good' WHEN 2 THEN 'bad' END;
is
expression
database
pls_integer

22. Clause added to a cursor to use it with WHERE CURRENT OF.
OTHERS
for update of
context
inclusive

23. Declare a package procedure P with no arguments - and give it definer's rights.
%BULK_ROWCOUNT
procedure P AUTHID definer;
fail
autonomous triggers

24. Types: One of the scalar data types specific to PL/SQL: R_________.
simple and compound symbols
implicit
REF_CURSOR
production

25. You can have many autonomous transactions in ___________.
an autonomous routine
fetch cv into myvar
suspended
FOR i IN REVERSE 1..10 LOOP

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

27. Cursors: An explicit cursor (can/cannot) accept parameters.
can
255
subtype
literal

28. Cursors: Give the statement to fetch data from cursor variable CV into MyVar.
EVERE - PERFORMANCE - INFORMATIONAL
commit - rollback
virtual machine
fetch cv into myvar

29. You can define PL/SQL collections using TYPEs defined in the _______.
database
API
value
for update of

30. NAN stands for _________.
not a number
forward
30
anonymous

31. Exceptions: A GOTO statement CAN branch from an exception handler into an ________ block.
include
integrated
end
enclosing

32. A unit with AUTHID = DEFINER is a ________ rights unit.

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

33. Delimiters: The assignment operator.
$IF $THEN $ELSE $END
current BEGIN-END block
:=
varray

34. Simple CASE statement checks for different values of a single _________
expression
fine-grained auditing
label
SQL

35. Types: One of the scalar data types specific to PL/SQL: B_______
IF - CASE or LOOP
BINARY_INTEGER
is
information that changes infrequently

36. Advantage: PL/SQL is PORTABLE to any OS where ________ runs.
Oracle
DBMS_PREPROCESSOR
external subprogram
will not

37. Mode designation for an input parameter.
L.V
DBMS_PIPE
IN
CASE_NOT_FOUND

38. Nested tables can become sparse via ______.
BINARY_INTEGER
anonymous
deletions
STANDARD

39. Fundamental: Delimiters are _____ and _____ symbols.
STANDARD
slower
nested
simple and compound symbols

40. Give the value list in the PLSQL_WARNINGS parameter to turn on SEVERE compiler warnings and make compiler warning 06002 be an error.

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

41. Cursors: Define a ref cursor type called T.
PUT_LINE
EXIT WHEN
cursor c RETURN rC;
type T is ref cursor

42. Assigning values to PL/SQL variables that appear in SQL statements is called _______.
literals
=
fine-grained auditing
binding

43. PL/SQL is a ________ typed programming language.
a number := 10
EXIT WHEN cv%NOTFOUND
associative
statically

44. I/O: This package lets PL/SQL programs read and write OS files.
REF CURSOR
USER_PLSQL_OBJECT_SETTINGS
composite
UTL_FILE

45. Advantage: Performance: PL/SQL automatically creates ______ variables for variables in WHERE and VALUES clauses.
versions
32 -000
bind
aggregate - analytical

46. The EXCEPTION section is (optional/mandatory).
query
statement
BOOLEAN
optional

47. Cursors: A cursor with a name is an _________ cursor.
in the database
explicit
expression
network

48. The attribute used to get the type of a column or variable without knowing what it is.
VARRAY - Nested table
propagates
%TYPE
USER_PROCEDURES

49. Kind of comment not to put in a PL/SQL block to be processed dynamically by an Oracle Precompiler program.
single-line
DBMS_SQL
not the same
index

50. Which collection type is bounded?
cursor variable
varray
PRAGMA EXCEPTION_INIT (E - -1);
1

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