Introduction to SQL Which of the following group functions ignore NULL values? SUM COUNT MAX All of these SUM COUNT MAX All of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL statement is used to update data in a database? SAVE SAVE AS UPDATE MODIFY SAVE SAVE AS UPDATE MODIFY ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is the correct order of keywords for SQL SELECT statements? WHERE, FROM,SELECT SELECT,WHERE,FROM SELECT, FROM, WHERE FROM, WHERE, SELECT WHERE, FROM,SELECT SELECT,WHERE,FROM SELECT, FROM, WHERE FROM, WHERE, SELECT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The rows of the result relation produced by a SELECT statement can be sorted, but only by one column. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL What is the meaning of LIKE '%0%0%' Feature has two 0's in it, at any position Feature ends with two 0's Feature begins with two 0's Feature has more than two 0's Feature has two 0's in it, at any position Feature ends with two 0's Feature begins with two 0's Feature has more than two 0's ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The result of every SQL query is a table. True False True False ANSWER DOWNLOAD EXAMIANS APP