Introduction to SQL What is the meaning of LIKE '%0%0%' Feature has two 0's in it, at any position Feature begins with two 0's Feature ends with two 0's Feature has more than two 0's Feature has two 0's in it, at any position Feature begins with two 0's Feature ends with two 0's Feature has more than two 0's ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Find the temperature in increasing order of all cities SELECT city FROM weather ORDER BY temperature; SELECT city, temperature FROM weather ORDER BY temperature; SELECT city, temperature FROM weather ORDER BY city; SELECT city, temperature FROM weather; SELECT city FROM weather ORDER BY temperature; SELECT city, temperature FROM weather ORDER BY temperature; SELECT city, temperature FROM weather ORDER BY city; SELECT city, temperature FROM weather; 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 Most companies keep at least two versions of any database they are using. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statementSELECT SUBSTR('abcdefghij', INSTR('123321234', '2', 3, 2), 2) FROM DUAL;prints gh bc 23 ab gh bc 23 ab 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 5 9 10 0 5 9 10 0 ANSWER DOWNLOAD EXAMIANS APP