Introduction to SQL Find all the tuples having temperature greater than 'Paris'. SELECT * FROM weather WHERE temperature > 'Paris' temperature SELECT * FROM weather WHERE temperature > (SELECT * FROM weather WHERE city = 'Paris') SELECT * FROM weather WHERE temperature > (SELECT temperature FROM weather WHERE city = 'Paris') SELECT * FROM weather WHERE temperature > (SELECT city FROM weather WHERE city = 'Paris') SELECT * FROM weather WHERE temperature > 'Paris' temperature SELECT * FROM weather WHERE temperature > (SELECT * FROM weather WHERE city = 'Paris') SELECT * FROM weather WHERE temperature > (SELECT temperature FROM weather WHERE city = 'Paris') SELECT * FROM weather WHERE temperature > (SELECT city FROM weather WHERE city = 'Paris') ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Most companies keep at least two versions of any database they are using. False True False True ANSWER DOWNLOAD EXAMIANS APP
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. IN only. LIKE only. Both IN and NOT IN. NOT IN only. IN only. LIKE only. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the SQL statements is correct? SELECT Username, Password FROM Users SELECT Username, Password WHERE Username = 'user1' SELECT Username AND Password FROM Users None of these SELECT Username, Password FROM Users SELECT Username, Password WHERE Username = 'user1' SELECT Username AND Password FROM Users None of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL What is the meaning of LIKE '%0%0%' Feature has two 0's in it, at any position Feature has more than two 0's Feature begins with two 0's Feature ends with two 0's Feature has two 0's in it, at any position Feature has more than two 0's Feature begins with two 0's Feature ends with two 0's ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL provides five built-in functions: COUNT, SUM, AVG, MAX, MIN. False True False True ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS