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. A (simple / searched) CASE statement begins with CASE <expression>.
ADT
in the database
simple
ex := tbl1 MULTISET EXCEPT tbl2

2. Type: A __________ subtype has only a subset of the values of its base type.
PVM
definer's
Declaration
constrained

3. An autonomous program runs in its own __________.
SYS_CONTEXT
%FOUND - %ISOPEN - %NOTFOUND - %ROWCOUNT
transaction
RETURN

4. Advantage: PL/SQL runs anywhere Oracle runs - so it is very ________.
scalable
portable
fetch cv into myvar
strong

5. I/O: If the current (outermost) PL/SQL block ends with an unhandled exception - the output buffer will not be ___________.
same
flushed
<<>>
suspended

6. _____ arrays cannot be used as the type of an Oracle table column.
associative
do not
...
FALSE

7. The DEFINITION of a cursor is the part after the keyword __.
TYPE tN IS TABLE of NUMBER
array
savepoint ab
IS

8. Exceptions: Associate exception E with error code -1.
%TYPE
PRAGMA EXCEPTION_INIT (E - -1);
collections
RETURN

9. Advantage: Having procedures stored and executed on the server makes PL/SQL ________.
a number := 10
scalable
variable
ENABLE

10. With Edition-based Redefinition enabled - the unique specification of an object requires OWNER - OBJECT_NAME and ___________.
concatenation
EDITION_NAME
DECLARE - BEGIN - EXCEPTION - END
for each row

11. I/O: One of the 3 types of data that can be passed to the DBMS_OUTPUT buffer.
VARCHAR2
...
True - false or NULL.
executable

12. In a FORALL loop - you (can / cannot) use the index variable for purposes other than indexing into the collection.
can
selection
cursor
cannot

13. Advantage: PL/SQL is tightly _______ with Oracle SQL.
integrated
IS
v2 IN NUMBER default 20
decimal

14. The meaning of 'FGA'.
fine-grained auditing
lowest
INTO
compile

15. Cursors: The value of SQL%ROWCOUNT after a SELECT INTO statement returns more than one row.
1
current BEGIN-END block
STANDARD
=

16. PL/SQL is a ________ typed programming language.
4
statically
$IF
compiles

17. Fundamental: identifiers (include/do not include) reserved words.
include
COMMIT - ROLLBACK - SAVEPOINT - SET TRANSACTION
cannot
DATE

18. To run DDL statements - a trigger must be autonomous and must use ______ ______ SQL.
v1 OUT number default 10
native dynamic
r tRec := tRec(9 - 'Jones');
Gateway

19. Types: The only Oracle datetime type that doesn't begin with TIMESTAMP is ________.
DATE
lowest
literals
CREATE TRIGGER

20. I/O: The DBMS_OUTPUT buffer will not be flushed until it is full or until the current PL/SQL block _________.
information that changes infrequently
invoker's
finishes
session cursor

21. Types: The PL/SQL type that is identical to PLS_INTEGER.
anonymous
BINARY_INTEGER
function f (n number) return number result_cache relies_on (emps);
finishes

22. Triggers: You (can/cannot) explicitly invoke a trigger.
cannot
create procedure
dbms_output.put_line
error code

23. DynSQL: The clause that supplies bind arguments to EXECUTE IMMEDIATE.
FALSE
an enclosing block
With a letter.
USING

24. Triggers: The clause to make a trigger run before inserting or updating table EMPS.
server
ex := tbl1 MULTISET EXCEPT tbl2
USING
before insert or update on emps

25. The 2 characters that begin all inquiry directives.
$$
suspended
PVM
propagates

26. Delimiters: the attribute indicator.
parameter
session cursor
%
single-line

27. Triggers: The code in a trigger is actually an ________ block.
ordinary
user-defined
lower sub-block
anonymous

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

29. Fundamental: Labels furnish targets for GOTO and _____ statements.
significant
EXIT
$IF
exception

30. A record is a group of related data items stored in fields - each with its own...
name and datatype
is certain
is
DATE

31. Triggers and views always have _________ rights.

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

32. A value that is neither represented by an identifier nor calculated from other values.
SYS_REFCURSOR
raise_application_error(-20 -100 - 'Bad');
INSTEAD OF
literal

33. What do you FETCH from?
a cursor
variable
an autonomous routine
literal

34. A kind of variable used as a placeholder.
does not
$END
literals
bind

35. True encryption is done with package __________.
STANDARD
elements
DBMS_CRYPTO
v2 IN NUMBER default 20

36. A basic PL/SQL datatype that SQL does not have.
CURRENT_USER - DEFINER
boolean
fetch cv into myvar
'ENABLE:SEVERE' - 'ERROR:06002'

37. Command to assign to variables from a cursor.
FETCH
do not
SUBTYPE n IS number not null;
propagates

38. Subprograms are stored in __________ form.
executable
RETURN
DEFINER
code

39. Triggers: An INSTEAD OF trigger is (always/never) a row-level trigger.
fetch C into V
EVERE - PERFORMANCE - INFORMATIONAL
4K
always

40. IDs: The two types of words that can - but should not - be used as user-defined identifiers.
finishes
Keywords and predefined names.
procedure P AUTHID current_user;
not the same

41. Exceptions: The three words that can be used to guarantee all exceptions will be handled.
WHEN OTHERS THEN
IS
CASE_NOT_FOUND
virtual machine

42. IDs: List the two types of user-defined identifiers.
elsif
cursor variable
Ordinary - Quoted.
database

43. Fundamental: Character used to escape a single quote inside a literal.

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

44. Declare an input/output NUMBER parameter - v3.
v3 IN OUT NUMBER
nested
IN
CURRENT OF

45. Wrapped code (is / is not) not backward compatible.
integer
is not
value
user-defined

46. To run a PIPE ROW statement in your autonomous routine - you must close any _____________.
network
*/
32 -000
autonomous transaction

47. DBMS_DDL.WRAP returns a string containing wrapped _____ _____.
source code
%TYPE
$IF
DML

48. IDs: The type of words that cannot be user-defined identifiers.
Reserved words.
bind
unhandled
bind

49. Exceptions: Type ______ to re-raise the current exception.
RAISE
current BEGIN-END block
TYPE t IS TABLE OF rPerson INDEX BY PLS_INTEGER;
for each row

50. Bulk: The keywords of a bulk collect FETCH statement.
FETCH - BULK COLLECT INTO
RETURN
can
rollback to 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