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. Cursors: A cursor FOR loop can use an explicit or an _______ cursor.
variable
cannot
code
implicit
2. An ordinary character literal is composed of characters in the ________ character set.
database
associative arrays
numeric and cursor
disable
3. Types: PL/SQL has all the _____ data types.
DML
SQL
nested tables - associative arrays
FOR i IN REVERSE 1..10 - LOOP - NULL; END LOOP;
4. The four keywords that define a PL/SQL block.
set serveroutput on
block
DECLARE - BEGIN - EXCEPTION - END
Ordinary - Quoted.
5. Cursors: What is the 'name' of the implicit cursor?
select
SQL
END CASE
execute immediate
6. The PL/SQL ________ evaluates compiler directives.
varray
Keywords and predefined names.
preprocessor
boolean
7. Types: One of the 4 PL/SQL things that have a data type (begins with 'c').
composite
constant
GET_LINE
invoker's
8. Define a collection type - tV - which is a varray of 100 NUMBERs.
elements
associative
create procedure
TYPE tV IS VARRAY(100) OF NUMBER
9. Static typing is also called _____ typing.
searched
strong
CASE_NOT_FOUND
PSP
10. Characters that begin a single-line comment.
dynamic
-
$END
source code
11. A type of compiler directive - begins with 'i'.
inquiry
SQL
r t.%ROWTYPE;
SUBTYPE n IS number not null;
12. You can have many autonomous transactions in ___________.
True - false or NULL.
current transaction
FETCH - BULK COLLECT INTO
an autonomous routine
13. TCL: Create a savepoint called ab
implicit CASE_NOT_FOUND exception
finishes
savepoint ab
14. Command to assign to variables from a cursor.
simple
FETCH
procedure P AUTHID current_user;
literal
15. A pointer to a private SQL area that stores information about processing a specific SELECT or DML statement.
cursor
inquiry
UTL_FILE
increment
16. A user-defined TYPE can have...
CLOSE
identifiers
$$
an AUTHID property
17. Types: One of the 4 PL/SQL things that have a data type (begins with 'v').
SQL
variable
before insert or update on emps
flushed
18. DynSQL: In EXECUTE IMMEDIATE - the statement string can use either placeholders - or string ________.
cursor number
SQLCODE
concatenation
source
19. Web: The gateway that allows a web browser to invoke a PL/SQL procedure through an HTTP listener.
PL/SQL Gateway
literals
bind
an autonomous routine
20. I/O: One of the 3 types of data stored in the DBMS_OUTPUT buffer.
NUMBER
CHAR - VARCHAR2
value
suspended
21. Web: PL/SQL _____ _______ lets you to develop Web applications made of PL/SQL procedures.
dbms_output.put_line
Web Toolkit
exit when cgo%NOTFOUND
order
22. A (simple / searched) CASE statement begins with CASE WHEN <boolean expression>.
searched
UTL_FILE
an autonomous routine
SQL
23. Types: The PL/SQL type that is identical to PLS_INTEGER.
BINARY_INTEGER
EDITION_NAME
is certain
associative
24. Triggers: If two or more triggers are defined with the same timing point - then you can control the firing order using the ________ clause.
rollback to ab
pseudocolumn
follows
implicit
25. Declare a variable r whose type is that of the records in table t.
user-defined
autonomous transaction
suspended
r t.%ROWTYPE;
26. You can put a label before any executable PL/SQL _________.
can
statement
base
index
27. VARRAYs are (always / never) sparse.
never
injection
lower sub-block
WHERE CURRENT OF
28. Define a record variable r - of type tRec - initialized with values 9 and 'Jones' in its two fields.
Warning
: Invalid argument supplied for foreach() in
/var/www/html/basicversity.com/show_quiz.php
on line
183
29. A subprogram created inside a block is a _________ subprogram.
cannot
4
nested
SIMPLE_INTEGER
30. I/O: This DBMS_OUTPUT proc retrieves one line from the buffer.
GET_LINE
rollback to ab
DATE
SQL
31. You (can / cannot) wrap trigger source code.
will not
CHAR - VARCHAR2
v1 OUT number default 10
cannot
32. Triggers: In a per-row trigger - the ____ record shows you the changed state of an affected row.
exception handler
NEW
implicit
unhandled
33. The RESULT_CACHE clause has to be in both the declaration and in the ______ of the function.
EXIT WHEN
DML
NUMBER
definition
34. How many times are a FOR loop's index bounds evaluated?
once
slower
names
object
35. Cursors: The statement that closes a cursor.
Wrap
CLOSE
expression
CURSOR - RETURN - IS
36. INSTEAD OF triggers are alternatives to ___ triggers
DML
cursor number
dynamic
anonymous
37. Exceptions: If there is no handler for an exception - PL/SQL returns an ________ exception error to the invoker or host environment.
unhandled
static boolean
system global area
EXIT
38. Cursors: The statement where you pass the parameters to a cursor.
INSTEAD OF
forward
an AUTHID property
OPEN
39. Fundamental: Which one of these is a compound symbol: = - :=
:=
open C(p)
EXIT WHEN cv%NOTFOUND
FETCH
40. NAN stands for _________.
SQL
cannot
not a number
RECORD OF ARRAYS
41. Conversion: Implicit conversion can be (faster / slower) than explicit conversion.
slower
IN
255
query
42. The DEFINITION of a cursor is the part after the keyword __.
OTHERS
IS
an enclosing block
enclosing
43. Cursors: Only a _____ _____ cursor can appear in the CURRENT OF clause of an UPDATE or DELETE statement.
an autonomous routine
FOR UPDATE
DML
constructor
44. You cannot bulk collect into an ARRAY OF ________.
composite
RECORDS
IN OUT
FETCH
45. Associative arrays (do / do not) have to be initialized with a constructor.
hardware
512
END LOOP
do not
46. I/O: The DBMS_OUTPUT function that writes output without a newline character.
open cv for
CURSOR - RETURN - IS
currval and nextval
PUT
47. IDs: The two types of words that can - but should not - be used as user-defined identifiers.
Keywords and predefined names.
invalid
searched
execute
48. Type: An ________ subtype has all the values of its base type.
system global area
do not
unconstrained
integrated
49. Conversion: Just about everything will implicitly convert to _____ or _________.
SQLERRM
CHAR - VARCHAR2
injection
buffer
50. 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.
calls
NESTED TABLE myColl STORE AS myCollTab
national
TIMESTAMP.