SUBJECTS
|
BROWSE
|
CAREER CENTER
|
POPULAR
|
JOIN
|
LOGIN
Business Skills
|
Soft Skills
|
Basic Literacy
|
Certifications
About
|
Help
|
Privacy
|
Terms
|
Email
Search
Test your basic knowledge |
Oracle PL - SQL
Start Test
Study First
Subjects
:
oracle
,
it-skills
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: PL/SQL is tightly _______ with Oracle SQL.
integrated
EXCEPTION_INIT
ALTER SESSION
loop
2. Types: One of the scalar data types specific to PL/SQL: P________
cursor number
invalid
PLS_INTEGER
alter procedure
3. Cursors: The SQL%FOUND attribute has how many possible values?
3
boolean
STANDARD
..
4. Official acronym for PL/SQL's runtime engine.
EXIT WHEN
SIMPLE_INTEGER
PVM
r tRec := tRec(9 - 'Jones');
5. The DEFINITION of a cursor is the _____ that returns the records.
v3 IN OUT NUMBER
specification - body
..
query
6. Bulk: The implicit cursor attribute that gives the number of rows affected by each DML statement in a FORALL statement.
%BULK_ROWCOUNT
Declaration
SQL
anonymous block
7. The BETWEEN operator is (inclusive / exclusive).
inclusive
compilation
RETURN
same
8. Value of a character literal with zero characters.
close C
CHAR - VARCHAR2
Keywords and predefined names.
9. A collection is an ordered group of ________ - all of the same ____
nested
NUMBER
elements - type
literal
10. You can have many autonomous transactions in ___________.
UTL_FILE
.
an autonomous routine
static
11. A result-cached function caches its results in the _____ _____ ____ (SGA)
system global area
invoker's
v3 IN OUT NUMBER
3
12. Assignment of PLSQL_CCFLAGS (cannot / can) be included in ALTER PROCEDURE ... COMPILE ...
FOR i IN REVERSE 1..10 - LOOP - NULL; END LOOP;
unhandled
can
HTP
13. Nested tables are multisets - meaning that there is no inherent _____ of their elements.
include
order
an autonomous routine
DBMS_PIPE
14. DynSQL: Maximum string length to pass to EXECUTE IMMEDIATE.
wrap
associative
32 -000
pls_integer
15. I/O: To make sure the DBMS_OUTPUT buffer will be flushed - put a WHEN ______ clause in the EXCEPTION section of your outer block.
EXIT
$IF
for each row
OTHERS
16. Exceptions: A GOTO statement CAN branch from an exception handler into an ________ block.
enclosing
invoker's
BINARY_INTEGER
obfuscates
17. Triggers: An INSTEAD OF trigger (can/cannot) be conditional.
cannot
SESSION_USER
closed
PLS_INTEGER
18. A unit with AUTHID = CURRENT_USER is an ________ rights unit.
Warning
: Invalid argument supplied for foreach() in
/var/www/html/basicversity.com/show_quiz.php
on line
183
19. With an sparse - integer-indexed associative array - you (can / cannot) use a regular FOR loop.
cannot
SQL
literals
DML
20. A null string and a BOOLEAN null are _______ (same/not the same).
REF_CURSOR
DML
aliases
not the same
21. A record is a group of related data items stored in fields - each with its own...
anonymous block
name and datatype
RECORDS
create procedure
22. Fundamental: A label can be used to name an ______ block.
manageable
anonymous
wrap
SQL cursor
23. The declaration section is (optional/mandatory).
optional
statement
:=
network
24. Cursors: An explicit cursor (can/cannot) accept parameters.
DBMS_OUTPUT
is
explicit
can
25. Delimiters: The association operator.
compiles
executable
=>
unqualified
26. The meaning of 'FGA'.
DATE
TRUE - FALSE - NULL
fine-grained auditing
explicit
27. DynSQL: The standard package that does dynamic SQL.
DBMS_SQL
static boolean
# - $ - _
always
28. If an initialized collection has no elements - FIRST and LAST return _____.
exception handler
specification - body
after
29. Characters that end a multi-line comment.
*/
-
INSTEAD OF
create
30. The PL/SQL virtual machine turns bytecode into system ______.
calls
SQLERRM
colon
non-editioning views
31. When a session starts - CURRENT_SCHEMA has the value of the schema owned by ___________.
%FOUND - %ISOPEN - %NOTFOUND - %ROWCOUNT
FOR UPDATE
SESSION_USER
TRUE - FALSE - NULL
32. I/O: One of the 3 types of data stored in the DBMS_OUTPUT buffer.
commit - rollback
optional
REF CURSOR
NUMBER
33. Triggers: When using the NEW or OLD pseudo-records in the body of the trigger - they must be prefixed with a _______.
colon
UTL_HTTP
SQL
invoker's
34. The method to add one or more elements to a nested table or VARRAY is ______.
FETCH - BULK COLLECT INTO
EXTEND
commit - rollback
view
35. DynSQL: The clause that receives single-row query output from EXECUTE IMMEDIATE.
searched
names
INTO
expression
36. Collections are one of the two kinds of PL/SQL _______ data types.
suspended
composite
slower
external subprogram
37. IDs: You can use a reserved word as a _______ user-defined identifier.
quoted
RAISE
v1 OUT number default 10
definer's
38. Give the first line of the FOR loop with index i going from 1 to 10 in reverse.
bytecode
1
FOR i IN REVERSE 1..10 LOOP
PUT_LINE
39. DynSQL: The three modes of arguments in the USING clause of EXECUTE IMMEDIATE.
searched
composite
IN - OUT - IN OUT
for update of
40. True encryption is done with package __________.
EXECUTE
lowest
compilation
DBMS_CRYPTO
41. Triggers: On a non-editioning view - you can only define __________ triggers.
INSTEAD OF
WHEN
RECORDS
REF_CURSOR
42. The values defined in PLSQL_CCFLAGS can be referenced as _____ directives.
FETCH
order
inquiry
implicit
43. Cursors: If an exception is raised inside a cursor loop - the cursor (is / is not) also closed automatically.
is
;
inquiry
open cv for
44. A PL/SQL block that is not stored.
anonymous block
close C
...
%BULK_ROWCOUNT
45. What are two categories of SQL functions that cannot be used in procedural statements?
aggregate - analytical
finishes
1
package
46. In Native Mode - PL/SQL code is compiled into ______ ______.
FETCH
cursor
cannot
machine code
47. Cursors: A cursor FOR loop can use an explicit or an _______ cursor.
.
enclosing
end
implicit
48. DynSQL: The clause that supplies bind arguments to EXECUTE IMMEDIATE.
USING
REUSE SETTINGS
STANDARD
DBMS_OUTPUT
49. A value that is neither represented by an identifier nor calculated from other values.
255
CURRENT OF
compiles
literal
50. Cursors: A session cursor that is automatically created and managed by PL/SQL.
bind
TYPE rec IS RECORD (num NUMBER - name VARCHAR2(10));
implicit cursor
ex := tbl1 MULTISET EXCEPT tbl2