Introduction to SQL The SQL keyword GROUP BY instructs the DBMS to group together those rows that have the same value in a column. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The benefits of a standard relational language include which of the following? All of these Increased dependence on a single vendor Reduced training costs Applications are not needed All of these Increased dependence on a single vendor Reduced training costs Applications are not needed ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The keyword LIKE can be used in a WHERE clause to refer to a range of values. False True False True 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 > ALL (SELECT SALARY FROM EMPLOYEE);prints 0 5 9 10 0 5 9 10 ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Find all the cities with temperature, condition and humidity whose humidity is in the range of 63 to 79 SELECT * FROM weather WHERE humidity BETWEEN 63 AND 79 SELECT * FROM weather WHERE humidity NOT BETWEEN 63 AND 79 SELECT * FROM weather WHERE humidity NOT IN (63 AND 79) SELECT * FROM weather WHERE humidity IN (63 to 79) SELECT * FROM weather WHERE humidity BETWEEN 63 AND 79 SELECT * FROM weather WHERE humidity NOT BETWEEN 63 AND 79 SELECT * FROM weather WHERE humidity NOT IN (63 AND 79) SELECT * FROM weather WHERE humidity IN (63 to 79) ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statementSELECT SUBSTR('123456789', INSTR('abcabcabc', 'b'), 4) FROM DUAL; 6789 1234 456789 2345 6789 1234 456789 2345 ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS