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:
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