Introduction to SQL Which SQL keyword is used to sort the result-set? ORDER BY SORT BY ORDER SORT ORDER BY SORT BY ORDER SORT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following group functions ignore NULL values? All of these MAX SUM COUNT All of these MAX SUM COUNT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The wildcard in a WHERE clause is useful when? An exact match is necessary in a SELECT statement. An exact match is not possible in a CREATE statement. An exact match is not possible in a SELECT statement. An exact match is necessary in a CREATE statement. An exact match is necessary in a SELECT statement. An exact match is not possible in a CREATE statement. An exact match is not possible in a SELECT statement. An exact match is necessary in a CREATE statement. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL There is an equivalent join expression that can be substituted for all subquery expressions. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following SQL commands is used to retrieve data? JOIN INSERT DELETE SELECT JOIN INSERT DELETE SELECT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL To sort the results of a query use: None of these ORDER BY. SORT BY. GROUP BY. None of these ORDER BY. SORT BY. GROUP BY. ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS