1. (TCO 3) The _____ column attribute will provide a value for a field if none i

Question

1. (TCO 3) The _____ column attribute will provide a value for a field if none is specified. (Points : 3)        DEFAULT
       AUTO_INCREMENT
       VALUE
       NOT NULL

       AUTO_INCREMENT only
       DEFAULT only
       NOT NULL only
       AUTO_INCREMENT, DEFAULT, and fields that allow NULL

Question 2. 2. (TCO 5) The _____ keyword is used in an ALTER statement to remove a column from an existing table. (Points : 3)        MODIFY COLUMN
       ADD COLUMN
       DELETE COLUMN
       DROP COLUMN

Explanation / Answer

1. Default - if no value is specified it assigns default value

2. Drop column

3. They all use the same amount of storage.

4. date and time

5. Foreign key

6. the primary key column must be created first in each table

7. The data type must immediately follow the field name.

8.INTEGER

9. ALTER TABLE customers ADD COLUMN orderdate DATE;

10. AUTO_INCREMENT, DEFAULT, and fields that allow NULL

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.