In order to add a new column to an existing table in SQL, we can use the command - MySQL MCQs

Y

Yogesh • 7.43K Points
Tutor III

Q. In order to add a new column to an existing table in SQL, we can use the command

(A) Edit Table
(B) Modify Table
(C) Alter Colums
(D) Alter Table

No solution found for this question.
Add Solution and get +2 points.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Related MCQs on MySQL

Q. Using indexes optimizes query performance.

Q. x'ffff' in decimal is . . . . . . . .

Q. The datatype that stores the longest length of strings is . . . . . . . .

Q. The term ___________ is used to refer a column.

Q. Which of these has a lower memory requirements? mysql_use_result(), mysql_store_result()

Q. What is exec_stmt_ssl written in?

Q. Find the error in the following SQL statement? CREATE TABLE person ( person_id SMALLINT, name VARCHAR, LAST VARCHAR CONSTRAINTS pk_person PRIMARY KEY (person_id)); INSERT INTO person VALUES( person_id, name, LAST) (1, ’s’, ’p’); INSERT INTO person ( person_id, name, LAST) VALUES(1,’s’,’p’);

Q. How many of the following use NULL to indicate failure? mysql_init(), mysql_real_connect()

Q. The option used to specify the socket file pathname is ______________.

Q. Which statement can be used to specify the sql_mode system variable at runtime?

Learn All MySQL MCQs