21. Table Employee has 10 records. It has a non-NULL SALARY column which is also UNIQUE.
The SQL statement
SELECT COUNT(*) FROM Employee WHERE SALARY > ANY (SELECT SALARY FROM EMPLOYEE);
prints
The SQL statement
SELECT COUNT(*) FROM Employee WHERE SALARY > ANY (SELECT SALARY FROM EMPLOYEE);
prints
22. The SQL statement
SELECT SUBSTR('abcdefghij', INSTR('123321234', '2', 3, 2), 2) FROM DUAL;
prints
SELECT SUBSTR('abcdefghij', INSTR('123321234', '2', 3, 2), 2) FROM DUAL;
prints
23. The SQL statement
SELECT ROUND(45.926, -1) FROM DUAL;
SELECT ROUND(45.926, -1) FROM DUAL;
24. Which of the following must be enclosed in double quotes?
25. Which of the following command makes the updates performed by the transaction permanent in the database?
Read More Section(Sql Miscellaneous)
Each Section contains maximum 70 questions. To get more questions visit other sections.