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 supports ______-oriented programming.
TYPE tN IS TABLE of NUMBER
1
CHAR - VARCHAR2
object
2. Declare an unconstrained subtype of NUMBER called NUMB.
drop procedure
SUBTYPE numb IS number;
production
TYPE tN IS TABLE of NUMBER
3. Fundamental: What are the 3 compound symbols for 'not equal to'?
EXTEND
LOOP - END LOOP
v3 IN OUT NUMBER
<> - != - ^=
4. IDs: The two types of words that can - but should not - be used as user-defined identifiers.
is certain
Keywords and predefined names.
EXIT
concatenation
5. DynSQL: The three modes of arguments in the USING clause of EXECUTE IMMEDIATE.
run
IN - OUT - IN OUT
ROLLBACK
implicit CASE_NOT_FOUND exception
6. You (can/cannot) put a label before an END LOOP statement.
cannot
COMMIT - ROLLBACK - SAVEPOINT - SET TRANSACTION
EXECUTE IMMEDIATE
propagates
7. FOR-Looping over a collection from FIRST to LAST only works if the collection is _______.
sequence pseudo-columns
savepoint ab
dense
disable
8. What is the simplest statement for conditionally getting out of simple loop?
fail
EXIT WHEN
WHERE CURRENT OF
current
9. IDs: The type of words that cannot be user-defined identifiers.
will not
Reserved words.
FALSE
INTO
10. The declaration section is (optional/mandatory).
preprocessor
mandatory
optional
...
11. Dbms_sql: The integer returned by OPEN_CURSOR is a _____ _____.
DECLARE - BEGIN - EXCEPTION - END
1
associative
cursor number
12. The allowed data types of user-defined conditional compilation directives are boolean and _______.
anonymous block
SYS_REFCURSOR
boolean
pls_integer
13. Define a record type REC with number num and varchar2(10) name.
TYPE rec IS RECORD (num NUMBER - name VARCHAR2(10));
USER_PROCEDURES
drop procedure
oname
14. Types: ________ data types have no internal components.
scalar
compile
Abstract
define
15. In a cursor loop - the clause added to an INSERT or UPDATE to point at the current record.
ENABLE
WHERE CURRENT OF
fine-grained auditing
IN
16. Internally - the NUMBER type is stored as ______. Therefore - decimal numbers (such as prices) are stored exactly - with no rounding.
function f (n number) return number result_cache relies_on (emps);
transaction
decimal
cursor
17. Conversion: If the specific value is suitable - ____ or _______ values can convert to almost any datatype
external subprogram
%BULK_ROWCOUNT
CHAR - VARCHAR2
REF_CURSOR
18. I/O: The PL/SQL I/O packages (can/cannot) accept input directly from the keyboard.
compile
autonomous transaction
cannot
index
19. Triggers: You create a trigger with the _______ ________ statement.
injection
Oracle
CREATE TRIGGER
base
20. The _______ package lets you wrap dynamically generated PL/SQL.
SESSION_USER
DBMS_DDL
WHERE CURRENT OF
multi-row
21. In short-circuit evaluation - IF-conditions are only evaluated up to where the outcome ___________.
CHARARR
Gateway
procedure P AUTHID current_user;
is certain
22. Cursors: A cursor FOR loop cannot use a _______ variable.
PLS_INTEGER
nested tables - associative arrays
%ROWTYPE
cursor
23. Bytecode is _______ _______ code.
lower sub-block
a cursor
plb
virtual machine
24. Triggers: In a DML trigger - the phrase that makes the trigger run for every affected record.
name and datatype
L.V
selection
for each row
25. Cursors: Give the statement to close cursor C.
close C
True
is
<<>>
26. I/O: dbms_output.put_line puts output into a _______.
IN - OUT - IN OUT
EXIT WHEN
optional
buffer
27. I/O: The most basic PL/SQL way to give output to the user.
cursor
dbms_output.put_line
implicit cursor
external subprogram
28. The $ERROR directive is used to make compilation ____.
closed
r tRec := tRec(9 - 'Jones');
fail
simple and compound symbols
29. Fundamental: A label can be used to name an ______ block.
database
procedure P AUTHID current_user;
DBMS_SQL
anonymous
30. Web: mod_plsql is an implementation of the PL/SQL _________.
Gateway
compiles
-20 -000
after
31. Triggers: The clause to make a trigger run before inserting or updating table EMPS.
before insert or update on emps
FOR - IN
is not
timing
32. Triggers: An INSTEAD OF trigger (can/cannot) be conditional.
Ordinary - Quoted.
sql
cannot
simple and compound symbols
33. _____ arrays cannot be used as the type of an Oracle table column.
SQL
SQL
fail
associative
34. Advantage: Performance: Storing and runnng procedures on the server minimizes ______ traffic.
$IF $THEN $ELSE $END
composite
network
lower sub-block
35. Abbreviation of definer's rights
execute immediate
error
suspended
DR
36. A kind of variable used as a placeholder.
dynamic
bind
END
before insert or update on emps
37. A PL/SQL block that is not stored.
RECORDS
bb:true
function f (n number) return number result_cache relies_on (emps);
anonymous block
38. Types of blocks: Procedures and functions are _______ blocks.
cannot
invoker's
stored
FORALL and BULK COLLECT
39. I/O: The buffered output of dbms_output.put_line is retrieved by _______.
SQLPlus
database
NDS
external subprogram
40. The three types of compiler warnings.
EVERE - PERFORMANCE - INFORMATIONAL
source code
anonymous
plb
41. Name the two types of FOR loop.
REF CURSOR
exit when cgo%NOTFOUND
HTF
numeric and cursor
42. Bulk: The two features that comprise Bulk SQL are:
SUBTYPE numb IS number;
implicit cursor
FORALL and BULK COLLECT
bind
43. Fundamental: A label can only go directly before an _______ statement.
executable
selection
...
open C(p)
44. The attribute used to get the type of a column or variable without knowing what it is.
finishes
invoker's
obfuscates
%TYPE
45. The first SQL statement in an autonomous routine begins a _______.
transaction
ENABLE
EXIT
query
46. The BEGIN section is (optional/mandatory)
varray
mandatory
do not
%ROWTYPE
47. Cursors: Opening keyword of a cursor FETCH loop.
object
LOOP
is
explicit
48. Cursors: If an exception is raised inside a cursor loop - the cursor (is / is not) also closed automatically.
NESTED TABLE myColl STORE AS myCollTab
is
execute
implicit cursor
49. What do you FETCH from?
bytecode
512
block
a cursor
50. Types of blocks: A pl/sql block that is not stored in the database.
2
versions
anonymous
USING