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: This DBMS_OUTPUT proc retrieves one line from the buffer.
GET_LINE
procedure P AUTHID definer;
statement
RAISE
2. Wrapped code (is / is not) not backward compatible.
IN OUT
CLOSE_CURSOR
RELIES_ON
is not
3. Associative arrays (do / do not) have to be initialized with a constructor.
do not
anonymous
optional
PL/SQL
4. Mode designation for an input parameter.
PLS_INTEGER
IN
loop
PRAGMA EXCEPTION_INIT (E - -1);
5. Are good for logging table DML operations.
FETCH - INTO
autonomous triggers
ENABLE
suspended
6. Cursors: An implicit cursor is also called a/n ________ ________ -
is certain
SQL cursor
OPEN_CURSOR
7. What are two categories of SQL functions that cannot be used in procedural statements?
wrap
FORALL and BULK COLLECT
aggregate - analytical
BINARY_INTEGER
8. Cursors: Which cursor attribute is not meaningful for an implicit cursor?
network
associative arrays
%ISOPEN.
TIMESTAMP.
9. What clause makes a compilation default to the PLSQL_CCFLAGS settings from the last compilation?
FOR i IN REVERSE 1..10 LOOP
CURSOR - RETURN
composite
REUSE SETTINGS
10. Triggers: In a per-row trigger - the ____ record shows you the original state of an affected row.
$IF
FETCH - BULK COLLECT INTO
OLD
BOOLEAN
11. Characters that begin a multi-line comment.
..
user-defined
/*
manageable
12. In PL/SQL - what the variables in DML statements are turned into.
TYPE tA IS TABLE OF NUMBER INDEX BY VARCHAR2(20)
bind arguments
database
EXECUTE IMMEDIATE
13. Types: A data type family consists of a ______ type and its subtypes.
base
;
explicit
Server Pages
14. Web: PL/SQL _______ enables a Web browser to invoke a PL/SQL stored subprogram through an HTTP listener.
FOR i IN REVERSE 1..10 - LOOP - NULL; END LOOP;
Gateway
machine code
bind arguments
15. Cursors: Give the statement to close cursor C.
wrap
255
BOOLEAN
close C
16. Types: ________ data types have no internal components.
scalar
dynamic
cannot
for each row
17. In a FORALL loop - you (can / cannot) use the index variable for purposes other than indexing into the collection.
1 million
cannot
current transaction
stored
18. Cursors: WHERE _______ ______ makes an UPDATE or DELETE apply to the current row of a cursor.
$END
CURRENT OF
invoker's
%
19. Triggers: You create a trigger with the _______ ________ statement.
CREATE TRIGGER
.
WHERE CURRENT OF
...
20. A user-defined TYPE can have...
an AUTHID property
follows
cannot
inquiry
21. Types: PL/SQL has all the _____ data types.
$$PLSQL_LINE
SQL
expression
index
22. Command to delete a procedure.
set serveroutput on
drop procedure
associative
-20 -000
23. Dbms_sql: A cursor opened with OPEN_CURSOR (can/cannot) be reused for multiple queries without first closing it.
CURSOR - RETURN - IS
composite
does not
can
24. I/O: This package sends text output to SQLPlus
DBMS_OUTPUT
do not
1
Declaration
25. Bulk: The two features that comprise Bulk SQL are:
FORALL and BULK COLLECT
do not
order
information that changes infrequently
26. Cursors: Statement to end a loop when MyCur is used up: _____ ______ MyCur%NOTFOUND.
EXIT WHEN
sequence pseudo-columns
RECORDS
inquiry
27. The source for wrapping begins with the word ______.
forward
..
create
collections - records
28. I/O: dbms_output.put_line puts output into a _______.
parameter
buffer
subtype
is
29. 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
30. Types: One of the scalar data types specific to PL/SQL: P________
DML
cursor
increment
PLS_INTEGER
31. Types: ______ data types are those storing values with no internal components.
scalar
bind
inclusive
is
32. Fundamental: One of the 4 types of lexical units: L_____
literals
CHAR - VARCHAR2
Web Toolkit
not a number
33. Conversion: Implicit conversion can be (faster / slower) than explicit conversion.
statement
selection
slower
DECLARE - BEGIN - EXCEPTION - END
34. Which collection type is bounded?
EXECUTE IMMEDIATE
mandatory
varray
subtype
35. Cursors: The second keyword of a FETCH statement.
system global area
IN - OUT - IN OUT
-
INTO
36. TCL: Create a savepoint called ab
scalar
4K
savepoint ab
HTP
37. Cursors: The keyword that makes a ref cursor type STRONG.
RETURN
static boolean
FOR i IN REVERSE 1..10 LOOP
does not
38. Give the statement to make a program autonomous.
PRAGMA AUTONOMOUS_TRANSACTION;
boolean
cannot
user-defined
39. Fundamental: A label can be used to name an ______ block.
anonymous
EXIT WHEN
INTO
EXTEND
40. The _____ utility turns PL/SQL source code into unreadable text.
scalable
placeholders
RETURN
Wrap
41. Exceptions: The keyword that begins an exception handler.
colon
RETURN
cursor
WHEN
42. For a collection - the NEXT method returns ____ when there is no next index value.
compiles
virtual machine
v3 IN OUT NUMBER
43. Declare a constrained subtype of NUMBER called N that is not null.
exit when cgo%NOTFOUND
SUBTYPE n IS number not null;
Gateway
code
44. Delimiters: Host variable indicator.
anonymous block
cannot
...
names
45. _______ arrays can be sparse or dense - depending on how you fill them.
associative
binding
optional
searched
46. The command used to populate PLSQL_CCFLAGS.
closed
4
%FOUND - %ISOPEN - %NOTFOUND - %ROWCOUNT
ALTER SESSION
47. In Native Mode - PL/SQL code is compiled into ______ ______.
binding
does not
machine code
transaction
48. Triggers and views always have _________ rights.
Warning
: Invalid argument supplied for foreach() in
/var/www/html/basicversity.com/show_quiz.php
on line
183
49. IDs: How an ordinary user-defined identifier must begin.
With a letter.
TOO_MANY_ROWS
bind
ALTER SESSION
50. By default - OUT and IN OUT parameters are passed by _____.
multi-row
PUT_LINE
anonymous
value