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. Type: A __________ subtype has only a subset of the values of its base type.
constrained
execute
open cv for
EVERE - PERFORMANCE - INFORMATIONAL
2. Define a record type REC with number num and varchar2(10) name.
PL/SQL
TOO_MANY_ROWS
deletions
TYPE rec IS RECORD (num NUMBER - name VARCHAR2(10));
3. Cursors: The SQL%FOUND attribute has how many possible values?
an enclosing block
3
:=
associative
4. For an associative array - the FIRST method gets the (lowest / first-created) index.
DBMS_PIPE
binding
scalable
lowest
5. I/O: This package has hypertext functions that generate HTML tags
EXECUTE
LOOP
network
HTF
6. The compiler directive governing conditional compilation.
current BEGIN-END block
DBMS_PREPROCESSOR
$IF
network
7. Fundamental: identifiers (include/do not include) reserved words.
associative
CLOSE
include
VARCHAR2
8. This is a CASE (expression / statement): myvar := CASE num WHEN 1 THEN 'good' WHEN 2 THEN 'bad' END;
DATE
p.v
expression
dense
9. Conversion: Just about everything will implicitly convert to _____ or _________.
BINARY_INTEGER
invalid
CHAR - VARCHAR2
invoker's
10. I/O: Max number of bytes to pass in a call to DBMS_OUTPUT.PUT_LINE.
255
CLOSE
expression
RETURN
11. Two types of stored subprograms.
procedure - function
collections
TOO_MANY_ROWS
binding
12. Cursors: Opening keyword of a cursor FETCH loop.
aggregate - analytical
include
$IF
LOOP
13. Cursors: Give the statement to open cursor C that takes parameter p.
CURSOR - RETURN - IS
buffer
open C(p)
network
14. Triggers: An INSTEAD OF trigger is (always/never) a row-level trigger.
network
'ENABLE:SEVERE' - 'ERROR:06002'
always
significant
15. Triggers: In a per-row trigger - the ____ record shows you the changed state of an affected row.
cursor
anonymous
NEW
colon
16. A CASE statement (can / cannot) execute more than one group of statements.
RECORDS
cannot
compile
colon
17. For a collection - the NEXT method returns ____ when there is no next index value.
SQL
enclosing
SQL
18. Cursors: The keyword that makes a ref cursor type STRONG.
identifiers
RETURN
BOOLEAN
bind
19. Declare a variable r whose type is that of the records in table t.
OUT
r t.%ROWTYPE;
FGA
static
20. Bulk: The use of FORALL statements cuts down on ______ traffic.
significant
network
L.V
Gateway
21. Cursors: A cursor variable's type must be a ____ ______ type.
static boolean
..
REF CURSOR
explicit cursor
22. Collections are one of the two kinds of PL/SQL _______ data types.
Abstract
significant
composite
decimal
23. Fundamental: What is the exponentiation operator?
finishes
suspended
**
run
24. _________ exceptions can not be trapped with an error handler
object
collections
Declaration
PL/SQL Gateway
25. DynSQL: The standard package that does dynamic SQL.
implicit
slower
DBMS_SQL
enclosing
26. Exceptions: The built-in procedure for raising an application-defined error.
SQL
Oracle
v3 IN OUT NUMBER
raise_application_error
27. DynSQL: Native Dynamic SQL
array
dynamic
NDS
transaction
28. What is the simplest statement for conditionally getting out of simple loop?
IN - OUT - IN OUT
OTHERS
SYS_CONTEXT
EXIT WHEN
29. Delimiters: Item separator.
statement
executable
disable
30. I/O: The output from DBMS_OUTPUT will display (during/after) program execution.
after
Server Pages
associative
finishes
31. IDs: Maximum number of bytes in a user-defined identifier.
implicit CASE_NOT_FOUND exception
cursor
30
cursor variable
32. Exceptions: Start of the range of error codes for RAISE_APPLICATION_ERROR.
-20 -000
BOOLEAN
inquiry
RAISE
33. Declare a cursor c with no parameters - and return type rC.
5
3
injection
cursor c RETURN rC;
34. Set flag bb true: ALTER SESSION SET PLSQL_CCFLAGS= '____'
finishes
bb:true
mandatory
IF - CASE or LOOP
35. A type of compiler directive - begins with 'e'.
SYS_CONTEXT
is
error
selection
36. Fundamental: Character used to escape a single quote inside a literal.
Warning
: Invalid argument supplied for foreach() in
/var/www/html/basicversity.com/show_quiz.php
on line
183
37. A (simple / searched) CASE statement begins with CASE <expression>.
definer's
simple and compound symbols
simple
exception
38. Characters that begin a single-line comment.
-
in the database
implicit cursor
comments
39. Declare an unconstrained subtype of NUMBER called NUMB.
USER_PROCEDURES
Ada
label
SUBTYPE numb IS number;
40. Cursors: The FOR UPDATE phrase goes at the (beginning/end) of the cursor definition.
end
follows
enabled
aggregate - analytical
41. List the transaction control statements.
CLOSE
cannot
r t.%ROWTYPE;
COMMIT - ROLLBACK - SAVEPOINT - SET TRANSACTION
42. Types of blocks: Procedures and functions are _______ blocks.
is
ordinary
injection
stored
43. A GOTO cannot branch into a...
is
lower sub-block
buffer
@
44. Declare an associative array type - t - whose elements are of type rPerson - and whose index is PLS_INTEGER.
TYPE t IS TABLE OF rPerson INDEX BY PLS_INTEGER;
compilation
Oracle
dynamic
45. In a FORALL loop - you (can / cannot) use the index variable for purposes other than indexing into the collection.
PLS_INTEGER
GET_LINE
OLD
cannot
46. Cursors: The type definition of a WEAK ref cursor type has no _______ clause.
Reserved words.
must
END LOOP
RETURN
47. One good use of bind variables is to guard against SQL _______.
-20 -000
fetch C into V
injection
SQLCODE
48. Exceptions: Some internal exceptions have ________ names.
-
predefined
explicit cursor
comments
49. Delimiters: Host variable indicator.
# - $ - _
statement
after
...
50. Triggers: The code in a trigger is actually an ________ block.
anonymous
bb:true
strong
Gateway