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. In a cursor loop - the clause added to an INSERT or UPDATE to point at the current record.
executable
WHERE CURRENT OF
suspended
cursor variable
2. You can have many autonomous transactions in ___________.
an autonomous routine
CREATE TYPE
STANDARD
execute immediate
3. What are two categories of SQL functions that cannot be used in procedural statements?
explicit
aggregate - analytical
disable
transaction
4. The allowed data types of user-defined conditional compilation directives are boolean and _______.
FOR i IN REVERSE 1..10 LOOP
pls_integer
rollback to ab
VARRAY - Nested table
5. Term for a character literal with zero characters.
null string
bind
vname CONSTANT VARCHAR2 := 'x';
never
6. The compiler directive used to select which code to compile.
3
boolean
$IF
not a number
7. Kind of comment not to put in a PL/SQL block to be processed dynamically by an Oracle Precompiler program.
compilation
placeholders
COMMIT - ROLLBACK - SAVEPOINT - SET TRANSACTION
single-line
8. Conditional compilation is useful for compiling a program under different ______ of Oracle.
versions
error
CREATE TRIGGER
Reserved words.
9. VARRAYs are (always / never) sparse.
column
invalid
never
unhandled
10. Web: Abbreviation of PL/SQL Server Page.
PRAGMA EXCEPTION_INIT (E - -1);
PSP
Apache
finishes
11. Triggers: On a non-editioning view - you can only define __________ triggers.
network
CURRENT_USER
INSTEAD OF
portable
12. Cursors: The four cursor attributes - in alphabetical order.
3
%FOUND - %ISOPEN - %NOTFOUND - %ROWCOUNT
Apache
is
13. Declare a package procedure P with no arguments - and give it definer's rights.
aliases
statically
..
procedure P AUTHID definer;
14. Advantage: PL/SQL programs are stored centrally - making them more ______.
p.v
CURRENT_USER - DEFINER
$IF $THEN $ELSE $END
manageable
15. Bulk: The implicit cursor attribute that gives the number of rows affected by each DML statement in a FORALL statement.
True - false or NULL.
DBMS_PREPROCESSOR
%BULK_ROWCOUNT
binding
16. Give the ANSI Date literal for December 25 - 2005.
Warning
: Invalid argument supplied for foreach() in
/var/www/html/basicversity.com/show_quiz.php
on line
183
17. Fundamental: What are the 3 compound symbols for 'not equal to'?
suspended
<> - != - ^=
suspended
dense
18. The two kinds of CASE statements are simple and ________.
searched
procedure P AUTHID current_user;
run
DATE '2005-12-25'
19. Cursors: If an exception is raised inside a cursor loop - the cursor (is / is not) also closed automatically.
CREATE TYPE
expression
is
stored
20. The attribute used to get the type of a column or variable without knowing what it is.
PL/SQL Gateway
%TYPE
1
OPEN_CURSOR
21. What is the simplest statement for getting out of simple loop?
FORALL i IN MyList.FIRST..MyList.LAST
EXIT
savepoint ab
%FOUND - %ISOPEN - %NOTFOUND - %ROWCOUNT
22. With dynamic typing - type checking is done at ______time.
HTP
1
v1 OUT number default 10
run
23. Types: ________ data types have no internal components.
procedure - function
DATE
scalar
REUSE SETTINGS
24. The SET TRANSACTION statement affects only the ____________.
BINARY_INTEGER
iname
current transaction
REF_CURSOR
25. Cursors: A cursor FOR loop cannot use a _______ variable.
CREATE TYPE
CLOSE
ROLLBACK
cursor
26. Cursors: Give the statement to close cursor C.
$IF
BOOLEAN
close C
UTL_FILE
27. A unit with AUTHID = CURRENT_USER is an ________ rights unit.
Warning
: Invalid argument supplied for foreach() in
/var/www/html/basicversity.com/show_quiz.php
on line
183
28. Internally - the NUMBER type is stored as ______. Therefore - decimal numbers (such as prices) are stored exactly - with no rounding.
invalid
IF - CASE or LOOP
forward
decimal
29. In short-circuit evaluation - IF-conditions are only evaluated up to where the outcome ___________.
error
execute immediate
cannot
is certain
30. A GOTO cannot branch into a...
injection
lower sub-block
DR
same
31. TCL: Create a savepoint called ab
Declaration
savepoint ab
not the same
REUSE SETTINGS
32. A FOR-loop counter is defined only within the _____.
cannot
sql
binding
loop
33. Triggers: A compound trigger can fire at more than one ______ point.
<> - != - ^=
IS
buffer
timing
34. Triggers: You (can/cannot) explicitly invoke a trigger.
significant
cannot
include
STANDARD
35. The variable showing the user id of the session owner.
SESSION_USER
optional
FORALL i IN MyList.FIRST..MyList.LAST
after
36. Web: PL/SQL _______ enables a Web browser to invoke a PL/SQL stored subprogram through an HTTP listener.
DEFINER
Gateway
an enclosing block
open C
37. 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
38. From a block nested inside a procedure P - reference variable V of the outer procedure.
HTF
p.v
transaction
cannot
39. Default file extension of wrap's input file.
sql
=
UTL_HTTP
virtual machine
40. The $ERROR directive is used to make compilation ____.
FOR UPDATE
iname
fail
fields
41. In the IF syntax - is if ENDIF or END IF?
simple and compound symbols
bb:true
END IF
fields
42. I/O: The buffered output of dbms_output.put_line is retrieved by _______.
does not
END
SQLPlus
5
43. Parameter that controls how much Oracle optimizes your PL/SQL code on compilation.
FOR - IN
True
PLSQL_OPTIMIZE_LEVEL
does not
44. What do you FETCH from?
DBMS_PREPROCESSOR
closed
a cursor
sequence pseudo-columns
45. A pointer to a private SQL area that stores information about processing a specific SELECT or DML statement.
cursor
searched
open cv for
=
46. DynSQL: The three modes of arguments in the USING clause of EXECUTE IMMEDIATE.
...
view
IN - OUT - IN OUT
EVERE - PERFORMANCE - INFORMATIONAL
47. With conditional compilation you can avoid compiling debug code in the _______ environment.
statement
production
open C(p)
literal
48. The three sorts of date/time types are DATE - INTERVAL and _________.
associative
collections
error code
TIMESTAMP.
49. Which collection type is bounded?
varray
obfuscates
1
CURSOR - RETURN
50. The RESULT_CACHE clause has to be in both the declaration and in the ______ of the function.
definition
implicit cursor
user-defined
bind arguments