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. IDs: You (can/cannot) use keywords as ordinary user-defined identifiers.
wrap
CHAR - VARCHAR2
API
can

2. A user-defined TYPE can have...
sequence pseudo-columns
NESTED TABLE myColl STORE AS myCollTab
an AUTHID property
production

3. The $IF must evaluate a ______ _______ expression.
implicit
for each row
cursor
static boolean

4. Give the first line of the FOR loop with index i going from 1 to 10 in reverse.
5
numeric and cursor
FOR i IN REVERSE 1..10 LOOP
CASE_NOT_FOUND

5. Are good for logging table DML operations.
SQLCODE
autonomous triggers
ALTER SESSION
index

6. Abbreviation of invoker's rights
512
%BULK_ROWCOUNT
IR
decimal

7. Kind of datatypes that support object-oriented programming in PL/SQL.
Abstract
1
error
expression

8. Triggers: By default - a trigger is created in the ______ state.
enabled
...
implicit CASE_NOT_FOUND exception
invoker's

9. The $ERROR directive is used to make compilation ____.
cannot
fail
injection
FALSE

10. Web: Abbreviation of PL/SQL Server Page.
procedure P AUTHID definer;
DBMS_OUTPUT
PSP
3

11. DynSQL: The colon-prefixed names used in EXECUTE IMMEDIATE are called ________.
FOR i IN REVERSE 1..10 LOOP
SYS_CONTEXT
STANDARD
placeholders

12. Cursors: What are the 3 possible values of SQL%FOUND and SQL%NOTFOUND?
CURRENT_USER
TRUE - FALSE - NULL
END CASE
'

13. Conditional compilation is useful for compiling a program under different ______ of Oracle.
is not
versions
suspended
$IF

14. When an autonomous routine begins execution - the main transaction is ________.
open C(p)
procedure P AUTHID definer;
DBMS_SESSION.RESET_PACKAGE
suspended

15. If a result-cached function's data source (based on the RELIES_ON clause) is updated - any cached results become _______.
%FOUND - %ISOPEN - %NOTFOUND - %ROWCOUNT
query
invalid
run

16. Labels for blocks and statements are enclosed in '__' brackets.
<<>>
for each row
aggregate - analytical
dense

17. DynSQL: The clause that supplies bind arguments to EXECUTE IMMEDIATE.
name-value
portable
cannot
USING

18. Cursors: A session cursor that a PL/SQL user creates and manages.
query
explicit cursor
512
close C

19. In PL/SQL - what the variables in DML statements are turned into.
bind arguments
DECLARE - BEGIN - EXCEPTION - END
package
subtype

20. Give the statement to make a program autonomous.
always
RETURN
SUBTYPE n IS number not null;
PRAGMA AUTONOMOUS_TRANSACTION;

21. Make a FOR loop that executes NULL 10 times counting in reverse - using index i.
FOR i IN REVERSE 1..10 - LOOP - NULL; END LOOP;
view
v2 IN NUMBER default 20
FETCH - INTO

22. Default file extension of wrap's output file.
plb
SQL
open C(p)
index

23. Exceptions: The three words that can be used to guarantee all exceptions will be handled.
True - false or NULL.
WHEN OTHERS THEN
composite
END LOOP

24. GOTO branches to a ________.
Gateway
database
label
definition

25. Triggers: There are __ types of triggers.
cannot
UTL_FILE
executable
5

26. IDs: You cannot use reserved words as ______ user-defined identifiers.
colon
SUBTYPE n IS number not null;
inquiry
ordinary

27. The 4 keywords in the $IF compiler directive.
%ROWTYPE
TYPE rec IS RECORD (num NUMBER - name VARCHAR2(10));
$IF $THEN $ELSE $END
cannot

28. A (simple / searched) CASE statement begins with CASE WHEN <boolean expression>.
CURRENT OF
server
searched
BINARY_INTEGER

29. Name the two types of FOR loop.
elements - type
raise_application_error(-20 -100 - 'Bad');
composite
numeric and cursor

30. Cursors: The two keywords in a mere cursor declaration (one is optional).
rollback to ab
EVERE - PERFORMANCE - INFORMATIONAL
CURSOR - RETURN
TYPE tN IS TABLE of NUMBER

31. Associative array types (can / cannot) be defined in the database.
STANDARD
cannot
unconstrained
dense

32. In a sparse collection - the indexes of defined elements (do / do not) run in consecutive order.
Gateway
base
sql
do not

33. By default - OUT and IN OUT parameters are passed by _____.
expression
<<>>
value
definition

34. What are two categories of SQL functions that cannot be used in procedural statements?
aggregate - analytical
RESULT_CACHE
is
3

35. Delimiters: the attribute indicator.
3
%
WHEN OTHERS THEN
autonomous transaction

36. This is a CASE (expression / statement): myvar := CASE num WHEN 1 THEN 'good' WHEN 2 THEN 'bad' END;
expression
SIMPLE_INTEGER
DBMS_DDL
inquiry

37. To run DDL statements - a trigger must be autonomous and must use ______ ______ SQL.
native dynamic
variable
stored
delimiters

38. Declare a number variable - A - initialized to 10.
EXIT WHEN
2
a number := 10
after

39. In a collection - the internal components are called _______.
anonymous block
...
OLD
elements

40. The RESULT_CACHE clause comes (before / after) the RETURN clause.
1
after
quoted
static boolean

41. What clause makes a compilation default to the PLSQL_CCFLAGS settings from the last compilation?
Ada
exception
REUSE SETTINGS
anonymous

42. Triggers: The clause to make a trigger run after inserting into table EMPS.
after insert on emps
<> - != - ^=
database
lower sub-block

43. Static typing is also called _____ typing.
name-value
END CASE
numeric and cursor
strong

44. The variable showing the user id of the session owner.
PUT
static
bytecode
SESSION_USER

45. In interpreted mode - the PL/SQL VM interprets the _________.
EXIT
bytecode
sql
associative

46. Data dictionary view giving the AUTHID values on a user's objects.
bind
3
object
USER_PROCEDURES

47. User-defined compiler directives are defined in this system compile parameter.
literal
PLSQL_CCFLAGS
variable
$$

48. Cursors: WHERE _______ ______ makes an UPDATE or DELETE apply to the current row of a cursor.
HTF
fetch cv into myvar
server
CURRENT OF

49. I/O: This DBMS_OUTPUT proc retrieves multiple lines from the buffer.
exception
GET_LINES
implicit cursor
BOOLEAN

50. True encryption is done with package __________.
suspended
Keywords and predefined names.
exit when cgo%NOTFOUND
DBMS_CRYPTO

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