Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works

Questions from Oracle PL/SQL

  • Please log in to reply



    New Member

  • Member
  • Pip
  • 2 posts
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?


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.
  • 0


Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP