Introduction to SQL The wildcard asterisk (*) is the SQL-92 standard for indicating "any sequence of characters." True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statementSELECT SUBSTR('123456789', INSTR('abcabcabc', 'b'), 4) FROM DUAL; 1234 456789 6789 2345 1234 456789 6789 2345 ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL COUNT(field_name) tallies only those rows that contain a value; it ignores all null values. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Find the temperature in increasing order of all cities SELECT city, temperature FROM weather; SELECT city, temperature FROM weather ORDER BY city; SELECT city FROM weather ORDER BY temperature; SELECT city, temperature FROM weather ORDER BY temperature; SELECT city, temperature FROM weather; SELECT city, temperature FROM weather ORDER BY city; SELECT city FROM weather ORDER BY temperature; SELECT city, temperature FROM weather ORDER BY temperature; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The ADD command is used to enter one row of data or to add multiple rows as a result of a query. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following are the five built-in functions provided by SQL? 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 COUNT, SUM, AVG, MAX, MIN SUM, AVG, MULT, DIV, MIN SUM, AVG, MIN, MAX, NAME ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS