Introduction to SQL Which of the following is a SQL aggregate function? AVG LEFT LEN JOIN AVG LEFT LEN JOIN ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following do you need to consider when you make a table in SQL? Primary keys All of these Data types Default values Primary keys All of these Data types Default values ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL keyword BETWEEN is used: None of these to limit the columns displayed. as a wildcard. for ranges. None of these to limit the columns displayed. as a wildcard. for ranges. 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' 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' 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' 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' AND condition = 'cloudy' AND temperature > 70; SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' OR condition = 'cloudy' OR temperature > 70; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following SQL commands is used to retrieve data? JOIN DELETE INSERT SELECT JOIN DELETE INSERT SELECT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The result of a SQL SELECT statement is a ________ . file table report form file table report form ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS