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 BEGIN section is (optional/mandatory)
v2 IN NUMBER default 20
30
machine
mandatory

2. Fundamental: Which one of these is a compound symbol: = - :=
:=
simple and compound symbols
hardware
EXECUTE IMMEDIATE

3. Types: One of the 4 PL/SQL things that have a data type (begins with 'v').
cannot
variable
DML
HTP

4. A subprogram created inside a block is a _________ subprogram.
parameter
nested
reference
cached

5. If you are in a procedure inside a package - the compilation unit is the _______.
return value
package
iname
PLS_INTEGER

6. To enable result-caching for a function - use the _____________ clause.
DBMS_PREPROCESSOR
composite
literals
RESULT_CACHE

7. To run a PIPE ROW statement in your autonomous routine - you must close any _____________.
autonomous transaction
PLSQL_CCFLAGS
delimiters
SQL cursor

8. Exceptions: Some internal exceptions have ________ names.
explicit cursor
explicit
predefined
:=

9. You cannot bulk collect into an ARRAY OF ________.
PL/SQL Gateway
wrap
RECORDS
CURSOR - RETURN

10. What are the starting and ending keywords of a simple loop?
explicit
LOOP - END LOOP
'
%

11. In a sparse collection - the indexes of defined elements (do / do not) run in consecutive order.
finishes
WHEN
execute
do not

12. The $IF must evaluate a ______ _______ expression.
static boolean
EXECUTE
COUNT
fail

13. Wrap ______=xxxx oname=zzzzz
savepoint ab
iname
comments
order

14. Cursors: Give the statement to fetch data from cursor C into variable V.
SQL
fetch C into V
bb:true
collections - records

15. Advantage: PL/SQL gives SCALABILITY because stored procedures are executed on the _______.
1
server
RECORD OF ARRAYS
FETCH - INTO

16. A PL/SQL block that is not stored.
database
anonymous block
DATE '2005-12-25'
machine

17. Triggers: When using the NEW or OLD pseudo-records in the body of the trigger - they must be prefixed with a _______.
implicit
DBMS_SQL
injection
colon

18. When a parameter is passed by reference - changes made to it inside the procedure cannot be undone. True/False.
INTO
DATE '2005-12-25'
True
EXIT

19. Cursors: An implicit cursor is also called a/n ________ ________ -
1
inclusive
SQL cursor
DBMS_SESSION

20. Cursors: A cursor that lives in session memory until the session ends.
session cursor
create procedure
package
CURRENT OF

21. Types: In addition to the SQL data types - PL/SQL has ___ more scalar data types.
PLSQL_OPTIMIZE_LEVEL
compiles
4
associative arrays

22. Package for getting the postprocessed source of a program.
DBMS_PREPROCESSOR
cursor variable
savepoint ab
loop

23. A ___________ behaves like a table column - but it is not stored in the table.
execute immediate
literal
SQLPlus
pseudocolumn

24. DynSQL: The standard package that does dynamic SQL.
DBMS_DDL
binding
fetch C into V
DBMS_SQL

25. Cursors: Opening keyword of a cursor FETCH loop.
LOOP - END LOOP
RELIES_ON
LOOP
never

26. Exceptions: PL/SQL exceptions are of two types: internal and _________.
255
user-defined
after
CURSOR - RETURN - IS

27. Exceptions: When an exception is raised inside a cursor FOR loop - the cursor is _______ implicitly.
closed
explicit cursor
32 -000
END CASE

28. I/O: The DBMS_OUTPUT buffer will not be flushed until it is full or until the current PL/SQL block _________.
selection
finishes
procedure P AUTHID definer;
*/

29. Fundamental: Labels furnish targets for GOTO and _____ statements.
EXIT
SQLPlus
cursor variable
LOOP

30. For a collection - the NEXT method gets the next higher (element / index).
PL/SQL Gateway
index
propagates
label

31. The allowed data types of user-defined conditional compilation directives are boolean and _______.
VARRAYs
pls_integer
3
is certain

32. Cursors: A cursor FOR loop can use an explicit or an _______ cursor.
BINARY_INTEGER
executable
EXECUTE
implicit

33. I/O: This DBMS_OUTPUT proc retrieves one line from the buffer.
definition
invoker's
do not
GET_LINE

34. The RESULT_CACHE clause has to be in both the declaration and in the ______ of the function.
definition
cannot
FETCH
...

35. A basic PL/SQL datatype that SQL does not have.
$$PLSQL_LINE
boolean
sql
machine

36. An anonymous block is a(n) ____ statement.
bind
SQL
STANDARD
loop

37. Cursors: You cannot use cursor attributes in _______ statements.
dynamic
raise_application_error(-20 -100 - 'Bad');
error code
SQL

38. I/O: The most basic PL/SQL way to give output to the user.
PL/SQL
dbms_output.put_line
before insert or update on emps
TIMESTAMP.

39. The three sorts of date/time types are DATE - INTERVAL and _________.
is not
cursor
TIMESTAMP.
scalable

40. Nested tables can become sparse via ______.
execute immediate
deletions
never
dense

41. I/O: One of the 3 types of data stored in the DBMS_OUTPUT buffer.
cursor
after
bind arguments
DATE

42. True encryption is done with package __________.
UTL_SMTP
COUNT
DBMS_CRYPTO
ordinary

43. What clause makes a compilation default to the PLSQL_CCFLAGS settings from the last compilation?
after
REUSE SETTINGS
searched
*/

44. Clause added to a cursor to use it with WHERE CURRENT OF.
API
static boolean
;
for update of

45. Cursors: If no SELECT or DML statement has run - the value of SQL%ROWCOUNT is what?
.
include
GET_LINE

46. Associative arrays (do / do not) have to be initialized with a constructor.
VARRAY - Nested table
do not
raise_application_error(-20 -100 - 'Bad');
sequence pseudo-columns

47. Exceptions: Start of the range of error codes for RAISE_APPLICATION_ERROR.
-20 -000
END IF
once
FORALL i IN MyList.FIRST..MyList.LAST

48. Cursors: How many implicit cursors can you access?
savepoint ab
simple
1
3

49. A CASE statement ends with ____ ____.
END CASE
an enclosing block
EXECUTE IMMEDIATE
...

50. Cursors: The first two keywords of a basic fetch statement.
manageable
rollback to ab
FETCH - INTO
before insert or update on emps

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

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