Introduction to SQL Which of the following is valid SQL for an Index? REMOVE INDEX ID; CREATE INDEX ID; ADD INDEX ID; CHANGE INDEX ID; REMOVE INDEX ID; CREATE INDEX ID; ADD INDEX ID; CHANGE INDEX ID; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SELECT DISTINCT is used if a user wishes to see duplicate columns in a query. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Find the names of the countries whose condition is sunny. SELECT country FROM location WHERE city NOT IN (SELECT city FROM weather WHERE condition = 'sunny'); SELECT country FROM location WHERE city UNION (SELECT city FROM weather WHERE condition = 'sunny'); SELECT country FROM location WHERE city IN (SELECT city FROM weather WHERE condition = sunny'); SELECT country FROM location WHERE condition = 'sunny'; SELECT country FROM location WHERE city NOT IN (SELECT city FROM weather WHERE condition = 'sunny'); SELECT country FROM location WHERE city UNION (SELECT city FROM weather WHERE condition = 'sunny'); SELECT country FROM location WHERE city IN (SELECT city FROM weather WHERE condition = sunny'); SELECT country FROM location WHERE condition = 'sunny'; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL In SQL, which of the following is not a data definition language commands? RENAME UPDATE GRANT REVOKE RENAME UPDATE GRANT REVOKE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL is: an operating system. a DBMS. a programming language. a data sublanguage. an operating system. a DBMS. a programming language. a data sublanguage. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The FROM SQL clause is used to... specify search condition None of these specify what table we are selecting or deleting data FROM specify range for search condition specify search condition None of these specify what table we are selecting or deleting data FROM specify range for search condition ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS