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. Types: Which type of arithmetic does NUMBER use - library or hardware?
expression
32 -000
library
is not
2. 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
3. In interpreted mode - the PL/SQL VM interprets the _________.
bytecode
lock
cursor variable
suspended
4. I/O: To make sure the DBMS_OUTPUT buffer will be flushed - put a WHEN ______ clause in the EXCEPTION section of your outer block.
USING
order
OTHERS
DML
5. Clause added to a cursor to use it with WHERE CURRENT OF.
simple and compound symbols
for update of
pls_integer
INTO
6. IDs: The 3 non-alphanumeric characters that can be in an ordinary user-defined identifier.
# - $ - _
scalable
an autonomous routine
create
7. Triggers: There are __ types of triggers.
5
CREATE TRIGGER
IN OUT
nested
8. The Wrap utility ________ the source code.
:=
obfuscates
scalable
v1 OUT number default 10
9. IDs: The two types of words that can - but should not - be used as user-defined identifiers.
binding
TOO_MANY_ROWS
Keywords and predefined names.
1
10. I/O: This package handles HTTP.
UTL_HTTP
1
RESULT_CACHE
DEFINER
11. A unit with AUTHID = DEFINER is a ________ rights unit.
Warning
: Invalid argument supplied for foreach() in
/var/www/html/basicversity.com/show_quiz.php
on line
183
12. PL/SQL is a ________ typed programming language.
Abstract
statically
cannot
FORALL and BULK COLLECT
13. The statement that is used to execute most (native) dynamic SQL.
nested
current transaction
hardware
execute immediate
14. Cursors: A cursor with a name is an _________ cursor.
r t.%ROWTYPE;
oname
same
explicit
15. Assigning values to PL/SQL variables that appear in SQL statements is called _______.
binding
*/
can
executable
16. Types: ________ data types have internal components.
REUSE SETTINGS
lower sub-block
invoker's
composite
17. The _____ and ____ _____ collection types can be used in database table columns.
variable
VARRAY - Nested table
Gateway
TYPE rec IS RECORD (num NUMBER - name VARCHAR2(10));
18. Collections are one of the two kinds of PL/SQL _______ data types.
cannot
autonomous transaction
composite
expression
19. True encryption is done with package __________.
Oracle
WHERE CURRENT OF
DBMS_CRYPTO
p.v
20. Make a FOR loop that executes NULL 10 times counting in reverse - using index i.
procedure - function
FOR i IN REVERSE 1..10 - LOOP - NULL; END LOOP;
current
static boolean
21. Fundamental: identifiers (include/do not include) reserved words.
invoker's
SQLERRM
bind
include
22. Triggers: The clause to make a trigger run before inserting or updating table EMPS.
FOR i IN REVERSE 1..10 LOOP
code
before insert or update on emps
cannot
23. INSTEAD OF triggers are alternatives to ___ triggers
machine
national
DML
same
24. A subprogram defined within another subprogram is a _______ subprogram.
nested
STANDARD
create
FETCH
25. _________ exceptions can not be trapped with an error handler
<> - != - ^=
a number := 10
Declaration
function f (n number) return number result_cache relies_on (emps);
26. PLS_INTEGER has its arithmetic implemented in ________ - so it is very fast.
cursor c;
cannot
hardware
DEFINER
27. User-defined compiler directives are defined in this system compile parameter.
PLSQL_CCFLAGS
CURRENT_USER
NUMBER
code
28. Delimiters: Statement terminator.
;
IS
explicit cursor
STANDARD
29. Delimiters: Item separator.
SESSION_USER
=>
SQL
30. Types: The only PL/SQL type for which you can specify a range constraint.
associative
PLS_INTEGER
label
after insert on emps
31. What clause makes a compilation default to the PLSQL_CCFLAGS settings from the last compilation?
REUSE SETTINGS
exception handler
anonymous
1
32. Wrap iname=xxxx _____=zzzzz
searched
associative
oname
optional
33. The FIRST method gets the first (element / index) of a collection.
executable
order
fetch C into V
index
34. The default value of the AUTHID property.
follows
unqualified
DEFINER
PL/SQL
35. Triggers and views always have _________ rights.
Warning
: Invalid argument supplied for foreach() in
/var/www/html/basicversity.com/show_quiz.php
on line
183
36. Cursors: Give the statement for getting out of a FETCH loop for cursor CV.
FOR i IN REVERSE 1..10 - LOOP - NULL; END LOOP;
4K
nested
EXIT WHEN cv%NOTFOUND
37. Characters that begin a multi-line comment.
TIMESTAMP.
/*
TYPE rec IS RECORD (num NUMBER - name VARCHAR2(10));
cannot
38. The variable showing the user id of the session owner.
DBMS_SESSION
current BEGIN-END block
IN OUT
SESSION_USER
39. If an initialized collection has no elements - FIRST and LAST return _____.
value
executable
can
40. Conversion: Just about everything will implicitly convert to _____ or _________.
error code
CHAR - VARCHAR2
obfuscates
scalar
41. Exceptions: The maximum length of an Oracle error message is ____ characters
USER_PROCEDURES
collections - records
512
OLD
42. PL/SQL lets you define two kinds of composite data types: _______ and _______
4K
collections - records
associative
FOR UPDATE
43. The valid values of the AUTHID property.
INTO
255
can
CURRENT_USER - DEFINER
44. Types: A ______ has the same valid operations as its base type.
DR
native dynamic
CHARARR
subtype
45. Set flag bb true: ALTER SESSION SET PLSQL_CCFLAGS= '____'
exit when cgo%NOTFOUND
bb:true
current BEGIN-END block
cursor
46. Cursors: Give the statement to fetch data from cursor C into variable V.
fetch C into V
FGA
before insert or update on emps
NEW
47. Package for getting the postprocessed source of a program.
portable
DBMS_PREPROCESSOR
-
HTF
48. I/O: The output from DBMS_OUTPUT will display (during/after) program execution.
for update of
placeholders
<<
after
49. A CASE expression ends with _____.
not the same
END
HTP
dbms_output.put_line
50. Exceptions: A GOTO statement CAN branch from an exception handler into an ________ block.
associative
constrained
return value
enclosing