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 If a query involves NOT, AND, OR with no parenthesis The order of occurrence determines the order of evaluation. AND will be evaluated first; OR will be evaluated second; NOT will be evaluated last. NOT will be evaluated first; OR will be evaluated second; AND will be evaluated last. NOT will be evaluated first; AND will be evaluated second; OR will be evaluated last. The order of occurrence determines the order of evaluation. AND will be evaluated first; OR will be evaluated second; NOT will be evaluated last. NOT will be evaluated first; OR will be evaluated second; AND will be evaluated last. NOT will be evaluated first; AND will be evaluated second; OR will be evaluated last. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which operator performs pattern matching? EXISTS operator BETWEEN operator LIKE operator None of these EXISTS operator BETWEEN operator LIKE operator None of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL A SELECT statement within another SELECT statement and enclosed in square brackets ([...]) is called a subquery. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL In SQL, which command is used to change a table's storage characteristics? ALTER TABLE None of these CHANGE TABLE MODIFY TABLE ALTER TABLE None of these CHANGE TABLE MODIFY TABLE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Find all the cities whose humidity is 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; SELECT city FROM weather; SELECT humidity = 89 FROM weather; SELECT city WHERE humidity = 89; ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS