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. An autonomous program runs in its own __________.
currval and nextval
transaction
bind arguments
alter procedure
2. 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
3. Cursors: If an exception is raised inside a cursor loop - the cursor (is / is not) also closed automatically.
4K
EXECUTE IMMEDIATE
DML
is
4. Exceptions: User-defined exceptions must have _______.
before insert or update on emps
non-editioning views
names
cursor c RETURN rC;
5. Command to delete a procedure.
drop procedure
DBMS_CRYPTO
do not
information that changes infrequently
6. A ___________ behaves like a table column - but it is not stored in the table.
CLOSE
-20 -000
variable
pseudocolumn
7. NAN stands for _________.
not a number
collections - records
cursor
RECORD OF ARRAYS
8. When a parameter is passed by reference - changes made to it inside the procedure cannot be undone. True/False.
bytecode
for each row
True
DATE '2005-12-25'
9. Exceptions: The three words that can be used to guarantee all exceptions will be handled.
procedure P AUTHID current_user;
WHEN OTHERS THEN
does not
SIMPLE_INTEGER
10. Advantage: PL/SQL is PORTABLE to any OS where ________ runs.
PUT_LINE
DBMS_OUTPUT
Oracle
inquiry
11. SIMPLE_INTEGER is like PLS_INTEGER - but it does not allow ____ values - and it does not raise overflow exceptions.
DBMS_OUTPUT
FORALL and BULK COLLECT
Server Pages
12. I/O: The most basic PL/SQL way to give output to the user.
dbms_output.put_line
context
SYS_CONTEXT
autonomous transaction
13. Advantage: PL/SQL programs are stored centrally - making them more ______.
END IF
manageable
sequence pseudo-columns
-20 -000
14. DynSQL: EXECUTE IMMEDIATE can be used for any SQL statement or PL/SQL block - except for ________ queries.
-
multi-row
DBMS_SQL
v3 IN OUT NUMBER
15. A kind of variable used as a placeholder.
TYPE tA IS TABLE OF NUMBER INDEX BY VARCHAR2(20)
bind
WHERE CURRENT OF
wrap
16. The DECLARE keyword is only required in an _______ _______.
REUSE SETTINGS
anonymous block
cannot
can
17. Name the two types of FOR loop.
column
numeric and cursor
definer's
constructor
18. Triggers: In a DML trigger - the phrase that makes the trigger run for every affected record.
L.V
view
inclusive
for each row
19. If you are in a procedure inside a package - the compilation unit is the _______.
package
dynamic
statement
:=
20. Exceptions: Declare an exception called E.
FETCH - INTO
LOOP
library
E Exception;
21. DynSQL: The three modes of arguments in the USING clause of EXECUTE IMMEDIATE.
statement
is
predefined
IN - OUT - IN OUT
22. IDs: Maximum number of bytes in a user-defined identifier.
SUBTYPE n IS number not null;
comments
30
procedure - function
23. The first SQL statement in an autonomous routine begins a _______.
transaction
dynamic
stored
END CASE
24. Delimiters: Single-line comment marker.
transaction
index
-
BINARY_INTEGER
25. Conversion: Just about everything will implicitly convert to _____ or _________.
cursor number
library
static boolean
CHAR - VARCHAR2
26. Cursors: The type definition of a WEAK ref cursor type has no _______ clause.
procedure P AUTHID definer;
associative arrays
type T is ref cursor
RETURN
27. The _____ and ____ _____ collection types can be used in database table columns.
statement
VARRAY - Nested table
Web Toolkit
cursor c RETURN rC;
28. The variable showing the user id that is automatically prepended to object names.
CURRENT_USER
not the same
$$
suspended
29. Delimiters: The association operator.
collections - records
error
stored
=>
30. Cursors: How many DML statements can a FORALL statement contain?
autonomous triggers
error
1
system global area
31. An $ERROR directive ends with _____.
selection
$END
virtual machine
definer's
32. IDs: You cannot use reserved words as ______ user-defined identifiers.
SESSION_USER
nested tables - associative arrays
ordinary
after
33. Triggers: In a per-row trigger - the ____ record shows you the original state of an affected row.
quoted
1
OLD
ROLLBACK
34. With a result-cached function - it uses a cached value when the function is called again with the...
4K
4
same arguments
scalable
35. An incomplete type only has a ____.
is not
definition
name
INTO
36. The values defined in PLSQL_CCFLAGS can be referenced as _____ directives.
cannot
native dynamic
lower sub-block
inquiry
37. Types: One of the 4 PL/SQL things that have a data type (begins with 'r').
CURRENT_USER
calls
IN
return value
38. _____ arrays cannot be used as the type of an Oracle table column.
FOR UPDATE
SYS_CONTEXT
associative
STANDARD
39. The 2 characters that begin all inquiry directives.
/*
TYPE tV IS VARRAY(100) OF NUMBER
$$
NDS
40. Cursors: If you use an EXIT statement to exit a cursor FOR loop prematurely - the cursor (is / is not) closed automatically.
associative
FETCH - INTO
..
is
41. Cursors: What are the 3 possible values of SQL%FOUND and SQL%NOTFOUND?
define
TRUE - FALSE - NULL
name-value
unqualified
42. A (simple / searched) CASE statement begins with CASE WHEN <boolean expression>.
integrated
searched
...
column
43. Cursors: The FOR UPDATE phrase goes at the (beginning/end) of the cursor definition.
*/
end
:=
autonomous triggers
44. What is the exception that is implicitly raised in a CASE statement with no ELSE clause?
does not
iname
cannot
CASE_NOT_FOUND
45. The source for wrapping begins with the word ______.
create
CHAR - VARCHAR2
cursor variable
DBMS_SQL
46. The BEGIN section is (optional/mandatory)
-
mandatory
anonymous
colon
47. Loops: What is the index range operator in a FOR loop?
..
*/
1
hardware
48. Exceptions: Some internal exceptions have ________ names.
CURRENT_USER - DEFINER
predefined
CURSOR - RETURN
exception handler
49. I/O: Max number of bytes DBMS_OUTPUT can handle in a session.
select
1 million
name and datatype
50. After the RESULT_CACHE clause - you can put a _________ clause to enable dependency-checking.
RELIES_ON
SQLCODE
execute
DECLARE - BEGIN - EXCEPTION - END