Introduction to SQL Which of the following SQL commands is used to retrieve data? INSERT SELECT DELETE JOIN INSERT SELECT DELETE JOIN ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following group functions ignore NULL values? COUNT MAX SUM All of these COUNT MAX SUM All of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following SQL commands can be used to add data to a database table? APPEND INSERT ADD UPDATE APPEND INSERT ADD UPDATE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL keyword is used to sort the result-set? ORDER SORT ORDER BY SORT BY ORDER SORT ORDER BY SORT BY ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL In SQL, which command(s) is(are) used to change a table's storage characteristics? MODIFY TABLE All of these ALTER TABLE CHANGE TABLE MODIFY TABLE All of these ALTER TABLE CHANGE TABLE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which operator performs pattern matching? LIKE operator None of these BETWEEN operator EXISTS operator LIKE operator None of these BETWEEN operator EXISTS operator ANSWER DOWNLOAD EXAMIANS APP