Introduction to SQL Find all the tuples having temperature greater than 'Paris'. 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 > 'Paris' temperature SELECT * FROM weather WHERE temperature > (SELECT city FROM weather WHERE city = 'Paris') 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 > 'Paris' temperature SELECT * FROM weather WHERE temperature > (SELECT city FROM weather WHERE city = 'Paris') ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The rows of the result relation produced by a SELECT statement can be sorted, but only by one column. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL What is the full form of SQL? Structured Query Language Structured Query List None of these Simple Query Language Structured Query Language Structured Query List None of these Simple Query Language ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL What does the following query find?(SELECT DISTINCT r.sidFROM boats b, reserves rWHERE b.bid = r.bidAND b.color = 'red')MINUS(SELECT DISTINCT r.sidFROM boats b, reserves rWHERE b.bid = r.bidAND b.color = 'green') Find the sailor IDs of all sailors who have reserved red boats but not green boats Find the sailor IDs of at least one sailor who have reserved red boats but not green boats None of These Find the sailor Ids of atmost one sailor who have reserved red boats but not green boats Find the sailor IDs of all sailors who have reserved red boats but not green boats Find the sailor IDs of at least one sailor who have reserved red boats but not green boats None of These Find the sailor Ids of atmost one sailor who have reserved red boats but not green boats ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following group functions ignore NULL values? SUM COUNT All of these MAX SUM COUNT All of these MAX 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