Introduction to SQL Which of the following is valid SQL for an Index? ADD INDEX ID; CHANGE INDEX ID; REMOVE INDEX ID; CREATE INDEX ID; ADD INDEX ID; CHANGE INDEX ID; REMOVE INDEX ID; CREATE INDEX ID; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL In SQL, which of the following is not a data definition language commands? GRANT REVOKE RENAME UPDATE GRANT REVOKE RENAME UPDATE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Find the temperature in increasing order of all cities SELECT city, temperature FROM weather; SELECT city, temperature FROM weather ORDER BY temperature; SELECT city FROM weather ORDER BY temperature; SELECT city, temperature FROM weather ORDER BY city; SELECT city, temperature FROM weather; SELECT city, temperature FROM weather ORDER BY temperature; SELECT city FROM weather ORDER BY temperature; SELECT city, temperature FROM weather ORDER BY city; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL A view is which of the following? A base table that cannot be accessed via SQL commands A virtual table that cannot be accessed via SQL commands A virtual table that can be accessed via SQL commands A base table that can be accessed via SQL commands A base table that cannot be accessed via SQL commands A virtual table that cannot be accessed via SQL commands A virtual table that can be accessed via SQL commands A base table that can be accessed via SQL commands ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The qualifier DISTINCT must be used in an SQL statement when we want to eliminate duplicate rows. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following SQL commands can be used to add data to a database table? UPDATE ADD APPEND INSERT UPDATE ADD APPEND INSERT ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS