Introduction to SQL SQL data definition commands make up a(n) ________ . HTML DDL XML DML HTML DDL XML DML ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statementSELECT SUBSTR('abcdefghij', INSTR('123321234', '2', 3, 2), 2) FROM DUAL;prints gh ab bc 23 gh ab bc 23 ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Most companies keep at least two versions of any database they are using. True False True False 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 WHERE weather.city = location.city; SELECT city, temperature, humidity, country FROM location; SELECT weather.city, temperature, humidity, country FROM weather, 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 WHERE weather.city = location.city; SELECT city, temperature, humidity, country FROM location; SELECT weather.city, temperature, humidity, country FROM weather, location; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL 'AS' clause is used in SQL for Join operation. Projection operation. Rename operation. Selection operation. Join operation. Projection operation. Rename operation. Selection operation. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The result of every SQL query is a table. False True False True ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS