Multiple choice technology databases

Which one of the following is maximum limit for output generated by DBMS_OUTPUT?

  1. 10000000

  2. 1000000

  3. 100000

  4. 1000
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Historically, the maximum buffer size limit for output generated by the DBMS_OUTPUT package in Oracle databases was 1,000,000 bytes. Although later versions allowed unlimited output, 1,000,000 remains the classic limit referenced in certification exams.

Keep practicing — related questions