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 9 10 0 5 9 10 0 5 ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The result of every SQL query is a table. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following must be enclosed in double quotes? Dates Strings All of these Column Alias Dates Strings All of these Column Alias ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Find the name of those cities with temperature and condition whose condition is either sunny or cloudy but temperature must be greater than 70oF. SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' AND condition = 'cloudy' AND temperature > 70; SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' OR condition = 'cloudy' OR temperature > 70; SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' AND condition = 'cloudy' OR temperature > 70; SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' OR condition = 'cloudy' AND temperature > 70; SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' AND condition = 'cloudy' AND temperature > 70; SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' OR condition = 'cloudy' OR temperature > 70; SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' AND condition = 'cloudy' OR temperature > 70; SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' OR condition = 'cloudy' AND temperature > 70; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL -92 wildcards are ____ and ____ . percent sign (%); underscore (_) underscore(_); question mark (?) asterisk (*); percent sign (%) question mark (?); asterisk (*) percent sign (%); underscore (_) underscore(_); question mark (?) asterisk (*); percent sign (%) question mark (?); asterisk (*) ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The benefits of a standard relational language include which of the following? Increased dependence on a single vendor Applications are not needed Reduced training costs All of these Increased dependence on a single vendor Applications are not needed Reduced training costs All of these ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS