Courses Jobs Exams Questions
Courses Jobs Exams Questions

Which query can be used to Delete the column 'Birthday' from the Persons table?

DROP COLUMN Birthday FROM Persons;

ALTER TABLE Persons DROP COLUMN Birthday;

DELETE FROM Persons where COLUMN = 'Birthday';

ALTER TABLE Persons DELETE COLUMN Birthday;

Correct Option - b

To delete the column 'Birthday' from the 'Persons' table in SQL, you would use the following query:

Option 2: ALTER TABLE Persons DROP COLUMN Birthday;

The correct syntax for removing a column from a table is to use the ALTER TABLE statement with the DROP COLUMN clause, as shown in Option 2.

To get all Infosys Certified MySQL Associate Exam questions Join Group https://bit.ly/infy_premium_group

Home / All Vendors / Infosys Lex / Infosys Certified MySQL Associate /
Question

We're passionate about offering best placement materials and courses!! A one stop place for Placement Materials. We daily post Offcampus updates and Placement Materials.

Important Links

Privacy Policy
Refund Policy
Terms & Conditions
About Us
Contact Us

Qtr No. 213, New Town Yehlanka Indore 454775

admin@prepflix.in