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. DBMS_DDL.CREATE_WRAPPED: wraps and _______ the source code passed to it.
create
compiles
Reserved words.
**

2. What is the exception that is implicitly raised in a CASE statement with no ELSE clause?
REF_CURSOR
1 million
STANDARD
CASE_NOT_FOUND

3. The Wrap utility ________ the source code.
include
inquiry
executable
obfuscates

4. Declare an input NUMBER parameter - v2 - that defaults to 20.
v2 IN NUMBER default 20
DR
same arguments
raise_application_error

5. I/O: The DBMS_OUTPUT procedure that sets the size of the output buffer.

RETURN
ENABLE
finishes

6. Cursors: Give the statement to open cursor C.
3
1
open C
%BULK_ROWCOUNT

7. Cursors: The first two keywords of a basic fetch statement.
FETCH - INTO
TOO_MANY_ROWS
must
SUBTYPE numb IS number;

8. The valid values of the AUTHID property.
SESSION_USER
cannot
aggregate - analytical
CURRENT_USER - DEFINER

9. The meaning of 'FGA'.
implicit CASE_NOT_FOUND exception
fine-grained auditing
512
bind arguments

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

11. You (can / cannot) wrap trigger source code.
implicit CASE_NOT_FOUND exception
savepoint ab
cannot
for update of

12. Cursors: A Cursor FOR loop does not use a ______ statement.
FETCH
EXCEPTION_INIT
loop
explicit

13. I/O: This package does email.
@
UTL_SMTP
EDITION_NAME
# - $ - _

14. With a result-cached function - it uses a cached value when the function is called again with the...
raise_application_error(-20 -100 - 'Bad');
Server Pages
END IF
same arguments

15. In PL/SQL - what the variables in DML statements are turned into.
NDS
bind arguments
TYPE tA IS TABLE OF NUMBER INDEX BY VARCHAR2(20)
CURSOR - RETURN

16. Cursors: The value of SQL%ROWCOUNT after a SELECT INTO statement returns more than one row.
SQL
boolean
1
simple and compound symbols

17. The compiler directive governing conditional compilation.
RAISE
dbms_output.put_line
$IF
USER_PROCEDURES

18. IDs: The two types of words that can - but should not - be used as user-defined identifiers.
Keywords and predefined names.
...
numeric and cursor
implicit cursor

19. Fundamental: What are the 3 compound symbols for 'not equal to'?
CLOSE_CURSOR
<> - != - ^=
statement
scalar

20. Statement to exit a cursor loop on cursor cGo when there are no more records.
statement
exit when cgo%NOTFOUND
explicit
RELIES_ON

21. Cursors: The FOR UPDATE phrase goes at the (beginning/end) of the cursor definition.
subtype
not a number
end
machine code

22. Fundamental: Which one of these is a simple symbol: a - = - !=
WHERE CURRENT OF
block
=
after

23. Pkgs: This procedure de-instantiates/resets all packages in this session.
delimiters
Reserved words.
CURRENT OF
DBMS_SESSION.RESET_PACKAGE

24. PL/SQL does not automatically create bind variables in ________ SQL.
dynamic
INTO
unconstrained
null string

25. Types: One of the scalar data types specific to PL/SQL: b_____.
..
BOOLEAN
512
system global area

26. Cursors: The index variable in a cursor FOR loop (does/does not) need to be declared.
does not
Ada
scalar
index

27. The source for wrapping begins with the word ______.
statically
view
injection
create

28. Types: Which type of arithmetic does NUMBER use - library or hardware?
EVERE - PERFORMANCE - INFORMATIONAL
library
searched
DBMS_PREPROCESSOR

29. I/O: Max number of bytes DBMS_OUTPUT can handle in a session.
compile
CREATE TYPE
TYPE tN IS TABLE of NUMBER
1 million

30. How many types of compiler directives are there?
3
DBMS_SQL
255
STANDARD

31. The DECLARE keyword is only required in an _______ _______.
oname
REF_CURSOR
anonymous block
session cursor

32. Cursors: A cursor that lives in session memory until the session ends.
static boolean
session cursor
identifiers
PLS_INTEGER

33. Advantage: PL/SQL programs are stored centrally - making them more ______.
once
GET_LINES
vname CONSTANT VARCHAR2 := 'x';
manageable

34. In short-circuit evaluation - IF-conditions are only evaluated up to where the outcome ___________.
1
bind
FGA
is certain

35. Exceptions: The maximum length of an Oracle error message is ____ characters
procedure P AUTHID current_user;
fields
system global area
512

36. IDs: List the two types of user-defined identifiers.
Ordinary - Quoted.
r t.%ROWTYPE;
EXECUTE IMMEDIATE
network

37. You have to use _______ SQL to run DDL statements n PL/SQL.
dynamic
HTP
Apache
closed

38. You cannot bulk collect into an ARRAY OF ________.

RECORDS
32 -000
INTO

39. If none of a CASE expression's conditions are TRUE - it returns _____.
loop
open cv for
rollback to ab

40. A national character literal is composed of characters in the ________ character set.
portable
national
CHARARR
GET_LINES

41. Conversion: Implicit conversion can be (faster / slower) than explicit conversion.
DML
BOOLEAN
DR
slower

42. Cursors: The statement where you pass the parameters to a cursor.
OPEN
rollback to ab
associative arrays
concatenation

43. Cursors: A pointer to a cursor is called a ______ _______.
=
cursor variable
GET_LINE
v2 IN NUMBER default 20

44. Delimiters: the attribute indicator.
enabled
drop procedure
EXIT
%

45. Cursors: Give the statement for getting out of a FETCH loop for cursor CV.
ALTER SESSION
static
DBMS_CRYPTO
EXIT WHEN cv%NOTFOUND

46. Fundamental: One of the 4 types of lexical units: c_____.
comments
associative
implicit
NUMBER

47. The AUTHID property applies to PL/SQL objects that contain _____.
=
pseudocolumn
code
CURRENT_USER

48. FOR-Looping over a collection from FIRST to LAST only works if the collection is _______.
lowest
DML
dense
CLOSE_CURSOR

49. You can have many autonomous transactions in ___________.
OUT
an autonomous routine
statement
lower sub-block

50. To exit an active autonomous transaction without causing an exception - you must issue _____ or ______.
OTHERS
FORALL and BULK COLLECT
commit - rollback
DML

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