• Author / Uploaded
• Dorin Chioibas

Citation preview

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) (Choose 2) (1) Points

1. Which general exceptions may be handled by the UTL_FILE package? Mark for Review (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

package (1) Points

Correct 3. Which of the following procedures is not valid for the UTL_MAIL Mark for Review

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 Previous

Correct 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

Previous

Page 3 of 3 Summary