Which command is used to add a column to an existing table?

Related MCQs

• Consider a hash table of size seven, with starting index zero, and a hash function (3x + 4)mod7. Assuming the hash table is initially empty, which of the following is the contents of the table when the sequence 1, 3, 8, 10 is inserted into the table using closed hashing? Note that ‘_’ denotes an empty location in the table.
• What SQL command will allow you to change the table STUDENT to add the constraint named GradeCheck that states that the values of the Grade column must be greater than 0?
• Which of the following SQL command can be used to modify existing data in a database table?
• What SQL structure is used to limit column values of a table?
• Drop Table cannot be used to drop a table referenced by a                    constraint.
• Drop Table cannot be used to drop a table referenced by a …………… constraint.
• In SQL, which command is used to issue multiple CREATE TABLE, CREATE VIEW and GRANT statements in a single transaction?
• Which command enables alteration the data stored in existing records:
• Which join refers to join records from the write table that have no matching key in the left table are include in the result set:
• You have a column that will only contain values from 0 to 256. What is the most economical data type to use for the column?