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. TCL: Create a savepoint called ab
%BULK_ROWCOUNT
savepoint ab
EXIT
2. Define a record type REC with number num and varchar2(10) name.
enabled
an AUTHID property
TYPE rec IS RECORD (num NUMBER - name VARCHAR2(10));
1
3. What is the exception that is implicitly raised in a CASE statement with no ELSE clause?
EXECUTE
implicit
CASE_NOT_FOUND
EXIT WHEN
4. 5 types of events that can have triggers: DML - DDL - INSTEAD OFs - database events - and ________ statements.
statement
:=
suspended
TRUE - FALSE and NULL
5. CREATE TYPE cannot be used for _______ array types.
flushed
associative
database
EXTEND
6. Exceptions: When an exception is raised inside a cursor FOR loop - the cursor is _______ implicitly.
procedure P AUTHID current_user;
closed
enabled
cursor number
7. A numeric FOR loop cannot _________ by other than 1?
sql
$IF
lower sub-block
increment
8. A result-cached function caches its results in the _____ _____ ____ (SGA)
system global area
current
DBMS_SQL
TRUE - FALSE and NULL
9. By default - an IN parameter is passed by ______.
WHERE CURRENT OF
=
reference
savepoint ab
10. Associative array types (can / cannot) be defined in the database.
cannot
DML
True - false or NULL.
significant
11. Advantage: PL/SQL runs anywhere Oracle runs - so it is very ________.
PUT
function f (n number) return number result_cache relies_on (emps);
portable
lock
12. Exceptions: Start of the range of error codes for RAISE_APPLICATION_ERROR.
1
an autonomous routine
3
-20 -000
13. A unit with AUTHID = CURRENT_USER is an ________ rights unit.
Warning
: Invalid argument supplied for foreach() in
/var/www/html/basicversity.com/show_quiz.php
on line
183
14. The method to add one or more elements to a nested table or VARRAY is ______.
machine code
EXTEND
significant
order
15. You can define PL/SQL collections using TYPEs defined in the _______.
searched
flushed
database
DR
16. Web: PL/SQL ______ ______ (PSPs) let you develop web pages with dynamic content.
Server Pages
executable
value
optional
17. Delimiters: the attribute indicator.
finishes
%
statement
30
18. The $ERROR directive is used to make compilation ____.
simple
TIMESTAMP.
constant
fail
19. Cursors: How many DML statements can a FORALL statement contain?
1
definition
fine-grained auditing
nested
20. A nested table has to be initialized using a ________ - named the same as the type.
constructor
multi-row
database
pls_integer
21. In the special IF syntax - is it ELSIF - or ELSEIF?
REF CURSOR
*/
same
elsif
22. The EXTEND method is not used with ______ _______.
associative arrays
system global area
1
flushed
23. A PL/SQL extension to the WHERE clause of the SQL statements UPDATE and DELETE
is not
quoted
TRUE - FALSE and NULL
WHERE CURRENT OF
24. After the RESULT_CACHE clause - you can put a _________ clause to enable dependency-checking.
RELIES_ON
$END
function f (n number) return number result_cache relies_on (emps);
after
25. I/O: This DBMS_OUTPUT proc retrieves multiple lines from the buffer.
$IF
PUT
fail
GET_LINES
26. Define a collection type - tV - which is a varray of 100 NUMBERs.
PSP
composite
Declaration
TYPE tV IS VARRAY(100) OF NUMBER
27. If an initialized collection has no elements - FIRST and LAST return _____.
%
SUBTYPE numb IS number;
TRUE - FALSE and NULL
28. _____ arrays cannot be used as the type of an Oracle table column.
object
associative
loop
create
29. An $ERROR directive ends with _____.
$END
v1 OUT number default 10
name
anonymous
30. 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
31. Web: PL/SQL _____ _______ lets you to develop Web applications made of PL/SQL procedures.
REF_CURSOR
:=
cursor c RETURN rC;
Web Toolkit
32. An incomplete type only has a ____.
FALSE
collections
1
name
33. Exceptions: The three words that can be used to guarantee all exceptions will be handled.
EXIT WHEN cv%NOTFOUND
end
cursor c;
WHEN OTHERS THEN
34. Characters that end a multi-line comment.
inquiry
*/
an AUTHID property
stored
35. Dbms_sql: The DBMS_SQL procedure that will execute a DDL or DML statement.
execute
PL/SQL Gateway
delimiters
WHERE CURRENT OF
36. Dbms_sql: The return type DBMS_SQL.open_cursor.
integer
pls_integer
autonomous transaction
FGA
37. The command used to populate PLSQL_CCFLAGS.
searched
v2 IN NUMBER default 20
bind arguments
ALTER SESSION
38. Data dictionary view giving the AUTHID values on a user's objects.
bind
open C
LOOP - END LOOP
USER_PROCEDURES
39. Cursors: Give the statement to close cursor C.
close C
cursor
NDS
ordinary
40. The three possible values of a BOOLEAN literal.
$IF $THEN $ELSE $END
True - false or NULL.
suspended
oname
41. You cannot bulk collect into an ARRAY OF ________.
package
TYPE tA IS TABLE OF NUMBER INDEX BY VARCHAR2(20)
RETURN
RECORDS
42. I/O: This DBMS_OUTPUT proc retrieves one line from the buffer.
GET_LINE
library
loop
numeric and cursor
43. Types of blocks: Procedures and functions are _______ blocks.
inquiry
block
E Exception;
stored
44. Mode designation for an input/output parameter.
CHAR - VARCHAR2
IN OUT
in the database
512
45. A null string and a BOOLEAN null are _______ (same/not the same).
not the same
OUT
versions
Oracle
46. Advantage: Performance: PL/SQL automatically creates ______ variables for variables in WHERE and VALUES clauses.
1 million
inquiry
bind
expression
47. Cursors: The two keywords in a mere cursor declaration (one is optional).
external subprogram
FOR i IN REVERSE 1..10 LOOP
CURSOR - RETURN
pls_integer
48. Mode designation for an input parameter.
IN
name
IF - CASE or LOOP
boolean
49. Exceptions: Some internal exceptions have ________ names.
COUNT
HTP
predefined
source
50. The declaration section is (optional/mandatory).
CURRENT_USER
HTF
definer's
optional