COMPUTER APPLICATIONS
DATABASE MANAGEMENT SYSTEMS
|
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: -Q 14-Which of the following is NOT true about the SQL transaction control statements? A-The COMMIT statement ends the current transaction and makes all data changes permanent.
There is 1 question to complete.