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. Where an external subprogram is stored.
in the database
package
same arguments
Abstract
2. Cursors: If you use an EXIT statement to exit a cursor FOR loop prematurely - the cursor (is / is not) closed automatically.
transaction
is
nested
name-value
3. A pointer to a private SQL area that stores information about processing a specific SELECT or DML statement.
cursor
invoker's
fetch C into V
explicit
4. If none of a CASE expression's conditions are TRUE - it returns _____.
LOOP - END LOOP
v3 IN OUT NUMBER
REF CURSOR
5. Triggers: In a DML trigger - the phrase that makes the trigger run for every affected record.
unhandled
query
/*
for each row
6. Types: The only PL/SQL type for which you can specify a range constraint.
FOR - IN
finishes
error code
PLS_INTEGER
7. Conversion: If the specific value is suitable - ____ or _______ values can convert to almost any datatype
INTO
DBMS_OUTPUT
CHAR - VARCHAR2
an autonomous routine
8. A national character literal is composed of characters in the ________ character set.
/*
national
3
NEW
9. The FIRST method gets the first (element / index) of a collection.
DBMS_SQL
DR
index
v1 OUT number default 10
10. IDs: The type of words that cannot be user-defined identifiers.
session cursor
source code
Reserved words.
procedure - function
11. Triggers: You (can/cannot) explicitly invoke a trigger.
'
DATE
cannot
static boolean
12. Exceptions: An exception raised inside an _______ _______ propagates immediately to the enclosing block
RETURN
composite
exception handler
cursor
13. I/O: This package has hypertext procedures that generate HTML tags
fields
HTP
definer's
error code
14. Cursors: Give the first 3 words to open a cursor variable called cv.
EXIT WHEN
invoker's
open cv for
implicit
15. Advantage: PL/SQL runs anywhere Oracle runs - so it is very ________.
portable
IS
END
source code
16. Collections are one of the two kinds of PL/SQL _______ data types.
nested
can
anonymous block
composite
17. A CASE statement (can / cannot) execute more than one group of statements.
cannot
statement
VARCHAR2
cursor
18. Cursors: A session cursor that a PL/SQL user creates and manages.
significant
explicit cursor
FOR UPDATE
elsif
19. Web: PL/SQL ______ ______ (PSPs) let you develop web pages with dynamic content.
FOR - IN
information that changes infrequently
OPEN_CURSOR
Server Pages
20. What is the simplest statement for conditionally getting out of simple loop?
Web Toolkit
Ada
EXIT WHEN
STANDARD
21. $$PLSQL_LINE and $$PLSQL_UNIT are ______-ly defined inquiry directives.
database
implicit
procedure - function
reference
22. Types: ________ data types have no internal components.
rollback to ab
scalar
optional
machine code
23. User-defined compiler directives are defined in this system compile parameter.
PLSQL_CCFLAGS
reference
TYPE tN IS TABLE of NUMBER
always
24. An INSTEAD OF trigger is used - e.g - when you want to insert into a complex _____.
view
PUT
SUBTYPE numb IS number;
nested
25. Cursors: Give the statement to fetch data from cursor C into variable V.
fetch C into V
PRAGMA AUTONOMOUS_TRANSACTION;
NUMBER
STANDARD
26. Characters that begin a multi-line comment.
function f (n number) return number result_cache relies_on (emps);
always
IS
/*
27. Dbms_sql: The DBMS_SQL procedure that closes a cursor.
CLOSE_CURSOR
CREATE TRIGGER
ALTER SESSION
executable
28. I/O: One of the 3 types of data stored in the DBMS_OUTPUT buffer.
order
-20 -000
current
NUMBER
29. 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.
FETCH - BULK COLLECT INTO
NESTED TABLE myColl STORE AS myCollTab
%BULK_ROWCOUNT
explicit
30. Advantage: Performance: PL/SQL automatically creates ______ variables for variables in WHERE and VALUES clauses.
comments
CLOSE_CURSOR
bind
package
31. In a sparse collection - the indexes of defined elements (do / do not) run in consecutive order.
%FOUND - %ISOPEN - %NOTFOUND - %ROWCOUNT
do not
anonymous
simple
32. Pkgs: RESET_PACKAGE only takes effect after the outermost PL/SQL proc that called it ________.
finishes
cannot
native dynamic
subtype
33. To enable result-caching for a function - use the _____________ clause.
bytecode
EXIT
procedure - function
RESULT_CACHE
34. You (can/cannot) put a label before an END LOOP statement.
cannot
network
VARRAYs
scalar
35. If you are in a procedure inside a package - the compilation unit is the _______.
base
SQL
portable
package
36. You can put a label before any executable PL/SQL _________.
error code
composite
EDITION_NAME
statement
37. Web: The gateway that allows a web browser to invoke a PL/SQL procedure through an HTTP listener.
DBMS_DDL
selection
SQL
PL/SQL Gateway
38. Advantage: PL/SQL is PORTABLE to any OS where ________ runs.
Oracle
significant
OTHERS
comments
39. Two types of stored subprograms.
procedure - function
PSP
WHEN OTHERS THEN
NDS
40. IDs: Maximum number of bytes in a user-defined identifier.
30
DBMS_CRYPTO
.
static boolean
41. To recompile a procedure - use the _____ ______ command.
rollback to ab
alter procedure
-
a number := 10
42. Fundamental: One of the 4 types of lexical units: i_____
identifiers
SYS_REFCURSOR
literals
not a number
43. Exceptions: The three words that can be used to guarantee all exceptions will be handled.
fine-grained auditing
WHEN OTHERS THEN
exception handler
bind
44. When a session starts - CURRENT_SCHEMA has the value of the schema owned by ___________.
v2 IN NUMBER default 20
calls
SESSION_USER
fetch C into V
45. The attribute used to get the type of a row without knowing what it is.
rollback to ab
%ROWTYPE
SQLERRM
255
46. How many types of compiler directives are there?
Gateway
can
IN OUT
3
47. Clause added to a cursor to use it with WHERE CURRENT OF.
error
EXIT WHEN cv%NOTFOUND
for update of
ADT
48. The attribute used to get the type of a column or variable without knowing what it is.
%TYPE
calls
IN OUT
CURRENT OF
49. Declare an input NUMBER parameter - v2 - that defaults to 20.
API
drop procedure
varray
v2 IN NUMBER default 20
50. A (simple / searched) CASE statement begins with CASE <expression>.
TYPE rec IS RECORD (num NUMBER - name VARCHAR2(10));
DATE
simple
nested