Introduction to SQL The keyword LIKE can be used in a WHERE clause to refer to a range of values. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which one of the following sorts rows in SQL? SORT BY ORDER BY ALIGN BY GROUP BY SORT BY ORDER BY ALIGN BY GROUP BY 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 None of these SELECT name FROM staffinfo WHERE salary BETWEEN 10000 AND 25000; SELECT name FROM staffinfo WHERE salary IN (10000, 25000); Both A and B None of these SELECT name FROM staffinfo WHERE salary BETWEEN 10000 AND 25000; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is illegal? SELECT SYSDATE - SYSDATE FROM DUAL; SELECT SYSDATE - (SYSDATE + 2) FROM DUAL; None of these SELECT SYSDATE - (SYSDATE - 2) FROM DUAL; SELECT SYSDATE - SYSDATE FROM DUAL; SELECT SYSDATE - (SYSDATE + 2) FROM DUAL; None of these SELECT SYSDATE - (SYSDATE - 2) FROM DUAL; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following query finds the total rating of the sailors who have reserved boat "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; 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 ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the SQL statements is correct? None of these SELECT Username AND Password FROM Users SELECT Username, Password FROM Users SELECT Username, Password WHERE Username = 'user1' None of these SELECT Username AND Password FROM Users SELECT Username, Password FROM Users SELECT Username, Password WHERE Username = 'user1' ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS