Introduction to SQL Which SQL statement is used to delete data FROM a database? ALTER REMOVE DELETE COLLAPSE ALTER REMOVE DELETE COLLAPSE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statementSELECT SUBSTR('abcdefghij', INSTR('123321234', '2', 3, 2), 2) FROM DUAL;prints 23 bc gh ab 23 bc gh ab ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL To sort the results of a query use: ORDER BY. None of these GROUP BY. SORT BY. ORDER BY. None of these GROUP BY. SORT BY. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Find the name of all cities with their temperature, humidity and countries. SELECT weather.city, temperature, humidity FROM weather SELECT country FROM location WHERE weather.city = location.city; SELECT weather.city, temperature, humidity, country FROM weather, location; SELECT weather.city, temperature, humidity, country FROM weather, location WHERE weather.city = location.city; SELECT city, temperature, humidity, country FROM location; SELECT weather.city, temperature, humidity FROM weather SELECT country FROM location WHERE weather.city = location.city; SELECT weather.city, temperature, humidity, country FROM weather, location; SELECT weather.city, temperature, humidity, country FROM weather, location WHERE weather.city = location.city; SELECT city, temperature, humidity, country FROM location; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The FROM SQL clause is used to... specify range for search condition None of these specify search condition specify what table we are selecting or deleting data FROM specify range for search condition None of these specify search condition specify what table we are selecting or deleting data FROM ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following join is also called as an 'inner-join'? Non-Equijoin None of these Equijoin Self-Join Non-Equijoin None of these Equijoin Self-Join ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS