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. A user-defined TYPE can have...
$IF
an AUTHID property
255
%FOUND - %ISOPEN - %NOTFOUND - %ROWCOUNT
2. Packaged constants can synchronize programs through use in _______ directives.
compiles
selection
set serveroutput on
oname
3. I/O: Max number of bytes to pass in a call to DBMS_OUTPUT.PUT_LINE.
IR
FGA
/*
255
4. Term for a character literal with zero characters.
SUBTYPE numb IS number;
Declaration
RELIES_ON
null string
5. The $IF must evaluate a ______ _______ expression.
alter procedure
r tRec := tRec(9 - 'Jones');
SYS_REFCURSOR
static boolean
6. An ordinary character literal is composed of characters in the ________ character set.
@
ALTER SESSION
1 million
database
7. If none of a CASE expression's conditions are TRUE - it returns _____.
1
slower
TYPE rec IS RECORD (num NUMBER - name VARCHAR2(10));
8. INSTEAD OF triggers are alternatives to ___ triggers
DML
EXIT WHEN
is
exception
9. The Wrap utility (does / does not) encrypt source code.
database
512
does not
cannot
10. User-defined compiler directives are defined in this system compile parameter.
;
IN
anonymous block
PLSQL_CCFLAGS
11. An $ERROR directive ends with _____.
TYPE tV IS VARRAY(100) OF NUMBER
value
end
$END
12. Fundamental: Labels furnish targets for GOTO and _____ statements.
'ENABLE:SEVERE' - 'ERROR:06002'
Server Pages
EXIT
TYPE tV IS VARRAY(100) OF NUMBER
13. DynSQL: The main command for Native Dynamic SQL.
explicit
compilation
EXECUTE IMMEDIATE
14. A kind of variable used as a placeholder.
static boolean
source code
bind
error code
15. Exceptions: The package that defines pre-defined exceptions.
iname
finishes
PVM
STANDARD
16. Conversion: Implicit conversion is not always predictable; it is _______-sensitive. And its rules might change.
REUSE SETTINGS
1
FOR i IN REVERSE 1..10 LOOP
context
17. 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
18. Associative array types (can / cannot) be defined in the database.
TRUE - FALSE - NULL
oname
closed
cannot
19. DynSQL: The colon-prefixed names used in EXECUTE IMMEDIATE are called ________.
FETCH - INTO
an AUTHID property
placeholders
bytecode
20. Type: An ________ subtype has all the values of its base type.
unconstrained
inquiry
increment
SUBTYPE numb IS number;
21. What are the starting and ending keywords of a simple loop?
USING
SQLERRM
LOOP - END LOOP
VARRAY - Nested table
22. DynSQL: EXECUTE IMMEDIATE does both dynamic SQL and dynamic _______.
SQLCODE
forward
:=
PL/SQL
23. Name the two types of FOR loop.
numeric and cursor
cursor variable
bind
varray
24. IDs: What a quoted user-defined identifier is enclosed in.
Double quotes.
dynamic
-
cannot
25. Exceptions: Write the call (2 args) to associate message 'Bad' with error code -20 -100.
Warning
: Invalid argument supplied for foreach() in
/var/www/html/basicversity.com/show_quiz.php
on line
183
26. Cursors: The second keyword of a FETCH statement.
cursor number
DECLARE - BEGIN - EXCEPTION - END
INTO
finishes
27. Package for getting the postprocessed source of a program.
DBMS_PREPROCESSOR
cannot
TRUE - FALSE and NULL
fetch C into V
28. The $ERROR directive is used to make compilation ____.
ex := tbl1 MULTISET EXCEPT tbl2
fail
-
REF CURSOR
29. DynSQL: The standard package that does dynamic SQL.
'
anonymous block
value
DBMS_SQL
30. In PL/SQL - what the variables in DML statements are turned into.
aggregate - analytical
bind arguments
<<>>
USER_PROCEDURES
31. Language that PL/SQL is derived from.
loop
Ada
%BULK_ROWCOUNT
OUT
32. If a procedure fails - an OUT parameter passed to it by value (will / will not) be passed back with changes.
cannot
will not
package
include
33. Which two collection types are unbounded?
error code
simple and compound symbols
nested tables - associative arrays
not a number
34. Characters that begin a multi-line comment.
/*
national
create
FOR - IN
35. I/O: The output from DBMS_OUTPUT will display (during/after) program execution.
ALTER SESSION
query
after
error code
36. I/O: This package has hypertext procedures that generate HTML tags
COUNT
USER_PROCEDURES
CURRENT OF
HTP
37. Set flag bb true: ALTER SESSION SET PLSQL_CCFLAGS= '____'
bb:true
vname CONSTANT VARCHAR2 := 'x';
increment
in the database
38. Delimiters: Statement terminator.
5
PRAGMA EXCEPTION_INIT (E - -1);
;
binding
39. Conditional ______ allows backward compability with older database versions.
invoker's
savepoint ab
compilation
expression
40. Delimiters: Item separator.
can
FALSE
With a letter.
41. The command used to populate PLSQL_CCFLAGS.
True - false or NULL.
ALTER SESSION
SQL cursor
USER_PLSQL_OBJECT_SETTINGS
42. Triggers: The clause to make a trigger run before inserting or updating table EMPS.
before insert or update on emps
composite
portable
fail
43. Types: The only PL/SQL type for which you can specify a range constraint.
CHAR - VARCHAR2
deletions
PLS_INTEGER
return value
44. Two types of stored subprograms.
fields
null string
procedure - function
hardware
45. Types: One of the scalar data types specific to PL/SQL: P________
<> - != - ^=
portable
PLS_INTEGER
execute immediate
46. The 4 keywords in the $IF compiler directive.
elements - type
TYPE t IS TABLE OF rPerson INDEX BY PLS_INTEGER;
E Exception;
$IF $THEN $ELSE $END
47. FOR-Looping over a collection from FIRST to LAST only works if the collection is _______.
include
dense
open C(p)
PVM
48. A nested table has to be initialized using a ________ - named the same as the type.
%
constructor
DEFINER
scalar
49. Native compilation turns bytecode into ________ code.
machine
base
DBMS_PREPROCESSOR
DBMS_SESSION
50. The FORALL statement to loop over a collection MyList using index i.
IN OUT
CHAR - VARCHAR2
FORALL i IN MyList.FIRST..MyList.LAST
'