Which of the following is the correct syntax to add a field using alter command? - MySQL MCQs

Home / Programming MCQs / MySQL MCQs / Question

J

Jatin Dubey • 3.78K Points
Extraordinary

Q. Which of the following is the correct syntax to add a field using alter command?

(A) ALTER TABLE table_name ADD field_name data type;

(B) ALTER TABLE table_name, field_name data type;

(C) ALTER TABLE field_name data type;

(D) None of these

Correct answer: Option(A)

MySQL Share

Explanation by: Jatin Dubey

To add a field using alter statement following syntax should be followed:

ALTER TABLE table_name ADD field_name data type;

You must be Logged in to update hint/solution

Previous MCQ Next MCQ

Discusssion

Login to discuss.

Related MCQs on MySQL

The TLS protocol is _____________.

Foreign keys cannot handle deletes and updates.

Select the correct order of precedence among the following?

Regardless of whether a database or table name is case sensitive on the system, it must be referred to using the same lettercase throughout a given query.

Which mode is a shorthand for ‘both strict modes plus a bunch of other restrictions’?

A function called from SQL statements must obey certain rules meant to control side effects.

Which statement is not true about SQL?

The SQL keyword BETWEEN is used

Triggers enable to enforce data integrity constraints.

Which statement is used to check how MySQL would execute a SELECT query?

Learn All MySQL MCQs