Telecommunication and Information Technology > QUESTIONS and ANSWERS > CIT 111 Final Exam Prep Flash Cards (All)

CIT 111 Final Exam Prep Flash Cards

Document Content and Description Below

You can use the AS keyword with the CREATE TABLE statement to create a copy of a table from a ____________________ statement. SELECT When you code a column list in an INSERT statement, you can omit co... lumns with default values and columns that allow ____________________________ values. NULL If you code a column list in an INSERT statement that includes a column that's defined with a default value, you can insert the default value for that column by coding the ____________________ keyword in the VALUES clause of the INSERT statement. DEFAULT By default, MySQL automatically commits changes to the database immediately after each INSERT, UPDATE, and ______________ statement that you issue DELETE Which uses the least amount of storage? 'example' stored in a column of type VARCHAR2(20) 'exam' stored in a column of type VARCHAR2(20) 'ex' stored in a column of type VARCHAR2(20) they all use the same amount of storage 'ex' stored in a column of type VARCHAR2(20) [Show More]

Last updated: 2 years ago

Preview 1 out of 29 pages

Buy Now

Instant download

We Accept: