Introduction to SQL In SQL, which command(s) is(are) used to change a table's storage characteristics? CHANGE TABLE ALTER TABLE MODIFY TABLE All of these CHANGE TABLE ALTER TABLE MODIFY TABLE All of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The HAVING clause acts like a WHERE clause, but it identifies groups that meet a criterion, rather than rows. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL statement is used to update data in a database? UPDATE SAVE AS MODIFY SAVE UPDATE SAVE AS MODIFY SAVE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SELECT DISTINCT is used if a user wishes to see duplicate columns in a query. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL COUNT(field_name) tallies only those rows that contain a value; it ignores all null values. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Select the right statement to insert values to the student table. INSERT VALUES ( INSERT INTO student VALUES ( INSERT student VALUES ( INSERT VALUES INTO student ( INSERT VALUES ( INSERT INTO student VALUES ( INSERT student VALUES ( INSERT VALUES INTO student ( ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS