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 temperature FROM weather WHERE city = 'Paris') SELECT * FROM weather WHERE temperature > (SELECT * 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 temperature FROM weather WHERE city = 'Paris') SELECT * FROM weather WHERE temperature > (SELECT * FROM weather WHERE city = 'Paris') ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL keyword BETWEEN is used: None of these as a wildcard. for ranges. to limit the columns displayed. None of these as a wildcard. for ranges. to limit the columns displayed. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL -92 wildcards are ____ and ____ . percent sign (%); underscore (_) underscore(_); question mark (?) question mark (?); asterisk (*) asterisk (*); percent sign (%) percent sign (%); underscore (_) underscore(_); question mark (?) question mark (?); asterisk (*) asterisk (*); percent sign (%) ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL can be used to: create database structures only. modify database data only. query database data only. All of these create database structures only. modify database data only. query database data only. All of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL query and modification commands make up a(n) ________ . XML DDL DML HTML XML DDL DML HTML ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Table employee has 10 records. It has a non-NULL SALARY column which is also UNIQUE.The SQL statementSELECT COUNT(*) FROM employee WHERE SALARY > ALL (SELECT SALARY FROM EMPLOYEE);prints 10 9 5 0 10 9 5 0 ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS