Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003

    Unanswered: Full Table Scan?


    Qn. Which three actions will cause queries to place a table’s blocks at the most-recently-used end of the LRU list for the DEFAULT pool? (Choose three)

    A. Creating a table with the CACHE option.
    B. Querying the table by using a CACHE hint.
    C. Ensuring the query performs a full table scan.
    D. Defining the table without the option for caching.
    E. Altering an existing table to set the CACHE option.
    F. Ensuring the query does not retrieve data through index lookup.
    G. Creating a separate database buffer cache to hold cached table.

    Is the Ans. A, C, E correct? or A,B,E?

    Please advice.

    Rakesh Sharma

  2. #2
    Join Date
    Apr 2003
    Minneapolis, MN
    A, B and E

    MS Computer Science
    OCP DBA 9i/8i

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts