Introduction to SQL The condition in a WHERE clause can refer to only one value. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following are the five built-in functions provided by SQL? COUNT, SUM, AVG, MAX, MIN SUM, AVG, MULT, DIV, MIN SUM, AVG, MIN, MAX, NAME SUM, AVG, MIN, MAX, MULT COUNT, SUM, AVG, MAX, MIN SUM, AVG, MULT, DIV, MIN SUM, AVG, MIN, MAX, NAME SUM, AVG, MIN, MAX, MULT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following join is also called as an 'inner-join'? Non-Equijoin Self-Join Equijoin None of these Non-Equijoin Self-Join Equijoin None of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Count function in SQL returns the number of distinct values. values. groups. columns. distinct values. values. groups. columns. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL To sort the results of a query use: SORT BY. None of these ORDER BY. GROUP BY. SORT BY. None of these ORDER BY. GROUP BY. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Table Employee has 10 records. It has a non-NULL SALARY column which is also UNIQUE.The SQL statementSELECT COUNT(*) FROM Employee WHERE SALARY > ANY (SELECT SALARY FROM EMPLOYEE);prints 5 10 0 9 5 10 0 9 ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS