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 string table type in DBMS_OUTPUT for holding lines of text.
CHARARR
for each row
Ordinary - Quoted.
OPEN_CURSOR
2. Cursors: WHERE _______ ______ makes an UPDATE or DELETE apply to the current row of a cursor.
CURRENT OF
=>
multi-row
do not
3. Declare an input NUMBER parameter - v2 - that defaults to 20.
v2 IN NUMBER default 20
binding
DBMS_OUTPUT
Declaration
4. In the special IF syntax - is it ELSIF - or ELSEIF?
selection
colon
elsif
exit when cgo%NOTFOUND
5. The SET TRANSACTION statement affects only the ____________.
disable
current transaction
fields
'ENABLE:SEVERE' - 'ERROR:06002'
6. When a parameter is passed by reference - changes made to it inside the procedure cannot be undone. True/False.
3
BINARY_INTEGER
**
True
7. How many times are a FOR loop's index bounds evaluated?
do not
once
%TYPE
subtype
8. Types: Which type of arithmetic does PLS_INTEGER use - library or hardware?
FETCH
hardware
injection
deletions
9. You can use the BULK COLLECT INTO clause in a SELECT or a ______.
LOOP
FETCH
UTL_FILE
SYS_CONTEXT
10. IDs: You (can/cannot) use keywords as ordinary user-defined identifiers.
FETCH - BULK COLLECT INTO
hardware
can
multi-row
11. Exceptions: A GOTO statement CAN branch from an exception handler into an ________ block.
FORALL i IN MyList.FIRST..MyList.LAST
composite
enclosing
DBMS_DDL
12. What is the simplest statement for conditionally getting out of simple loop?
executable
concatenation
EXIT WHEN
INSTEAD OF
13. Wrap iname=xxxx _____=zzzzz
alter procedure
oname
DML
INTO
14. Cursors: The index variable in a cursor FOR loop (does/does not) need to be declared.
searched
does not
composite
Keywords and predefined names.
15. Pkgs: This procedure de-instantiates/resets all packages in this session.
enclosing
CREATE TRIGGER
DBMS_SESSION.RESET_PACKAGE
=
16. The attribute used to get the type of a row without knowing what it is.
INSTEAD OF
%BULK_ROWCOUNT
WHEN
%ROWTYPE
17. Web: PL/SQL ______ ______ (PSPs) let you develop web pages with dynamic content.
Server Pages
EXIT
aggregate - analytical
-20 -000
18. In a collection - the internal components always have the _____ data type.
an AUTHID property
same
calls
ENABLE
19. Delimiters: The association operator.
=>
scalar
UTL_FILE
expression
20. Cursors: The keyword that makes a ref cursor type STRONG.
$IF
RETURN
placeholders
wrap
21. Cursors: An implicit cursor is also called a/n ________ ________ -
label
GET_LINES
information that changes infrequently
SQL cursor
22. Triggers: On a non-editioning view - you can only define __________ triggers.
package
deletions
INSTEAD OF
network
23. The three sorts of date/time types are DATE - INTERVAL and _________.
TIMESTAMP.
DR
names
numeric and cursor
24. Data dictionary view giving the AUTHID values on a user's objects.
an AUTHID property
VARRAY - Nested table
USER_PROCEDURES
p.v
25. Cursors: Give the statement to open cursor C.
open C
cannot
open cv for
fields
26. Assignment of PLSQL_CCFLAGS (cannot / can) be included in ALTER PROCEDURE ... COMPILE ...
can
WHEN OTHERS THEN
SQLERRM
v2 IN NUMBER default 20
27. What are two categories of SQL functions that cannot be used in procedural statements?
STANDARD
package
aggregate - analytical
a number := 10
28. The method to add one or more elements to a nested table or VARRAY is ______.
scalar
EXTEND
REF CURSOR
PUT_LINE
29. A user-defined TYPE can have...
end
machine code
an AUTHID property
composite
30. Exceptions: Pragma that links an exception to an Oracle error code.
EXCEPTION_INIT
machine code
fail
integrated
31. To enable result-caching for a function - use the _____________ clause.
optional
library
RESULT_CACHE
cannot
32. Cursors: A cursor with a name is an _________ cursor.
ordinary
**
%BULK_ROWCOUNT
explicit
33. VARRAYs are (always / never) sparse.
procedure P AUTHID definer;
cannot
never
for each row
34. A PL/SQL extension to the WHERE clause of the SQL statements UPDATE and DELETE
bind arguments
INSTEAD OF
-20 -000
WHERE CURRENT OF
35. Bulk: The two features that comprise Bulk SQL are:
cannot
comments
bytecode
FORALL and BULK COLLECT
36. Package for getting the postprocessed source of a program.
EXCEPTION_INIT
DBMS_PREPROCESSOR
type T is ref cursor
drop procedure
37. A subprogram created inside a block is a _________ subprogram.
associative
nested
compile
after insert on emps
38. Fundamental: Which one of these is a compound symbol: = - :=
same
reference
wrap
:=
39. Declare an output NUMBER parameter - v1 - that defaults to 10.
name-value
v1 OUT number default 10
TYPE tA IS TABLE OF NUMBER INDEX BY VARCHAR2(20)
constrained
40. Dbms_sql: A cursor opened with OPEN_CURSOR (can/cannot) be reused for multiple queries without first closing it.
once
can
drop procedure
selection
41. Name the two types of FOR loop.
loop
disable
numeric and cursor
can
42. The exception raised when a SELECT INTO statement returns more than one row.
CURRENT OF
TOO_MANY_ROWS
dynamic
WHEN
43. The allowed data types of user-defined conditional compilation directives are boolean and _______.
pls_integer
FORALL and BULK COLLECT
OUT
INTO
44. In the IF syntax - is if ENDIF or END IF?
END IF
propagates
REUSE SETTINGS
COUNT
45. If a result-cached function's data source (based on the RELIES_ON clause) is updated - any cached results become _______.
SQL
$IF
OLD
invalid
46. An $ERROR directive ends with _____.
constructor
4
$END
RESULT_CACHE
47. To use a TYPE declared in the database - a PL/SQL block has to have _______ privilege on the type.
SIMPLE_INTEGER
5
select
PLSQL_OPTIMIZE_LEVEL
48. Advantage: PL/SQL is tightly _______ with Oracle SQL.
statically
fine-grained auditing
implicit CASE_NOT_FOUND exception
integrated
49. Types: In addition to the SQL data types - PL/SQL has ___ more scalar data types.
pls_integer
label
4
calls
50. I/O: This package lets two or more sessions in the same instance communicate.
expression
DBMS_PIPE
RETURN
PSP