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. Declare an unconstrained subtype of NUMBER called NUMB.
DATE '2005-12-25'
SUBTYPE numb IS number;
pseudocolumn
bind arguments
2. Cursors: You give an explicit cursor a name and associate it with a _______.
-
query
SUBTYPE numb IS number;
-20 -000
3. Exceptions: PL/SQL exceptions are of two types: internal and _________.
upper - coalesce
elsif
user-defined
cannot
4. IDs: You can use a reserved word as a _______ user-defined identifier.
national
1
view
quoted
5. I/O: This package lets PL/SQL programs read and write OS files.
does not
name-value
UTL_FILE
TIMESTAMP.
6. Cursors: The first two keywords in a Cursor FOR loop.
FOR - IN
IN - OUT - IN OUT
FORALL i IN MyList.FIRST..MyList.LAST
after insert on emps
7. Fundamental: Which one of these is a simple symbol: a - = - !=
can
procedure P AUTHID current_user;
=
definer's
8. Triggers: In a trigger - you cannot issue a COMMIT or a ______.
TYPE tA IS TABLE OF NUMBER INDEX BY VARCHAR2(20)
GET_LINE
ROLLBACK
SQL
9. Exceptions: Each internal exception has an Oracle ______ _______.
RAISE
type T is ref cursor
PUT_LINE
error code
10. Exceptions: User-defined exceptions must have _______.
BINARY_INTEGER
GET_LINE
names
TRUE - FALSE - NULL
11. Wrapped code (is / is not) not backward compatible.
fine-grained auditing
bind
is not
anonymous block
12. A result-cached function caches its results in the _____ _____ ____ (SGA)
system global area
..
for update of
run
13. Clause added to a cursor to use it with WHERE CURRENT OF.
does not
SUBTYPE n IS number not null;
for update of
IN
14. The compiler directive governing conditional compilation.
PRAGMA EXCEPTION_INIT (E - -1);
DBMS_SQL
FETCH
$IF
15. The attribute used to get the type of a row without knowing what it is.
Wrap
not the same
$IF
%ROWTYPE
16. A nested table has to be initialized using a ________ - named the same as the type.
DML
explicit cursor
Gateway
constructor
17. Web: PL/SQL ______ ______ (PSPs) let you develop web pages with dynamic content.
Server Pages
DML
boolean
scalable
18. Cursors: The statement that closes a cursor.
CLOSE
fields
GET_LINES
OTHERS
19. You have to use _______ SQL to run DDL statements n PL/SQL.
PLSQL_OPTIMIZE_LEVEL
name and datatype
autonomous transaction
dynamic
20. Which two collection types are unbounded?
Reserved words.
nested tables - associative arrays
virtual machine
1
21. Triggers and views always have _________ rights.
Warning
: Invalid argument supplied for foreach() in
/var/www/html/basicversity.com/show_quiz.php
on line
183
22. I/O: The output from DBMS_OUTPUT will display (during/after) program execution.
associative
*/
3
after
23. Triggers: The clause to make a trigger run after inserting into table EMPS.
value
bind
elsif
after insert on emps
24. Triggers: An INSTEAD OF trigger (can/cannot) be conditional.
With a letter.
sequence pseudo-columns
fine-grained auditing
cannot
25. Cursors: The four cursor attributes - in alphabetical order.
%FOUND - %ISOPEN - %NOTFOUND - %ROWCOUNT
cannot
SQL cursor
Declaration
26. Exceptions: Pragma that links an exception to an Oracle error code.
-
ROLLBACK
$$
EXCEPTION_INIT
27. Exceptions: The ________ function returns the current error code.
SQLCODE
**
FETCH
for update of
28. Types: The PL/SQL type that is identical to PLS_INTEGER.
PRAGMA AUTONOMOUS_TRANSACTION;
BINARY_INTEGER
VARCHAR2
unhandled
29. Setting CURRENT_SCHEMA only changes what is prepended to __________ references.
source
unqualified
cannot
value
30. Cursors: An explicit cursor (can/cannot) accept parameters.
%ROWTYPE
SQLCODE
can
OTHERS
31. Delimiters: The remote access symbol.
quoted
a cursor
Declaration
@
32. Advantage: PL/SQL programs are stored centrally - making them more ______.
...
IN - OUT - IN OUT
FORALL and BULK COLLECT
manageable
33. To create a collection type - use the TYPE command in PL/SQL and the ______ _____ command in SQL.
CREATE TYPE
CURRENT OF
current BEGIN-END block
PUT
34. DynSQL: The three modes of arguments in the USING clause of EXECUTE IMMEDIATE.
invoker's
drop procedure
IN - OUT - IN OUT
OPEN_CURSOR
35. ______ SQL is a PL/SQL feature that allows SQL syntax directly in a PL/SQL statement.
suspended
static
1
label
36. VARRAYs are (always / never) sparse.
never
STANDARD
RETURN
variable
37. What is the simplest statement for conditionally getting out of simple loop?
EXIT WHEN
SQL
RAISE
unqualified
38. Wrap ______=xxxx oname=zzzzz
collections - records
statement
iname
name
39. Where an external subprogram is stored.
FETCH - INTO
Abstract
in the database
cursor c;
40. Triggers: You (can/cannot) explicitly invoke a trigger.
cannot
error
create
invoker's
41. The DEFINITION of a cursor is the part after the keyword __.
optional
DBMS_PIPE
IS
DBMS_SESSION
42. For a collection - the NEXT method gets the next higher (element / index).
server
CREATE TRIGGER
Double quotes.
index
43. Cursors: The value of SQL%ISOPEN is always ______.
FALSE
DECLARE - BEGIN - EXCEPTION - END
fail
select
44. Conversion: Implicit conversion is not always predictable; it is _______-sensitive. And its rules might change.
%BULK_ROWCOUNT
context
CHAR - VARCHAR2
5
45. Characters that begin a multi-line comment.
anonymous block
before insert or update on emps
/*
collections - records
46. Give the statement to make a program autonomous.
EXIT
end
PRAGMA AUTONOMOUS_TRANSACTION;
Abstract
47. I/O: This package lets two or more sessions in the same instance communicate.
DBMS_PIPE
TYPE tA IS TABLE OF NUMBER INDEX BY VARCHAR2(20)
forward
never
48. I/O: The DBMS_OUTPUT buffer will not be flushed until it is full or until the current PL/SQL block _________.
30
finishes
$$
bind
49. Fundamental: One of the 4 types of lexical units: d_____
PRAGMA AUTONOMOUS_TRANSACTION;
delimiters
unconstrained
CURSOR - RETURN - IS
50. The EXCEPTION section is (optional/mandatory).
optional
procedure P AUTHID definer;
PUT
pseudocolumn