Introduction to SQL Which of the following group functions ignore NULL values? COUNT All of these MAX SUM COUNT All of these MAX SUM ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The result of a SQL SELECT statement is a(n) ________ . report table form file report table form file ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Find the temperature in increasing order of all cities SELECT city, temperature FROM weather ORDER BY temperature; SELECT city, temperature FROM weather ORDER BY city; SELECT city FROM weather ORDER BY temperature; SELECT city, temperature FROM weather; SELECT city, temperature FROM weather ORDER BY temperature; SELECT city, temperature FROM weather ORDER BY city; SELECT city FROM weather ORDER BY temperature; SELECT city, temperature FROM weather; 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 has more than two 0's Feature ends with two 0's Feature begins with two 0's Feature has two 0's in it, at any position Feature has more than two 0's Feature ends with two 0's Feature begins with two 0's ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statementSELECT ROUND(45.926, -1) FROM DUAL; prints 045.926 is illegal prints garbage prints 50 prints 045.926 is illegal prints garbage prints 50 ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following join is also called as an 'inner-join'? Non-Equijoin Equijoin None of these Self-Join Non-Equijoin Equijoin None of these Self-Join ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS