Introduction to SQL Which SQL statement is used to update data in a database? SAVE AS MODIFY UPDATE SAVE SAVE AS MODIFY UPDATE SAVE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Let the statementSELECT column1 FROM myTable;return 10 rows. The statementSELECT ALL column1 FROM myTable;will return None of these exactly 10 rows less than 10 rows more than 10 rows None of these exactly 10 rows less than 10 rows more than 10 rows ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included. SINGLE DISTINCT ONLY UNIQUE SINGLE DISTINCT ONLY UNIQUE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL statement is used to delete data FROM a database? REMOVE ALTER DELETE COLLAPSE REMOVE ALTER DELETE COLLAPSE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL DISTINCT and its counterpart, ALL, can be used more than once in a SELECT statement. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The condition in a WHERE clause can refer to only one value. False True False True ANSWER DOWNLOAD EXAMIANS APP