CIT 111 FINAL EXAM PREP QUESTIONS WITH 100% CORRECT ANSWERS| 100% verified

CIT 111 FINAL EXAM PREP QUESTIONS WITH 100% CORRECT ANSWERS You can use the AS keyword with the CREATE TABLE statement to create a copy of a table from a ____________________ statement. CORRECT ANSWER SELECT When you code a column list in an INSERT statement, you can omit columns with default values and columns that allow ____________________________ values. CORRECT ANSWER 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. CORRECT ANSWER DEFAULT By default, MySQL automatically commits changes to the database immediately after each INSERT, UPDATE, and ______________ statement that you issue CORRECT ANSWER 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 CORRECT ANSWER 'ex' stored in a column of type VARCHAR2(20) The _____________________ function is an ANSI-standard function that you can use to perform an explicit conversion. CORRECT ANSWER CAST In MySQL 5.6 the CHAR and VARCHAR2 data types use which character set? A) Latin1 B) UTF-8 C) ASCII D) ISO 8859 E) UTF-16 CORRECT ANSWER B) UTF-8 If you want to store a decimal number, you must use the FLOAT data type. True False CORRECT ANSWER False