Introduction to SQL If you are going to use a combination of three or more AND and OR conditions, it is often easier to use the NOT and NOT IN operators. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Find all the cities whose humidity is 89 SELECT city FROM weather; SELECT humidity = 89 FROM weather; SELECT city WHERE humidity = 89; SELECT city FROM weather WHERE humidity = 89; SELECT city FROM weather; SELECT humidity = 89 FROM weather; SELECT city WHERE humidity = 89; SELECT city FROM weather WHERE humidity = 89; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL If a query involves NOT, AND, OR with no parenthesis NOT will be evaluated first; OR will be evaluated second; AND will be evaluated last. AND will be evaluated first; OR will be evaluated second; NOT will be evaluated last. The order of occurrence determines the order of evaluation. NOT will be evaluated first; AND will be evaluated second; OR will be evaluated last. NOT will be evaluated first; OR will be evaluated second; AND will be evaluated last. AND will be evaluated first; OR will be evaluated second; NOT will be evaluated last. The order of occurrence determines the order of evaluation. NOT will be evaluated first; AND will be evaluated second; OR will be evaluated last. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Find all the tuples having temperature greater than 'Paris'. SELECT * FROM weather WHERE temperature > (SELECT city FROM weather WHERE city = 'Paris') SELECT * FROM weather WHERE temperature > (SELECT temperature FROM weather WHERE city = 'Paris') SELECT * FROM weather WHERE temperature > (SELECT * 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 temperature FROM weather WHERE city = 'Paris') SELECT * FROM weather WHERE temperature > (SELECT * FROM weather WHERE city = 'Paris') SELECT * FROM weather WHERE temperature > 'Paris' temperature ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL 'AS' clause is used in SQL for Selection operation. Projection operation. Join operation. Rename operation. Selection operation. Projection operation. Join operation. Rename operation. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statementSELECT ROUND(45.926, -1) FROM DUAL; prints 50 is illegal prints garbage prints 045.926 prints 50 is illegal prints garbage prints 045.926 ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS