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. Triggers: Programmers (as opposed to DBAs) mostly make use of _____ triggers.
GET_LINES
cached
DML
cursor
2. Bulk: The keywords of a bulk collect FETCH statement.
specification - body
FETCH - BULK COLLECT INTO
PLS_INTEGER
TYPE tN IS TABLE of NUMBER
3. NAN stands for _________.
EXECUTE IMMEDIATE
once
static
not a number
4. The meaning of 'FGA'.
cannot
fine-grained auditing
exception handler
searched
5. In the IF syntax - is if ENDIF or END IF?
boolean
exit when cgo%NOTFOUND
associative
END IF
6. I/O: The buffered output of dbms_output.put_line is retrieved by _______.
dense
a cursor
SQLPlus
view
7. An anonymous block is a(n) ____ statement.
SQL
SESSION_USER
anonymous
Gateway
8. The _______ package lets you wrap dynamically generated PL/SQL.
DBMS_DDL
=>
simple and compound symbols
associative
9. Records are one of the two kinds of PL/SQL _______ data types.
compiles
must
currval and nextval
composite
10. An ordinary character literal is composed of characters in the ________ character set.
composite
oname
database
INTO
11. Declare an associative array type - t - whose elements are of type rPerson - and whose index is PLS_INTEGER.
v1 OUT number default 10
TYPE t IS TABLE OF rPerson INDEX BY PLS_INTEGER;
associative
UTL_SMTP
12. Advantage: PL/SQL programs are stored centrally - making them more ______.
binding
manageable
Wrap
fail
13. TCL: Undo changes back to savepoint ab.
..
CURRENT_USER
rollback to ab
$$
14. For an associative array - the FIRST method gets the (lowest / first-created) index.
FETCH
vname CONSTANT VARCHAR2 := 'x';
lowest
TYPE tV IS VARRAY(100) OF NUMBER
15. Cursors: If an exception is raised inside a cursor loop - the cursor (is / is not) also closed automatically.
is
1
1
LOOP - END LOOP
16. The BEGIN section is (optional/mandatory)
OLD
TOO_MANY_ROWS
DECLARE - BEGIN - EXCEPTION - END
mandatory
17. Triggers: If two or more triggers are defined with the same timing point - then you can control the firing order using the ________ clause.
cannot
follows
Ada
Apache
18. This is a CASE (expression / statement): myvar := CASE num WHEN 1 THEN 'good' WHEN 2 THEN 'bad' END;
expression
OPEN_CURSOR
$END
type T is ref cursor
19. How many types of compiler directives are there?
3
WHEN OTHERS THEN
DBMS_DDL
IN OUT
20. Types: A data type family consists of a ______ type and its subtypes.
REUSE SETTINGS
USING
enclosing
base
21. _______ arrays can be sparse or dense - depending on how you fill them.
associative
TYPE tV IS VARRAY(100) OF NUMBER
UTL_HTTP
after
22. Triggers: You (can/cannot) explicitly invoke a trigger.
cannot
array
unhandled
GET_LINE
23. Dbms_sql: This DBMS_SQL function opens a new cursor.
constant
True - false or NULL.
collections - records
OPEN_CURSOR
24. The command used to populate PLSQL_CCFLAGS.
production
SESSION_USER
ordinary
ALTER SESSION
25. Keyword for doing assignment to a variable with SELECT.
Ada
INTO
%BULK_ROWCOUNT
bind
26. Triggers: The clause to make a trigger run once for every affected row.
SQL
PLS_INTEGER
drop procedure
for each row
27. In interpreted mode - the PL/SQL VM interprets the _________.
DATE '2005-12-25'
True
slower
bytecode
28. IDs: How an ordinary user-defined identifier must begin.
2
With a letter.
slower
compiles
29. Exceptions: User-defined exceptions must have _______.
names
oname
explicit
simple
30. An autonomous program runs in its own __________.
transaction
placeholders
can
..
31. 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
32. Setting CURRENT_SCHEMA only changes what is prepended to __________ references.
unqualified
fetch cv into myvar
name-value
never
33. Triggers: There are __ types of triggers.
obfuscates
view
5
p.v
34. The NOCOPY option on an OUT or IN OUT parameter - causes it to be passed by ______.
CHAR - VARCHAR2
same
reference
$$
35. Cursors: The type definition of a WEAK ref cursor type has no _______ clause.
RETURN
constrained
label
PL/SQL
36. Bulk: The two features that comprise Bulk SQL are:
collections
=>
FORALL and BULK COLLECT
does not
37. Cursors: What is the 'name' of the implicit cursor?
%
SQL
always
delimiters
38. Fundamental: What is the range operator?
virtual machine
IS
..
vname CONSTANT VARCHAR2 := 'x';
39. Types: The storage size of a NUMBER value is based on the number of ______ digits.
PL/SQL Gateway
pseudocolumn
significant
names
40. A subprogram defined within another subprogram is a _______ subprogram.
..
TIMESTAMP.
1
nested
41. After the RESULT_CACHE clause - you can put a _________ clause to enable dependency-checking.
RELIES_ON
RESULT_CACHE
executable
.
42. I/O: SQLPlus command for turning on buffered output.
set serveroutput on
Web Toolkit
can
RAISE
43. Wrap iname=xxxx _____=zzzzz
CLOSE_CURSOR
oname
disable
specification - body
44. Fundamental: A label can only go directly before an _______ statement.
executable
1
OTHERS
statically
45. Bulk: The use of FORALL statements cuts down on ______ traffic.
network
static boolean
constant
current BEGIN-END block
46. DynSQL: The clause that receives single-row query output from EXECUTE IMMEDIATE.
INTO
collections
FALSE
RETURN
47. In PL/SQL - what the variables in DML statements are turned into.
..
code
30
bind arguments
48. Advantage: Performance: Stored subprograms are ______ in memory.
cached
can
invoker's
IF - CASE or LOOP
49. To create a collection type - use the TYPE command in PL/SQL and the ______ _____ command in SQL.
$IF $THEN $ELSE $END
PLS_INTEGER
CREATE TYPE
external subprogram
50. The FORALL statement to loop over a collection MyList using index i.
selection
FORALL i IN MyList.FIRST..MyList.LAST
machine
executable