A

Admin • 36.96K Points
Coach 

Q. Which statement can be used for modifying the definition for an existing table?

  • (A) ALTER
  • (B) Modified
  • (C) SELECT
  • (D) FROM
  • Correct Answer - Option(A)
  • Views: 18
  • Filed under category MySQL
Explanation by: Admin 
ALTER: The ALTER statement in SQL is used to modify the structure or definition of an existing database object, including tables. With the ALTER TABLE statement, you can add, modify, or drop columns, constraints, or indexes, among other modifications to the table's structure.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Be the first to start discuss.

Related MCQs on MySQL

Q. What are X'61626364? and X'61626364??

Q. A FULLTEXT index can be created for multiple columns.

Q. Which of the following columns is not returned by ‘OPTIMIZE TABLE’?

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

Q. In oracle database variable length column is declared by . . . . . . . .

Q. You can pass parameters to procedures or functions in a package.

Q. What is the significance of "ORDER BY emp_id DESC" in the following MySQL command? SELECT emp_id, fname, lname FROM person ORDER BY emp_id DESC;

Q. The hub of a MySQL installation is

Q. Which command is used to redefined the mysql delimiter?

Q. Which datatypes make it practical to write PL/SQL programs to do number-crunching, for scientific applications involving floating-point calculations.

Learn All MySQL MCQs

Question analytics