The SQL ALTER statement can be used to:
A. change the table data.
B. change the table structure.
C. delete rows from the table.
D. add rows to the table.
Answer: Option B
Solution(By Examveda Team)
The SQL ALTER statement is primarily used to change the table structure. It allows you to modify the structure of an existing table by adding, modifying, or deleting columns, as well as changing various constraints or properties of the table. Option B is the correct choice, while Options A, C, and D do not accurately describe the primary purpose of the ALTER statement.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
Join The Discussion