Question 1. 1. (TCO 3) The _____ column attribute will provide a value for a fie

Question

Question 1. 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 Question 2. 2. (TCO 5) The _____ keyword is used in an ALTER statement to change the data type of an existing column in a table. (Points : 3)        MODIFY
       ADD
       INSERT
       DROP Question 3. 3. (TCO 3) Which uses the least amount of storage? (Points : 3)        “Example” stored in a column of type CHAR(20)
       “Exam” stored in a column of type CHAR(20)
       “Ex” stored in a column of type CHAR(20)
       They all use the same amount of storage. Question 4. 4. (TCO 3) The DATETIME data type in MySQL can store _____. (Points : 3)        dates only
       times only
       dates and times
       None of the above Question 5. 5. (TCO 3) Which statement is false regarding the creation of a foreign key constraint at table level or with an ALTER statement? (Points : 3)        The parent table must already exist.
       The field must already be defined in the table.
       The PK and FK fields must have the same name.
       The PK and FK fields may have different names. Question 6. 6. (TCO 3) When you build a script for creating tables in a database, _____. (Points : 3)        the order that you create the tables does not matter
       you must create child tables before parent tables
       you must create parent tables before child tables
       the primary key column must be created first in each table Question 7. 7. (TCO 3) You are creating a table called Department, with fields for the primary key DeptID (Integer) and department name (VARCHAR). What (if anything) is wrong with the following code?

       CREATE TABLE Department
       (
       deptID       INTEGER Primary Key,
       deptName VARCHAR(10) NOT NULL
       ); (Points : 3)        You must use curly braces, not parentheses.
       The field names must be all lower case.
       The keywords cannot be in upper case.
       Nothing is wrong. Question 8. 8. (TCO 3) What datatype is best to store a person’s age? (Points : 3)        INTEGER
       VARCHAR
       DECIMAL
       FLOAT Question 9. 9. (TCO 5) Which statement will add a new column named ORDERDATE to the CUSTOMERS table? (Points : 3)        CREATE COLUMN orderdate, DATE ADD to customers;
       ALTER TABLE customers ADD COLUMN orderdate DATE;
       ALTER TABLE customers ADD orderdate DATE;
       MODIFY TABLE customers ADD orderdate DATE; Question 10. 10. (TCO 8) When you write an INSERT statement with a column list, which columns must be specified in the column list? (Points : 3)        AUTO_INCREMENT
       DEFAULT
       NOT NULL
       Fields that allow NULL Question 1. 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

Explanation / Answer

Question 1. DEFAULT

Question 2. MODIFY

Question 3. They all use the same amount of storage.

Question 4. dates and times

Question 5. The PK and FK fields must have the same name.

Question 6. you must create parent tables before child tables

Question 7. Nothing is wrong.

Question 8. INTEGER

Question 9. ALTER TABLE customers ADD COLUMN orderdate DATE;

Question 10. NOT NULL

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

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