CLOUD COMPUTING
DATABASE MANAGEMENT
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which of the following is not true about the ALTER TABLE statement?
|
|
It can add a new row.
|
|
|
It can add a new column
|
|
|
It can modify existing columns
|
|
|
It can define a default value for the new column
|
Explanation:
Detailed explanation-1: -Q 7-Which of the following is not true about modifying rows in a table? A-Existing rows in a table are modified using the UPDATE statement.
Detailed explanation-2: -Q 1-Which of the following is not true about SQL statements? A-SQL statements are not case sensitive.
Detailed explanation-3: -Explanation: ALTER TABLE command allows a user to add a new column to a table. Option B is the correct syntax of ALTER to add a column in the table.
There is 1 question to complete.