SQL MCQ Questions and answers – 03 Posted on June 16, 2020June 16, 2020 by admin 0 Created on June 16, 2020 By admin SQL MCQ Questions and answers - 03 1 / 10 1. 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 A. 10 B. 9 C. 5 D. 0 2 / 10 2. The SQL statementSELECT SUBSTR('abcdefghij', INSTR('123321234', '2', 3, 2), 2) FROM DUAL;prints A. gh B. 23 C. bc D. ab 3 / 10 3. The SQL statementSELECT ROUND(45.926, -1) FROM DUAL; A. is illegal B. prints garbage C. prints 045.926 D. prints 50 4 / 10 4. Which of the following must be enclosed in double quotes? A. Dates B. Column Alias C. Strings D. All of the above 5 / 10 5. Which of the following command makes the updates performed by the transaction permanent in the database? A. ROLLBACK B. COMMIT C. TRUNCATE D. DELETE 6 / 10 6. Which command undo all the updates performed by the SQL in the transaction? A. ROLLBACK B. COMMIT C. TRUNCATE D. DELETE 7 / 10 7. Find all the cities whose humidity is 89 A. SELECT city WHERE humidity = 89; B. SELECT city FROM weather WHERE humidity = 89; C. SELECT humidity = 89 FROM weather; D. SELECT city FROM weather; 8 / 10 8. Find the temperature in increasing order of all cities A. SELECT city FROM weather ORDER BY temperature; B. SELECT city, temperature FROM weather; C. SELECT city, temperature FROM weather ORDER BY temperature; D. SELECT city, temperature FROM weather ORDER BY city; 9 / 10 9. What is the meaning of LIKE '%0%0%' A. Feature begins with two 0's B. Feature ends with two 0's C. Feature has more than two 0's D. Feature has two 0's in it, at any position 10 / 10 10. Find the names of these cities with temperature and condition whose condition is neither sunny nor cloudy A. SELECT city, temperature, condition FROM weather WHERE condition NOT IN ('sunny', 'cloudy'); B. SELECT city, temperature, condition FROM weather WHERE condition NOT BETWEEN ('sunny', 'cloudy'); C. SELECT city, temperature, condition FROM weather WHERE condition IN ('sunny', 'cloudy'); D. SELECT city, temperature, condition FROM weather WHERE condition BETWEEN ('sunny', 'cloudy'); Your score is The average score is 0% LinkedIn Facebook Twitter 0% Restart quiz