Introduction to SQL The SQL statementSELECT SUBSTR('abcdefghij', INSTR('123321234', '2', 3, 2), 2) FROM DUAL;prints 23 gh bc ab 23 gh bc ab ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL A SELECT statement within another SELECT statement and enclosed in square brackets ([...]) is called a subquery. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL ORDER BY can be combined with the SELECT statements. True False True False 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 > ANY (SELECT SALARY FROM EMPLOYEE);prints 10 0 5 9 10 0 5 9 ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Each index consumes extra storage space and also requires overhead maintenance time whenever indexed data change value. False True False True 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 * 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') SELECT * FROM weather WHERE temperature > (SELECT city FROM weather WHERE city = 'Paris') ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS