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. Delimiters: The left label delimiter.
<<
32 -000
do not
p.v
2. In a collection - the internal components always have the _____ data type.
package
Double quotes.
same
dynamic
3. Package for getting the postprocessed source of a program.
SYS_REFCURSOR
DBMS_PREPROCESSOR
iname
FETCH
4. Cursors: How many implicit cursors can you access?
1
# - $ - _
native dynamic
can
5. If none of a CASE expression's conditions are TRUE - it returns _____.
non-editioning views
PLSQL_CCFLAGS
fail
6. Exceptions: The maximum length of an Oracle error message is ____ characters
nested tables - associative arrays
512
FALSE
boolean
7. Clause added to a cursor to use it with WHERE CURRENT OF.
cannot
FETCH - INTO
for update of
integer
8. Cursors: The second keyword of a FETCH statement.
pls_integer
INTO
%BULK_ROWCOUNT
drop procedure
9. Cursors: Give the first 3 words to open a cursor variable called cv.
open cv for
Declaration
CLOSE_CURSOR
FETCH
10. DBMS_DDL.WRAP returns a string containing wrapped _____ _____.
implicit
source code
NDS
UTL_SMTP
11. Declare an input/output NUMBER parameter - v3.
invoker's
propagates
v3 IN OUT NUMBER
inquiry
12. When a parameter is passed by reference - changes made to it inside the procedure cannot be undone. True/False.
NESTED TABLE myColl STORE AS myCollTab
DBMS_SQL
True
...
13. A GOTO cannot branch into a...
after
lower sub-block
reference
FOR i IN REVERSE 1..10 LOOP
14. An editioning view is like an ____ for a table.
.
API
CURSOR - RETURN
SUBTYPE numb IS number;
15. I/O: The DBMS_OUTPUT function that writes output without a newline character.
PUT
DECLARE - BEGIN - EXCEPTION - END
EXIT WHEN cv%NOTFOUND
base
16. The four keywords that define a PL/SQL block.
FALSE
compile
DECLARE - BEGIN - EXCEPTION - END
pls_integer
17. A result-cached function caches its results in the _____ _____ ____ (SGA)
cannot
system global area
optional
current
18. CREATE TYPE cannot be used for _______ array types.
statically
open cv for
associative
...
19. PL/SQL is a ________ typed programming language.
statically
cannot
static boolean
**
20. The EXCEPTION section is (optional/mandatory).
GET_LINE
GET_LINES
COMMIT - ROLLBACK - SAVEPOINT - SET TRANSACTION
optional
21. Declare an unconstrained subtype of NUMBER called NUMB.
RESULT_CACHE
CURRENT OF
PRAGMA AUTONOMOUS_TRANSACTION;
SUBTYPE numb IS number;
22. In a record - the internal components are called ______.
network
fields
fetch cv into myvar
multi-row
23. Data dictionary view that shows the compiler settings for each compiled object.
USER_PLSQL_OBJECT_SETTINGS
1
rollback to ab
drop procedure
24. The Wrap utility ________ the source code.
Abstract
obfuscates
define
anonymous
25. DynSQL: The main command for Native Dynamic SQL.
EXECUTE IMMEDIATE
variable
HTF
API
26. I/O: SQLPlus command for turning on buffered output.
session cursor
*/
set serveroutput on
IR
27. The PL/SQL ________ evaluates compiler directives.
p.v
preprocessor
machine
3
28. Advantage: PL/SQL programs are stored centrally - making them more ______.
manageable
v1 OUT number default 10
CASE_NOT_FOUND
will not
29. Triggers: In a trigger - you cannot issue a COMMIT or a ______.
upper - coalesce
RECORDS
propagates
ROLLBACK
30. Cursors: If no SELECT or DML statement has run - the value of SQL%ROWCOUNT is what?
ordinary
SYS_CONTEXT
name and datatype
31. Declare an input NUMBER parameter - v2 - that defaults to 20.
v2 IN NUMBER default 20
do not
32 -000
type T is ref cursor
32. Fundamental: What is the exponentiation operator?
include
USER_PROCEDURES
**
close C
33. The PL/SQL preprocessor passes ______ code to the compiler.
manageable
package
32 -000
source
34. Exceptions: Start of the range of error codes for RAISE_APPLICATION_ERROR.
Keywords and predefined names.
implicit cursor
-20 -000
transaction
35. An ordinary character literal is composed of characters in the ________ character set.
1
aggregate - analytical
information that changes infrequently
database
36. A nested table has to be initialized using a ________ - named the same as the type.
constructor
ALTER SESSION
obfuscates
unhandled
37. Triggers: When using the NEW or OLD pseudo-records in the body of the trigger - they must be prefixed with a _______.
colon
enabled
%TYPE
SQLPlus
38. A GOTO cannot branch into an...
inclusive
IF - CASE or LOOP
executable
dynamic
39. Delimiters: The remote access symbol.
ENABLE
DEFINER
does not
@
40. Web: Abbreviation of PL/SQL Server Page.
$IF $THEN $ELSE $END
PSP
Double quotes.
EXCEPTION_INIT
41. To create a collection type - use the TYPE command in PL/SQL and the ______ _____ command in SQL.
CREATE TYPE
DML
explicit cursor
error
42. Pkgs: The _______ package gives access to such SQL things as ALTER SESSION.
FETCH - INTO
unconstrained
after
DBMS_SESSION
43. Exceptions: The ________ function returns the error message associated with an error code.
LOOP - END LOOP
array
SQLERRM
RETURN
44. Nested tables can become sparse via ______.
STANDARD
deletions
CREATE TRIGGER
cursor c;
45. Exceptions: User-defined exceptions must have _______.
ADT
collections
value
names
46. Cursors: The statement that closes a cursor.
CLOSE
LOOP
cannot
Declaration
47. You cannot bulk collect into an ARRAY OF ________.
Oracle
implicit cursor
RECORDS
HTF
48. The compiler directive used to select which code to compile.
$IF
'ENABLE:SEVERE' - 'ERROR:06002'
fetch C into V
for each row
49. Triggers: On a non-editioning view - you can only define __________ triggers.
/*
INSTEAD OF
mandatory
define
50. DBMS_DDL.CREATE_WRAPPED: wraps and _______ the source code passed to it.
GET_LINES
compiles
scalable
EXECUTE