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. Advantage: Performance: Stored subprograms are ______ in memory.
database
SESSION_USER
bytecode
cached

2. Types: The only Oracle datetime type that doesn't begin with TIMESTAMP is ________.
deletions
expression
DATE
non-editioning views

3. Cursors: What is the 'name' of the implicit cursor?
TYPE t IS TABLE OF rPerson INDEX BY PLS_INTEGER;
SQL
SQLCODE
PLS_INTEGER

4. Cursors: A cursor with a name is an _________ cursor.
bind arguments
r tRec := tRec(9 - 'Jones');
explicit
PSP

5. Cursors: A session cursor that is automatically created and managed by PL/SQL.
source
literals
implicit cursor
explicit cursor

6. Triggers: The clause to make a trigger run after inserting into table EMPS.
nested tables - associative arrays
%BULK_ROWCOUNT
END IF
after insert on emps

7. I/O: The most basic PL/SQL way to give output to the user.
an autonomous routine
dbms_output.put_line
API
query

8. Fundamental: Delimiters are _____ and _____ symbols.
searched
OLD
simple and compound symbols
server

9. Conditional ______ allows backward compability with older database versions.
compilation
HTF
WHEN OTHERS THEN
<> - != - ^=

10. I/O: This package sends text output to SQLPlus
DBMS_OUTPUT
exit when cgo%NOTFOUND
DBMS_PREPROCESSOR
ENABLE

11. Types: The only PL/SQL type for which you can specify a range constraint.
query
BOOLEAN
PLS_INTEGER
$$PLSQL_LINE

12. The 4 keywords in the $IF compiler directive.
order
EXIT WHEN cv%NOTFOUND
$IF $THEN $ELSE $END
anonymous

13. For an associative array - the FIRST method gets the (lowest / first-created) index.
ALTER SESSION
lowest
anonymous block
follows

14. PL/SQL does not automatically create bind variables in ________ SQL.
$END
$$PLSQL_LINE
dynamic
code

15. Default file extension of wrap's output file.
statement
plb
source code
nested

16. Exceptions: An unhandled exception ________ to the enclosing block.
propagates
30
same
index

17. I/O: This package lets PL/SQL programs read and write OS files.
SYS_CONTEXT
r tRec := tRec(9 - 'Jones');
fine-grained auditing
UTL_FILE

18. The EXCEPTION section is (optional/mandatory).
variable
cursor c;
optional
aliases

19. One good use of bind variables is to guard against SQL _______.
injection
collections
open C
implicit

20. Types: One of the 4 PL/SQL things that have a data type (begins with 'p').
NEW
an enclosing block
WHEN
parameter

21. Labels for blocks and statements are enclosed in '__' brackets.
error code
binding
pseudocolumn
<<>>

22. Language that PL/SQL is derived from.
cannot
COUNT
Ada
r t.%ROWTYPE;

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

24. DynSQL: The main command for Native Dynamic SQL.
EXIT WHEN cv%NOTFOUND
order
EXECUTE IMMEDIATE
ROLLBACK

25. In the IF syntax - is if ENDIF or END IF?
%
versions
cursor variable
END IF

26. IDs: What a quoted user-defined identifier is enclosed in.
Oracle
Double quotes.
FETCH - INTO
oname

27. The command used to populate PLSQL_CCFLAGS.
fields
ALTER SESSION
cannot
=

28. Default value of PLSQL_OPTIMIZE_LEVEL.
composite
2
32 -000
decimal

29. Cursors: How many implicit cursors can you access?
current transaction
WHEN
is
1

30. Exceptions: The three words that can be used to guarantee all exceptions will be handled.
FETCH
WHEN OTHERS THEN
cannot
<> - != - ^=

31. When an autonomous routine begins execution - the main transaction is ________.
512
'ENABLE:SEVERE' - 'ERROR:06002'
subtype
suspended

32. Bulk: The use of FORALL statements cuts down on ______ traffic.
pseudocolumn
currval and nextval
network
invalid

33. Delimiters: The assignment operator.
portable
:=
ALTER SESSION
3

34. I/O: The DBMS_OUTPUT procedure that sets the size of the output buffer.
ENABLE
simple
SQLCODE
compilation

35. Types of blocks: Procedures and functions are _______ blocks.
can
order
stored
constructor

36. A CASE expression ends with _____.
cursor
executable
source code
END

37. DBMS_DDL.CREATE_WRAPPED: wraps and _______ the source code passed to it.
must
implicit
compiles
inquiry

38. The three sorts of date/time types are DATE - INTERVAL and _________.
4
ALTER SESSION
TIMESTAMP.
pseudocolumn

39. Fundamental: What is the exponentiation operator?
**
anonymous block
512
DATE '2005-12-25'

40. How many times are a FOR loop's index bounds evaluated?
simple and compound symbols
once
optional
HTF

41. Wrapped code (is / is not) not backward compatible.
nested
selection
is not
SQL cursor

42. Data dictionary view giving the AUTHID values on a user's objects.
USER_PROCEDURES
1 million
fine-grained auditing
invoker's

43. Triggers: You create a trigger with the _______ ________ statement.
DATE
CREATE TRIGGER
DBMS_SESSION.RESET_PACKAGE
implicit

44. SIMPLE_INTEGER is like PLS_INTEGER - but it does not allow ____ values - and it does not raise overflow exceptions.
512
FALSE

run

45. What are the 3 values of the BOOLEAN data type?
procedure P AUTHID current_user;
query
TRUE - FALSE and NULL
static boolean

46. Triggers: The clause to make a trigger run before inserting or updating table EMPS.
dense
ADT
before insert or update on emps
$$PLSQL_LINE

47. The attribute used to get the type of a column or variable without knowing what it is.
binding
ROLLBACK
%TYPE
package

48. Static typing is also called _____ typing.
strong
HTP
SQLPlus
calls

49. To recompile a procedure - use the _____ ______ command.
integer
error code
alter procedure
elements - type

50. Simple CASE statement checks for different values of a single _________
machine
bb:true
expression
information that changes infrequently

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