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: Caching of programs and sharing among users lowers _______ requirements.
OPEN_CURSOR
memory
significant
once

2. Dbms_sql: The integer returned by OPEN_CURSOR is a _____ _____.
query
cursor number
DBMS_PREPROCESSOR
boolean

3. I/O: The DBMS_OUTPUT procedure that sets the size of the output buffer.
currval and nextval
ENABLE
%BULK_ROWCOUNT
SUBTYPE n IS number not null;

4. Cursors: Give the first 3 words to open a cursor variable called cv.
'ENABLE:SEVERE' - 'ERROR:06002'
open cv for
NEW
virtual machine

5. I/O: The output from DBMS_OUTPUT will display (during/after) program execution.
definition
after
once
will not

6. To exit an active autonomous transaction without causing an exception - you must issue _____ or ______.
..
commit - rollback
v2 IN NUMBER default 20
END CASE

7. DynSQL: The colon-prefixed names used in EXECUTE IMMEDIATE are called ________.
define
dbms_output.put_line
placeholders
wrap

8. A __________ can have an AUTHID property
package
PLSQL_OPTIMIZE_LEVEL
static
composite

9. The declaration section is (optional/mandatory).
optional
1
E Exception;
rollback to ab

10. To use a TYPE declared in the database - a PL/SQL block has to have _______ privilege on the type.
select
DBMS_CRYPTO
...
reference

11. In Native Mode - PL/SQL code is compiled into ______ ______.
%ROWTYPE
set serveroutput on
machine code
anonymous

12. Cursors: A cursor FOR loop can use an explicit or an _______ cursor.
network
implicit
COUNT
SQL

13. Cursors: What is the 'name' of the implicit cursor?
SQL
will not
do not
literals

14. I/O: This package has hypertext functions that generate HTML tags
do not
HTF
pseudocolumn
INTO

15. The compiler directive used to select which code to compile.
non-editioning views
CURRENT OF
$IF
expression

16. Types: Which type of arithmetic does NUMBER use - library or hardware?
library
cursor number
True - false or NULL.
exit when cgo%NOTFOUND

17. Exceptions: If there is no handler for an exception - PL/SQL returns an ________ exception error to the invoker or host environment.
TYPE rec IS RECORD (num NUMBER - name VARCHAR2(10));
bytecode
invalid
unhandled

18. The NOCOPY option on an OUT or IN OUT parameter - causes it to be passed by ______.
reference
definer's
FOR i IN REVERSE 1..10 LOOP
TYPE tN IS TABLE of NUMBER

19. The command used to populate PLSQL_CCFLAGS.
boolean
not a number
is not
ALTER SESSION

20. Bulk: The keywords of a bulk collect FETCH statement.
FETCH - BULK COLLECT INTO
open C(p)
is certain
lower sub-block

21. Cursors: A cursor that lives in session memory until the session ends.
PLSQL_CCFLAGS
%ISOPEN.
REUSE SETTINGS
session cursor

22. Declare a variable r whose type is that of the records in table t.
statically
FETCH
r t.%ROWTYPE;
definer's

23. Dbms_sql: The DBMS_SQL procedure that closes a cursor.
library
CLOSE_CURSOR
SQL cursor
can

24. Declare an associative array type - t - whose elements are of type rPerson - and whose index is PLS_INTEGER.
server
WHERE CURRENT OF
TYPE t IS TABLE OF rPerson INDEX BY PLS_INTEGER;
can

25. Conditional ______ allows backward compability with older database versions.
compilation
p.v
NUMBER
:=

26. Cursors: The statement that closes a cursor.
single-line
CLOSE
selection
GET_LINES

27. Cursors: You cannot use cursor attributes in _______ statements.
current BEGIN-END block
anonymous
SQL
value

28. Types: ________ data types have internal components.
composite
4
execute immediate
anonymous block

29. A PL/SQL extension to the WHERE clause of the SQL statements UPDATE and DELETE
procedure P AUTHID definer;
1
WHERE CURRENT OF
definer's

30. Advantage: Performance: PL/SQL automatically creates ______ variables for variables in WHERE and VALUES clauses.
VARRAYs
constant
bind
NUMBER

31. An anonymous block is a(n) ____ statement.
virtual machine
associative
SQL
set serveroutput on

32. Exceptions: The maximum length of an Oracle error message is ____ characters
IN
an autonomous routine
512
$$

33. The $IF must evaluate a ______ _______ expression.
current
NDS
static boolean
anonymous

34. Cursors: The first two keywords in a Cursor FOR loop.
FOR - IN
index
literal
1

35. The BETWEEN operator is (inclusive / exclusive).
never
inclusive
4K
function f (n number) return number result_cache relies_on (emps);

36. Advantage: PL/SQL supports ______-oriented programming.
fetch cv into myvar
VARRAY - Nested table
object
%

37. Declaration of a varchar2 constant - called vname - with value 'x'.

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

38. Advantage: Performance: Stored subprograms are ______ in memory.
Server Pages
cached
raise_application_error
EXIT WHEN

39. True encryption is done with package __________.
run
FGA
invoker's
DBMS_CRYPTO

40. After the RESULT_CACHE clause - you can put a _________ clause to enable dependency-checking.
forward
quoted
reference
RELIES_ON

41. The 2 characters that begin all inquiry directives.

$$
SQL cursor
composite

42. In interpreted mode - PL/SQL code is run in a _______ _______.
integer
invalid
bytecode
virtual machine

43. Statement to set current schema to x: _____ _____ SET CURRENT_SCHEMA = 'x';
FETCH
ALTER SESSION
is not
TRUE - FALSE - NULL

44. Cursors: The type definition of a WEAK ref cursor type has no _______ clause.
composite
fetch C into V
REF_CURSOR
RETURN

45. What are two categories of SQL functions that cannot be used in procedural statements?
NEW
DML
ROLLBACK
aggregate - analytical

46. Delimiters: Statement terminator.
elements - type
;
OPEN
ENABLE

47. Cursors: What implicit cursor attribute gives row counts for a FORALL statement?
1 million
%BULK_ROWCOUNT
DBMS_DDL
parameter

48. I/O: Max number of bytes DBMS_OUTPUT can handle in a session.
anonymous
1 million
PLS_INTEGER
bind arguments

49. Command used to execute dynamic SQL.
disable
stored
EXECUTE IMMEDIATE
UTL_HTTP

50. Cursors: Which cursor attribute is not meaningful for an implicit cursor?
...
bytecode
%ISOPEN.
define

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