Question on UNUSED Columns Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Question on UNUSED Columns

  1. #1
    Join Date
    Jul 2003

    Question on UNUSED Columns

    Could someone please answer this Q for me?

    Many Thanks,

    ABC Company consolidated into one office building, so the very large EMPLOYEES table no longer requires the OFFICE_LOCATION column. The DBA decided to drop the column using the syntax below:
    ALTER TABLE hr.employees
    DROP COLUMN building_location
    Dropping this column has turned out to be very time consuming and is requiring a large amount of undo space.
    What could the DBA have done to minimize the problem regarding time and undo space consumption?
    A. Use the Export and Import utilities to bypass undo.
    B. Mark the column as UNUSED.
    C. Remove the column at a later time when less activity is on the system.
    D. Drop all indexes and constraints associated with the column prior to dropping the column.
    E. Mark the column INVALID prior to beginning the drop to bypass undo.
    F. Remove the column using the DROP UNUSED COLUMNS command.

  2. #2
    Join Date
    Jun 2000
    Madrid, Spain

  3. #3
    Join Date
    Mar 2002
    Manchester, England
    I'll tell you what, you paint my house and I'll answer your exam questions

Posting Permissions

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

Click Here to Expand Forum to Full Width