READ Free Dumps For Oracle- 1z0-144
| Question ID 22019 | Which of the following procedures of the DBMS_OUTPUT package has two overloaded forms? |
| Option A | DBMS_OUTPUT.PUT_LINE |
| Option B | DBMS_OUTPUT.PUT |
| Option C | DBMS_OUTPUT.GET_LINES |
| Option D | DBMS_OUTPUT.GET_LINE |
| Correct Answer | C |
| Question ID 22020 | Which of the following statements are true about the DBMSOUTPUT.ENABLE procedure? Each correct answer represents a complete solution. Choose all that apply. |
| Option A | The minimum and maximum values of the buffer_size that the user can specify are 20,000 and 1,000,000 respectively. |
| Option B | The calls to the DBMS_OUTPUT.PUT, DBMS_OUTPUT.PUT_LINE, DBMS_OUTPUT.NEWLINE, DBMS_OUTPUT.GET_LINE and DBMS_OUTPUT.GET_LINES procedures are acknowledged only when the DBMS_OUTPUT is activated. |
| Option C | It is not necessary to call DBMS_OUTPUT.ENABLE procedure when a user uses the SET SERVEROUTPUT option of SQL*Plus. |
| Option D | When the DBMS_OUTPUT. ENABLE procedure is called more than once, the buffer_size is set to the value passed in the first call. |
| Option E | When the DBMSOUTPUT. ENABLE procedure is called and the buffer_size is set to NULL, the buffer_size takes 20,000 as its default value. |
| Option F | The minimum and maximum values of the buffer_size that the user can specify are 2,000 and1,000,000 respectively. |
| Correct Answer | B,C,E,F |