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. The AUTHID property applies to PL/SQL objects that contain _____.
package
invalid
GET_LINES
code
2. I/O: The DBMS_OUTPUT buffer will not be flushed until it is full or until the current PL/SQL block _________.
Keywords and predefined names.
RETURN
-
finishes
3. The FORALL statement to loop over a collection MyList using index i.
nested
mandatory
Wrap
FORALL i IN MyList.FIRST..MyList.LAST
4. IDs: The two types of words that can - but should not - be used as user-defined identifiers.
implicit CASE_NOT_FOUND exception
executable
Keywords and predefined names.
SIMPLE_INTEGER
5. You can put a label before any executable PL/SQL _________.
statement
EXIT
fetch cv into myvar
specification - body
6. Nested tables can become sparse via ______.
OPEN_CURSOR
deletions
error code
expression
7. TCL: Undo changes back to savepoint ab.
SUBTYPE n IS number not null;
2
rollback to ab
INTO
8. I/O: This package lets PL/SQL programs read and write OS files.
explicit
slower
STANDARD
UTL_FILE
9. IDs: Maximum number of bytes in a user-defined identifier.
30
v3 IN OUT NUMBER
lock
package
10. The meaning of 'FGA'.
fine-grained auditing
never
oname
delimiters
11. Advantage: PL/SQL programs are stored centrally - making them more ______.
TYPE tV IS VARRAY(100) OF NUMBER
FETCH
manageable
ex := tbl1 MULTISET EXCEPT tbl2
12. Cursors: The second keyword of a FETCH statement.
LOOP - END LOOP
a number := 10
name and datatype
INTO
13. If a procedure fails - an OUT parameter passed to it by value (will / will not) be passed back with changes.
FOR i IN REVERSE 1..10 LOOP
will not
concatenation
NDS
14. Advantage: PL/SQL supports ______-oriented programming.
set serveroutput on
object
5
SQL
15. Pkgs: The _______ package gives access to such SQL things as ALTER SESSION.
enabled
inquiry
current
DBMS_SESSION
16. For a collection - the NEXT method gets the next higher (element / index).
autonomous triggers
LOOP
index
unconstrained
17. By default - an IN parameter is passed by ______.
expression
reference
Declaration
names
18. Command to assign to variables from a cursor.
include
boolean
composite
FETCH
19. Records are one of the two kinds of PL/SQL _______ data types.
<<>>
'ENABLE:SEVERE' - 'ERROR:06002'
composite
inquiry
20. Advantage: PL/SQL gives SCALABILITY because stored procedures are executed on the _______.
exception handler
server
1
reference
21. Types: A ______ has the same valid operations as its base type.
END IF
subtype
statically
server
22. The values defined in PLSQL_CCFLAGS can be referenced as _____ directives.
PRAGMA EXCEPTION_INIT (E - -1);
anonymous
ALTER SESSION
inquiry
23. Exceptions: Each internal exception has an Oracle ______ _______.
bb:true
PSP
error code
before insert or update on emps
24. With an sparse - integer-indexed associative array - you (can / cannot) use a regular FOR loop.
bb:true
cannot
DML
production
25. DynSQL: Maximum string length to pass to EXECUTE IMMEDIATE.
END IF
enclosing
TOO_MANY_ROWS
32 -000
26. Exceptions: An exception in the declarations section propagates to the enclosing _______.
PSP
cannot
INTO
block
27. Cursors: A cursor variable's type must be a ____ ______ type.
REF CURSOR
disable
name-value
EDITION_NAME
28. I/O: The buffered output of dbms_output.put_line is retrieved by _______.
SQLPlus
%BULK_ROWCOUNT
code
unqualified
29. Static typing is also called _____ typing.
CURRENT_USER - DEFINER
bb:true
index
strong
30. Cursors: The four cursor attributes - in alphabetical order.
simple and compound symbols
SQL
PL/SQL Gateway
%FOUND - %ISOPEN - %NOTFOUND - %ROWCOUNT
31. The three types of compiler warnings.
.
versions
type T is ref cursor
EVERE - PERFORMANCE - INFORMATIONAL
32. The RESULT_CACHE clause has to be in both the declaration and in the ______ of the function.
definition
USER_PROCEDURES
integrated
<<>>
33. Dbms_sql: The integer returned by OPEN_CURSOR is a _____ _____.
stored
512
index
cursor number
34. Cursors: SYS_REFCURSOR is a predefined type based on _____ ______.
autonomous transaction
PLSQL_OPTIMIZE_LEVEL
REF CURSOR
stored
35. The FOR UPDATE OF clause references a (table / column).
EXECUTE
upper - coalesce
column
never
36. Web: mod_plsql is an _______ module.
literals
IF - CASE or LOOP
iname
Apache
37. Types: One of the 4 PL/SQL things that have a data type (begins with 'p').
REF CURSOR
parameter
calls
EXIT
38. Delimiters: Host variable indicator.
...
exception handler
PLSQL_OPTIMIZE_LEVEL
literals
39. Mode designation for an output parameter.
TIMESTAMP.
FOR UPDATE
OUT
value
40. PL/SQL lets you define two kinds of composite data types: _______ and _______
DBMS_DDL
=>
SQL cursor
collections - records
41. Cursors: If you use an EXIT statement to exit a cursor FOR loop prematurely - the cursor (is / is not) closed automatically.
is
bb:true
FETCH
select
42. The DECLARE keyword is only required in an _______ _______.
USER_PROCEDURES
anonymous block
DEFINER
LOOP - END LOOP
43. In Native Mode - PL/SQL code is compiled into ______ ______.
FORALL and BULK COLLECT
PVM
machine code
cursor number
44. The PL/SQL virtual machine turns bytecode into system ______.
INSTEAD OF
vname CONSTANT VARCHAR2 := 'x';
Abstract
calls
45. Name the two types of FOR loop.
numeric and cursor
USER_PROCEDURES
Server Pages
implicit
46. DynSQL: The clause that receives single-row query output from EXECUTE IMMEDIATE.
REF CURSOR
SIMPLE_INTEGER
INTO
cached
47. Web: PL/SQL ______ ______ (PSPs) let you develop web pages with dynamic content.
FETCH
is certain
rollback to ab
Server Pages
48. Cursors: A session cursor that a PL/SQL user creates and manages.
hardware
UTL_FILE
explicit cursor
non-editioning views
49. Fundamental: One of the 4 types of lexical units: L_____
...
cannot
literals
database
50. Cursors: If an exception is raised inside a cursor loop - the cursor (is / is not) also closed automatically.
GET_LINE
%ROWTYPE
is
-