Introduction to SQL When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s): LIKE only. Both IN and NOT IN. IN only. NOT IN only. LIKE only. Both IN and NOT IN. IN only. NOT IN only. 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 > ANY (SELECT SALARY FROM EMPLOYEE);prints 9 5 0 10 9 5 0 10 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 All of these Reduced training costs Applications are not needed Increased dependence on a single vendor All of these Reduced training costs ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following query finds the total rating of the sailors who have reserved boat "103"? c) SELECT COUNT(s.rating) FROM sailors s, reserves r WHERE s.sid = r.sid AND r.bid = 103 SELECT SUM(s.rating) FROM sailors s, reserves r WHERE s.sid = r.sid AND r.bid = 103 SELECT s.rating FROM sailors s, reserves r WHERE s.sid = r.sid AND r.bid = 103 SELECT SUM(s.rating) FROM sailors s, reserves r AND r.bid = 103; c) SELECT COUNT(s.rating) FROM sailors s, reserves r WHERE s.sid = r.sid AND r.bid = 103 SELECT SUM(s.rating) FROM sailors s, reserves r WHERE s.sid = r.sid AND r.bid = 103 SELECT s.rating FROM sailors s, reserves r WHERE s.sid = r.sid AND r.bid = 103 SELECT SUM(s.rating) FROM sailors s, reserves r AND r.bid = 103; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statementSELECT SUBSTR('abcdefghij', INSTR('123321234', '2', 3, 2), 2) FROM DUAL;prints bc gh ab 23 bc gh ab 23 ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The HAVING clause does which of the following? Acts like a WHERE clause but is used for columns rather than groups. Acts like a WHERE clause but is used for rows rather than columns. Acts like a WHERE clause but is used for groups rather than rows. Acts EXACTLY like a WHERE clause. Acts like a WHERE clause but is used for columns rather than groups. Acts like a WHERE clause but is used for rows rather than columns. Acts like a WHERE clause but is used for groups rather than rows. Acts EXACTLY like a WHERE clause. ANSWER DOWNLOAD EXAMIANS APP