Introduction to SQL Microsoft Access has become ubiquitous, and being able to program in Access is a critical skill. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL data definition commands make up a(n) ________ . XML HTML DML DDL XML HTML DML DDL 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' 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' 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' 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' OR condition = 'cloudy' OR temperature > 70; SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' AND condition = 'cloudy' AND temperature > 70; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following SQL query is correct for selecting the name of staffs from 'staffinfo' table where salary is 10,000 or 25,000? SELECT name FROM staffinfo WHERE salary IN (10000, 25000); Both A and B SELECT name FROM staffinfo WHERE salary BETWEEN 10000 AND 25000; None of these SELECT name FROM staffinfo WHERE salary IN (10000, 25000); Both A and B SELECT name FROM staffinfo WHERE salary BETWEEN 10000 AND 25000; None of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL What operator tests column for the absence of data? IS NULL operator NOT operator EXISTS operator None of these IS NULL operator NOT operator EXISTS operator None of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL A dynamic view is one whose contents materialize when referenced. True False True False ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS