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. Cursors: Statement to end a loop when MyCur is used up: _____ ______ MyCur%NOTFOUND.
null string
END LOOP
EXIT WHEN
injection

2. How many times are a FOR loop's index bounds evaluated?
base
once
4
PSP

3. The compiler directive governing conditional compilation.
vname CONSTANT VARCHAR2 := 'x';
execute
cached
$IF

4. Exceptions: Pragma that links an exception to an Oracle error code.
network
EXCEPTION_INIT
FOR UPDATE
TRUE - FALSE and NULL

5. Fundamental: Which one of these is a compound symbol: = - :=
optional
native dynamic
calls
:=

6. A numeric FOR loop cannot _________ by other than 1?
increment
nested tables - associative arrays
=>
PL/SQL Gateway

7. An autonomous program runs in its own __________.
TYPE tA IS TABLE OF NUMBER INDEX BY VARCHAR2(20)
transaction
for each row
optional

8. Cursors: An explicit cursor (can/cannot) accept parameters.
integrated
DATE '2005-12-25'
inquiry
can

9. Cursors: A cursor FOR loop can use an explicit or an _______ cursor.
error code
current BEGIN-END block
implicit
RECORDS

10. I/O: The string table type in DBMS_OUTPUT for holding lines of text.
CLOSE
numeric and cursor
CHAR - VARCHAR2
CHARARR

11. Packaged constants can synchronize programs through use in _______ directives.
CHAR - VARCHAR2
ROLLBACK
machine code
selection

12. I/O: The output from DBMS_OUTPUT will display (during/after) program execution.
is not
flushed
after
inclusive

13. Into nested table ex - put elements of tbl1 that are not in tbl2.
HTF
ex := tbl1 MULTISET EXCEPT tbl2
DML
Abstract

14. A basic PL/SQL datatype that SQL does not have.
boolean
EXIT WHEN cv%NOTFOUND
view
composite

15. Set flag bb true: ALTER SESSION SET PLSQL_CCFLAGS= '____'
statement
$END
bb:true
delimiters

16. Declare an input NUMBER parameter - v2 - that defaults to 20.
scalable
DML
v2 IN NUMBER default 20
error code

17. Abbreviation of invoker's rights
%BULK_ROWCOUNT
IR
is certain
bind

18. What is the simplest statement for getting out of simple loop?
current BEGIN-END block
open C(p)
TYPE tV IS VARRAY(100) OF NUMBER
EXIT

19. Static typing is also called _____ typing.
cannot
strong
GET_LINES
slower

20. Value of PLSQL_OPTIMIZE_LEVEL that prevents optimization.
1
numeric and cursor
v1 OUT number default 10
cannot

21. The variable showing the user id of the session owner.
SESSION_USER
IN
'
STANDARD

22. Keyword for doing assignment to a variable with SELECT.
INTO
machine
a cursor
$IF $THEN $ELSE $END

23. I/O: This package has hypertext functions that generate HTML tags
HTF
UTL_HTTP
stored
255

24. The _______ package lets you wrap dynamically generated PL/SQL.
searched
DBMS_PIPE
CLOSE
DBMS_DDL

25. ______ SQL is a PL/SQL feature that allows SQL syntax directly in a PL/SQL statement.
set serveroutput on
BINARY_INTEGER
aggregate - analytical
static

26. Triggers: In a trigger - you cannot issue a COMMIT or a ______.
nested
ROLLBACK
Gateway
execute immediate

27. Advantage: PL/SQL supports ______-oriented programming.
anonymous
object
composite
r tRec := tRec(9 - 'Jones');

28. Name the two types of FOR loop.
$$
numeric and cursor
API
Declaration

29. Triggers: An INSTEAD OF trigger (can/cannot) be conditional.
searched
cannot
literal
package

30. Command to assign to variables from a cursor.
FETCH
machine code
UTL_SMTP
not a number

31. Are good for logging table DML operations.
Reserved words.
.
an AUTHID property
autonomous triggers

32. You (can / cannot) wrap trigger source code.
slower
enclosing
autonomous triggers
cannot

33. The _____ and ____ _____ collection types can be used in database table columns.
column
a number := 10
varray
VARRAY - Nested table

34. Cursors: What is the 'name' of the implicit cursor?
value
can
SQL
boolean

35. I/O: This package lets two or more sessions in the same instance communicate.
DBMS_PIPE
ADT
TYPE t IS TABLE OF rPerson INDEX BY PLS_INTEGER;
3

36. The inquiry directive that gives the current line number in the procedure.
$$PLSQL_LINE
END IF
scalar
32 -000

37. Two types of stored subprograms.
L.V
procedure - function
package
implicit

38. TCL: Create a savepoint called ab
savepoint ab
CHARARR
DML
binding

39. Abbreviation for Abstract Data Type.
ADT
Ada
current BEGIN-END block
mandatory

40. User-defined compiler directives are defined in this system compile parameter.
hardware
IN
NDS
PLSQL_CCFLAGS

41. Exceptions: Type ______ to re-raise the current exception.
DML
CLOSE_CURSOR
RAISE
1 million

42. Advantage: PL/SQL runs anywhere Oracle runs - so it is very ________.
portable
255
OTHERS
machine

43. Cursors: The first two keywords of a basic fetch statement.
/*
REF CURSOR
FETCH - INTO
WHEN OTHERS THEN

44. With a result-cached function - it uses a cached value when the function is called again with the...
same arguments
subtype
FOR i IN REVERSE 1..10 - LOOP - NULL; END LOOP;
for each row

45. The AUTHID property applies to PL/SQL objects that contain _____.
will not
code
set serveroutput on
same

46. Pkgs: RESET_PACKAGE only takes effect after the outermost PL/SQL proc that called it ________.
can
TYPE rec IS RECORD (num NUMBER - name VARCHAR2(10));
Abstract
finishes

47. Fundamental: One of the 4 types of lexical units: L_____
scalar
PLSQL_OPTIMIZE_LEVEL
reference
literals

48. DBMS_DDL.CREATE_WRAPPED: wraps and _______ the source code passed to it.
ADT
suspended
compiles
composite

49. The DECLARE keyword is only required in an _______ _______.
EXTEND
anonymous block
$IF $THEN $ELSE $END
=>

50. $$PLSQL_LINE and $$PLSQL_UNIT are ______-ly defined inquiry directives.
is
implicit
subtype
STANDARD

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