Multiple choice technology programming languages

Min, Default and Max size of DBMS Output Buffer is ?

  1. 1 - 10,000 - 1,000,000

  2. 1 - 10,000 - 100,000

  3. 1 - 20,000 - 100,000

  4. 1 - 20,000 - 1,000,000

Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

In Oracle, the DBMS_OUTPUT buffer has configurable size limits: minimum 1 byte, default 20,000 bytes, and maximum 1,000,000 bytes. These limits can be set using the ENABLE procedure with the buffer size parameter.