Jump to content

Welcome to Geeks to Go - Register now for FREE

Need help with your computer or device? Want to learn new tech skills? You're in the right place!
Geeks to Go is a friendly community of tech experts who can solve any problem you have. Just create a free account and post your question. Our volunteers will reply quickly and guide you through the steps. Don't let tech troubles stop you. Join Geeks to Go now and get the support you need!

How it Works Create Account
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