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. In a collection - the internal components always have the _____ data type.
UTL_FILE
same
DECLARE - BEGIN - EXCEPTION - END
associative arrays
2. You (can/cannot) put a label before an END LOOP statement.
cannot
reference
significant
selection
3. DBMS_DDL.WRAP returns a string containing wrapped _____ _____.
include
source code
dbms_output.put_line
suspended
4. A type of compiler directive - begins with 'e'.
COUNT
error
RETURN
same
5. Setting CURRENT_SCHEMA only changes what is prepended to __________ references.
unqualified
collections - records
BOOLEAN
fields
6. Default file extension of wrap's input file.
an autonomous routine
DBMS_PREPROCESSOR
FETCH - BULK COLLECT INTO
sql
7. Delimiters: The component indicator/selector.
2
timing
increment
.
8. Language that PL/SQL is derived from.
Apache
label
Ada
SIMPLE_INTEGER
9. The $ERROR directive is used to make compilation ____.
fail
STANDARD
anonymous
literals
10. I/O: This package lets two or more sessions in the same instance communicate.
END CASE
TOO_MANY_ROWS
DBMS_PIPE
CURRENT OF
11. Command to make a no-op (omit semicolon).
USER_PLSQL_OBJECT_SETTINGS
cannot
procedure P AUTHID definer;
12. Advantage: Performance: Storing and runnng procedures on the server minimizes ______ traffic.
REF_CURSOR
variable
network
anonymous
13. Delimiters: Statement terminator.
;
versions
SQL
virtual machine
14. An incomplete type is a type created by a ______ type definition.
TOO_MANY_ROWS
machine
forward
30
15. Cursors: Give the statement to close cursor C.
# - $ - _
close C
statement
CURSOR - RETURN - IS
16. The variable showing the user id of the session owner.
lowest
SESSION_USER
bind
scalar
17. Conversion: Just about everything will implicitly convert to _____ or _________.
FORALL and BULK COLLECT
column
CHAR - VARCHAR2
package
18. Triggers: In a trigger - you cannot issue a COMMIT or a ______.
ROLLBACK
create
never
DBMS_SESSION
19. Delimiters: Item separator.
exception
INTO
include
20. Cursors: The first two keywords of a basic fetch statement.
calls
ADT
FETCH - INTO
STANDARD
21. Which two of these built-in SQL functions can be used in procedural (PL/SQL) statements: DECODE - CORR - UPPER - SUM - COALESCE - DEREF.
DBMS_OUTPUT
national
IN OUT
upper - coalesce
22. Labels for blocks and statements are enclosed in '__' brackets.
package
definer's
<<>>
cursor c;
23. Define a nested table type - tN - which is a table NUMBERs.
upper - coalesce
TYPE tN IS TABLE of NUMBER
Server Pages
do not
24. What are the 3 values of the BOOLEAN data type?
GET_LINES
national
TRUE - FALSE and NULL
cursor number
25. The SET TRANSACTION statement affects only the ____________.
v2 IN NUMBER default 20
hardware
current transaction
NESTED TABLE myColl STORE AS myCollTab
26. Cursors: A cursor that lives in session memory until the session ends.
can
implicit CASE_NOT_FOUND exception
Ada
session cursor
27. Cursors: A cursor FOR loop can use an explicit or an _______ cursor.
implicit
EVERE - PERFORMANCE - INFORMATIONAL
can
savepoint ab
28. Loops: What is the index range operator in a FOR loop?
..
USER_PLSQL_OBJECT_SETTINGS
cannot
currval and nextval
29. A (simple / searched) CASE statement begins with CASE <expression>.
simple
IR
TYPE rec IS RECORD (num NUMBER - name VARCHAR2(10));
PL/SQL
30. Give the ANSI Date literal for December 25 - 2005.
Warning
: Invalid argument supplied for foreach() in
/var/www/html/basicversity.com/show_quiz.php
on line
183
31. Which two collection types are unbounded?
fields
exception handler
p.v
nested tables - associative arrays
32. I/O: To make sure the DBMS_OUTPUT buffer will be flushed - put a WHEN ______ clause in the EXCEPTION section of your outer block.
OTHERS
CREATE TRIGGER
numeric and cursor
execute
33. In interpreted mode - PL/SQL code is run in a _______ _______.
VARRAYs
virtual machine
<> - != - ^=
invoker's
34. Dbms_sql: The integer returned by OPEN_CURSOR is a _____ _____.
slower
cursor number
timing
PVM
35. The BETWEEN operator is (inclusive / exclusive).
4
inclusive
injection
RETURN
36. Declare an output NUMBER parameter - v1 - that defaults to 10.
SQL cursor
anonymous
v1 OUT number default 10
DBMS_PIPE
37. I/O: This package handles HTTP.
UTL_HTTP
in the database
cursor
create procedure
38. A null string and a BOOLEAN null are _______ (same/not the same).
not the same
VARCHAR2
aggregate - analytical
DML
39. Types: One of the 4 PL/SQL things that have a data type (begins with 'v').
collections
plb
variable
DBMS_PIPE
40. I/O: The buffered output of dbms_output.put_line is retrieved by _______.
static
SQLPlus
implicit cursor
1
41. Dbms_sql: DBMS_SQL package is compiled with _______ rights.
Warning
: Invalid argument supplied for foreach() in
/var/www/html/basicversity.com/show_quiz.php
on line
183
42. I/O: Max number of bytes to pass in a call to DBMS_OUTPUT.PUT_LINE.
COMMIT - ROLLBACK - SAVEPOINT - SET TRANSACTION
255
calls
implicit
43. Types: One of the scalar data types specific to PL/SQL: P________
$$PLSQL_LINE
error code
PLS_INTEGER
hardware
44. Triggers and views always have _________ rights.
Warning
: Invalid argument supplied for foreach() in
/var/www/html/basicversity.com/show_quiz.php
on line
183
45. A numeric FOR loop cannot _________ by other than 1?
timing
reference
increment
explicit
46. To run a PIPE ROW statement in your autonomous routine - you must close any _____________.
associative
END LOOP
%
autonomous transaction
47. Exceptions: Start of the range of error codes for RAISE_APPLICATION_ERROR.
quoted
-20 -000
manageable
END LOOP
48. Exceptions: You cannot GOTO from an exception handler back into the __________ block.
upper - coalesce
network
anonymous
current
49. Cursors: You cannot use cursor attributes in _______ statements.
Server Pages
SQL
unconstrained
definition
50. IDs: Maximum number of bytes in a user-defined identifier.
30
IS
DEFINER
PRAGMA EXCEPTION_INIT (E - -1);