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. Conversion: Implicit conversion is not always predictable; it is _______-sensitive. And its rules might change.
INTO
WHEN OTHERS THEN
context
DML
2. Exceptions: The built-in procedure for raising an application-defined error.
network
USER_PLSQL_OBJECT_SETTINGS
BINARY_INTEGER
raise_application_error
3. How many times are a FOR loop's index bounds evaluated?
cannot
forward
FETCH
once
4. _____ arrays cannot be used as the type of an Oracle table column.
associative
boolean
# - $ - _
1
5. Web: PL/SQL _______ enables a Web browser to invoke a PL/SQL stored subprogram through an HTTP listener.
EDITION_NAME
hardware
EXTEND
Gateway
6. A (simple / searched) CASE statement begins with CASE WHEN <boolean expression>.
order
searched
REUSE SETTINGS
NUMBER
7. Triggers: Unlike a stored procedure - you can enable and _____ a trigger.
PUT_LINE
execute immediate
predefined
disable
8. Cursors: An explicit cursor (can/cannot) accept parameters.
EXIT
USING
can
4
9. TCL: Undo changes back to savepoint ab.
open cv for
1
4
rollback to ab
10. Characters that end a multi-line comment.
L.V
PVM
*/
after insert on emps
11. I/O: This package lets PL/SQL programs read and write OS files.
PSP
mandatory
composite
UTL_FILE
12. When a parameter is passed by reference - changes made to it inside the procedure cannot be undone. True/False.
DR
cannot
cannot
True
13. By default - an IN parameter is passed by ______.
explicit
compile
%BULK_ROWCOUNT
reference
14. Types: In addition to the SQL data types - PL/SQL has ___ more scalar data types.
FETCH - BULK COLLECT INTO
RELIES_ON
DATE '2005-12-25'
4
15. Exceptions: The ________ function returns the current error code.
SQLCODE
loop
colon
<<>>
16. Delimiters: The assignment operator.
current
:=
aggregate - analytical
inclusive
17. Cursors: A pointer to a cursor is called a ______ _______.
does not
cursor variable
CHAR - VARCHAR2
Wrap
18. Define a collection type - tA - which is an associative array of NUMBERS - indexed with varchar2(20) values.
'ENABLE:SEVERE' - 'ERROR:06002'
information that changes infrequently
TYPE tA IS TABLE OF NUMBER INDEX BY VARCHAR2(20)
RESULT_CACHE
19. Cursors: The Oracle predefined REF CURSOR type.
SYS_REFCURSOR
obfuscates
not the same
production
20. A ___________ behaves like a table column - but it is not stored in the table.
pseudocolumn
suspended
STANDARD
Wrap
21. 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
22. Exceptions: Associate exception E with error code -1.
PRAGMA EXCEPTION_INIT (E - -1);
for update of
BINARY_INTEGER
STANDARD
23. _________ exceptions can not be trapped with an error handler
Declaration
FGA
%TYPE
PL/SQL
24. Declare a package procedure P with no arguments - and give it definer's rights.
SQLERRM
value
procedure P AUTHID definer;
PVM
25. IDs: Predefined identifiers are declared in this package.
DBMS_SESSION.RESET_PACKAGE
STANDARD
DBMS_PREPROCESSOR
searched
26. Statement to set current schema to x: _____ _____ SET CURRENT_SCHEMA = 'x';
database
database
cursor
ALTER SESSION
27. Types: PL/SQL has all the _____ data types.
query
<<>>
SQL
RECORDS
28. Triggers: An INSTEAD OF trigger (can/cannot) be conditional.
r tRec := tRec(9 - 'Jones');
cannot
currval and nextval
FETCH
29. Delimiters: Single-line comment marker.
UTL_HTTP
decimal
-
%BULK_ROWCOUNT
30. If a procedure fails - an OUT parameter passed to it by value (will / will not) be passed back with changes.
associative
will not
DML
nested
31. The DECLARE keyword is only required in an _______ _______.
error code
mandatory
:=
anonymous block
32. Where an external subprogram is stored.
COMMIT - ROLLBACK - SAVEPOINT - SET TRANSACTION
manageable
parameter
in the database
33. Cursors: You cannot use cursor attributes in _______ statements.
SQL
invalid
ENABLE
BINARY_INTEGER
34. ______ SQL is a PL/SQL feature that allows SQL syntax directly in a PL/SQL statement.
EDITION_NAME
static
HTF
virtual machine
35. Fundamental: Which one of these is a compound symbol: = - :=
significant
<> - != - ^=
3
:=
36. DynSQL: The colon-prefixed names used in EXECUTE IMMEDIATE are called ________.
SQLCODE
network
placeholders
open cv for
37. Clause added to a cursor to use it with WHERE CURRENT OF.
static
implicit cursor
for update of
name-value
38. The BETWEEN operator is (inclusive / exclusive).
scalar
code
inclusive
TRUE - FALSE - NULL
39. Cursors: The values plugged into the DML in a FORALL must come from existing - populated _________.
is not
collections
execute
Apache
40. Searchable CASE statement: Each WHEN has its own _______ condition.
=
boolean
context
RETURN
41. An incomplete type only has a ____.
cursor variable
memory
Reserved words.
name
42. Cursors: If no SELECT or DML statement has run - the value of SQL%ROWCOUNT is what?
cursor
DBMS_OUTPUT
do not
43. Types: The only Oracle datetime type that doesn't begin with TIMESTAMP is ________.
unhandled
RELIES_ON
execute
DATE
44. Delimiters: Item separator.
CREATE TRIGGER
parameter
Server Pages
45. For a collection - the NEXT method gets the next higher (element / index).
quoted
an AUTHID property
composite
index
46. Labels for blocks and statements are enclosed in '__' brackets.
True
after insert on emps
<<>>
for each row
47. Fundamental: Which one of these is a simple symbol: a - = - !=
COMMIT - ROLLBACK - SAVEPOINT - SET TRANSACTION
numeric and cursor
block
=
48. The lowest index of a nested table is ___.
32 -000
1
an autonomous routine
dynamic
49. Types: A ______ has the same valid operations as its base type.
source
optional
OUT
subtype
50. Cursors: The four cursor attributes - in alphabetical order.
%FOUND - %ISOPEN - %NOTFOUND - %ROWCOUNT
PL/SQL
TIMESTAMP.
DML