Introduction to SQL SQL provides the AS keyword, which can be used to assign meaningful column names to the results of queries using the SQL built-in functions. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL What operator tests column for the absence of data? IS NULL operator EXISTS operator NOT operator None of these IS NULL operator EXISTS operator NOT operator None of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Indexes can usually be created for both primary and secondary keys. True False True False 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' OR condition = 'cloudy' OR 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' AND 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' OR 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' AND temperature > 70; SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' AND condition = 'cloudy' OR temperature > 70; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Count function in SQL returns the number of values. distinct values. columns. groups. values. distinct values. columns. groups. ANSWER DOWNLOAD EXAMIANS APP