Introduction to SQL Which SQL statement is used to delete data FROM a database? COLLAPSE DELETE ALTER REMOVE COLLAPSE DELETE ALTER REMOVE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following join is also called as an 'inner-join'? Equijoin None of these Self-Join Non-Equijoin Equijoin None of these Self-Join Non-Equijoin ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Microsoft Access has become ubiquitous, and being able to program in Access is a critical skill. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statement: SELECT Number1 + Number 2 AS Total FROM NUMBER_TABLE; adds two numbers from each row together and lists the results in a column named Total. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is valid SQL for an Index? CREATE INDEX ID; CHANGE INDEX ID; REMOVE INDEX ID; ADD INDEX ID; CREATE INDEX ID; CHANGE INDEX ID; REMOVE INDEX ID; ADD INDEX ID; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Find all the tuples having temperature greater than 'Paris'. SELECT * FROM weather WHERE temperature > (SELECT city FROM weather WHERE city = 'Paris') SELECT * FROM weather WHERE temperature > 'Paris' temperature SELECT * FROM weather WHERE temperature > (SELECT * FROM weather WHERE city = 'Paris') SELECT * FROM weather WHERE temperature > (SELECT temperature FROM weather WHERE city = 'Paris') SELECT * FROM weather WHERE temperature > (SELECT city FROM weather WHERE city = 'Paris') SELECT * FROM weather WHERE temperature > 'Paris' temperature SELECT * FROM weather WHERE temperature > (SELECT * FROM weather WHERE city = 'Paris') SELECT * FROM weather WHERE temperature > (SELECT temperature FROM weather WHERE city = 'Paris') ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS