[OracleWizard]

Hey everyone, I'm stuck on some questions, needing help, lol. Been trying to read up to get figure out the answer on these questions all day. Here they are.

1. Which one of the following options of SQL*Plus allows you to generate HTML reports via the SPOOL command?

A. -M HTML ON
B. -M MARKUP ON
C. -MARKUP ON
D. -MARKUP
E. -M HTML


2. When displaying debug info using DBMS_OUTPUT, which one of the following is the maximum line size that can be printed using a signle invocation to DBMS_OUTPUT.PUT_LINE?

A. 63
B. 255
C. 1024
D. 8192
E. 32767

3. Why do you use pipelined functions?

A. To return collections of columns instead of single column values
B. To return collections of records instead of single values.
C. To return large volumes of records collections without having to wait until the last record is retrieved to process the first one.
D. To do complex arithmetic inside the function, DBMS_PIPE requires this property to increase the size of the buffer.
E. To load the function in memory and do not want it swapped out.


Thanks a lot to those who answer.