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. Kind of datatypes that support object-oriented programming in PL/SQL.
Abstract
cursor
VARCHAR2
True
2. The PL/SQL ________ evaluates compiler directives.
error code
type T is ref cursor
scalable
preprocessor
3. Types: A ______ has the same valid operations as its base type.
disable
subtype
enclosing
cursor
4. $$PLSQL_LINE and $$PLSQL_UNIT are ______-ly defined inquiry directives.
STANDARD
implicit
EXCEPTION_INIT
quoted
5. A (simple / searched) CASE statement begins with CASE <expression>.
simple
3
SQL
dynamic
6. Exceptions: You can pass an ______ ________ to SQLERRM.
hardware
=>
error code
stored
7. The variable showing the user id that is automatically prepended to object names.
simple and compound symbols
CURRENT_USER
stored
optional
8. For a collection - the NEXT method returns ____ when there is no next index value.
r tRec := tRec(9 - 'Jones');
portable
OPEN_CURSOR
9. Exceptions: Associate exception E with error code -1.
PRAGMA EXCEPTION_INIT (E - -1);
IN - OUT - IN OUT
True - false or NULL.
ALTER SESSION
10. 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
11. Fundamental: Which one of these is a simple symbol: a - = - !=
=
server
compiles
TIMESTAMP.
12. Keyword for doing assignment to a variable with SELECT.
not the same
INTO
boolean
must
13. Where an external subprogram is stored.
:=
CHAR - VARCHAR2
in the database
$$
14. Types: The only Oracle datetime type that doesn't begin with TIMESTAMP is ________.
invoker's
DATE
savepoint ab
v2 IN NUMBER default 20
15. Cursors: The values plugged into the DML in a FORALL must come from existing - populated _________.
collections
bind arguments
numeric and cursor
NESTED TABLE myColl STORE AS myCollTab
16. I/O: To make sure the DBMS_OUTPUT buffer will be flushed - put a WHEN ______ clause in the EXCEPTION section of your outer block.
%
cursor c;
OTHERS
upper - coalesce
17. IDs: Maximum number of bytes in a user-defined identifier.
30
open cv for
anonymous block
Gateway
18. Define a collection type - tA - which is an associative array of NUMBERS - indexed with varchar2(20) values.
CREATE TYPE
TYPE tA IS TABLE OF NUMBER INDEX BY VARCHAR2(20)
TYPE rec IS RECORD (num NUMBER - name VARCHAR2(10));
anonymous
19. Loops: What is the index range operator in a FOR loop?
invoker's
..
literal
20. How many types of compiler directives are there?
subtype
3
UTL_HTTP
cannot
21. Exceptions: The three words that can be used to guarantee all exceptions will be handled.
**
WHEN OTHERS THEN
searched
cached
22. A __________ can have an AUTHID property
PUT_LINE
EXCEPTION_INIT
package
SUBTYPE n IS number not null;
23. Triggers: Programmers (as opposed to DBAs) mostly make use of _____ triggers.
procedure P AUTHID current_user;
expression
not a number
DML
24. Delimiters: The assignment operator.
:=
invoker's
loop
concatenation
25. Types: One of the scalar data types specific to PL/SQL: B_______
BINARY_INTEGER
PUT_LINE
invalid
virtual machine
26. From a block nested inside a procedure P - reference variable V of the outer procedure.
p.v
DBMS_SQL
ENABLE
fail
27. A value that is neither represented by an identifier nor calculated from other values.
cannot
nested
literal
EXIT
28. The FORALL statement to loop over a collection MyList using index i.
DATE
UTL_SMTP
fine-grained auditing
FORALL i IN MyList.FIRST..MyList.LAST
29. IDs: You cannot use reserved words as ______ user-defined identifiers.
CURRENT OF
strong
UTL_FILE
ordinary
30. Declare a cursor c with no parameters - and return type rC.
1 million
cursor c RETURN rC;
fetch C into V
dense
31. Advantage: PL/SQL runs anywhere Oracle runs - so it is very ________.
exception handler
30
portable
cursor
32. I/O: This package has hypertext procedures that generate HTML tags
HTP
4
iname
forward
33. Cursors: You can just declare a cursor at first - then _______ it later.
$IF
define
PSP
Wrap
34. Exceptions: An exception raised inside an _______ _______ propagates immediately to the enclosing block
identifiers
exception handler
bytecode
FETCH - INTO
35. Conversion: If the specific value is suitable - ____ or _______ values can convert to almost any datatype
RETURN
open C
CHAR - VARCHAR2
UTL_SMTP
36. The RESULT_CACHE clause has to be in both the declaration and in the ______ of the function.
invoker's
open cv for
definition
boolean
37. In interpreted mode - PL/SQL code is run in a _______ _______.
error code
FETCH - INTO
virtual machine
SQL
38. Statement to set current schema to x: _____ _____ SET CURRENT_SCHEMA = 'x';
is
ALTER SESSION
SYS_CONTEXT
integrated
39. Java - C or other program called directly in PL/SQL.
True
TYPE tN IS TABLE of NUMBER
external subprogram
never
40. I/O: The most basic PL/SQL way to give output to the user.
invoker's
dbms_output.put_line
associative
TYPE rec IS RECORD (num NUMBER - name VARCHAR2(10));
41. Exceptions: The ________ handler must always be the last handler.
SQL
Keywords and predefined names.
nested
OTHERS
42. %ROWTYPE gets the type of a table or _______.
DBMS_OUTPUT
after
cursor
SQLCODE
43. An ordinary character literal is composed of characters in the ________ character set.
an AUTHID property
composite
database
specification - body
44. 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
45. In a FORALL loop - you (can / cannot) use the index variable for purposes other than indexing into the collection.
cannot
plb
$END
%
46. Triggers: You (can/cannot) explicitly invoke a trigger.
cannot
can
DBMS_SQL
reference
47. Fundamental: What is the range operator?
wrap
..
GET_LINE
PL/SQL Gateway
48. A subprogram created inside a block is a _________ subprogram.
raise_application_error
v2 IN NUMBER default 20
4K
nested
49. Types: One of the 4 PL/SQL things that have a data type (begins with 'c').
associative
buffer
in the database
constant
50. Exceptions: Declare an exception called E.
OPEN
E Exception;
FETCH
WHERE CURRENT OF