Author Topic: Oracle DBA Question 66  (Read 55 times)

0 Members and 1 Guest are viewing this topic.

Offline ralph0595

  • Full Member
  • *
  • Posts: 107
  • Karma: +0/-0
    • View Profile
Oracle DBA Question 66
« on: April 21, 2009, 01:05:15 PM »
Question:
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
CASCADE CONSTRAINTS;
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 column as UNUSED. Remove the column at a later time when less activity is on the system.
C. Drop all indexes and constraints associated with the column prior to the dropping column.
D. Mark the column INVALID prior to beginning the drop to bypass undo.
E. Add a checkpoint to the DROP UNUSED COLUMNS command to minimize the undo space.

Answer: E

Techronnati | where technology never sleeps

Oracle DBA Question 66
« on: April 21, 2009, 01:05:15 PM »

Mountain View

 

Related Topics

  Subject / Started by Replies Last post
0 Replies
62 Views
Last post April 19, 2009, 06:01:21 AM
by ralph0595
0 Replies
64 Views
Last post April 19, 2009, 06:39:28 AM
by ralph0595
0 Replies
55 Views
Last post April 19, 2009, 06:41:37 AM
by ralph0595
0 Replies
58 Views
Last post April 19, 2009, 06:46:32 AM
by ralph0595
0 Replies
54 Views
Last post April 19, 2009, 06:51:28 AM
by ralph0595

Posting Disclaimer: Any individual may post a message in this forum and may do so anonymously. Therefore, the sole author is exclusively and entirely responsible for all opinions in that message. They do not represent the official opinions of Techronnati, its administrators or moderators or the Techronnati Management. Techronnati is merely acting as an impartial conduit for constitutionally protected free speech and is not responsible and will not be held liable for the content of such messages. All images and service logos are trademarks of their respective owners.