Introduction to SQL In SQL, which command is used to change a table's storage characteristics? CHANGE TABLE ALTER TABLE MODIFY TABLE None of these CHANGE TABLE ALTER TABLE MODIFY TABLE None of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The format SELECT-FROM-WHERE is the fundamental framework of SQL SELECT statements. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is the original purpose of SQL? To define the data structures All of these To specify the syntax and semantics of SQL data definition language To specify the syntax and semantics of SQL manipulation language To define the data structures All of these To specify the syntax and semantics of SQL data definition language To specify the syntax and semantics of SQL manipulation language ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statementSELECT SUBSTR('123456789', INSTR('abcabcabc', 'b'), 4) FROM DUAL; 2345 456789 1234 6789 2345 456789 1234 6789 ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Each index consumes extra storage space and also requires overhead maintenance time whenever indexed data change value. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Find the name of all cities with their temperature, humidity and countries. SELECT city, temperature, humidity, country FROM location; SELECT weather.city, temperature, humidity, country FROM weather, location; SELECT weather.city, temperature, humidity, country FROM weather, location WHERE weather.city = location.city; SELECT weather.city, temperature, humidity FROM weather SELECT country FROM 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, country FROM weather, location WHERE weather.city = location.city; SELECT weather.city, temperature, humidity FROM weather SELECT country FROM location WHERE weather.city = location.city; ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS