Section 11 Quiz
Uploaded by
Dorin ChioibasSection 11 Quiz
Uploaded by
Dorin ChioibasTest: Section 11 Quiz
Review your answers, feedback, and question scores below. An asterisk (*) indicates
a correct answer.
Section 11 Quiz
(Answer all questions in this section)
1. Which general exceptions may be handled by the UTL_FILE package?
(Choose 2) Mark for Review
(1) Points
(Choose all correct answers)
VALUE_ERROR (*)
NO_DATA_FOUND (*)
ZERO_DIVIDE
TOO_MANY_ROWS
Correct Correct
2. The UTL_MAIL package allows sending email from the Oracle
database to remote recipients. Mark for Review
(1) Points
True (*)
False
Correct Correct
3. Which of the following procedures is not valid for the UTL_MAIL
package Mark for Review
(1) Points
SEND_ATTACH_RAW
SEND_ATTACH_VARCHAR2
All are valid.
SEND
SEND_ATTACH_BOOLEAN (*)
Correct Correct
4. DBMS_OUTPUT.PUT_LINE can be invoked from inside a private
packaged function. True or False? Mark for Review
(1) Points
True (*)
False
Correct Correct
5. Which of the following exceptions can be raised ONLY when using
the UTL_FILE package? (Choose two.) Mark for Review
(1) Points
(Choose all correct answers)
E_MYEXCEP
VALUE_ERROR
NO_DATA_FOUND
INVALID_PATH (*)
READ_ERROR (*)
Correct Correct
Page 1 of 3 Next Summary
Test: Section 11 Quiz
Review your answers, feedback, and question scores below. An asterisk (*) indicates
a correct answer.
Section 11 Quiz
(Answer all questions in this section)
6. The UTL_FILE package can be used to read and write binary files
such as JPEGs as well as text files. True or False? Mark for Review
(1) Points
True
False (*)
Correct Correct
7. Using the FOPEN function, you can do which actions with the
UTL_FILE package? (Choose 2) Mark for Review
(1) Points
(Choose all correct answers)
It is used to manipulate large object data type items in columns.
It is used to find out how much free space is left on an operating system
disk.
It is used to append to a file until processing is complete. (*)
It is used to read and write text files stored outside the database. (*)
Correct Correct
8. The DBMS_OUTPUT package is useful for which of the following
activities? (Choose two) Mark for Review
(1) Points
(Choose all correct answers)
Display results to the developer during testing for debugging purposes (*)
Interact with a user during execution of a function or procedure
Trace the code execution path for a function or procedure (*)
Write operating system text files to the user's screen
Correct Correct
9. The DBMS_OUTPUT.PUT procedure places text in a buffer but does
not display the contents of the buffer. True or False? Mark for Review
(1) Points
True (*)
False
Correct Correct
10. The UTL_FILE package can be used to create binary files such as
JPEGs as well as text files. True or False? Mark for Review
(1) Points
True
False (*)
Correct Correct
Previous Page 2 of 3 Next Summary
Test: Section 11 Quiz
Review your answers, feedback, and question scores below. An asterisk (*) indicates
a correct answer.
Section 11 Quiz
(Answer all questions in this section)
11. Package CURSPACK declares a global cursor in the package
specification. The package contains three public procedures: OPENPROC opens the
cursor; FETCHPROC fetches 5 rows from the cursor's active set; CLOSEPROC closes the
cursor.
What will happen when a user session executes the following commands in the order
shown?
curspack.openproc; -- line 1
curspack.fetchproc; -- line 2
curspack.fetchproc; -- line 3
curspack.openproc; -- line 4
curspack.fetchproc; -- line 5
curspack.closeproc; -- line 6
Mark for Review
(1) Points
The first 10 rows will be fetched, then the first 5 rows will be fetched
again.
The first 15 rows will be fetched.
An error will occur at line 2.
The first 5 rows will be fetched three times.
An error will occur at line 4. (*)
Correct Correct
12. Package MULTIPACK declares the following global variable:
g_myvar NUMBER;
User DICK executes the following:
multipack.g_myvar := 45;
User HAZEL now connects to the database. Both users immediately execute:
BEGIN
DBMS_OUTPUT.PUT_LINE(multipack.g_myvar);
END;
What values will Dick and Hazel see?
Mark for Review
(1) Points
Dick: 45, Hazel: null (*)
Dick: 45, Hazel: 45
Dick: 45, Hazel: 0
Dick: 0, Hazel: 0
Both queries will fail because the syntax of DBMS_OUTPUT.PUT_LINE is
incorrect
Correct Correct
13. A cursor is declared in a package specification. User SIOBHAN
opens the cursor and fetches the first three rows from the cursor's active set, but
does not close the cursor.
User FRED now connects to the database. FRED can immediately fetch the next three
rows without opening the cursor. True or False? Mark for Review
(1) Points
True
False (*)
Correct Correct
14. Users A and B call the same procedure in a package to initialize
a global variable my_pkg.g_var. What will be the value of my_pkg.g_var for User A
at Point A?
User A: my_pkg.g_var is 10
User B: my_pkg.g_var is 10
User A: my_pkg.g_var is 50
User B: my_pkg.g_var is 25
Point A
Mark for Review
(1) Points
25
50 (*)
10
Correct Correct
15. A package's state is initialized when the package is first
loaded. True or False? Mark for Review
(1) Points
True (*)
False
Correct Correct