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. After the RESULT_CACHE clause - you can put a _________ clause to enable dependency-checking.
RELIES_ON
cursor
1
%ISOPEN.

2. Data dictionary view giving the AUTHID values on a user's objects.
USER_PROCEDURES
nested
...
SUBTYPE n IS number not null;

3. Native compilation turns bytecode into ________ code.
machine
ENABLE
API
a cursor

4. Loops: What is the index range operator in a FOR loop?
name and datatype
currval and nextval
..
versions

5. Types: One of the 4 PL/SQL things that have a data type (begins with 'r').
return value
collections - records
FORALL and BULK COLLECT
always

6. Delimiters: The assignment operator.
FOR UPDATE
:=
boolean
Apache

7. A type of compiler directive - begins with 'i'.
API
inquiry
executable
raise_application_error

8. Advantage: Performance: Stored subprograms are ______ in memory.
before insert or update on emps
cached
name
REF CURSOR

9. Fundamental: Character used to escape a single quote inside a literal.

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

10. Cursors: Define a ref cursor type called T.
calls
type T is ref cursor
current transaction
**

11. The Wrap utility ________ the source code.
obfuscates
iname
an autonomous routine
execute

12. The _______ package lets you wrap dynamically generated PL/SQL.
collections - records
vname CONSTANT VARCHAR2 := 'x';
END IF
DBMS_DDL

13. For an associative array - the FIRST method gets the (lowest / first-created) index.
expression
cannot
PLSQL_CCFLAGS
lowest

14. Internally - the NUMBER type is stored as ______. Therefore - decimal numbers (such as prices) are stored exactly - with no rounding.
decimal
With a letter.
transaction
scalable

15. If none of a CASE expression's conditions are TRUE - it returns _____.
fields
CREATE TYPE

block

16. Command used to execute dynamic SQL.
EXECUTE IMMEDIATE
dense
CURSOR - RETURN
cannot

17. PLSQL_CCFLAGS hold a comma-separated list of ______ pairs (hyphenated).
PRAGMA EXCEPTION_INIT (E - -1);
name-value
TYPE t IS TABLE OF rPerson INDEX BY PLS_INTEGER;
PUT_LINE

18. An $ERROR directive ends with _____.
nested
$END
include
CASE_NOT_FOUND

19. Delimiters: Host variable indicator.
TRUE - FALSE - NULL
...
p.v
invalid

20. Fundamental: identifiers (include/do not include) reserved words.
include
drop procedure
library
variable

21. Cursors: The statement that closes a cursor.
CLOSE
4K
define
drop procedure

22. I/O: This package has hypertext functions that generate HTML tags
<> - != - ^=
..
after
HTF

23. Command to delete a procedure.
drop procedure
SIMPLE_INTEGER
must
FETCH - BULK COLLECT INTO

24. Dbms_sql: This DBMS_SQL function opens a new cursor.
INSTEAD OF
SQL cursor
OPEN_CURSOR
HTF

25. An INSTEAD OF trigger specifies what to do instead of a ___ statement.
DML
EXIT
literal
enclosing

26. One good use of bind variables is to guard against SQL _______.
SQL
OTHERS
national
injection

27. Language that PL/SQL is derived from.
cached
suspended
index
Ada

28. Exceptions: User-defined exceptions must have _______.
FGA
names
FETCH
LOOP

29. I/O: One of the 3 types of data stored in the DBMS_OUTPUT buffer.
upper - coalesce
unhandled
DATE
function f (n number) return number result_cache relies_on (emps);

30. An anonymous block is a(n) ____ statement.
1
system global area
SQL
r tRec := tRec(9 - 'Jones');

31. Types: ________ data types have internal components.
injection
hardware
composite
null string

32. Labels for blocks and statements are enclosed in '__' brackets.
close C
PVM
<<>>
FETCH

33. To insert or update on a table that has a collection column - you have to have _______ privilege on the collection type.
...
close C
EXECUTE
dense

34. Types: Which type of arithmetic does PLS_INTEGER use - library or hardware?
hardware
Double quotes.
static
information that changes infrequently

35. Triggers: The clause to make a trigger run once for every affected row.
finishes
cannot
unconstrained
for each row

36. The lowest index of a nested table is ___.
1
cannot
$$PLSQL_LINE
database

37. Exceptions: An unhandled exception ________ to the enclosing block.
scalable
:=
national
propagates

38. The SET TRANSACTION statement affects only the ____________.
propagates
finishes
PUT
current transaction

39. Cursors: What are the 3 possible values of SQL%FOUND and SQL%NOTFOUND?
END LOOP
TRUE - FALSE - NULL
in the database
VARRAY - Nested table

40. IDs: The 3 non-alphanumeric characters that can be in an ordinary user-defined identifier.
does not
Declaration
BOOLEAN
# - $ - _

41. For a collection - the NEXT method gets the next higher (element / index).
index
BINARY_INTEGER
%BULK_ROWCOUNT
PLSQL_OPTIMIZE_LEVEL

42. When a parameter is passed by reference - changes made to it inside the procedure cannot be undone. True/False.
%TYPE
cursor variable
IR
True

43. I/O: The DBMS_OUTPUT procedure that sets the size of the output buffer.
implicit
ENABLE
cannot
$$PLSQL_LINE

44. An editioning view can only select a subset of the columns from the base table and provide ________ for them
invoker's
aliases
package
transaction

45. Triggers: By default - a trigger is created in the ______ state.
.
enabled
DBMS_PREPROCESSOR
FETCH

46. In a cursor loop - the clause added to an INSERT or UPDATE to point at the current record.
fetch cv into myvar
BOOLEAN
WHERE CURRENT OF
aliases

47. Types: One of the scalar data types specific to PL/SQL: b_____.
:=
DBMS_PIPE
does not
BOOLEAN

48. I/O: The DBMS_OUTPUT function that writes output WITH a newline character.
package
EXECUTE IMMEDIATE
PUT_LINE
anonymous

49. Fundamental: Delimiters are _____ and _____ symbols.
CURRENT_USER - DEFINER
can
simple and compound symbols
2

50. Delimiters: The association operator.
bind
=>
TOO_MANY_ROWS
30

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