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. An editioning view can only select a subset of the columns from the base table and provide ________ for them
SIMPLE_INTEGER
aliases
TYPE rec IS RECORD (num NUMBER - name VARCHAR2(10));
dense
2. The Wrap utility ________ the source code.
obfuscates
index
varray
FGA
3. Cursors: SYS_REFCURSOR is a predefined type based on _____ ______.
buffer
REF CURSOR
UTL_SMTP
execute
4. Advantage: Having procedures stored and executed on the server makes PL/SQL ________.
invalid
scalable
ENABLE
cannot
5. You can put a label before any executable PL/SQL _________.
literals
statement
TOO_MANY_ROWS
REF_CURSOR
6. Bulk: The use of FORALL statements cuts down on ______ traffic.
static boolean
drop procedure
network
library
7. In a FORALL loop - you (can / cannot) use the index variable for purposes other than indexing into the collection.
closed
boolean
constructor
cannot
8. A result-cached function caches its results in the _____ _____ ____ (SGA)
system global area
calls
simple and compound symbols
v2 IN NUMBER default 20
9. Cursors: The first two keywords in a Cursor FOR loop.
**
for each row
invoker's
FOR - IN
10. DynSQL: The colon-prefixed names used in EXECUTE IMMEDIATE are called ________.
placeholders
FETCH
DBMS_PREPROCESSOR
END LOOP
11. You have to use _______ SQL to run DDL statements n PL/SQL.
UTL_FILE
inclusive
after insert on emps
dynamic
12. The Wrap utility (does / does not) encrypt source code.
END
LOOP - END LOOP
does not
before insert or update on emps
13. You cannot bulk collect into an ARRAY OF ________.
specification - body
RECORDS
1
$IF
14. Triggers: In a per-row trigger - the ____ record shows you the changed state of an affected row.
explicit cursor
NEW
...
selection
15. The command used to populate PLSQL_CCFLAGS.
autonomous triggers
HTP
ALTER SESSION
network
16. Types: PL/SQL has all the _____ data types.
SQL
loop
elements - type
4
17. With a result-cached function - it uses a cached value when the function is called again with the...
composite
invoker's
same arguments
external subprogram
18. Types: One of the 4 PL/SQL things that have a data type (begins with 'r').
TIMESTAMP.
return value
decimal
PRAGMA AUTONOMOUS_TRANSACTION;
19. Declare an input NUMBER parameter - v2 - that defaults to 20.
for update of
cursor variable
=>
v2 IN NUMBER default 20
20. I/O: Max number of bytes to pass in a call to DBMS_OUTPUT.PUT_LINE.
expression
255
OPEN_CURSOR
dense
21. Advantage: Performance: Stored subprograms are ______ in memory.
BINARY_INTEGER
TYPE tN IS TABLE of NUMBER
%
cached
22. Cursors: How many implicit cursors can you access?
512
RETURN
1
label
23. In Native Mode - PL/SQL code is compiled into ______ ______.
machine code
VARRAY - Nested table
32 -000
nested
24. IDs: Predefined identifiers are declared in this package.
preprocessor
cursor number
implicit CASE_NOT_FOUND exception
STANDARD
25. Cursors: Give the statement to close cursor C.
close C
INTO
%BULK_ROWCOUNT
lower sub-block
26. Dbms_sql: The integer returned by OPEN_CURSOR is a _____ _____.
aliases
cursor number
preprocessor
index
27. DynSQL: EXECUTE IMMEDIATE does both dynamic SQL and dynamic _______.
PL/SQL
after
implicit
preprocessor
28. Which two collection types are unbounded?
USER_PROCEDURES
END IF
cached
nested tables - associative arrays
29. DynSQL: The standard package that does dynamic SQL.
PVM
UTL_FILE
index
DBMS_SQL
30. Fundamental: What are the 3 compound symbols for 'not equal to'?
is
<> - != - ^=
predefined
SQL
31. Cursors: If you use an EXIT statement to exit a cursor FOR loop prematurely - the cursor (is / is not) closed automatically.
OTHERS
is
END IF
package
32. Exceptions: An unhandled exception ________ to the enclosing block.
PL/SQL Gateway
selection
propagates
can
33. Web: PL/SQL ______ ______ (PSPs) let you develop web pages with dynamic content.
Server Pages
base
anonymous
USING
34. Triggers: The clause to make a trigger run after inserting into table EMPS.
simple and compound symbols
propagates
after insert on emps
PL/SQL Gateway
35. Cursors: An explicit cursor (can/cannot) accept parameters.
can
nested
Gateway
query
36. Exceptions: Write the call (2 args) to associate message 'Bad' with error code -20 -100.
Warning
: Invalid argument supplied for foreach() in
/var/www/html/basicversity.com/show_quiz.php
on line
183
37. What are the two sequence pseudo-columns?
currval and nextval
TYPE tV IS VARRAY(100) OF NUMBER
TYPE tN IS TABLE of NUMBER
array
38. Cursors: You give an explicit cursor a name and associate it with a _______.
memory
national
cursor number
query
39. In short-circuit evaluation - IF-conditions are only evaluated up to where the outcome ___________.
IR
is certain
pls_integer
define
40. Cursors: The values plugged into the DML in a FORALL must come from existing - populated _________.
collections
autonomous triggers
FETCH
include
41. You (can / cannot) wrap trigger source code.
Double quotes.
cannot
comments
pls_integer
42. The AUTHID property applies to PL/SQL objects that contain _____.
CURRENT_USER - DEFINER
slower
code
RETURN
43. Cursors: Give the statement to fetch data from cursor C into variable V.
1
fetch C into V
after insert on emps
finishes
44. The valid values of the AUTHID property.
COUNT
PL/SQL
API
CURRENT_USER - DEFINER
45. Cursors: A Cursor FOR loop does not use a ______ statement.
optional
FETCH
SQL cursor
v2 IN NUMBER default 20
46. The DEFINITION of a cursor is the _____ that returns the records.
plb
USING
query
OPEN
47. Exceptions: Declare an exception called E.
E Exception;
HTF
fail
information that changes infrequently
48. Give the value list in the PLSQL_WARNINGS parameter to turn on SEVERE compiler warnings and make compiler warning 06002 be an error.
Warning
: Invalid argument supplied for foreach() in
/var/www/html/basicversity.com/show_quiz.php
on line
183
49. Type: An ________ subtype has all the values of its base type.
SYS_CONTEXT
stored
unconstrained
WHEN OTHERS THEN
50. The DECLARE keyword is only required in an _______ _______.
DATE '2005-12-25'
anonymous block
set serveroutput on
same