Devry CIS 336 Week 3 Quiz Latest

Description

Devry CIS 336 Week 3 Quiz Latest 

Devry CIS336 Week 3 Quiz Latest

1. 1.Question : (TCO 3) The _____ column attribute will automatically generate unique numbers in sequence.

DEFAULT

AUTO_INCREMENT

AUTO_SEQUENCE

NOT NULL

Question 2. Question : (TCO 5) The _____ keyword is used in an ALTER statement to remove a column from an existing table.

MODIFY COLUMN

ADD COLUMN

DELETE COLUMN

DROP COLUMN

Question 3. Question : (TCO 3) Which uses the least amount of storage?

“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. Question : (TCO 3) The TIME data type in MySQL can store _____.

dates only

times only

dates and times

None of the above

Question 5. Question : (TCO 3) Which statement is false regarding the creation of a foreign key constraint at table level or with an ALTER statement?

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. Question : (TCO 3) A foreign key constraint can only reference a column in another table that has been assigned a(n) _____ constraint.

NOT NULL

UNIQUE

PRIMARY KEY

DEFAULT

Question 7. Question : (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 Primary Key INTEGER ,

deptName NOT NULL VARCHAR(10)

);

You must use curly braces, not parentheses.

The data type must immediately follow the field name.

The keywords cannot be in upper case.

Nothing is wrong.

Question 8. Question : (TCO 3) What datatype is best to store a person’s age?

INTEGER

VARCHAR

DECIMAL

FLOAT

Question 9. Question : (TCO 5) Which statement will remove the field STATUS from the CUSTOMERS table?

ALTER TABLE customers REMOVE status;

ALTER TABLE customers DROP status;

ALTER TABLE customers DROP COLUMN status;

ALTER TABLE customers DELETE status;

Question 10. Question : (TCO 8) When you write an INSERT statement with a column list, which columns can be omitted from the column list?

AUTO_INCREMENT only

DEFAULT only

NOT NULL only

AUTO_INCREMENT, DEFAULT, and fields that allow NULL

 

DeVry Courses helps in providing the best essay writing service. If you need 100% original papers for Devry CIS 336 Week 3 Quiz Latest , then contact us through call or live chat.

Devry CIS 336 Week 3 Quiz Latest