In SQL, which command is used to change a table's storage characteristics?
A. ALTER TABLE
B. MODIFY TABLE
C. CHANGE TABLE
D. None of these
Answer: Option A
Solution(By Examveda Team)
In SQL, the command used to change a table's storage characteristics is ALTER TABLE. The ALTER TABLE statement allows you to modify an existing table, which can include changes to the table's structure, storage, or other attributes.Option B: MODIFY TABLE is not a standard SQL command.
Option C: CHANGE TABLE is also not a standard SQL command.
Option D: "None of these" is incorrect because ALTER TABLE is the correct command for this purpose.
So, the correct answer is Option A: ALTER TABLE.
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