The _____ command is used to allocates an extent for the table in SQL A. MODIFY ALLOCATES B. MODIFY TABLE C. ALTER TABLE D. REDEFINE TABLE E. None of the above

[amp_mcq option1=”MODIFY ALLOCATES” option2=”MODIFY TABLE” option3=”ALTER TABLE” option4=”REDEFINE TABLE E. None of the above” correct=”option3″]

The correct answer is: C. ALTER TABLE

The ALTER TABLE command is used to change the structure of a table. This can include adding or removing columns, changing the data type of a column, or changing the constraints on a column. The ALTER TABLE command can also be used to allocate an extent for a table. An extent is a contiguous block of storage that is used to store data for a table.

The MODIFY ALLOCATES command is not a valid SQL command. The MODIFY command is used to change the properties of a table, but it does not allow you to allocate an extent for the table. The MODIFY TABLE command is a synonym for the ALTER TABLE command. The REDEFINE TABLE command is used to completely redefine a table, including its structure and data.

Here is an example of how to use the ALTER TABLE command to allocate an extent for a table:

sql
ALTER TABLE my_table ALLOCATE EXTENT;

This command will allocate a new extent for the table my_table. The size of the extent will be determined by the table’s data type and the amount of data that is currently stored in the table.