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. I/O: The output from DBMS_OUTPUT will display (during/after) program execution.
after
UTL_SMTP
USER_PLSQL_OBJECT_SETTINGS
elements
2. By default - an IN parameter is passed by ______.
reference
DBMS_PREPROCESSOR
'ENABLE:SEVERE' - 'ERROR:06002'
statically
3. DynSQL: The three modes of arguments in the USING clause of EXECUTE IMMEDIATE.
IN - OUT - IN OUT
r tRec := tRec(9 - 'Jones');
PLSQL_CCFLAGS
unconstrained
4. Fundamental: What is the range operator?
..
implicit
aliases
SQLERRM
5. You can use the BULK COLLECT INTO clause in a SELECT or a ______.
FETCH
v3 IN OUT NUMBER
procedure P AUTHID definer;
fine-grained auditing
6. Cursors: Give the statement to open cursor C that takes parameter p.
INTO
BINARY_INTEGER
open C(p)
# - $ - _
7. Labels for blocks and statements are enclosed in '__' brackets.
error code
user-defined
<<>>
fetch C into V
8. Declare a number variable - A - initialized to 10.
compilation
:=
INSTEAD OF
a number := 10
9. Declare an unconstrained subtype of NUMBER called NUMB.
FETCH
SUBTYPE numb IS number;
decimal
OPEN_CURSOR
10. The EXTEND method is not used with ______ _______.
associative arrays
select
3
specification - body
11. Exceptions: The three words that can be used to guarantee all exceptions will be handled.
OPEN_CURSOR
create procedure
procedure - function
WHEN OTHERS THEN
12. Types: The predefined subtype of PLS_INTEGER that has the NOT NULL constraint.
package
CURRENT OF
SIMPLE_INTEGER
CLOSE_CURSOR
13. Bytecode is _______ _______ code.
Declaration
inquiry
after
virtual machine
14. The first SQL statement in an autonomous routine begins a _______.
transaction
fine-grained auditing
base
include
15. Fundamental: What is the exponentiation operator?
**
open cv for
in the database
alter procedure
16. What are the two sequence pseudo-columns?
simple and compound symbols
WHERE CURRENT OF
ROLLBACK
currval and nextval
17. PL/SQL is a ________ typed programming language.
statically
*/
expression
is certain
18. A type of compiler directive - begins with 'i'.
LOOP
CLOSE
EXECUTE
inquiry
19. Cursors: The statement where you pass the parameters to a cursor.
cursor c;
1
OPEN
CLOSE
20. You can define PL/SQL collections using TYPEs defined in the _______.
database
$IF $THEN $ELSE $END
DEFINER
FETCH - INTO
21. The AUTHID property applies to PL/SQL objects that contain _____.
bind
TYPE t IS TABLE OF rPerson INDEX BY PLS_INTEGER;
code
cursor
22. Cursors: What is the 'name' of the implicit cursor?
SQL
include
literal
GET_LINE
23. Triggers: If two or more triggers are defined with the same timing point - then you can control the firing order using the ________ clause.
1
**
follows
cannot
24. Exceptions: If there is no handler for an exception - PL/SQL returns an ________ exception error to the invoker or host environment.
TRUE - FALSE - NULL
DBMS_SESSION
unhandled
IN - OUT - IN OUT
25. A type of compiler directive - begins with 'e'.
VARRAY - Nested table
simple and compound symbols
WHEN OTHERS THEN
error
26. Exceptions: The package that defines pre-defined exceptions.
CURRENT_USER
literals
STANDARD
error code
27. Types: One of the 4 PL/SQL things that have a data type (begins with 'c').
1 million
delimiters
constant
RETURN
28. Cursors: An implicit cursor is also called a/n ________ ________ -
SQL cursor
CURSOR - RETURN
must
exit when cgo%NOTFOUND
29. IDs: The two types of words that can - but should not - be used as user-defined identifiers.
Keywords and predefined names.
DR
cannot
TOO_MANY_ROWS
30. In interpreted mode - the PL/SQL VM interprets the _________.
cursor
nested
bytecode
SQL
31. Cursors: Only a _____ _____ cursor can appear in the CURRENT OF clause of an UPDATE or DELETE statement.
invoker's
FOR UPDATE
DBMS_OUTPUT
hardware
32. Default file extension of wrap's input file.
library
definition
30
sql
33. The DECLARE keyword is only required in an _______ _______.
set serveroutput on
significant
database
anonymous block
34. GOTO branches to a ________.
expression
scalable
label
boolean
35. Are good for logging table DML operations.
autonomous triggers
CREATE TRIGGER
cursor c RETURN rC;
package
36. Command used to execute dynamic SQL.
closed
suspended
EXECUTE IMMEDIATE
..
37. Exceptions: An unhandled exception ________ to the enclosing block.
anonymous
timing
propagates
DECLARE - BEGIN - EXCEPTION - END
38. Define a collection type - tV - which is a varray of 100 NUMBERs.
TRUE - FALSE and NULL
v2 IN NUMBER default 20
%ISOPEN.
TYPE tV IS VARRAY(100) OF NUMBER
39. Fundamental: One of the 4 types of lexical units: i_____
identifiers
bytecode
DML
error code
40. Advantage: Performance: Stored subprograms are ______ in memory.
DBMS_OUTPUT
cached
SQL cursor
USER_PROCEDURES
41. Types: PL/SQL has all the _____ data types.
variable
closed
SQL
object
42. Name the two types of FOR loop.
Declaration
numeric and cursor
query
FETCH - INTO
43. A GOTO statement can branch from an exception handler into...
an enclosing block
unconstrained
savepoint ab
decimal
44. To recompile a procedure - use the _____ ______ command.
always
alter procedure
DECLARE - BEGIN - EXCEPTION - END
after
45. Mode designation for an input/output parameter.
IN OUT
IS
Abstract
pls_integer
46. A SELECT statement with the FOR UPDATE clause puts a ______ on the selected rows.
lock
TYPE t IS TABLE OF rPerson INDEX BY PLS_INTEGER;
<<>>
significant
47. Web: PL/SQL _____ _______ lets you to develop Web applications made of PL/SQL procedures.
IR
Web Toolkit
DBMS_PIPE
L.V
48. Dbms_sql: The DBMS_SQL procedure that will execute a DDL or DML statement.
do not
DBMS_SESSION
execute
server
49. Delimiters: Single-line comment marker.
1
before insert or update on emps
;
-
50. Assigning values to PL/SQL variables that appear in SQL statements is called _______.
ex := tbl1 MULTISET EXCEPT tbl2
CURRENT_USER - DEFINER
binding
index