Introduction to SQL What operator tests column for the absence of data? EXISTS operator IS NULL operator NOT operator None of these EXISTS operator IS NULL operator NOT operator None of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL In SQL, which command(s) is(are) used to change a table's storage characteristics? MODIFY TABLE ALTER TABLE CHANGE TABLE All of these MODIFY TABLE ALTER TABLE CHANGE TABLE All of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The benefits of a standard relational language include which of the following? Applications are not needed Increased dependence on a single vendor Reduced training costs All of these Applications are not needed Increased dependence on a single vendor Reduced training costs All of these 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 Each index consumes extra storage space and also requires overhead maintenance time whenever indexed data change value. 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' 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' 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' 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' OR condition = 'cloudy' OR temperature > 70; SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' AND condition = 'cloudy' OR temperature > 70; ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS