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. 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
2. The _____ utility turns PL/SQL source code into unreadable text.
disable
optional
virtual machine
Wrap
3. Advantage: PL/SQL programs are stored centrally - making them more ______.
OTHERS
unconstrained
manageable
L.V
4. Which collection type is bounded?
cannot
varray
after insert on emps
=
5. Triggers: In a per-row trigger - the ____ record shows you the changed state of an affected row.
CURRENT_USER - DEFINER
implicit
%ISOPEN.
NEW
6. Give the clause you add to a CREATE TABLE statement - when there is a collection column myColl - that you want to be stored in a table called myCollTab.
PL/SQL
NESTED TABLE myColl STORE AS myCollTab
dynamic
select
7. Declare a package procedure P with no arguments - and give it definer's rights.
procedure P AUTHID definer;
manageable
is certain
compilation
8. Types: ________ data types have internal components.
ALTER SESSION
aliases
composite
in the database
9. Types: Which type of arithmetic does NUMBER use - library or hardware?
bind
index
define
library
10. The inquiry directive that gives the current line number in the procedure.
library
DBMS_PIPE
an enclosing block
$$PLSQL_LINE
11. Advantage: PL/SQL is PORTABLE to any OS where ________ runs.
UTL_FILE
PLS_INTEGER
searched
Oracle
12. Types: A ______ has the same valid operations as its base type.
5
SQL
subtype
FETCH
13. Declare an unconstrained subtype of NUMBER called NUMB.
SUBTYPE numb IS number;
'
savepoint ab
True
14. Triggers: INSTEAD OF triggers only run on ______ views.
cannot
non-editioning views
cursor
pseudocolumn
15. Unlike the CASE statement - the CASE expression does not have the...
simple and compound symbols
cursor
**
implicit CASE_NOT_FOUND exception
16. Triggers: Unlike a stored procedure - you can enable and _____ a trigger.
disable
not a number
static
source code
17. The PL/SQL ________ evaluates compiler directives.
1
index
preprocessor
type T is ref cursor
18. Exceptions: Each internal exception has an Oracle ______ _______.
IN OUT
versions
lower sub-block
error code
19. Cursors: A cursor FOR loop can use an explicit or an _______ cursor.
USING
implicit
elsif
FOR i IN REVERSE 1..10 - LOOP - NULL; END LOOP;
20. Give the first line of the FOR loop with index i going from 1 to 10 in reverse.
anonymous block
FOR i IN REVERSE 1..10 LOOP
=
ROLLBACK
21. Dbms_sql: A cursor opened with OPEN_CURSOR (can/cannot) be reused for multiple queries without first closing it.
EXECUTE IMMEDIATE
UTL_HTTP
can
aggregate - analytical
22. In interpreted mode - PL/SQL code is run in a _______ _______.
virtual machine
END CASE
implicit
IF - CASE or LOOP
23. Types of blocks: A pl/sql block that is not stored in the database.
national
L.V
FETCH
anonymous
24. Cursors: Only a _____ _____ cursor can appear in the CURRENT OF clause of an UPDATE or DELETE statement.
1
external subprogram
FOR UPDATE
.
25. The RESULT_CACHE clause has to be in both the declaration and in the ______ of the function.
FOR i IN REVERSE 1..10 LOOP
definition
implicit
3
26. I/O: The most basic PL/SQL way to give output to the user.
cannot
dbms_output.put_line
portable
colon
27. Bulk: The keywords of a bulk collect FETCH statement.
array
single-line
anonymous
FETCH - BULK COLLECT INTO
28. Web: mod_plsql is an implementation of the PL/SQL _________.
information that changes infrequently
null string
ROLLBACK
Gateway
29. Cursors: How many DML statements can a FORALL statement contain?
1
True - false or NULL.
SYS_CONTEXT
ADT
30. Fundamental: One of the 4 types of lexical units: d_____
p.v
cannot
delimiters
CURSOR - RETURN
31. Are good for logging table DML operations.
create procedure
follows
autonomous triggers
CURRENT_USER - DEFINER
32. Cursors: An explicit cursor (can/cannot) accept parameters.
cursor
can
view
DBMS_SESSION
33. Delimiters: The component indicator/selector.
network
same arguments
.
DBMS_SESSION.RESET_PACKAGE
34. PL/SQL is a ________ typed programming language.
RAISE
statically
$$PLSQL_LINE
parameter
35. IDs: List the two types of user-defined identifiers.
Ordinary - Quoted.
variable
elsif
With a letter.
36. To get the current value of CURRENT_SCHEMA - CURRENT_USER - or SESSION_USER - use the ____ function.
:=
1
SYS_CONTEXT
DR
37. Exceptions: An exception in the declarations section propagates to the enclosing _______.
block
END IF
UTL_SMTP
hardware
38. Triggers: When using the NEW or OLD pseudo-records in the body of the trigger - they must be prefixed with a _______.
colon
DATE
exception handler
cursor variable
39. An anonymous block is a(n) ____ statement.
increment
SQL
Gateway
PUT_LINE
40. What is the simplest statement for conditionally getting out of simple loop?
literals
...
EXIT WHEN
unhandled
41. An incomplete type is a type created by a ______ type definition.
/*
SQL
forward
=
42. Dbms_sql: The integer returned by OPEN_CURSOR is a _____ _____.
implicit
cursor number
implicit cursor
base
43. Triggers: A compound trigger can fire at more than one ______ point.
timing
IN
autonomous triggers
30
44. Assignment of PLSQL_CCFLAGS (cannot / can) be included in ALTER PROCEDURE ... COMPILE ...
can
DBMS_PIPE
FETCH - BULK COLLECT INTO
45. I/O: One of the 3 types of data that can be passed to the DBMS_OUTPUT buffer.
VARCHAR2
value
%TYPE
exception
46. Cursors: Opening keyword of a cursor FETCH loop.
increment
REF CURSOR
LOOP
47. An autonomous program runs in its own __________.
transaction
slower
flushed
nested tables - associative arrays
48. VARRAYs are (always / never) sparse.
never
after
EXIT WHEN
API
49. By default - OUT and IN OUT parameters are passed by _____.
value
@
unhandled
cannot
50. I/O: This DBMS_OUTPUT proc retrieves one line from the buffer.
GET_LINE
nested
Double quotes.
1