CIS 336 DeVry Week 3 Quiz Latest

admin   June 29, 2017   Comments Off on CIS 336 DeVry Week 3 Quiz Latest

CIS 336 DeVry Week 3 Quiz Latest

Downloading is very simple, you can download this Course here:

http://wiseamerican.us/product/cis-336-devry-week-3-quiz-latest/

Or

Contact us at:

SUPPORT@WISEAMERICAN.US

CIS 336 DeVry Week 3 Quiz Latest

CIS336

CIS 336 DeVry Week 3 Quiz Latest

  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