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. Types: The only PL/SQL type for which you can specify a range constraint.
PLS_INTEGER
DBMS_OUTPUT
transaction
can
2. Exceptions: When an exception is raised inside a cursor FOR loop - the cursor is _______ implicitly.
open cv for
%TYPE
significant
closed
3. The meaning of 'FGA'.
fine-grained auditing
-
1
alter procedure
4. Native compilation turns bytecode into ________ code.
machine
enabled
same
definer's
5. To exit an active autonomous transaction without causing an exception - you must issue _____ or ______.
identifiers
commit - rollback
not a number
decimal
6. An $ERROR directive ends with _____.
/*
CASE_NOT_FOUND
$END
definer's
7. An editioning view is like an ____ for a table.
DBMS_PREPROCESSOR
timing
OLD
API
8. $$PLSQL_LINE and $$PLSQL_UNIT are ______-ly defined inquiry directives.
delimiters
implicit
function f (n number) return number result_cache relies_on (emps);
IS
9. Exceptions: Pragma that links an exception to an Oracle error code.
currval and nextval
composite
EXCEPTION_INIT
..
10. Parameter that controls how much Oracle optimizes your PL/SQL code on compilation.
ENABLE
PLSQL_OPTIMIZE_LEVEL
upper - coalesce
RECORD OF ARRAYS
11. Cursors: Give the statement to open cursor C that takes parameter p.
SESSION_USER
fields
SQLCODE
open C(p)
12. I/O: The DBMS_OUTPUT procedure that sets the size of the output buffer.
bind
unhandled
ENABLE
TOO_MANY_ROWS
13. Bulk: The two features that comprise Bulk SQL are:
END
COMMIT - ROLLBACK - SAVEPOINT - SET TRANSACTION
FORALL and BULK COLLECT
view
14. You (can / cannot) wrap trigger source code.
%FOUND - %ISOPEN - %NOTFOUND - %ROWCOUNT
commit - rollback
integrated
cannot
15. I/O: This DBMS_OUTPUT proc retrieves one line from the buffer.
GET_LINE
elements - type
alter procedure
specification - body
16. Declare a variable r whose type is that of the records in table t.
r t.%ROWTYPE;
TYPE tA IS TABLE OF NUMBER INDEX BY VARCHAR2(20)
PVM
IR
17. An anonymous block always has _________ rights.
Warning
: Invalid argument supplied for foreach() in
/var/www/html/basicversity.com/show_quiz.php
on line
183
18. Define a record type REC with number num and varchar2(10) name.
END CASE
TYPE rec IS RECORD (num NUMBER - name VARCHAR2(10));
non-editioning views
INTO
19. Dbms_sql: The DBMS_SQL procedure that closes a cursor.
CLOSE_CURSOR
IN
for each row
composite
20. Types: One of the 4 PL/SQL things that have a data type (begins with 'v').
compile
variable
SQL
end
21. Cursors: The keyword that makes a ref cursor type STRONG.
RETURN
dynamic
TYPE tA IS TABLE OF NUMBER INDEX BY VARCHAR2(20)
calls
22. For an associative array - the FIRST method gets the (lowest / first-created) index.
lowest
strong
versions
significant
23. In a record - the internal components are called ______.
query
$END
DML
fields
24. Declare an unconstrained subtype of NUMBER called NUMB.
WHEN
cached
SUBTYPE numb IS number;
1
25. IDs: You (can/cannot) use keywords as ordinary user-defined identifiers.
obfuscates
alter procedure
can
26. PL/SQL is a ________ typed programming language.
PUT
statically
PLS_INTEGER
server
27. _______ arrays can be sparse or dense - depending on how you fill them.
associative
cannot
can
E Exception;
28. What word is in a function header but not in a procedure header?
cannot
With a letter.
RETURN
after
29. Bulk: The keywords of a bulk collect FETCH statement.
FETCH - BULK COLLECT INTO
FETCH - INTO
execute
1
30. The EXTEND method is not used with ______ _______.
TYPE rec IS RECORD (num NUMBER - name VARCHAR2(10));
associative arrays
for each row
DBMS_PIPE
31. The SET TRANSACTION statement affects only the ____________.
current transaction
system global area
OPEN
varray
32. The RESULT_CACHE clause comes (before / after) the RETURN clause.
virtual machine
SQLCODE
concatenation
after
33. Triggers: In a per-row trigger - the ____ record shows you the changed state of an affected row.
NEW
associative
PLS_INTEGER
an enclosing block
34. With a result-cached function - it uses a cached value when the function is called again with the...
is certain
external subprogram
REUSE SETTINGS
same arguments
35. A FOR loop can be indexed by numbers or by a ______.
compile
cursor
open C(p)
v1 OUT number default 10
36. Delimiters: the attribute indicator.
*/
%
$$PLSQL_LINE
$END
37. Fundamental: Which one of these is a compound symbol: = - :=
bytecode
cached
exception handler
:=
38. What are the two sequence pseudo-columns?
expression
bind
currval and nextval
base
39. The variable showing the user id of the session owner.
rollback to ab
calls
dynamic
SESSION_USER
40. Value of a character literal with zero characters.
expression
%ROWTYPE
in the database
41. An autonomous program runs in its own __________.
transaction
ENABLE
SYS_REFCURSOR
TIMESTAMP.
42. A (simple / searched) CASE statement begins with CASE <expression>.
for each row
simple
comments
enclosing
43. Cursors: The values plugged into the DML in a FORALL must come from existing - populated _________.
collections
bytecode
does not
True
44. The RESULT_CACHE clause has to be in both the declaration and in the ______ of the function.
definition
boolean
error code
:=
45. The three possible values of a BOOLEAN literal.
32 -000
True - false or NULL.
CREATE TRIGGER
512
46. The BETWEEN operator is (inclusive / exclusive).
inclusive
constant
after
can
47. The PL/SQL ________ evaluates compiler directives.
preprocessor
delimiters
STANDARD
compilation
48. An INSTEAD OF trigger specifies what to do instead of a ___ statement.
DML
PUT_LINE
selection
PLS_INTEGER
49. Cursors: The FOR UPDATE phrase goes at the (beginning/end) of the cursor definition.
inquiry
context
GET_LINE
end
50. True encryption is done with package __________.
PLSQL_OPTIMIZE_LEVEL
RELIES_ON
DBMS_CRYPTO
unconstrained