Introduction to SQL When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s): Both IN and NOT IN. NOT IN only. LIKE only. IN only. Both IN and NOT IN. NOT IN only. LIKE only. IN only. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SUM, AVG, MIN, and MAX can only be used with numeric columns. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Table employee has 10 records. It has a non-NULL SALARY column which is also UNIQUE.The SQL statementSELECT COUNT(*) FROM employee WHERE SALARY > ALL (SELECT SALARY FROM EMPLOYEE);prints 5 9 10 0 5 9 10 0 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 s.sname FROM sailors s, reserves r WHERE s.sid = r.sid; None of These SELECT DISTINCT s.sname FROM sailors, reserves WHERE s.sid = r.sid; 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; None of These SELECT DISTINCT s.sname FROM sailors, reserves WHERE s.sid = r.sid; SELECT DISTINCT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included. DISTINCT ONLY UNIQUE SINGLE DISTINCT ONLY UNIQUE SINGLE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL What operator tests column for the absence of data? NOT operator None of these IS NULL operator EXISTS operator NOT operator None of these IS NULL operator EXISTS operator ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS