Introduction to SQL Which of the following must be enclosed in double quotes? Column Alias Dates Strings All of these Column Alias Dates Strings All of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SUM, AVG, MIN, and MAX can only be used with numeric columns. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Indexes may be created or dropped at any time. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statement: SELECT Name, COUNT(*) FROM NAME_TABLE; counts the number of name rows and displays this total in a table with a single row and a single column. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Find all the tuples having temperature greater than 'Paris'. SELECT * FROM weather WHERE temperature > 'Paris' temperature 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 > (SELECT * FROM weather WHERE city = 'Paris') SELECT * FROM weather WHERE temperature > 'Paris' temperature 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 > (SELECT * FROM weather WHERE city = 'Paris') ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The rows of the result relation produced by a SELECT statement can be sorted, but only by one column. False True False True ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS