📊 MySQL
Q. Suppose you have a table named to test and inside this table you have a column named CGPA now if you are asked to change the column named CGPA to total percentage, using alter command then which of the following statement you will write?
  • (A) ALTER TABLE test CHANGE COLUMN 'cgpa’ 'total_percentage’ int;
  • (B) ALTER test table CHANGE 'cgpa’ ,'total_percentage’ int;
  • (C) ALTER TABLE test CHANGE 'cgpa 'total_percentage’ int;
  • (D) None of these
💬 Discuss
✅ Correct Answer: (A) ALTER TABLE test CHANGE COLUMN 'cgpa’ 'total_percentage’ int;

You must be Logged in to update hint/solution

💬 Discussion


📊 Question Analytics

👁️
421
Total Visits
📽️
3 y ago
Published
🎖️
Jatin Dubey
Publisher
📈
80%
Success Rate