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 WHEN <boolean expression>.
searched
%BULK_ROWCOUNT
block
same arguments

2. Triggers and views always have _________ rights.

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

3. The RESULT_CACHE clause comes (before / after) the RETURN clause.
definition
must
TYPE tV IS VARRAY(100) OF NUMBER
after

4. Kind of code created by the PL/SQL compiler.
bytecode
an enclosing block
L.V
PLS_INTEGER

5. Advantage: PL/SQL runs anywhere Oracle runs - so it is very ________.
can
portable
fine-grained auditing
will not

6. Bulk: The use of FORALL statements cuts down on ______ traffic.
FETCH
network
DATE
'

7. Data dictionary view that shows the compiler settings for each compiled object.
USER_PLSQL_OBJECT_SETTINGS
invalid
implicit
OTHERS

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

9. Cursors: The statement where you pass the parameters to a cursor.
SQL
OPEN
SQLCODE
PL/SQL Gateway

10. Triggers: You (can/cannot) explicitly invoke a trigger.
cannot
production
return value
PUT

11. Advantage: Caching of programs and sharing among users lowers _______ requirements.
can
integer
API
memory

12. 5 types of events that can have triggers: DML - DDL - INSTEAD OFs - database events - and ________ statements.
DEFINER
definition
suspended
FGA

13. PL/SQL lets you define two kinds of composite data types: _______ and _______
GET_LINES
BOOLEAN
once
collections - records

14. Advantage: PL/SQL is tightly _______ with Oracle SQL.
integrated
numeric and cursor
32 -000
label

15. The RESULT_CACHE clause has to be in both the declaration and in the ______ of the function.
session cursor
is
definition
iname

16. An $ERROR directive ends with _____.
$END
Server Pages
$$
=>

17. I/O: If the current (outermost) PL/SQL block ends with an unhandled exception - the output buffer will not be ___________.
/*
Oracle
END IF
flushed

18. I/O: This package does email.
error code
must
UTL_SMTP
1 million

19. The inquiry directive that gives the current line number in the procedure.
increment
execute immediate
$$PLSQL_LINE
autonomous triggers

20. Cursors: What are the 3 possible values of SQL%FOUND and SQL%NOTFOUND?
an autonomous routine
TRUE - FALSE - NULL
IR
TYPE tN IS TABLE of NUMBER

21. Triggers: The clause to make a trigger run once for every affected row.
library
anonymous
for each row
anonymous

22. In 11g you can directly reference _____________ in PL/SQL.
$$
does not
sequence pseudo-columns
DBMS_DDL

23. What word is in a function header but not in a procedure header?
iname
4K
RETURN
Double quotes.

24. When a parameter is passed by reference - changes made to it inside the procedure cannot be undone. True/False.
True
column
suspended
fields

25. In PL/SQL - what the variables in DML statements are turned into.
index
512
oname
bind arguments

26. Cursors: The first two keywords in a Cursor FOR loop.
SQL
database
FOR - IN
create

27. The source for wrapping begins with the word ______.
cannot
NDS
aliases
create

28. Fundamental: identifiers (include/do not include) reserved words.
include
sequence pseudo-columns
decimal
static

29. I/O: One of the 3 types of data stored in the DBMS_OUTPUT buffer.
is not
procedure - function
WHERE CURRENT OF
NUMBER

30. IDs: List the two types of user-defined identifiers.
does not
integrated
same
Ordinary - Quoted.

31. An editioning view is like an ____ for a table.
API
4K
PLS_INTEGER
cursor

32. The _____ utility turns PL/SQL source code into unreadable text.
1
Wrap
integer
SQL

33. The three sorts of date/time types are DATE - INTERVAL and _________.
cursor
executable
TIMESTAMP.
1 million

34. Delimiters: Statement terminator.
;
END
GET_LINES
rollback to ab

35. (from inside a package) Declare a function f - that takes a number n - returns a number - and caches results - depending on table EMPS.
function f (n number) return number result_cache relies_on (emps);
cannot
current BEGIN-END block
portable

36. Bytecode is _______ _______ code.
hardware
literals
explicit
virtual machine

37. Exceptions: Each internal exception has an Oracle ______ _______.
cursor
error code
cannot
END IF

38. The PL/SQL ________ evaluates compiler directives.
v1 OUT number default 10
preprocessor
open cv for
do not

39. Declare a variable r whose type is that of the records in table t.
closed
hardware
-
r t.%ROWTYPE;

40. IDs: You (can/cannot) use keywords as ordinary user-defined identifiers.
definer's
EDITION_NAME
..
can

41. Give the first line of the FOR loop with index i going from 1 to 10 in reverse.
OTHERS
open C
FOR i IN REVERSE 1..10 LOOP
SESSION_USER

42. Declare a package procedure P with no arguments - and give it invoker's rights.
dbms_output.put_line
savepoint ab
PLSQL_OPTIMIZE_LEVEL
procedure P AUTHID current_user;

43. What do you FETCH from?
an AUTHID property
statically
1
a cursor

44. To get the current value of CURRENT_SCHEMA - CURRENT_USER - or SESSION_USER - use the ____ function.
SYS_CONTEXT
255
anonymous
END

45. Collections are one of the two kinds of PL/SQL _______ data types.
composite
CHARARR
is not
PLS_INTEGER

46. Fundamental: What is the exponentiation operator?
**
execute immediate
TRUE - FALSE and NULL
5

47. Cursors: Give the statement to open cursor C that takes parameter p.
same
searched
UTL_HTTP
open C(p)

48. Exceptions: Declare an exception called E.
STANDARD
fine-grained auditing
can
E Exception;

49. Triggers: You create a trigger with the _______ ________ statement.
TYPE rec IS RECORD (num NUMBER - name VARCHAR2(10));
CREATE TRIGGER
30
integrated

50. With dynamic typing - type checking is done at ______time.
run
RETURN
cursor
explicit

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