logo

CuriousTab

CuriousTab

Discussion


Home Interview Technology See What Others Are Saying!
  • Question
  • What does cache and no cache options mean while creating a sequence?


  • Correct Answer
  • The CACHE option means how many sequences will be stored in memory for access by the application objects The performance is faster However in case of the database is down the data is memory is lost for the sequence The NO CACHE option means values are not stored in memory So there might be some performance issue 


  • More questions

    • 1. Describe the use of PL/SQL table?
    • Discuss
    • 2. Name any three PL/SQL exceptions?
    • Discuss
    • 3. Which one of the following sorts rows in SQL?

    • Options
    • A. ORDER BY
    • B. GROUP BY
    • C. SORT BY
    • D. ALIGN BY
    • Discuss
    • 4. What is the meaning of ABAP editor integrated with ABAP data dictionary?
    • Discuss
    • 5. Which one of the following is not a 'Money Market Instrument'?

    • Options
    • A. Commercial Paper
    • B. Equity Shares
    • C. Certificate of Deposit
    • D. Treasury Bills
    • Discuss
    • 6. What is onshore outsourcing?
    • Discuss
    • 7. What is the Use of SPAN in HTML and give one example?
    • Discuss
    • 8. .What are the different types of environments available in the web?
    • Discuss
    • 9. What is web portal?
    • Discuss
    • 10. What is web application?
    • Discuss


    Comments

    There are no comments.

Enter a new Comment