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. Fundamental: One of the 4 types of lexical units: i_____
identifiers
calls
OUT
REUSE SETTINGS

2. PLS_INTEGER has its arithmetic implemented in ________ - so it is very fast.
after
hardware
fail
variable

3. Characters that end a multi-line comment.
cursor c;
*/
finishes
CLOSE

4. Cursors: WHERE _______ ______ makes an UPDATE or DELETE apply to the current row of a cursor.
;
CURRENT OF
rollback to ab
specification - body

5. This is a CASE (expression / statement): myvar := CASE num WHEN 1 THEN 'good' WHEN 2 THEN 'bad' END;
expression
virtual machine
unconstrained
HTF

6. _____ arrays cannot be used as the type of an Oracle table column.
drop procedure
associative
buffer
autonomous transaction

7. The lowest index of a nested table is ___.
v2 IN NUMBER default 20
1
versions
portable

8. INSTEAD OF triggers are alternatives to ___ triggers
WHERE CURRENT OF
INTO
DML
anonymous

9. Parameter that controls how much Oracle optimizes your PL/SQL code on compilation.
WHERE CURRENT OF
concatenation
cursor
PLSQL_OPTIMIZE_LEVEL

10. An incomplete type is a type created by a ______ type definition.
forward
object
optional
suspended

11. Dbms_sql: This DBMS_SQL function opens a new cursor.
OPEN_CURSOR
PL/SQL
elements
EXIT WHEN

12. For an associative array - the FIRST method gets the (lowest / first-created) index.
SYS_CONTEXT
unqualified
lowest
BINARY_INTEGER

13. Triggers: A compound trigger can fire at more than one ______ point.
nested tables - associative arrays
timing
always
4K

14. The AUTHID property applies to PL/SQL objects that contain _____.
base
OTHERS
LOOP
code

15. Data dictionary view that shows the compiler settings for each compiled object.
USER_PLSQL_OBJECT_SETTINGS
...
FORALL i IN MyList.FIRST..MyList.LAST
1

16. After the RESULT_CACHE clause - you can put a _________ clause to enable dependency-checking.
EVERE - PERFORMANCE - INFORMATIONAL
-
RELIES_ON
slower

17. Exceptions: An exception raised inside an _______ _______ propagates immediately to the enclosing block
DML
exception handler
'ENABLE:SEVERE' - 'ERROR:06002'
cursor

18. By default - OUT and IN OUT parameters are passed by _____.
unhandled
function f (n number) return number result_cache relies_on (emps);
value
PLS_INTEGER

19. Advantage: PL/SQL programs are stored centrally - making them more ______.
composite
obfuscates
...
manageable

20. A FOR-loop counter is defined only within the _____.
HTF
r t.%ROWTYPE;
loop
open C

21. Exceptions: When an exception is raised inside a cursor FOR loop - the cursor is _______ implicitly.
user-defined
exception handler
TYPE tN IS TABLE of NUMBER
closed

22. Set flag bb true: ALTER SESSION SET PLSQL_CCFLAGS= '____'
error
concatenation
EDITION_NAME
bb:true

23. A CASE statement ends with ____ ____.
RAISE
END CASE
EXECUTE IMMEDIATE
manageable

24. Advantage: Having procedures stored and executed on the server makes PL/SQL ________.
PL/SQL Gateway
scalable
null string
anonymous block

25. Web: Abbreviation of PL/SQL Server Page.
SQL
USING
PSP
'

26. A kind of variable used as a placeholder.
LOOP
composite
IN OUT
bind

27. Unlike the CASE statement - the CASE expression does not have the...
implicit CASE_NOT_FOUND exception
name and datatype
scalar
CURRENT_USER

28. Searchable CASE statement: Each WHEN has its own _______ condition.
boolean
:=
memory
index

29. A value that is neither represented by an identifier nor calculated from other values.
literal
FETCH - BULK COLLECT INTO
same arguments
CASE_NOT_FOUND

30. Cursors: A session cursor that a PL/SQL user creates and manages.
calls
variable
is not
explicit cursor

31. IDs: What a quoted user-defined identifier is enclosed in.
Double quotes.
$$PLSQL_LINE
searched
specification - body

32. Exceptions: The maximum length of an Oracle error message is ____ characters
hardware
SUBTYPE numb IS number;
FETCH
512

33. Default file extension of wrap's output file.
COMMIT - ROLLBACK - SAVEPOINT - SET TRANSACTION
external subprogram
plb
optional

34. In a collection - the internal components are called _______.
255
dense
elements
FETCH

35. A SELECT statement with the FOR UPDATE clause puts a ______ on the selected rows.
system global area
rollback to ab
lock
flushed

36. The _______ package lets you wrap dynamically generated PL/SQL.
4
DBMS_DDL
in the database
aggregate - analytical

37. Mode designation for an input/output parameter.
IN OUT
package
cursor
..

38. In PL/SQL - what the variables in DML statements are turned into.
transaction
bind arguments
oname
after

39. Conversion: Implicit conversion can be (faster / slower) than explicit conversion.
Wrap
function f (n number) return number result_cache relies_on (emps);
slower
lock

40. Types: The storage size of a NUMBER value is based on the number of ______ digits.
significant
an AUTHID property
FETCH
query

41. %ROWTYPE gets the type of a table or _______.
order
cursor
dynamic
EXECUTE IMMEDIATE

42. Cursors: Only a _____ _____ cursor can appear in the CURRENT OF clause of an UPDATE or DELETE statement.
FOR UPDATE
composite
return value
compile

43. Advantage: Performance: Storing and runnng procedures on the server minimizes ______ traffic.
RAISE
must
quoted
network

44. Give the statement to make a program autonomous.
PRAGMA AUTONOMOUS_TRANSACTION;
HTF
EXTEND
do not

45. I/O: Max number of bytes DBMS_OUTPUT can handle in a session.
PUT_LINE
SYS_CONTEXT
'
1 million

46. I/O: One of the 3 types of data that can be passed to the DBMS_OUTPUT buffer.
DECLARE - BEGIN - EXCEPTION - END
VARCHAR2
single-line
TRUE - FALSE - NULL

47. A result-cached function caches its results in the _____ _____ ____ (SGA)
SQLPlus
system global area
v1 OUT number default 10
SQL

48. To run TCL or DDL statements - a trigger (must / must not) be autonomous .
must
invoker's
r t.%ROWTYPE;
value

49. The DECLARE keyword is only required in an _______ _______.
TYPE t IS TABLE OF rPerson INDEX BY PLS_INTEGER;
unhandled
identifiers
anonymous block

50. Cursors: The type definition of a WEAK ref cursor type has no _______ clause.
RETURN
enabled
DATE
code

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