Multiple choice technology databases

Is it possible to modify a Datatype of a column when column contains Data

  1. Yes

  2. No

  3. NA

  4. na
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Most traditional databases restrict changing a column's data type once it contains data to prevent data loss or corruption. While some modern databases allow type conversions when compatible, the general principle in traditional RDBMS is that schema changes on populated columns are restricted. Options C and D are not meaningful responses.

Keep practicing — related questions