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. TCL: Undo changes back to savepoint ab.
p.v
rollback to ab
definition
explicit cursor
2. PL/SQL is a ________ typed programming language.
statically
oname
optional
preprocessor
3. Triggers: You create a trigger with the _______ ________ statement.
CREATE TRIGGER
TIMESTAMP.
currval and nextval
obfuscates
4. The BEGIN section is (optional/mandatory)
Keywords and predefined names.
not the same
mandatory
concatenation
5. A __________ can have an AUTHID property
package
Declaration
SQL
is certain
6. TCL: Create a savepoint called ab
aliases
ROLLBACK
savepoint ab
do not
7. This is a CASE (expression / statement): CASE num WHEN 1 THEN goto LABEL1 WHEN 2 THEN var := 2 END CASE;
32 -000
statement
single-line
not a number
8. Exceptions: PL/SQL exceptions are of two types: internal and _________.
exception
index
open cv for
user-defined
9. What word is in a function header but not in a procedure header?
DML
error code
RETURN
does not
10. User-defined compiler directives are defined in this system compile parameter.
RETURN
PLSQL_CCFLAGS
network
invoker's
11. Web: PL/SQL ______ ______ (PSPs) let you develop web pages with dynamic content.
Server Pages
cannot
composite
$$PLSQL_LINE
12. DynSQL: The clause that supplies bind arguments to EXECUTE IMMEDIATE.
STANDARD
USING
FETCH - BULK COLLECT INTO
EXECUTE IMMEDIATE
13. Cursors: The values plugged into the DML in a FORALL must come from existing - populated _________.
sql
closed
invoker's
collections
14. A result-cached function caches its results in the _____ _____ ____ (SGA)
system global area
Gateway
is certain
FETCH
15. Cursors: The statement that closes a cursor.
compiles
package
name
CLOSE
16. Triggers: In a per-row trigger - the ____ record shows you the changed state of an affected row.
cursor variable
NEW
ENABLE
LOOP - END LOOP
17. To enable result-caching for a function - use the _____________ clause.
r t.%ROWTYPE;
dbms_output.put_line
RESULT_CACHE
<<>>
18. With static typing - type checking is done at ______ time.
compile
STANDARD
CREATE TRIGGER
session cursor
19. Conditional compilation is useful for compiling a program under different ______ of Oracle.
versions
SQLCODE
an autonomous routine
cannot
20. Cursors: The FOR UPDATE phrase goes at the (beginning/end) of the cursor definition.
end
optional
subtype
finishes
21. Kind of code created by the PL/SQL compiler.
calls
expression
bytecode
DATE
22. Exceptions: You cannot GOTO from an exception handler back into the __________ block.
3
procedure - function
current
FOR - IN
23. The lowest index of a VARRAY is ___.
$END
1
selection
fail
24. Cursors: If no SELECT or DML statement has run - the value of SQL%ROWCOUNT is what?
do not
define
open C
25. For an associative array - the FIRST method gets the (lowest / first-created) index.
lowest
unhandled
END
OPEN_CURSOR
26. Cursors: A session cursor that a PL/SQL user creates and manages.
explicit cursor
portable
1
Abstract
27. The $IF must evaluate a ______ _______ expression.
INTO
flushed
function f (n number) return number result_cache relies_on (emps);
static boolean
28. Mode designation for an input/output parameter.
EXECUTE
IN OUT
1
anonymous
29. Wrap iname=xxxx _____=zzzzz
DML
static
inquiry
oname
30. Parameter that controls how much Oracle optimizes your PL/SQL code on compilation.
FORALL i IN MyList.FIRST..MyList.LAST
PLSQL_OPTIMIZE_LEVEL
inquiry
%ISOPEN.
31. $$PLSQL_LINE and $$PLSQL_UNIT are ______-ly defined inquiry directives.
error
iname
implicit
statement
32. Triggers: By default - a trigger is created in the ______ state.
enabled
explicit cursor
invoker's
searched
33. Types: One of the scalar data types specific to PL/SQL: R_________.
FORALL and BULK COLLECT
REF_CURSOR
CLOSE
collections
34. Cursors: An explicit cursor (can/cannot) accept parameters.
can
optional
sql
cursor number
35. I/O: This package has hypertext procedures that generate HTML tags
EVERE - PERFORMANCE - INFORMATIONAL
DEFINER
external subprogram
HTP
36. To run TCL or DDL statements - a trigger (must / must not) be autonomous .
LOOP
column
must
null string
37. I/O: dbms_output.put_line puts output into a _______.
buffer
select
%FOUND - %ISOPEN - %NOTFOUND - %ROWCOUNT
invoker's
38. I/O: To make sure the DBMS_OUTPUT buffer will be flushed - put a WHEN ______ clause in the EXCEPTION section of your outer block.
wrap
order
predefined
OTHERS
39. A numeric FOR loop cannot _________ by other than 1?
CLOSE
object
increment
SQLPlus
40. After the RESULT_CACHE clause - you can put a _________ clause to enable dependency-checking.
RELIES_ON
expression
CLOSE
same arguments
41. I/O: The buffered output of dbms_output.put_line is retrieved by _______.
SQLPlus
$$
constructor
compile
42. Keyword for doing assignment to a variable with SELECT.
EXECUTE
INTO
integer
NDS
43. Cursors: A Cursor FOR loop does not use a ______ statement.
FETCH
PL/SQL
once
OPEN_CURSOR
44. If none of a CASE expression's conditions are TRUE - it returns _____.
USER_PLSQL_OBJECT_SETTINGS
finishes
user-defined
45. Nested tables are multisets - meaning that there is no inherent _____ of their elements.
propagates
SYS_CONTEXT
SQL
order
46. Associative array types (can / cannot) be defined in the database.
library
=>
cannot
implicit cursor
47. In a sparse collection - the indexes of defined elements (do / do not) run in consecutive order.
do not
=>
closed
FETCH
48. Triggers: An INSTEAD OF trigger (can/cannot) be conditional.
null string
REF_CURSOR
cannot
not the same
49. Dbms_sql: The integer returned by OPEN_CURSOR is a _____ _____.
cursor number
CLOSE_CURSOR
IR
literals
50. I/O: The output from DBMS_OUTPUT will display (during/after) program execution.
FOR i IN REVERSE 1..10 LOOP
PRAGMA EXCEPTION_INIT (E - -1);
return value
after