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. Cursors: If an exception is raised inside a cursor loop - the cursor (is / is not) also closed automatically.
context
is
FORALL i IN MyList.FIRST..MyList.LAST
pseudocolumn
2. Dbms_sql: This DBMS_SQL function opens a new cursor.
obfuscates
OPEN_CURSOR
v3 IN OUT NUMBER
$IF
3. This is a CASE (expression / statement): myvar := CASE num WHEN 1 THEN 'good' WHEN 2 THEN 'bad' END;
VARCHAR2
expression
for update of
portable
4. Cursors: The second keyword of a FETCH statement.
INTO
aggregate - analytical
names
is
5. Delimiters: The assignment operator.
preprocessor
commit - rollback
:=
is not
6. A type of compiler directive - begins with 'e'.
3
an AUTHID property
error
CURSOR - RETURN
7. A subprogram defined within another subprogram is a _______ subprogram.
$$
anonymous block
nested
boolean
8. Triggers and views always have _________ rights.
Warning
: Invalid argument supplied for foreach() in
/var/www/html/basicversity.com/show_quiz.php
on line
183
9. Conversion: Implicit conversion is not always predictable; it is _______-sensitive. And its rules might change.
source code
composite
FOR i IN REVERSE 1..10 - LOOP - NULL; END LOOP;
context
10. Which collection type is bounded?
USER_PLSQL_OBJECT_SETTINGS
predefined
varray
EXIT WHEN
11. FOR-Looping over a collection from FIRST to LAST only works if the collection is _______.
transaction
dense
invoker's
RECORD OF ARRAYS
12. Cursors: Give the statement to fetch data from cursor C into variable V.
fetch C into V
OPEN_CURSOR
FOR i IN REVERSE 1..10 - LOOP - NULL; END LOOP;
WHEN
13. A numeric FOR loop cannot _________ by other than 1?
512
increment
commit - rollback
machine code
14. Type: An ________ subtype has all the values of its base type.
HTF
unconstrained
FORALL and BULK COLLECT
open C(p)
15. Cursors: The SQL%FOUND attribute has how many possible values?
3
constant
Web Toolkit
mandatory
16. Cursors: The Oracle predefined REF CURSOR type.
cannot
ordinary
SYS_REFCURSOR
DBMS_PIPE
17. Give the statement to make a program autonomous.
iname
CREATE TYPE
PRAGMA AUTONOMOUS_TRANSACTION;
associative
18. You cannot bulk collect into an ARRAY OF ________.
an enclosing block
RECORDS
cannot
procedure - function
19. With a result-cached function - it uses a cached value when the function is called again with the...
USING
finishes
same arguments
unhandled
20. Cursors: SYS_REFCURSOR is a predefined type based on _____ ______.
exception handler
ex := tbl1 MULTISET EXCEPT tbl2
REF CURSOR
%BULK_ROWCOUNT
21. Conversion: Implicit conversion can be (faster / slower) than explicit conversion.
executable
slower
collections - records
user-defined
22. The _______ package lets you wrap dynamically generated PL/SQL.
DBMS_DDL
rollback to ab
SYS_CONTEXT
aggregate - analytical
23. Cursors: The type definition of a WEAK ref cursor type has no _______ clause.
preprocessor
IN
RETURN
GET_LINE
24. Triggers: You (can/cannot) explicitly invoke a trigger.
4
name
hardware
cannot
25. How many types of compiler directives are there?
plb
executable
do not
3
26. If you are in a procedure inside a package - the compilation unit is the _______.
concatenation
decimal
BINARY_INTEGER
package
27. PL/SQL is a ________ typed programming language.
cannot
memory
currval and nextval
statically
28. Data dictionary view that shows the compiler settings for each compiled object.
REUSE SETTINGS
must
selection
USER_PLSQL_OBJECT_SETTINGS
29. What is the simplest statement for conditionally getting out of simple loop?
255
suspended
upper - coalesce
EXIT WHEN
30. Triggers: A compound trigger can fire at more than one ______ point.
user-defined
WHERE CURRENT OF
code
timing
31. Advantage: Caching of programs and sharing among users lowers _______ requirements.
identifiers
unhandled
memory
concatenation
32. Advantage: PL/SQL gives SCALABILITY because stored procedures are executed on the _______.
do not
server
reference
can
33. _______ arrays can be sparse or dense - depending on how you fill them.
associative
set serveroutput on
UTL_FILE
RAISE
34. Into nested table ex - put elements of tbl1 that are not in tbl2.
ALTER SESSION
elsif
ex := tbl1 MULTISET EXCEPT tbl2
can
35. Declare an unconstrained subtype of NUMBER called NUMB.
database
SUBTYPE numb IS number;
literals
decimal
36. A SELECT statement with the FOR UPDATE clause puts a ______ on the selected rows.
IN OUT
lock
sql
forward
37. Searchable CASE statement: Each WHEN has its own _______ condition.
boolean
Declaration
fail
dense
38. I/O: The most basic PL/SQL way to give output to the user.
hardware
optional
SQLPlus
dbms_output.put_line
39. The RESULT_CACHE clause has to be in both the declaration and in the ______ of the function.
definition
END IF
...
code
40. The two kinds of CASE statements are simple and ________.
CHARARR
not a number
searched
fail
41. Make a FOR loop that executes NULL 10 times counting in reverse - using index i.
FOR i IN REVERSE 1..10 - LOOP - NULL; END LOOP;
INTO
CLOSE_CURSOR
RETURN
42. Conditional compilation is useful for compiling a program under different ______ of Oracle.
associative
executable
increment
versions
43. Exceptions: The ________ function returns the error message associated with an error code.
SQLERRM
alter procedure
injection
EXIT
44. Types: One of the scalar data types specific to PL/SQL: B_______
associative
column
BINARY_INTEGER
ex := tbl1 MULTISET EXCEPT tbl2
45. Associative array types (can / cannot) be defined in the database.
colon
USER_PROCEDURES
FOR - IN
cannot
46. I/O: The PL/SQL I/O packages (can/cannot) accept input directly from the keyboard.
-
cannot
DECLARE - BEGIN - EXCEPTION - END
anonymous
47. PLS_INTEGER has its arithmetic implemented in ________ - so it is very fast.
$IF
for each row
hardware
name-value
48. In Native Mode - PL/SQL code is compiled into ______ ______.
PLS_INTEGER
machine code
suspended
alter procedure
49. Cursors: A Cursor FOR loop does not use a ______ statement.
close C
mandatory
FETCH
single-line
50. To run TCL or DDL statements - a trigger (must / must not) be autonomous .
must
DATE '2005-12-25'
array
rollback to ab