DBA GENESIS

  • Courses

  • Certification

  • Contact

  • Members

  • More

    Use tab to navigate through the menu items.

    Book a mock interview and get instant feedback - Learn More

    To see this working, head to your live site.
    • Categories
    • All Posts
    • My Posts
    Balaji
    Jan 06

    Oracle interview question

    in Oracle Database Administration

    The SGA size is 10 GB and the output of SQL query is 50 GB. Could you please let me know whether this SQL query will succeed or fail.

    2 comments
    2 Comments

    Share Your ThoughtsSign up to leave a comment.

    Piyush Ranjan
    Jan 06
    •
    Best Answer

    The query will succeed!


    Oracle Database will load the table into the buffer cache. If the cache is full, it will load the data into the PGA instead, overwriting the entire cache for "big" tables.


    This is a read on the direct path. If the database needs to handle data from the huge table before returning to the client (for example, for a join), the information will be written to temp (disk).


    For more Interview Questions and Answers visit link mention below:


    https://www.support.dbagenesis.com/post/oracle-dba-interview-questions-answers

    0
    B
    Balaji
    Jan 07
    •
    Replying to

    Thank you

    Like
    2 comments
    Similar Posts
    • ASM disk drop interview question
    • Oracle installation
    • Oracle Enterprises manager

    support@dbagenesis.com

    • Facebook
    • Instagram
    • Twitter
    • YouTube

    © 2023 Biggest Database Forum by DBA Genesis