Introduction to SQL What operator tests column for the absence of data? None of these NOT operator IS NULL operator EXISTS operator None of these NOT operator IS NULL operator EXISTS operator ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following query finds the names of the sailors who have reserved at least one boat? SELECT DISTINCT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid; SELECT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid; SELECT DISTINCT s.sname FROM sailors, reserves WHERE s.sid = r.sid; None of These SELECT DISTINCT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid; SELECT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid; SELECT DISTINCT s.sname FROM sailors, reserves WHERE s.sid = r.sid; None 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 Reduced training costs Increased dependence on a single vendor All of these Applications are not needed Reduced training costs Increased dependence on a single vendor All of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The command to eliminate a table from a database is: DROP TABLE CUSTOMER; DELETE TABLE CUSTOMER; UPDATE TABLE CUSTOMER; REMOVE TABLE CUSTOMER; DROP TABLE CUSTOMER; DELETE TABLE CUSTOMER; UPDATE TABLE CUSTOMER; REMOVE TABLE CUSTOMER; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following are the five built-in functions provided by SQL? SUM, AVG, MIN, MAX, NAME SUM, AVG, MULT, DIV, MIN SUM, AVG, MIN, MAX, MULT COUNT, SUM, AVG, MAX, MIN SUM, AVG, MIN, MAX, NAME SUM, AVG, MULT, DIV, MIN SUM, AVG, MIN, MAX, MULT COUNT, SUM, AVG, MAX, MIN ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Find the temperature in increasing order of all cities SELECT city, temperature FROM weather ORDER BY temperature; SELECT city, temperature FROM weather; SELECT city, temperature FROM weather ORDER BY city; SELECT city FROM weather ORDER BY temperature; SELECT city, temperature FROM weather ORDER BY temperature; SELECT city, temperature FROM weather; SELECT city, temperature FROM weather ORDER BY city; SELECT city FROM weather ORDER BY temperature; ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS