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
Photo

Anyone who has experience with either oracle admin, unix, oracle pl/sq


  • This topic is locked This topic is locked

#1
OracleWizard

OracleWizard

    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?

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

Advertisements


#2
rshaffer61

rshaffer61

    Moderator

  • Moderator
  • 34,114 posts
Please do not duplicate your topic. it makes more work for members and staff and could potentially get you mixed advice being given. Your original topic is HERE so please edit your original post to include any new info but do not reply to your topic or someone may think you are already getting assistance. Thank you for your cooperation and understanding. :D
This topic is now closed.
  • 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