July 24, 2009 at 5:26 am
It really depends on the datatype in question, the answer options should be more elaborate...
July 24, 2009 at 11:42 am
abhijeetv (7/24/2009)
It really depends on the datatype in question, the answer options should be more elaborate...
Hear, hear! This happens too frequently (the correct answer is mostly, but not always, the correct answer)
July 28, 2009 at 9:42 am
I was taking the question to mean the mechanics of changing a data type. One should always think about the data types before changing and determine if there could be problems. The question was correct on the mechanics.
Mechanically speaking, I can drain the oil from my car and try to run the engine. Would I want to do this? NO. True/False questions can be worded to skew the answer in any direction.
August 4, 2009 at 9:08 am
I also agreed because conversion make a lot of problem, like convert from integer to DateTime. Thus, it should have third option.:-)
October 24, 2009 at 8:59 am
sknox (7/23/2009)
Carlo Romagnano (7/23/2009)
Lynn Pettis (7/23/2009)
There really should have been a third choice: It Depends. It really does, what data type is being converted to what data type?For example you can't eliminate the IDENTITY from a column.
But IDENTITY is not a data type; it's an attribute of the column. 😛
Besides, if you configure the DBMS to allow direct editing of system tables you CAN eliminate the identity property from a column (unset the identity flag in the status field of the syscolumnms row for the column); this is definitely not something I would reccomend, not even to my worst enemy, but it's possible to do.
Tom
Viewing 5 posts - 16 through 19 (of 19 total)
You must be logged in to reply to this topic. Login to reply