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. If none of a CASE expression's conditions are TRUE - it returns _____.
enclosing
enabled
hardware
2. With conditional compilation you can avoid compiling debug code in the _______ environment.
END CASE
external subprogram
production
decimal
3. Clause added to a cursor to use it with WHERE CURRENT OF.
is
for update of
unhandled
DML
4. Types: One of the 4 PL/SQL things that have a data type (begins with 'p').
can
CLOSE_CURSOR
DML
parameter
5. Exceptions: Each internal exception has an Oracle ______ _______.
optional
error code
plb
static boolean
6. Define a record variable r - of type tRec - initialized with values 9 and 'Jones' in its two fields.
Warning
: Invalid argument supplied for foreach() in
/var/www/html/basicversity.com/show_quiz.php
on line
183
7. DynSQL: The three modes of arguments in the USING clause of EXECUTE IMMEDIATE.
IN - OUT - IN OUT
LOOP - END LOOP
cursor variable
3
8. Mode designation for an input parameter.
IN
block
cannot
Gateway
9. In a collection - the internal components always have the _____ data type.
IF - CASE or LOOP
is
same
PRAGMA AUTONOMOUS_TRANSACTION;
10. Fundamental: One of the 4 types of lexical units: c_____.
WHERE CURRENT OF
BOOLEAN
comments
NUMBER
11. Delimiters: Single-line comment marker.
elsif
-
anonymous block
LOOP - END LOOP
12. Pkgs: The _______ package gives access to such SQL things as ALTER SESSION.
DBMS_SESSION
DML
cursor
fetch cv into myvar
13. Exceptions: Start of the range of error codes for RAISE_APPLICATION_ERROR.
flushed
inclusive
-20 -000
type T is ref cursor
14. Cursors: What are the 3 possible values of SQL%FOUND and SQL%NOTFOUND?
code
TRUE - FALSE - NULL
suspended
Ordinary - Quoted.
15. Web: mod_plsql is an _______ module.
Apache
Wrap
raise_application_error
alter procedure
16. Web: PL/SQL _____ _______ lets you to develop Web applications made of PL/SQL procedures.
Web Toolkit
DBMS_SQL
1 million
reference
17. I/O: The output from DBMS_OUTPUT will display (during/after) program execution.
after
True
UTL_FILE
boolean
18. The command used to populate PLSQL_CCFLAGS.
after
ALTER SESSION
definer's
HTP
19. Dbms_sql: The return type DBMS_SQL.open_cursor.
lowest
a number := 10
CREATE TRIGGER
integer
20. IDs: Maximum number of bytes in a user-defined identifier.
HTF
transaction
EXIT WHEN cv%NOTFOUND
30
21. Which two of these built-in SQL functions can be used in procedural (PL/SQL) statements: DECODE - CORR - UPPER - SUM - COALESCE - DEREF.
RECORDS
CURRENT_USER - DEFINER
follows
upper - coalesce
22. Type: An ________ subtype has all the values of its base type.
unconstrained
FETCH - INTO
constant
do not
23. In 11g you can directly reference _____________ in PL/SQL.
network
%ROWTYPE
sequence pseudo-columns
composite
24. SIMPLE_INTEGER is like PLS_INTEGER - but it does not allow ____ values - and it does not raise overflow exceptions.
@
WHEN OTHERS THEN
integrated
25. The AUTHID property applies to PL/SQL objects that contain _____.
stored
Reserved words.
code
procedure - function
26. Exceptions: The keyword that begins an exception handler.
FORALL i IN MyList.FIRST..MyList.LAST
same
WHEN
searched
27. DynSQL: Maximum string length to pass to EXECUTE IMMEDIATE.
32 -000
4
.
current transaction
28. When a session starts - CURRENT_SCHEMA has the value of the schema owned by ___________.
SESSION_USER
v2 IN NUMBER default 20
lowest
inquiry
29. Types: One of the scalar data types specific to PL/SQL: B_______
timing
BINARY_INTEGER
name-value
*/
30. Types: One of the scalar data types specific to PL/SQL: b_____.
executable
BOOLEAN
1
DATE
31. A result-cached function caches its results in the _____ _____ ____ (SGA)
GET_LINE
IF - CASE or LOOP
system global area
SQLERRM
32. Characters that begin a multi-line comment.
versions
1
/*
PL/SQL Gateway
33. Declare a constrained subtype of NUMBER called N that is not null.
SUBTYPE n IS number not null;
RESULT_CACHE
inquiry
context
34. Give the first line of the FOR loop with index i going from 1 to 10 in reverse.
plb
FOR i IN REVERSE 1..10 LOOP
create
set serveroutput on
35. _____ arrays cannot be used as the type of an Oracle table column.
REF_CURSOR
is
exit when cgo%NOTFOUND
associative
36. A FOR-loop counter is defined only within the _____.
open C
loop
32 -000
optional
37. The FORALL statement to loop over a collection MyList using index i.
is
EVERE - PERFORMANCE - INFORMATIONAL
FORALL i IN MyList.FIRST..MyList.LAST
composite
38. DynSQL: EXECUTE IMMEDIATE does both dynamic SQL and dynamic _______.
OLD
elsif
PL/SQL
package
39. To recompile a procedure - use the _____ ______ command.
flushed
EXIT WHEN cv%NOTFOUND
3
alter procedure
40. Collections are one of the two kinds of PL/SQL _______ data types.
EXIT WHEN
composite
binding
USING
41. Triggers: The code in a trigger is actually an ________ block.
STANDARD
a cursor
True - false or NULL.
anonymous
42. Delimiters: Item separator.
BINARY_INTEGER
open cv for
SYS_CONTEXT
43. Unlike the CASE statement - the CASE expression does not have the...
$IF
cursor
dynamic
implicit CASE_NOT_FOUND exception
44. I/O: If the current (outermost) PL/SQL block ends with an unhandled exception - the output buffer will not be ___________.
DATE
BINARY_INTEGER
flushed
integrated
45. Cursors: The statement where you pass the parameters to a cursor.
OPEN
VARRAYs
same arguments
for each row
46. Triggers: If two or more triggers are defined with the same timing point - then you can control the firing order using the ________ clause.
Double quotes.
UTL_FILE
HTF
follows
47. The LIMIT method is only meaningful for _______.
VARRAYs
variable
-
NEW
48. When a parameter is passed by reference - changes made to it inside the procedure cannot be undone. True/False.
commit - rollback
compiles
True
package
49. Cursors: Define a ref cursor type called T.
static
TYPE rec IS RECORD (num NUMBER - name VARCHAR2(10));
definer's
type T is ref cursor
50. Cursors: Give the statement to fetch data from cursor C into variable V.
'
hardware
sequence pseudo-columns
fetch C into V