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

    Unanswered: Full Table Scan?

    Hi,

    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.

    Thanks,
    Rakesh Sharma

  2. #2
    Join Date
    Apr 2003
    Location
    Minneapolis, MN
    Posts
    273
    A, B and E
    Bhavin

    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
  •