What SQL command can be used to add columns to a table?
A. ALTER TABLE TableName ADD ColumnName
B. ALTER TABLE TableName ADD COLUMN ColumnName
C. MODIFY TABLE TableName ADD ColumnName
D. MODIFY TABLE TableName ADD COLUMN ColumnName
Answer: Option A
Solution(By Examveda Team)
To add columns to a table in SQL, you can use the ALTER TABLE TableName ADD ColumnName command. Option A is the correct choice for adding new columns to an existing table. Options B, C, and D do not represent the standard SQL syntax for adding columns.Join The Discussion
Comments ( 3 )
Related Questions on Sql Miscellaneous
A. Structured Query Language
B. Structured Query List
C. Simple Query Language
D. None of these
Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?
A. Data Definition Language(DDL)
B. Data Manipulation Language(DML)
C. Both of above
D. None
Which operator performs pattern matching?
A. BETWEEN operator
B. LIKE operator
C. EXISTS operator
D. None of these
What operator tests column for the absence of data?
A. EXISTS operator
B. NOT operator
C. IS NULL operator
D. None of these
answer should be B ithink
option B is also valid!
Answer should be "B"